Aug 04, 2017 09:51 AM
I’m looking for an easy way to have Airtable return the name of a linked record (instead of using the ID and doing a separate API call). Is there an Airtable formula that can get the name of a linked record as text?
Aug 05, 2017 12:55 AM
I don’t think so. AFAIK you can only use formulas for filtering.
You can add a second column with the formula to your table as a workaround.
Sep 03, 2018 06:47 AM
New here. Bumping this up because I have the same question. In my use case, I am retrieving record via rest get call. Would like to use the display value of the linked field in the call but appears only option is the record id? Thanks in advance for any thoughts!
Sep 03, 2018 07:41 AM
Chris - you need to add a lookup column to your table that looks up the name value. Then it will be available in the API call
Sep 03, 2018 04:26 PM
Thanks openside! I’m all set now.
Just one quick comment for others going down my beginner path:
the pointer about the lookup field is a great one and let’s one retrieve the display value when specifying a reference field in the fields you want returned (without it, you get the identifier string). My initial query was about suppling the display value in the selection criteria - which works without a lookup field. My issue was a mistake in how I structured the initial get call.
Mar 31, 2020 11:02 PM
What was your solution?
I am using the LIST method on the Airtable NODEJS api, and I want to get display names and not ids.