-
paginsAsked on October 28, 2020 at 11:13 AM
We are building a database for a small business to track all activities, so that we can analyze cost inputs against production. The type of activity will drive the input fields that are available, much like conditional logic in a standard Jotform "form".
For example if an employee completes Activity A, then variable data fields B, C, D will be open for entry and stored in the relational database, drawing from cost tables that re stored in the background.
If on the other hand, an employee completes activity B, then fields E,F & G will be open for entry with dropdown fields that are available, as well as text fields.
All data will be used ultimately to calculate final production costs.
Is it possible to use Jotform Tables for this purpose?
-
BJoannaReplied on October 28, 2020 at 12:33 PM
Unfortunately, it is not possible to conditionally show columns in JotForm Tables. You can only add Calculation Formula.
-
paginsReplied on October 28, 2020 at 1:28 PMSorry, I was unclear.
We need to show conditional information on the entry forms and have it
store the data accordingly.
Second part of the question is whether we can store 'static data' in the
background to be used in calculations.
For example:
We want to calculate the cost per tray of a certain kind of vegetable plant
We have the soil cost
We have the seed cost
We would RECORD the harvest data in an entry form.
The soil/seed cost would be used in the calculation to determine the
production cost.
Can Tables be used in this fashion?
George Page
Page Insurance, Ltd
(203) 453-5259
www.pageins.com
*Office hours: Monday-Friday 9am-5pm*
*Please note that I check email a few times during the day. *
*If this is urgent, please call me directly.*
... -
BJoannaReplied on October 28, 2020 at 2:50 PM
I'm still not sure if you only want to use only a Table that is not connected to any form. If so, you can add the Single Selection column or Multiple Selection column to the Table and set a default value. You can then set formula to perform a calculation based on the values that are entered inside of the other columns.
Example:
You can also perform a calculation in your form or set calculation in Table to calculate submitted data.