Hello!
I am using the airtable API with a formula to basically filter a set of records from a table. I am filtering on a multiple-select
-field, combined with a logical OR, so something like this:
OR((FIND(LOWER("First"),LOWER({Select})) >= 1),(FIND(LOWER("Second"),LOWER({Select})) >= 1))
Now I will have records that have both “First” and “Second” selected in the “Select” column. I would like to sort these more accurate matches to the top of my results. Is there any way to do this?
Thanks in advance!
Tom