[TRIRIGA] External formula
728x90
Some predefined formulas have inputs that are string or text values. The text values can come from fields of records or be the value in the formula. To put a string value directly in a formula, enclose it in double or single quotes like "THIS" or 'THAT'.
If you need a text value that contains a single quote, enclose it in double quotes like this: "O'Clock" If you need a text value that contains a double quote, enclose it in single quotes like this: 'He said, "Boo."'
You can not directly put a text value that contains both single and double quotes in a formula. However, you can concatenate to combine two or more text values into a single text value. To put the value It is at "four o'clock" in a formula you could write it as '"four ' + "o'clock" + '"'
If you need a text value that contains a single quote, enclose it in double quotes like this: "O'Clock" If you need a text value that contains a double quote, enclose it in single quotes like this: 'He said, "Boo."'
You can not directly put a text value that contains both single and double quotes in a formula. However, you can concatenate to combine two or more text values into a single text value. To put the value It is at "four o'clock" in a formula you could write it as '"four ' + "o'clock" + '"'