Using Advanced Formula in Jotform Tables

July 2, 2024

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

To use Advanced Formula

  1. In Jotform Tables, add or insert a new column. See How to Add and Organize Columns for more information.
The Add column button in Jotform Tables
  1. In the dialog, go to Formula at the top, then select Advanced Formula.
Steps to add Advanced Formula in Jotform Tables
  1. Enter your desired column name.
Steps to add Advanced Formula in Jotform Tables
  1. Create your formula in the editor.
  2. When finished, select Create Column.
Steps to add Advanced Formula in Jotform Tables

The formula editor has three major sections.

The Advanced Formula editor in Jotform Tables

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

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

KeyDescription
Up, DownFor navigating column or function suggestions.
TabFor inserting column or function suggestions or entered text.
Left, RightFor navigating through the formula. Also deselects the column or function suggestion.
Enter, EscFor inserting entered text.
BackspaceFor deleting preceding elements.


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 generated from your 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:

To update your formula, open the column’s menu, then select Edit Formula.

Steps to edit Advanced Formula in Jotform Tables
Academy Logo

Introduction to Data Management

Adding Columns and Action Buttons to Tables

Go to course :Adding Columns and Action Buttons to Tables
lesson-3 - image
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:

  • ofnhp5017 - Profile picture
  • Jared Ebrall - Profile picture
  • Tabitha Stalcup - Profile picture
  • wasim - Profile picture
  • Membership DSV - Profile picture