Can I split the Product Details into columns in Jotform Tables?

  • Profile Image
    jean.whalen
    Asked on February 17, 2021 at 11:26 AM

    I must be missing something but how can i create a list of the products our staff has ordered, individually with the chosen options? I only see a column with each submissions total order listing. I'd like to export an excel file with the total number of products so i know how many of what items to purchase and the sizes needed. I know i'm probably just looking in the wrong section.

  • Profile Image
    Katherine_W
    Answered on February 17, 2021 at 02:22 PM

    Hi there,

    Happy to help!

    By default, products are shown in a single column in Tables view as you had mentioned. To view each purchased product's details, you need to click on the product cell or click on the view button to expand the product details.

    1605663435_5fb47acb2cf8a_8.png

    From there, you can certainly Download the details.

    I have opened a feature request with our development team to have the Product details (ie. size, type, quantity, price) separated into their own columns. While I cannot guarantee that this will be implemented, if/when our team has an update for you, we will communicate it to you here.

    In the interim, you could create a Visual Report in your report builder that breaks down the product details. I created a clone of your form 210134749894160 and submitted a few test submissions for 'dummy data' for the purposes of this example:

    1613589636_602d6c847ff0c_createvisreport

    So, you can easily customize the data and how it is displayed in your report, and then download it from there.

    I hope this helps! Please let us know if we can assist further.

  • Profile Image
    jean.whalen
    Answered on February 18, 2021 at 12:13 PM

    Hello - I do hope your team is able to meet this request. I see many templates for order forms on your site so i cant believe it doesnt already do a breakdown collection of the products. The thought of having to go "old school" like in the past with tallying up the orders makes me cringe.

    I am very impressed with jotform overall though. It has solved our problem for collecting the data . . . now if i could just get to the data better know that its rolling in daily. Please beg them to solve this for us :)

    thanks!!

  • Profile Image
    BDAVID
    Answered on February 18, 2021 at 03:47 PM

    Hi, this has been added to our feature request list. Please note that there is no estimated time-frame for an implementation. If this is implemented in the future, you will be notified here.