Jotform Form Builder : Being Able to Make Conditional Calculations for any Input Table Cell

  • Profile Image
    bcottam89
    Asked on February 23, 2021 at 07:45 PM

    Hello,


    I want to have a table as follows

    Task Quantity Unit Rate Total

    Monday

    Tuesday

    Wednesday

    Thursday

    Friday


    In the task column which is a dropdown i want to list all the tasks. Task A, Task B, Task C, Task D.

    When a task is selected i want there to be a rate assigned to that particular task which is then automatically entered into the rate column.

    The user then inputs the Quantity and the total is calculated by Quantity x Rate

    However i cannot work out how to convert Selection of Task into a numerical rate in the Rate Column. Each task has a different rate assigned to it.

    Your help would be amazing.

    Thanks,

    Ben

  • Profile Image
    sylas
    Answered on February 24, 2021 at 03:38 AM

    Hi bcottam89,

    I'm working on your request. You'll be updated under this thread once I'm done. Thank you for your patience.

    Do not hesitate to contact us if you have any further questions.

  • Profile Image
    sylas
    Answered on February 24, 2021 at 04:08 AM

    Hi bcottam89,

    Unfortunately, it is not possible to change the rate input according to the corresponding task input (separate rows). Condition (Update / Calculate Field) settings allow us to select the whole field as a control field and only one cell as summary as you can see below:

    1614155610_60360f5a85d21_

    I have escalated this as a feature request to our developers. However, I can’t give you an ETA on it, as it depends on their workload. You will be informed via this thread if they have any updates.

    As a workaround, you can calculate the values separately (each cell will be an individual field) for each day. To achieve this,

    1) Click Add Form Element and select the corresponding fields (Dropdown for tasks, number or text for the others),

    2) Set options line by line for the Dropdown field under Dropdown Properties (Gear Icon) > Options.

    Note: Sorry for the typo, Range should've been Rate in the example below

    1614156678_603613861d12c_

    3) Go Settings > Conditions, click Add a New Condition and select Update / Calculate Field. In the example below, I set my Monday rate as 0.5 when Task A is selected:1614157108_60361534769af_calc_rate.gif

    4) Add another new condition to calculate the total by multiplying Rate and Quantity, and insert into the Total field. Kindly check if the Rate and Quantity fields are filled. You can create more than one control fields by clicking on the plus button on the right:

    1614157596_6036171c10cfc_calc_total.gif

    This is my sample form. Feel free to clone and test it out. You can apply the same process for the remaining weekdays:

    https://form.jotform.com/210541454333951

    Do not hesitate to contact us if you have any further