Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

900 2
Showing results for 
Search instead for 
Did you mean: 

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"APP"/"MYTABLE"?filterByFormula=FIND("ID",{Client+ID})&maxRecords=1&pageSize=90


2 Replies 2

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!