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

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

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.

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:

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

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:

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:

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