Filter data in the Car select, based on input from other fields Dates

Guys, I have a question, I need that when the user selects the car, it only lists cars that are available for that date.

My model:

Car collection
Reservation collection

The print screen form where the Car field is, is the Reservation collection, I tried the Set data scope, but it didn’t work.

How do you define “cars that are available for that date”?

The user fills in two date fields: reservation start date and reservation end date. Once the user has filled in these fields, the next field called car should list only the car models that are not reserved for that date.

The criterion is that there cannot be any cars reserved for that date, that is, the select only displays the cars that are not occupied for that date range.

This sounds like it will require additional development to implement.

I see some implementation suggestions:

  • Add an option to call a workflow after filling out a specific field, this workflow could have a flow to filter the reservation.

  • Add an action for an http request to the select, so I could use the nocobase API itself to filter the fields

Is there any specific documentation to implement something like this?