This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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”...
