How to perform calculations in Input Table?

Hello,

I am trying to add several columns within a single row together to give me a line total. Can you provide instructions on how to accomplish this?

Thank you,

Jake

Hi Jake,

Thanks for reaching out to Jotform Support. Can you explain a bit more about your question, so I can help you better? If you want to perform a calculation in your Input Table, you need to add calculation values for your columns. But this requires a form calculation widget to do this.

You can also use conditional logic to perform calculations in the Input Table field, and output the result on a text box field within the same Input Table field. But if you can give us more information on how the calculation works in your Input Table, we can help you to accomplish this.

Keep us updated and let us know if you need any more help.

So what I am trying to do with each row in the table is this:

The only fields the user will need to populate are 'Amount", "Tip", "Claim %", and 'Receipt total' and "Total claim" will be calculated values

Amount + Tip = Receipt total Receipt total * (Claim % / 100) = Total Claim

Amount + Tip = Receipt total

Receipt total * (Claim % / 100) = Total Claim

Hi Jake,

I tried setting up conditions to calculate the receipt total and total claim. Could you please check if this meets your requirements? Let me show you how I configured it:

1. In Form Builder, click on Settings at the top.
2. Click on Conditions on the left, and click on Add condition.
3. Select Update/Calculate Field.
4. Now, set up the conditions. You can copy my conditions as shown below.
5. Lastly, click on Save.

Here's my result:

Here's my demo form. You can clone it to test or inspect.

If the calculation meets your requirements, you can replicate the process for each row.

Keep us updated and let us know if you need any more help.

Thank you both this was very helpful and my form is now complete with correct calculations.

Hi Jake,

Since your new question is related to another topic, I have moved it to another thread. You can check it out here.

Let us know if you have any other questions.