Setting Up Tables and Formulas
In this section, we will show you how to add tables and formulas to a form.
Table of Contents
1. Add a Table
2. Add a Column
3. Open a Column
4. Set Up a Formula
5. Open a Formula
6. Register a Formula
7. Publish a Form
8. Submit the form
1. Click on "Add Table" at the bottom of the form builder screen.
2. Drag and drop elements from the left side of the screen to add to the table.
3. You will be able to add more elements to the table by dragging and dropping them on the right side.
4. Check the elements.
If you want to add a mathematical formula, make sure that all of the elements are "Number."
You can only add formulas to "Numbers."
The following is an example of how to set up a formula for "Number 1" + "Number 2" = "Number 3"
5. Click on "Edit" and change the names of the elements.
This will make it easier to make formulas.
6. Create a formula from the check box.
When the check box is filled, this table would show up, so select a field and select the operation (+, -, x, /) you want to use.
Click on "+ Add Record" to add another field.
Ex.) "Number 1" + "Number 2" = "Number 3" would look like the following.
7. Save the calculation and publish the application form.
8. Go to the actual application screen.
The table you just created will be displayed and if you enter a number, the sum of Number 1 and Number 2 will be automatically displayed in Number 3.
The table feature can also contain other elements like text fields.
Layout Elements are similar to tables, but you can add more than 4 columns using a table.
Calculations can be done even when not in a table, but it will be easier to see when in a table.