Hi,
I have created 2 lists
1) FAJ_Test_Transport booking
FAJ_Test_Transport booking
2) FAJ_Test_Transport vehicles
FAJ_Test_Transport vehicles
What I want to achieve is, if a vehicle is booked for a particular date and time then it should not show up in the available list of vehicles available when someone tries to book for that date and time range.
I was trying using but it looks like you cant use gallery with 2 different datasources ( I could be worng). Cant figure out how this can be achieved.
Filter(
'FAJ_Test_Transport vehicles', Not(Vehicle_No in Filter('FAJ_Test_Transport booking',ThisRecord.'Departure Date' >= var_starttime && ThisRecord.'Return date' <= var_endtime || ThisRecord.'Departure Date' <=var_endtime && ThisRecord.'Return date' >= var_endtime)
Any help on this would be appreciated