This is driving me nuts. I have a long text field (rich text turned off) that seems to have multiple line breaks.
Formula I used was Substitute(Field,“\n”,“”) and while it seems to work it also doesn’t. I tried with putting in a value instead of “” s...
If you think of the primary field of the properties table as the key column then on the transactions table a formula column that generates the primary field text you want to link to. It could be as simple as a basic concat formula.
The automation can...
The way I have been doing it is with a key generator formula column what creates the link data then an automation to copy this into the link column. Just make sure the key column in the properties table is a formula so that any incorrect link added d...
Ok I seem to have stumbled onto the solution substitute does not work for \r removal which I had tried already only regex_replace works but only on the original text column not if it is a lookup column.
REGEX_REPLACE(REGEX_REPLACE(Field,“\n”,“”),“\r”...
