Formula Troubleshooting 


In this Article
Related Articles

A## in Formula Output

Any 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.
 
Note: Spaces and line breaks in the formula can cause errors.


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:
http://www.tfaforms.com/000000?tfa_1=A26
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:
  1. Start with the IF condition
    @IF(%%tfa_1%%="Yes",
  2. 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%%),
  3. 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.

Terms of Service · Privacy Policy