Downloaded Spreadsheet/CSV: Only display the product selected in the payment field

  • Profile Image
    Andrew_Knowles
    Asked on October 26, 2021 at 05:27 PM

    Also, with the sheet that is created through you guys website is there a way to simplify the square information that is displayed on the sheet? When populating the spreadsheet from there as a downloaded CSV it shows a lot of excess information that makes it hard to read.

    Let me know if this makes sense to you or if you need to explain more. So sorry.

  • Profile Image
    VincentJay
    Answered on October 26, 2021 at 05:29 PM

    Hi,

    Could you please share a screenshot of the issue so we can check it? To post a screenshot here on the support page, please follow this guide so we can see the image or screenshot properly: https://www.jotform.com/help/438-how-to-post-screenshots-to-our-support-forum/

    We'll wait for your response. Thank you!

  • Profile Image
    Andrew_Knowles
    Answered on October 26, 2021 at 05:49 PM

    Gladly, thank you for your help. The first image is the way the "Square" orders are shown in the "submissions" view.

    1635284790_6178773608d50_Screen Shot 202

    The second image is how the data is displayed when downloading the spreadsheet (whether I choose CSV, Excel, or PDF).

    1635284892_6178779cc58ea_Screen Shot 202 I'm hoping to simplify the data that is produced in the spreadsheet to reflect the way it appears in the "submissions" view on your website (first image). Thanks!

  • Profile Image
    Vick_W
    Answered on October 27, 2021 at 12:17 AM

    Hi there,

    The information in the product list field will always appear like this. This field is linked to the payment integration and unfortunately, the data it displays can not be changed.

    However, once it is downloaded as an Excel file you can make the changes in it as per your requirement.

    Let us know if you have any questions.

    Thanks

  • Profile Image
    Andrew_Knowles
    Answered on October 27, 2021 at 11:21 AM

    Just to confirm/clarify. They way the data is shown in the "submissions" view is what we need.1635347840_61796d80c8441_Screen Shot 202

    There is no way to download the sheet/info as it appears above?

    Thanks!

  • Profile Image
    gerardw
    Answered on October 30, 2021 at 07:59 AM

    Sorry when you download the submission as excel, you cannot view the items exactly as shown on the tables page.

    You may try creating a Grid listing or HTML table listing report if that helps:

    https://www.jotform.com/help/105-how-to-create-a-grid-listing-report/

    https://www.jotform.com/help/209-how-to-create-an-html-table-listing-report/

    Otherwise, we can escalate as a feature to check if this is possible on the excel download itself.

    Please check and let us know.

  • Profile Image
    Andrew_Knowles
    Answered on October 30, 2021 at 02:04 PM

    Thanks for your ongoing help with this.

    I don't believe the Grid is what we are needing.

    Yes, it would be so very helpful if upon download, or perhaps even through an integration like Google sheets or something else/another 3rd party integration that can convert the data into a sheet the way it as seen on the "submissions".


    Thank you again for all of your help!

  • Profile Image
    Lorenz_A
    Answered on November 01, 2021 at 09:07 AM

    Hi there,

    I have escalated this to our devs as a feature request.

    Please take note that we cannot give any ETA or assurance about this feature, but if in case the requested feature got implemented, we'll inform you here right away.

    Thank you.