What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How can generate more useful submission reports from my form?

    Asked by mountaintoppizza on October 18, 2012 at 04:48 PM

    To Whom It May Concern: 

    I am a teacher at a small private school and we are using jotform for our online pizza lunch ordering form. We have created a form that gives customers the option of placing an order for multiple days. We have also used the Total Payment tool so that customers can see their Total Payment for their order. 

     

    Here are the problems:

    1) When we generate a report of our submissions the xcel spreadsheet puts the Food Order in one cell. We are not able to tally up the different food items separately. We have worked around this problem by creating additional columns and we manually transfer the items of the Food order into the different columns. 

     

    2) Since we give customers the option of ordering for more than one date, the submission report puts all the dates into one cell and we are not able to successfully filter that column to tally up the food order for one date at a time. 

     

    Here are our needs: 

    1) To be able to generate a submissions report with separate columns for each date. 

    2) To be able to generate a submission report with separate columns for each food order item while still giving customers a Total Payment at the end of submitting their order. 

     

    Thank you for your help, 

    Britt Gendell

    Page URL:
    http://jotform.us/form/20994268739167

  • Profile Image
    JotForm Support

    Answered by NeilVicente on October 18, 2012 at 05:07 PM

    Hello Britt,

    1) To be able to generate a submissions report with separate columns for each date.

    Checkboxes allow multiple selections, and the selections are being dumped on a single column to prevent messing up the Excel or the grid layout. Imagine what a report would look like with separate columns for a checkbox that would allow, say, 20 or 30 selections?

    A great alternative to this is the Visual Report feature. Check out this link: http://screencast.com/t/UQuyxPjHFef

    I have created one for your form. You may access and edit it by going to the My Forms area, selecting the form and clicking the Reports button.

    http://screencast.com/t/BKVYQkZAGch

    2) To be able to generate a submission report with separate columns for each food order item while still giving customers a Total Payment at the end of submitting their order.

    The food order items can be separated (from the downloaded Excel report) by use of special Excel functions/forumals. I will try to find a solution for this and will get back to you soon.