I use Purcahse Order (product selection) widget and need consolidated report

  • Profile Image
    Asked on September 26, 2016 at 05:33 PM

    I am using a Purchase Order widget on the form, and when I get the Excel report see all the products grouped in one column.

    I need to know how many of each product was ordered from all submissions.

    How do I do that?

  • Profile Image
    Answered on September 26, 2016 at 09:33 PM

    This is how the Purchase Order payment field work.  The items/products in the payment field will always be considered as single element only.

    So the output report or spreadsheet will always contain the data in a single column only since it is reading the data on single field only.

    If you want the items/products on your Purchase Order Form results/output to be individually configured in the output report, then, you will need to use custom Purchase Order.

    You can do this using individual fields for each of the items/products you want to use on the form.

    Example: https://form.jotform.com/62697911369975


    Hope this help. Let us know if you need further assistance.