Help

Re: Need a FIND/SEARCH Formula to lookup an ID that is within a Multiple Select Lookup Field

1580 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeff_Moore
4 - Data Explorer
4 - Data Explorer

Hi All,

I am looking for a FIND or SEARCH formula to use in a GET URL.
I need to lookup an ID, lets say "1234" and that ID is within a Multiple Select Option Column.
the column on the table is a lookup and has multiple ids all in a string. example: 1234, 3563, 235234, 1435

I am wanting to do the lookup to find the Record that the "ID" is within the multiple ids.
The formula i'm using now, is looking up a Single entry, not an entry within multiple.
What would my URL Formula Looklike?
Here is what i'm using now.api.airtable.com/v0/"APP"/"MYTABLE"?filterByFormula=FIND("ID",{Client+ID})&maxRecords=1&pageSize=90

Thanks

2 Replies 2
Jeff_Moore
4 - Data Explorer
4 - Data Explorer

I think i figured it out. The FIND still works when looking within a Multi Select Field.
Be curious to hear from experts on this. thanks

Hi Jeff! It looks like you’re right on track with this approach. We’d agree that using FIND() is the correct one for this use case, although one thing to note is that maxRecords and pageSize parameters may be unnecessary here. Hope that this can help!