Samantha, what you said about the columns did work for us!

Something to note is there were at least 8 columns additionally that exported that I didn't select. Many of them were blank, but still exported. Ideally the Excel spreadsheet wouldn't need to be formatted so much once exported. I'm not sure where those blank columns were coming from but they were neither on our registration form, nor on the column selections.

Thank you!

Hello,

For those having trouble getting Participant Options into an exportable format, you can add each Participant Option that has been setup as a column to your participant list, where it can then be exported. On the Participant List, choose "Columns." Near the bottom of the list of available columns, you'll see the participant options you've setup for your event. You can select which ones you want to see/include on your Participant List. Once on your participant list, you can view the participant responses to the options, or further filter down the participant list by responses to a specific option. The list with the participant options is then available to export.

Give that a try and see if that solves your problem of exporting additional information. into an excel spreadsheet, and please let us know if that worked for you or if there's a different problem you're running into.

Thanks,
Samantha McGuin
Principal Product Manager

Yes our VBS registration is very difficult to use and we haven't even gotten to our usual 300+ we get every year. Currently our event has the option to purchase a VBS t-shirt with registration which is free. I am trying to find out who has paid for a t-shirt and who has not and the only people who paid in the excel spreadsheet is the information placed in the payment fill in area. But the t-shirt size is asked in the registration area. So filtering that out is incredibly tedious. I am forced to sort by payment, then sort by names and if they bought two and didn't for others which registration child got the t-shirt and which one didn't. We should be able to have each of the payments sorted from the fees they selected. See the attached screenshot for an example. I can't find who selected what fee and the form that is used on each of those selections. The same goes with the allergies. We use wrist bands for those kids that need the allergy/medical awareness and we print their parents information on them. Sorting through whose parent goes to which child and other participant options is incredible tedious.

Event Registration custom Participant Options: These are only available in Webview and do not pull into the database, which is a huge problem. The way to retrieve this information is not only inconvenient, but inaccessible to non-Blackbaud users who need to use the information to plan and execute an event, especially a large event.

Our church is using an online Blackbaud event registration form for VBS signups. We have Participant Options questions ranging from allergy information, to who can pick up a child, to what age/grade a child is. This information needs to be accessible at-a-glance. At the very least, an Excel spreadsheet that recorded all of the answers to Participant Questions is needed. At best, this information could somehow be pulled into an individual's record, as well as able to be exported for easy-to-read offline use. (This might require Blackbaud adding more default options to forms that were in-sync with the database so it would put allergy information, etc. in the appropriate areas within a constituent record).

It is imperative we do not miss any of this sensitive information. By manually clicking through 100+ registrants and their 10+ Participant Options each, this isn't ideal and leaves too much room for human error.

Thanks for looking into this! This would be a huge win even with an Excel sheet export! :)