-
jstefanAsked on June 1, 2021 at 6:50 PM
-
Kevin Support Team LeadReplied on June 1, 2021 at 11:09 PM
Unfortunately, I cannot understand your requirement, please provide us more details about what you would like to achieve, we will be happy to help.
-
jstefanReplied on June 2, 2021 at 8:10 AM
I would like the values in this column:
To calculate the total in this field:
-
Sam_GReplied on June 2, 2021 at 8:52 AM
Hello Jstefan,
Unfortunately, it is not possible to do that in the Input table field.
Here's a workaround:
1) Add one text field and set any default value in it (you should make that text field hidden):
2) then add conditions that will insert $(or whatever you need) into each Input table field, for example, I have this:
3) And then I created these conditions:
Please note that this needs to be done to each input field under amount.
Here's my cloned form: https://form.jotform.com/211523418900952
I hope this helps.
Let us know if you need further assistance.
-
jstefanReplied on June 2, 2021 at 4:50 PM
Hi,
I tried doing this, but it is not adding up the values in each row to calculate a total in the field titled "Total Amount". It's add "$" to those amount fields, but I'd like it to calculate the total automatically. It seems that is possible.
Thanks
-
Kevin Support Team LeadReplied on June 2, 2021 at 7:30 PM
I see your form is not configured to calculate the total yet, you can do it following these steps:
1. Disable the condition that inserts the dollar signs into the total amount field:
2. Open the Form Calculation widget settings and delete everything you have there, then click on the add field button:
3. The last step is to add the fields from the input table, on this step you can add the dollar sign manually at the beginning:
I hope this helps.
-
jstefanReplied on June 2, 2021 at 7:57 PM
Where exactly am I adding the dollar sign manually?
-
jstefanReplied on June 2, 2021 at 8:15 PM
More specifically....can I add a $ sign in each "amount" cell in that column?
Thanks
-
Kevin Support Team LeadReplied on June 2, 2021 at 11:32 PM
You can add the dollar sign to the calculation widget, here is where:
To add the dollar sign in the amount cell of the table, you can refer to the steps provided by my colleague on his response, note that these steps apply to the cells in the table only: https://www.jotform.com/answers/3134333#3135455
To add the dollar sign to the Total Amount field refer to my response above.
Also, while on the conditions section delete all those conditions with the "missing field" error or they can cause conflicts with other conditions.
Kindly follow the steps carefully to get it working on your form too.