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. We want to create a formula using "Column (列)" and "Column 2," so click "Add New Column" to display the three columns.
3. Click on "Column 3."
4. Check the formula and click "Save."
If you change "Column 3," you can set the title of the column.
The following is an example of how to set up a formula for "Column 1" + "Column 2" = "Column 3"
5. Click "Mathematical Formula."
The "Total" will be displayed in the column where the formula was created.
6. Create a formula from the pull-down menu and click "Submit."
Make sure to leave the formula in the first column blank (unentered).
7. Publish the form after setting the approval route and permissions.
8. Go to the actual application screen.
The table you just created will be displayed and if you enter a number, the answer will be displayed in "Column 3."