Separate payment product items into different columns when exported to Excel

  • dhake
    Asked on January 24, 2018 at 2:40 PM

    How do I set up a form that when needed will export the items purchased into separate Excel columns.  I have done several forms in the past and they have all dumped the items ordered into one column.  This then takes an exorbitant amount of time to get Excel to divide them into columns.  Sometimes, it doesn't even work.  When you have about 20 items ordered, it gets to be a long process.  

    I am looking for a way to set up the initial form that it will just do this automatically without having to waste time in Excel.

    The link I am adding is a past form we used.  I am wanting to start over this year with a new one that will do what I need it to do without more time invested.


    Thanks

  • Elton Support Team Lead
    Replied on January 24, 2018 at 3:00 PM

    The product data are still displayed as the following into the Spreadsheet file. They are placed in a single cell.

    Separate payment product items into different columns when exported to Excel Image 1 Screenshot 20

    Unfortunately, there was no update made in this. 

    Let me escalate this to our developers instead so it would contribute to the existing requests related to this and hopefully our developers would take this into consideration. We will let you know via this thread once this is added in the future updates.

  • dhake
    Replied on January 24, 2018 at 3:16 PM

    Thanks.  We would need the corresponding quantity to be in a separate column, as well.  This will aid in the ordering process on our end.  In our camp situation, it will give us quick, real-time enrollment numbers.

  • jonathan
    Replied on January 24, 2018 at 3:59 PM

    Thank you for providing more details about the requested feature. We have added them in the feature list already. 

    We will notify you here for any news/updates on the status.