Joining from Event Surveys to Registrations

Event survey responses are stored as form responses. When a registrant submits an event survey, the survey response can be connected back to the related event registration by comparing the survey response's record value to the registration form response GUID.

Use an independent subquery join when you need a query that starts from event survey responses and then returns details from the associated event registration.

For background on configuring surveys, see Event Surveys. For more information about joins, see Joins.

⭐ Get Inspired

This article was adapted from a post by Technolutions staff in the Slate Community Forums' Get Inspired space. Have a great idea for a Get Inspired post? Let us know!

Create the join

1. Start a query that returns one row per event survey response. One way to do this is to select New Query from the event survey form.

2. Select the subquery button next to Join.

3. Set Name to Associated Event Registration.

4. Set Type to Independent subquery.

5. Set Category to Related.

6. Set Base to Form Responses.

Add the comparison filter

1. Add a subquery filter.

2. Set Name to Event Survey Record = Form Response GUID.

3. Set Aggregate to Comparison.

4. Add the Record GUID export from the event survey response.

5. Add the GUID export from the form response.

6. Add both exports to the comparison and select Save.

Use the joined base

1. Set Base to Form Response (independent subquery).

2. Select Save.

3. Add exports or filters from the joined form response base as needed for the event registration data you want to return.

Result

The independent subquery join connects each event survey response to its associated event registration. After the join is saved, the query can return event registration details from the joined form response while still using the event survey response as the primary row.