Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula filter based on record id

Topic Labels: API Scripting
Solved
Jump to Solution
1034 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi. I,m trying to filter records using filter formula based on record_id. The field is not exists in the table, and we don't want to create formula field to have record ids explicitly. Is there a way to compose query formula to filter data by their record_Ids like this:
AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({record_id}) & ","), ", ", ","))))
Thanks in advance.

1 Solution

Accepted Solutions

I found the solution, Just instead of {record_id} I used {RECORD_ID()} function in query like this:
AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({RECORD_ID()}) & ","), ", ", ","))))

See Solution in Thread

3 Replies 3

I don’t understand what it is that you’re trying to achieve - could you please provide a couple of mock-up images to help explain?

OK. this is my demo table, which has several records. I do not defined recordid field for my records, but as we know each record has record id like this "recctaxd2aq9fvtfj". So in my application I have conditional filters to fetch data from table by Brand, Name, Model etc.... I want to fetch data bu record id as well, but dont want to explicitly define record_id column in my table. I want to use the record id which comes with each record as you can see in code response screenshot.
So this query is working:
AND(OR(SEARCH(",MI 9T pro", "," & SUBSTITUTE(LOWER(ARRAYJOIN({Model}) & ","), ", ", ","))))
But this is not working:
AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({record_id}) & ","), ", ", ","))))

I found the solution, Just instead of {record_id} I used {RECORD_ID()} function in query like this:
AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({RECORD_ID()}) & ","), ", ", ","))))