Formula output is showing parenthesis when none exist

Topic Labels: Formulas
807 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Formula is pulling linked input to create a unique name and for some reason, the formula is putting parenthesis around some of the linked names and not on other linked names. When I double check the linked table, the names are clean.

Anyone know why this is happening and how I can get the parenthesis to not show up?

See line 40 - 43 on first screen shot.


2 Replies 2

I think you are probably referring to the quotation marks showing up in certain records, not parentheses.

Those quotation marks show up in records where the linked record in the Tubular Sub Name field contains a comma.

So, for example, the records that have Monel Collar in the Tubular Sub Name field have no quotation marks, because Monel Collar does not have a comma (,) in the name of the record. But the records that have Motor, Mandrel in the Tubular Sub Name field have quotation marks around the reference to that field name, because the record there has a comma in the name.

This happens because the Linked Record field type holds an Array as its core data-type (an Array is a collection of objects, in this case, a collection of record references). The trouble is, Arrays are comma-delineated – the values are separated by commas. So in order for Airtable to distinguish record references by commas, without turning Motor, Mandrel into two records, Motor and Mandrel, it has to surround that reference in quotation marks so that the system will ignore the comma in there.

Do you mean parenthesis () or quotes ""?

If you mean quotes, it is because you have a comma in the field value Motor, Mandrel. If you remove the comma, the extra quotes will go away.