Hello, I am using AppGyver as my front end.
From a multiselect field in AppGyver, User A chooses “red”, “blue”, “green”, “purple”. I want to pull all records from my Cloth table which have those 4 colours
From a multiselect field in AppGyver, User B chooses “pink”. I want to pull all records from my Cloth table which have pink.
I do not know in advance how many criteria the user will select.
I know i can sort by multiple fields using an array → ?sort[0][field]=day&sort[0][direction]=asc&sort[1][field]=name&sort[1][direction]=desc (of course the whole query parameter needs to be encoded)
But i don’t know how to do that for filters through API cause API filtering is done through filterByFormula → and if i were to use an OR function, i need to know how much filters there are in advance e.g. user will choose 1 colour, or 2 colours, or 3 colours etc
Could someone kindly teach me how I can get this done in AppGyver linking to Airtable? Thanks!