Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 24, 2022 06:43 AM
Hi,
I am getting an Error back on the very basic SUBSTITUTE, which I have used numerous times in other tables of my base.
SUBSTITUTE({Record Name}," “,”-")
{Record Name} is a FORMULA FIELD that pulls the text from a LOOKUP FIELD (in the same table) that pulls the text from a FORMULA FIELD in another table.
Any ideas? Thanks in advance.
Tobias
Solved! Go to Solution.
Feb 24, 2022 07:20 AM
Lookup fields are the trickiest to use in formula fields. This is because they often (but not always) return arrays, not simple text strings or numbers.
Try these versions that convert the array to a string by using & ""
SUBSTITUTE({Record Name} & ""," ","-")
LOWER({Record Name} & "")
Feb 24, 2022 06:47 AM
UPDATE:
This formula also produces an error:
LOWER({Record Name})
However, if I only reference {Record Name} in the formula the error goes away and my desired text appears.
Feb 24, 2022 07:20 AM
Lookup fields are the trickiest to use in formula fields. This is because they often (but not always) return arrays, not simple text strings or numbers.
Try these versions that convert the array to a string by using & ""
SUBSTITUTE({Record Name} & ""," ","-")
LOWER({Record Name} & "")
Feb 24, 2022 07:23 AM
Ahhh, perfect. Worked.
As you said. I have referenced Lookup Fields before without any problem.