Input Table: I would like to be able to have a count and total for every time a selection is made

  • Profile Image
    busalacr
    Asked 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?

  • Profile Image
    Mike
    Answered 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.

    How to Perform Form Calculation Using a Widget

    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.