Re: API: Filter formula when you have a linked ID

972 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I have a table I need to search through and pull records from.

That table has a column that is linked to another table.  I have that link ID.  It's set to a single link (not multiple items).

Here's the item from a list that I have retrieved.  I have the



So I want to filter the result by the, but I cannot figure out how to format it.

I tried to create a new column that used ARRAYJOIN to format that ID array into a string... but that actually formats the and not the item ID.

Any ideas?




2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

First query all items, so you can filter them:


I'm sorry, I don't understand what query.records.filter is.


I'm looking to use the filterByFormula to have the server filter the records for me.


What is this query records formula?