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
- In Jotform Tables, add or insert a new column. See How to Add and Organize Columns for more information.
- In the dialog, go to Formula at the top, then select Advanced Formula.
- Next, enter your desired column name.
- Next, create your formula in the editor, then select Create Column when finished.
The formula editor has three major sections.
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:
| Key | Description |
|---|---|
| Up, Down | For navigating column or function suggestions. |
| Tab | To insert a column or function suggestion or entered text. |
| Left, Right | To navigate through the formula. Also deselects the column or function suggestion. |
| Enter, Esc | For inserting entered text. |
| Backspace | For 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:
- Operators
- Text Functions
- Logical Functions
- Numeric Functions
- Date Functions
- Array and Record Functions
To update your formula, open the column’s menu, then select Edit Formula.
Send Comment:
8 Comments:
65 days ago
Logically, I should be able to concatenate 2 columns. One column with a URL and one column with the submission ID. However, it's not producing the URL with the submission ID appended, only the original URL from the URL column. I'm simply placing the concatenate action between the two columns I've selected. Is this not correct?
114 days ago
Hello, how can I convert this into a formula:
IF Column A has a date, then it should return "Scheduled" if not then it should be "For Scheduling"
I am having troubles navigating the advanced formula setting on tables
120 days ago
What formula to use to calculate three years from a column that has a date inserted
244 days ago
How can you get Jotform to consistently and reliably name the PDF attachments on submission emails based on an advanced formula that parses field values? We've been trying this all year and 75-80% of our PDFs arrive with the Submission ID as the file name and not the value set by the advanced formula.
More than a year ago
Is there any way to surface the result of an Advanced Formula on a Form and/or use it in the Conditions section?
More than a year ago
Why cant you also change the background color of the cell based on the output of the formula?...
More than a year ago
Dear Sir
i have problem Using Advanced Formula in Jotform Tables
some cells work & some not working
More than a year ago
Hi,
How do I edit an existing calculation.. or even identify which table columns contain calculations.
Have Read https://www.jotform.com/help/using-advanced-formula-in-jotform-tables/