Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula that contains a linked record field is adding quotations marks - need to remove

Topic Labels: Formulas
Solved
Jump to Solution
347 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a formula field that includes a linked record field {Supplier}. The result is the text in the linked record field has quotation marks. Is there a way to remove the quotation marks from my results?

DATETIME_FORMAT({Purchase Date},‘YYYY-MM-DD’) & “-” & {Supplier}

2018-03-31-“Supplier ABC - Your Town, WA - Unknown Address”

Many thanks :pray:

1 Solution

Accepted Solutions

Create a lookup field based on your linked record field (Supplier), and lookup the primary field (which will be the Supplier).

Then, use that lookup field in your formula instead of the linked record field.

See Solution in Thread

3 Replies 3

Create a lookup field based on your linked record field (Supplier), and lookup the primary field (which will be the Supplier).

Then, use that lookup field in your formula instead of the linked record field.

Thank you! :pray: :grinning:

You’re welcome! Glad I could help! :slightly_smiling_face: