FormAssembly Functions Update - What To Expect 


In this Article
Related Articles

Overview

On May 12, 2022, FormAssembly will be updating the functions used within our product in areas such as connectors, emails, thank you pages, and redirects, to more closely match Excel functions. This change will allow our team to work off of a supported library and will provide an updated range of functions. 

We’ve notified accounts with forms that may be affected through email, and we’ll be sending an additional email two weeks prior to the change. If you would like to receive a list of forms which use a specific function in your account then you can reach out to our Support team for assistance.

Most of our FormAssembly functions will remain the same and will not require any changes to be made. However, a few functions will be updated during this release. If you are using one of the following functions in your forms, please follow these steps:

  1. Review the functionality changes noted in the table below.
  2. Locate the formulas in your account which utilize the functions noted if they will be affected by the upcoming changes.
  3. Confirm whether the functionality change will impact the performance of your formula. If it will, proceed with one of the two following actions:
  • Update the formula on May 12 when the changes are released.
  • Alter the formula to use another function that will not be experiencing changes on May 12.

If you're unsure which action to take, you can reach out to our Support team with your formula and the required output for additional assistance. 


Function Changes List

Function
Current Behavior
Updated Behavior
@AND()

Boolean strings do not work.

  • Input: “@AND('true')”
  • Output: #VALUE!
Strings with a boolean inside will work.
  • Input: “@AND('true')”
  • Output: 1
@HOUR()Returns an incorrect string.
  • Input: "@HOUR('6:30 AM')“
  • Output: 11
Returns a correct string.
  • Input: "@HOUR('6:30 AM')“
  • Output: 6
@IFERROR()Division by zero returns INF.
  • Input: “@IFERROR(10 / 0, 'Division by Zero')"
  • Output: INF
Division by zero returns the defined message.
  • Input: “@IFERROR(10 / 0, 'Division by Zero')"
  • Output: Division by Zero
@INT()Rounds negative numbers UP.
  • Input: “@INT(-10.8)"
  • Output: -10
Rounds negative numbers DOWN.
  • Input: “@INT(-10.8)"
  • Output: -11
@ISEVEN()If a string is passed, returns TRUE.
  • Input: “@ISEVEN('test')”
  • Output: True
If a string is passed, returns #VALUE!.
  • Input: “@ISEVEN('test')”
  • Output: #VALUE!
@ISNUMBER()A string with a number returns TRUE.
  • Input: “@ISNUMBER('1')"
  • Output: True
A string with a number returns FALSE.
  • Input: “@ISNUMBER('1')"
  • Output: False
@ISODD()If a string is passed, returns FALSE.
  • Input: “@ISODD('test')”
  • Output: False
If a string is passed, returns #VALUE!.
  • Input: “@ISODD('test')”
  • Output: #VALUE!
@LEFT()Without the num_chars parameter, the function defaults to the whole string.
  • Input: “@LEFT('ABC')"
  • Output: “ABC”
Without the num_chars parameter, the function defaults to 1.
  • Input: “@LEFT('ABC')"
  • Output: “A”
@OR()Boolean strings do not work.
  • Input: “@OR('true')”
  • Output: #VALUE!
Strings with a boolean inside will work.
  • Input: “@OR('true')”
  • Output: 1
@TRIM()Only removes spaces at the beginning and end of the string.
  • Input: “     MY      TEST    STRING.   "
  • Output: “MY      TEST    STRING.”
Removes spaces at the beginning, end, and duplicate spaces in the middle.
  • Input: “     MY      TEST    STRING.    "
  • Output: “MY TEST STRING.”
@TRUNC()If num_digits is negative, returns #VALUE!.
  • Input: “@TRUNC(999.99,-1)”
  • Output: #VALUE!
If num_digits is negative, returns the correct value.
  • Input: “@TRUNC(999.99,-1)”
  • Output: 990



Terms of Service · Privacy Policy