How can I break out ticket information when I download submissions?

  • bciwebadmin
    Asked on March 31, 2017 at 12:41 PM

    I built a ticket sales form to sell four different "products". When I download the submissions in Excel or CSV, all the product data (ticket types and quantities and money collected) exports in one column, making it difficult (impossible) to total and summarize. Is there any way that the different products and totals could export into four (or more) different columns? Ideally there would be a column for the product, a column for thequantity, and then maybe even a third for the $$. 

  • KadeJM
    Replied on March 31, 2017 at 2:35 PM

    From what I understand you're looking for a way to separate your form product details.

    We actually use to have it that way quite awhile back but, as far as I know it was changed to one cell for the opposite reason due to several complaints.

    You can split up the information with tags in an email notification but, it won't work outside that so I'm not so sure that doing so would benefit you here.

    Alternatively, you can try using an excel formula to copy and separate the data into other cells for you to then configure further.