Skip to main content

Return Link Name (not reccord ID)

  • August 4, 2017
  • 5 replies
  • 36 views

Forum|alt.badge.img+4

Hi,
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?
Thanks!
-Donald

5 replies

Forum|alt.badge.img+19
  • Inspiring
  • 366 replies
  • August 5, 2017

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.


  • New Participant
  • 2 replies
  • September 3, 2018

Hi -
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!
-Chris


Forum|alt.badge.img+19
  • Inspiring
  • 351 replies
  • September 3, 2018

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


  • New Participant
  • 2 replies
  • September 3, 2018

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


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.


  • New Participant
  • 1 reply
  • April 1, 2020

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.


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.