Help with submissions / reports

  • jbird_90
    Asked on November 3, 2021 at 11:47 AM

    I have an order system setup using jotform. But the products have different sizes. How do I get the size ordered to show up in my submissions or reports. Right now it only shows the main item. It doesn't show the size of that item they ordered.


    ThanksJustin


  • Johann_A
    Replied on November 3, 2021 at 2:27 PM

    Hi,

    Can you please share the link to the form, so we can see the report?

    Johann

  • jbird_90
    Replied on November 3, 2021 at 3:56 PM

    https://www.jotform.com/report/21306371406604603


    Here is the link. I want to know what size turkey each customer ordered by looking at the report. As of now, I have to go into submissions and click each order to find out what they want. I ultimately want to know how many turkeys of each size I need for the holiday.



    Thanks

    Justin

  • Martin_A
    Replied on November 3, 2021 at 7:29 PM

    Hi there,

    When a submission is made to your form you are provided with all the details through the Submissions data in Tables and in your Notification Email. We use the Report Builder to give a more visual approach to the data in our forms, by using different styles, colors, and schemes. Because of the predefined styles we use when creating our report, some data cannot be shown in a creative visual style.

    A solution to your request can be done by implementing the Grid Element into your report. The Grid Element enables the fields from the Submissions data Tables to be presented. You can choose which field to be presented on the Grid Element in your report, so you can have the additional information you need in your report.

    1635982083 61831b0328842 Report%20builde Screenshot 10

    Let us know if the information provided was of any help to you.

  • jbird_90
    Replied on November 4, 2021 at 5:53 AM

    Thanks for response. That is closer to what I am looking for. I added the grid, but still in need of a product breakdown to aid with my sorting and ordering.

    If I export the grid to exel or a different format will it break down the products by size class?

    I still need more of a summary field for different sizes within the products. The grid still seems to fall short of giving me what I am looking for.


    Justin

  • Nikola JotForm Support
    Replied on November 4, 2021 at 7:10 AM

    You can filter submission by size.

    1636024206 6183bf8e0b911 filter Screenshot 10

    Related Guide: How to Search a Submission from the Submissions Page

  • jbird_90
    Replied on November 4, 2021 at 7:57 AM

    Bingo. That helps tremendously. Thank You