Variable Data

  • pagins
    Asked 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?

  • BJoanna
    Replied 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.

    1603902779 5f999d3b07148 formula1 Screenshot 10

  • pagins
    Replied on October 28, 2020 at 1:28 PM
    Sorry, 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.*
    ...
  • BJoanna
    Replied 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:

    1603910800 5f99bc906fc7d defult Screenshot 10

    You can also perform a calculation in your form or set calculation in Table to calculate submitted data.

    How to Perform Form Calculation Using a Widget