Skip to main content
Solved

Linked Records are Quoted when Original Record has no Quotations

  • September 20, 2023
  • 2 replies
  • 43 views

Forum|alt.badge.img+2

Hello!

I run a grant application processing Airtable base that needs to seamlessly take titles of records, notably the name of the organization, and link it to other facets of my database. However, when some records to linked to other tables, it contains quotation marks around the linked record. 

My system does not change the record name by any means such that it is crucial that the names stay the same since my automations require to search records in other tables to grab information. 

Help would be appreciated! Here is a picture of what is happening to a linked record. I suspect that the ",Inc." might freak out Airtable to quote the text.

 

Best answer by Sho

Hello @clubianski,

Is the field whose value is enclosed in quotes a Formula field?
If you want to display the primary field of the linked table, use the Lookup field.

2 replies

Forum|alt.badge.img+21
  • Inspiring
  • Answer
  • September 20, 2023

Hello @clubianski,

Is the field whose value is enclosed in quotes a Formula field?
If you want to display the primary field of the linked table, use the Lookup field.


Forum|alt.badge.img+2
  • Author
  • New Participant
  • September 20, 2023

Hello @clubianski,

Is the field whose value is enclosed in quotes a Formula field?
If you want to display the primary field of the linked table, use the Lookup field.


Hi Sho!

This works! Fortunately, the name is not the primary field of the table which primary fields do not allow Lookup fields. Thank you for your help!