To load or reload the registration list, select Extensions -> BA Eventbrite Sync -> Load / Refresh Registration List for Event.  

Two tabs, displayed at the bottom of the screen, will be generated within the Google Sheet:

• Participants - populates with the current registration data for your event.  

• ParticipantRoles - provides the list of roles that can be selected within the Current Role column within the Participants tab.  This list of roles can be customized based on event type. 

5.  In addition to the data items maintained by Eventbrite, BA Eventbrite Sync provides several additional columns organizers can use to capture information about each registrant.

• The Current Role column can be used to track how the registrants are currently anticipated to participate, as opposed to the role for which they originally registered via the Ticket Type.

• The Confirmed checkbox can be used to track whether a registrant's attendance has been confirmed after they initially registered.

• The Notes column can be used to add any information about a registrant the organizer would like to capture.

• The Attendance Status column is relevant only for in-person events. It can be used to mark whether a registrant actually attended the event.  To do this, change the pulldown from Registered to Attended. Other possible values for Attendance Status are Cancelled and No-Show.
  The following section "Reporting In-Person Event Attendance" describes why this is important for in-person events and how to send attendance data to Action Network once it has been collected for event registrants.

• You may also add any additional columns desired to the Participants sheet.

6. If an event registrant has information in Action Network (Braver Angels contact database and mass emailing tool)  in any of the following fields, they will be displayed in the same row as that person's Eventbrite registration info:

• County

• Is Member?  (Y or blank)

• Is Lapsed Member?  (Y or blank)

• National Newsletter Subscription Status (subscribed, unsubscribed, bouncing, etc.)

• Action Network Tags (list of tags)

• Events Registered (list of all events they have ever registered for)

• Volunteer Interest (list of volunteer interests indicated in member profile)

• Volunteer Roles (list of trained volunteer roles)

7. To sort the sheet, click on the spreadsheet menu item Extensions -> BA Eventbrite Sync -> Sort Sheet By. Currently available options are "Registration Date", "Ticket Type", "Last Name, First Name", and "First Name". You can also sort by any column using the upside-down triangle symbol displayed to the right of each column header.

8. To reduce the number of columns displayed, the best practice is to hide columns rather than deleting them. To hide columns, highlight the columns you do not wish to see, then execute the "Hide" command in the menu displayed by clicking the right mouse button (on Windows) or control-clicking (on MacOS). If columns are deleted rather than hidden, refreshing registration information (as described in item 9 below) will result in a garbled information display.

9. To share the registration list with other event staff members, click the Share button in the upper right of the spreadsheet. Then enter their email addresses, add a message if desired, then click Send.

10. To obtain current registrant information from Eventbrite after the initial data has been loaded, re-select the BA Eventbrite Sync -> Load / Refresh Registration List for Event menu item.  Any data you have written to the sheet will be preserved.  The date and time that registration data was loaded can be viewed by hovering the mouse over cell A1 of the spreadsheet, the one displaying the heading "Attendance Status".

11. If you need help with any of the above, email field-tech-support@braverangels.org

Please reach out to field-tech-support@braverangels.org if you need further assistance