Maybe somebody form the community will help with something I’m struggling with.
I’d like to make an API call with a Filter formula on a lookup field, which includes comme separated dates, see below :
As you can see, there is a simple calculation field that is : IS_BEFORE(TODAY(),Booked_Dates) that doesn’t seem to be very happy with the multiple item field on Line 1.
However, when I’m filtering lookup fields with conditions in Airtable it seems to work perfectly fine (don’t notice both conditions, only the second one):
And the result :
So my question is : Is there a formula I can use to have the same behavior than Airtable’s lookup filter so I can make the appropriate API call in the FilterByformula query ? Or is there any workaround that one of you might suggest ?
The idea here is to look for an available timeframe in a booking system…
Thank you for your help.