--- title: "Create QR Codes for Upcoming Events" slug: "create-qr-codes-for-upcoming-events" status: "new" updated: 2026-08-24T14:16:52Z published: 2026-08-24T14:16:52Z canonical: "knowledge.technolutions.net/create-qr-codes-for-upcoming-events" --- > ## Documentation Index > Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt > Use this file to discover all available pages before exploring further. # Create QR Codes for Upcoming Events 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. > [!NOTE] > 💡 You can generate a QR code in Slate for an individual event in [Edit Form → Embed Form](/v1/docs/embedding-forms). 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. > [!TIP] > ⭐ Get Inspired > > This article was adapted from [a post by Technolutions staff](https://community.technolutions.net/get-inspired/post/query-with-qr-codes-for-upcoming-events-9vOcxlIVqLO6P7N) in the Slate Community Forums' Get Inspired space. Have a great idea for a Get Inspired post? [Let us know](https://community.technolutions.net/get-inspired/new?post_type=gnHx7As1gZ8r6Ld)! ## Creating the query 1. Go to **Queries / Reports**. 2. Create a Configurable Joins query on the **Forms/Events** or **Form** base, depending on the base name available in your database. 3. Add exports that help staff identify each event, such as event title, trip, template, folder, user, location, and start date. 4. 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 > [!WARNING] > 📝 Note > > This example uses the third-party [goQR.me QR code API](https://goqr.me/api/doc/create-qr-code/). Review your organization's policies for third-party services before using the generated QR codes in a live process. 1. In the **Exports** section, select **Subquery Export**. 2. Name the export, such as **QR Code**. 3. Set the output to concatenate the query parts into one value. 4. Set the export **Format Type** to **HTML**. 5. 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**: `&amp;size=150x150" alt="" title="" />` 6. Select **Save**. ![QR code subquery export configuration](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/01-4fv56QYbVW0eDaWqiiCPb.webp) ## 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. ![Query results with generated QR codes](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/02-dbxFFU8GFDkODqYZU8C96.webp) ## 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. > [!NOTE] > 💡 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. ## Further reading 📖 [Creating a Query](https://knowledge.technolutions.net/docs/query-elements) 📖 [Subquery Exports & Outputs](https://knowledge.technolutions.net/docs/subquery-exports-outputs) 📖 [Adding and Configuring Exports](https://knowledge.technolutions.net/docs/adding-and-configuring-exports)