separate each product in PayPal Form submission

  • Profile Image
    KeshetBDC
    Asked on June 14, 2020 at 04:42 PM

    How can I have each product ordered appear under a separate tab/collumn (excel) rather than all grouped together under one tab?  Alternately, how can I duplicate the lunch ordering option so I can separate the lunches so the lunched ordered will appear under separate tabs?   


  • Profile Image
    Sonnyfer
    Answered on June 14, 2020 at 10:45 PM

    Hi there,

    How can I have each product ordered appear under a separate tab/column (excel) rather than all grouped together under one tab? 

    Unfortunately, payment fields are considered one field so it only occupies one column in the submissions.

    You can, however, download a copy of your submission as CSV/Excel format and then apply some Excel Formulas to achieve your requirement. Kindly refer to this Microsoft Guide for a sample formula.

    Alternately, how can I duplicate the lunch ordering option so I can separate the lunches so the lunched ordered will appear under separate tabs?   

    Unfortunately, you can only have one payment field on your form. You may refer to my answer to your initial question for the workaround.

    If you need further assistance, please let us know.