Help

API: Filter formula when you have a linked ID

Topic Labels: Formulas
172 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jed_Davidow
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 Travelers.id:

{
  "id":"recj6XBlCeO4Dk19z",
  "createdTime":"2023-03-15T02:04:52.000Z",
  "fields":{
    "stepName":"Start",
    "stepNum":1,
    "ID":"StandardBuild_1",
    "Travelers.id":["recswe1cU6X4b4XVY"],

    "travelers.PN":["FRM-0000REV01"],
    "Travelers.name":["StandardBuild"]
  }
}

So I want to filter the result by the Travelers.id, 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 Traveler.name and not the item ID.

Any ideas?

 

 

 

2 Replies 2
ramonscardua
5 - Automation Enthusiast
5 - Automation Enthusiast

First query all items, so you can filter them:

query.records.filter

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?