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", "", "")

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:
  1. Start with the IF condition
  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("", %%tfa_2%%),
  3. Add the false outcome, with a concatenate formula, if needed.
    @IF(%%tfa_1%%="Yes", @CONCATENATE("", %%tfa_2%%),"")

Terms of Service · Privacy Policy