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 a new column.
- Go to the Formula tab, select Advanced Formula, then click Next.
- Enter your desired column name, then select Next.
- Create your formula in the editor.
- Once you’re done, select Create Column.
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 | 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 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:
Send Comment:
4 Comments:
80 days ago
Is there any way to surface the result of an Advanced Formula on a Form and/or use it in the Conditions section?
138 days 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/