- busalacrAsked on January 11, 2018 at 12:20 PM
I am using a table with text selections. I would like to be able to have a count and total for every tiem a selection is made.
Please see Office Hour table at https://www.jotform.com/build/80098305584158
Would like to have a total (count of each half hour) for each day of the week and a grand total. Is it possible?
- JotForm SupportMikeAnswered on January 11, 2018 at 01:55 PM
The issue is that we cannot assign calculation values to the dropdown items within the input table. However, as a workaround, you can add '1' to each dropdown item. The calculation will be able to capture the '1' values.
- Add the 1 values.
- Perform calculations, see the next guide.
This way you can calculate a total for each day of the week and grand total using separate Form Calculation fields.
If you need any further assistance, please let us know.