Using Advanced Formula in Jotform Tables

Last Update: 

Advanced Formula is a column type in Jotform Tables where you can create equations or expressions that can perform calculations, return information, change values, and more.

How to Create an Advanced Formula Column

Here’s how you can create an Advanced Formula column in Jotform Tables:

  1. Add a new column.
tables-heading-add-column-min
  1. Go to the Formula tab, select Advanced Formula, then click Next.
tables-add-column-advanced-formula-min
  1. Enter a column name then click Next.
tables-advanced-formula-column-name-min
  1. Create the formula using the editor.
tables-advanced-formula-email-domain-name-min
  1. When you’re done, click the Create Column button.

How to Use the Formula Editor

The formula editor has three major sections.

tables-advanced-formula-editor-min

Create a Formula. The textarea is the visual editor where you create your formula and expressions. The editor automatically filters and shows any matching columns and functions as you type. Clicking the “T” icon will switch the editor to text mode.

Here’s a list of keyboard keys you can use in the visual editor:

Key Description
Up, Down To select a column or function suggestion.
Tab To insert the selected column or function suggestion or to insert what you typed in if no suggestion is selected.
Left, Right To navigate through the formula. Also deselects the column or function suggestion.
Enter, Esc To insert what you typed in.
Backspace To delete the preceding element.

Columns. The Columns section contains the list of available columns in your Tables that you can use as variables or arguments in your formula. This includes all supported column types either generated by the form or manually added in Jotform Tables.

Functions. The Function section contains all the available operators and functions you can use.

For more information on how to use the operators and functions, see:

Was this guide helpful?
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments: