How to set up tables and formulas

How to add tables and set formulas

In this section, we will show you how to add a table to a form and how to use a formula in the table.

---

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 creation 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.

 5. Click "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 "Register
　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".

That's all.
Thank you for reading to the end.

Related Keywords 👀
SmartFlow, tables, formulas, calculation methods

If you have any questions about the settings, please contact us at [e-mail].