Report data that I can customize.

  • peytonmusic
    Asked on November 15, 2017 at 2:02 PM

    Howdy!

    We're using this form to buy Christmas gifts for families in our community. 

    I've got an input table where we're collecting that data. As the time draws near to buy gifts, the shoppers will be asking me how many kids at each age and gender.

    Right now I have a report which comes sort of close (linked), but is it possible to generate a report which will tell me this in a glance?

    Ex: (Where "B" is for boy, and "#" is their age.)

    B-2

    B-2

    B-4...

    With something like that I could quickly tally how many boys at which ages we have and could do likewise with the girls. Does that make sense?


  • Marvih
    Replied on November 15, 2017 at 3:46 PM

    I think Grid report works on this one.

    Report data that I can customize. Image 10

    Or you integrate your form with Google Spreadsheet and apply a formula there to merge.

    Check out the guide below on how.

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet