A## in Formula OutputAny time you see an alias return a response of something like "A26," it means that there was a formula passed inside of a string of numbers or letters.
This most often occurs when you are attempting to prefill a form through a URL and you are also trying to use a formula.
In order to use aliases and strings together, you will have to use the concatenate formula to produce a correct result. Here is an example which would cause an error:
@IF(%%tfa_1%%="Yes", "http://www.tfaforms.com/000000?tfa_1=%%tfa_2%%", "http://www.tfaforms.com/000000")
The true value of this IF statement would come out to something like this:
which would prefill a field with incorrect information.
To solve this, you need to add the concatenate formula in order to produce the correct URL. Here are steps to produce the correct outcome:
- Start with the IF condition
- Add the true outcome, with a concatenate formula if needed.
Concatenate formulas should have:
- Text in quotes.
- No quotes around aliases
- Commas between each part.
@IF(%%tfa_1%%="Yes", @CONCATENATE("http://www.tfaforms.com/000000?tfa_1=", %%tfa_2%%),
- Add the false outcome, with a concatenate formula, if needed.
@IF(%%tfa_1%%="Yes", @CONCATENATE("http://www.tfaforms.com/000000?tfa_1=", %%tfa_2%%),"http://www.tfaforms.com/000000")
Integers/Numbers Being Cut Off
FormAssembly's formula engine can only handle a maximum integer/number length of 19 digits. This means if you are trying to prefill or use a formula that involves a number longer than 19 digits, it will be cut off. There is no limit for letters, only for numbers.