Re: Formula to Match Field That is a Link to Records

514 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to figure out how to write a formula that matches a field that contains a link to records.

In my setup, I have a field that is a link to another record. I’ve tried {Field_Name} = rec########, {Field_Name} = “rec########”, {Field_Name = “Record Identifier”}.

What am I missing??

2 Replies 2

Are you using a formula field in the native Airtable interface, the filterByFormula feature of the Standard REST API, or one of the other APIs?

If you are using a formula field in the native Airtable interface, you do not need to use the record id.

If you are using one of the other APIs, the linked record field is stored as an array of objects. Refer to the API documentation for the exact format.

If you need more help, could you please post some screen shots of your base and your code?

I’m using Integromat. As a bad workaround, I just made another field that is a CONCATENATE formula to pull the text of the name. It works, but it’s extra data in the table that isn’t needed.