How do I tally the selection from a table in the form?

  • Profile Image
    Asked on June 18, 2020 at 05:17 PM

    Hi There

    I have further investigated and the form needs to work in the following way.

    If a Field is selected i.e Always Tired, then in the columns; numbers 1,2,4,5 and 8 need to be "selected" and count as 1 each. So column 1 = 1 and column 2 = 1 for example. 

    As a person completes the survey and selects different fields that are applicable each tick needs to calculate at the bottom.

    So what I would need assistance with is the following.

    If Always Tired is selected, all the tick boxes that are white need to be selected and count for 1 point. Then once the survey is completed all the ticks in column 1 need to be tallied at the bottom. 

    Secondly it would be preferred if once Always Tired is selected that all the available tick boxes in the row are automatically ticked and calculated. 

    How would I go about creating the above?

    If you need the link to the PDF please let me know. 


  • Profile Image
    Answered on June 18, 2020 at 05:40 PM

    You will have to do this on a separate table with Textbox type as the input or a separate calculation boxes.

    For reference:

    Here's a demo form you can check: Choose 1s. Is this how you want to tally the result? Please confirm.