Split custom fields text in multiple columns

Split custom fields text in multiple columns

If you use multiple custom fields, the answers will be displayed in a single column in the Roll Call report. In this situation, you might want to present the answers for each custom field into a separate column.

To do this, run the Roll Call report, having ticket the 'Show All Fields' option and download it (click on the blue 'Export as CSV' button when viewing a report).
  1. Open the CSV file in Microsoft Excel and you will see in column Q the custom fields answers your customers have provided for each order.
  2. Select column Q and select Data > Text to Columns
  3. In the Convert Text to Columns Wizard, select Delimited > Next
  4. Select the Comma delimiters and select Next
  5. Select column Y as the Destination, and click Finish

    • Related Articles

    • Combine Reports

      In some circumstances, you might want to combine the data found in two separate reports. You just need to ensure that both reports have at least a unique variable in common: e.g. email address or order number. For example, you might want to see the ...

    • Reconcile your accounts with Stripe

      To reconcile your Little Box Office and bank accounts with Stripe, you need access to the reports or statements for all three. The Little Box Office Sales reports can be reconciled with the Stripe's 'All payments' report (found in the 'Payments' ...

    • Reconcile your accounts with Braintree

      To reconcile your Little Box Office and bank accounts with Braintree, you need access to the reports or statements for all three. The Little Box Office Sales reports can be reconciled with the Braintree's Transactions reports: Your Bank account ...

    • Add or change an event text

      You can amend the text displayed for a particular event. These appear on the front and More Details pages of your box office. You can change the wording and the formatting of the text as well as upload a new image for your event. Go to the Events ...

    • Change your admin password

      There are several ways of changing the password you use to log in as an administrator, but the easiest one is to: 1. Click on the circular black [Profile] icon on the top right of the screen on any admin pages to open your "User Details" page: 2. ...