I was able to successfully load data from Airtable using the api. I am trying to filter records within a date range. I created a date range component, and I tried two methods to filter the data in the table.
In the first method, I tried Airtable's filterByFormula IS_AFTER function, but it does not look like it supports this exact type of filter.
In the second method, I used the event handling on the date range component to set a filter on table. I set up two events. The first event sets the filter "is after", which uses filters after a specific date. The second event sets the filter "is before", which sets the filters before a specific date. It appears the filter created by second event overwrites the filter created by the first event. The filters also accumulate, so I need a way to clear out all of the other filters. I could do this with another event, but it starts to feel like a broken design.
Can anyone help me with either approach?