-
earlfreemanAsked on May 9, 2024 at 10:11 AM
-
Israel JotForm SupportReplied on May 9, 2024 at 10:19 AM
Hi Earl,
Thanks for reaching out to Jotform Support. Please note that the total submission of the form was display at bottom left side of the submission table. Take a look at the screenshot below:
If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?
Keep us updated and let us know if you need any more help.
-
earlfreemanReplied on May 9, 2024 at 10:27 AM
I was wanting to see if a another column could be added that would show the dollar value of the submission without going to the view.
Also could have the grand total dollar value of all submissions.
-
Angeli JotForm SupportReplied on May 9, 2024 at 10:59 AM
Hi Earl,
Thanks for getting back to us. Unfortunately, it's not possible to directly show the Total Amount or Sales from the Product List field on the Tables page. I've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. We’ll circle back to this thread and let you know if there are any updates.
A workaround for this is to add a Number Field and pass the value of the Product list field to the Number field. I'll walk you through setting that up:
1. Add a Number field.
2. Create a condition to copy or pass the value of the Product list field to the Number field like you see below:
Here's the result:
Then, you can get the Sum of the values in the Number column to get the Total:
Give it a try and let us know if you have any other questions.