We have Transportation assets (Drivers and Vehicles) and I want to check if the following is possible with JSM Assets.
My asset schema:
- Vehicles (key,name,created,updated)
- Drivers (key,name,created,updated)
- Assignments (key,name,created,updated, Vehicle, Driver, assignment date)
The process looks like this:
- Customer submits a request for a trip with a date (the date comes in as the system field Due Date)
- Agent selects a Driver and a Vehicle in the issue using custom fields (Assets object type)
- Jira automation creates a record in Assets with the assignment: vehicle, driver, date
Now, in step 2, I want to filter the drivers and vehicles that are available on that particular date, to avoid booking a driver or a vehicle more than once.
I don't know how to filter this so any help will be much appreciated. Thanks!