This article helps you create a query that displays QR codes for upcoming event registration forms. This approach can help staff quickly open a registration form from a phone or projected display while they are traveling, recruiting, or working at an event where they do not want to search for each event link individually.
The query uses a Form-based Configurable Joins query and an HTML subquery export. The export builds an image tag that sends each event registration URL to a QR code generation service.
📝 Note
This example uses the third-party goQR.me QR code API. Review your organization's policies for third-party services before using the generated QR codes in a live process.
⭐ 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!
Creating the query
Go to Queries / Reports.
Create a Configurable Joins query on the Forms/Events or Form base, depending on the base name available in your database.
Add exports that help staff identify each event, such as event title, trip, template, folder, user, location, and start date.
Add filters to return only the events that should appear in the query. For example, filter by trip, template, folder, assigned user, active status, or an upcoming start date range.
Adding the QR code export
In the Exports section, select Subquery Export.
Name the export, such as QR Code.
Set the output to concatenate the query parts into one value.
Set the export Format Type to HTML.
Add the following query parts in this order:
Literal:
<img src="https://api.qrserver.com/v1/create-qr-code/?data=System Database HTTPS
Literal:
/register/?id=Form GUID
Literal:
&size=150x150" alt="" title="" />
Select Save.
Previewing the query
Run the query and confirm that the QR code column appears for each returned event. Scan a QR code from a test event before sharing the query with staff. The scanned code should open the event registration form.
Understanding the QR code URL
The subquery export creates an HTML image tag for each row in the query. The image source calls the QR code API and passes the event registration URL as the value of the data parameter.
The generated URL uses the following parts:
QR code API URL: Sends the registration link to the QR code generator.
System Database HTTPS: Adds your database's public HTTPS domain.
/register/?id=: Opens the public registration route for a form or event.Form GUID: Identifies the specific event registration form.
size=150x150: Sets the QR code image size to 150 by 150 pixels.
Using the query with staff
Share the query with the staff members who need quick access to registration QR codes. Before travel or an event, staff can open the query, filter to their assigned events, and display the relevant QR code for attendees.
💡 Tip
Keep the query filters narrow enough that staff can quickly find the relevant event. A query that returns only upcoming events for a trip, folder, or assigned user is easier to use while traveling.