Hi Airtable Community,
When applying the TRIM function to fields that are lookup fields from another table I receive an error. However when testing other formula’s E.g. Concatenate that does work this particular situation using Linked/lookup fields from another table. I would assume that the all functions gather data in the back-end in the same way. Can one confirm this is actually not possible to use TRIM in combination with Lookup Field type?
Solved! Go to Solution.
Welcome to the Airtable community.
You are seeing this behavior because the
TRIM function requires a string as an input, but an lookup field is an array.
There are multiple methods for converting an array into a string. The
CONCATENATE function is one method. Concatenating the lookup with an empty string with
& "" also converts the array to a string. Yet another option is to use a rollup field instead of a lookup field.