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

Formula to Match Field That is a Link to Records

Topic Labels: Formulas
340 2
Showing results for 
Search instead for 
Did you mean: 

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.