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
Dec 01, 2021 06:39 PM
PROBLEM
In our TABLE 1 (PROJECTS):
EXAMPLE DATA / FORMULAS (Solution Below):
This example shows Table 1 concatenating Table 2’s primary field (which is also a concatenated formula). Even if your primary field in Table 2 is a write-in field containing one or more commas, the result & solution are the same.
TABLE 1: PROJECTS
Concatenate({Project Number}, " (", {Customer}, ")")
This is the field that will show the unwanted quote marks because you are concatenating using a linked field containing comma(s)
TABLE 2: CUSTOMERS
Concatenate({First Name}, " ", {Last Name}, " - " {Customer Company})
)TABLE 2 (CUSTOMERS) displays the correct Concatenate format. However, Column 1 is your primary field, which will then be the linked field referenced in TABLE 1. It will produce the unwanted quote marks when seen in TABLE 1’s concatenated field. Again, even if your Column 1 is a write-in field, if it contains commas it will produce the unwanted quote marks in your other table’s concatenated field.
SOLUTION:
Concatenate using a helper column from your linked table rather than the linked field.
Concatenate ({First Name}, " ", {Last Name}, " - " {Customer Company})
If you are using a write-in field for Column 1, your helper column can simply reference your Column 1 field name. The point is you are creating the same text string that is no longer the linked/primary field.
Concatenate({Project Number}, " - ", {Customer String})