Inspiration
Driven by the need for simple, scannable event information shared using accessible tools directly used to promote organizer events, or community/club websites.
How we built it
Leveraged Google Workspace for rapid development:
- *Google Forms: * A Front-End Development for event detail inputs that is User-Friendly.
- *Google Sheets: * Central data storage and trigger for QR code generation.
- "QR Code Generator" by AnyMerge: A Google Sheets add-on for automatic QR code creation from the event page URLs.
- *Google Apps Script: * The automation engine:
- Listens for form submissions.
- Creates event pages on Google Sites.
- (Initial Attempt) Email QR code that links to the organizers/website for consumers.
- Provides on-screen confirmation.
- ** Google Sites: ** Platform for quickly displaying even details via generated QR codes. Google Apps Script acted as the integrator, connecting data input to QR code generation and information display.
Challenges we ran into
There were problems with troubleshooting the initial trigger setup, the complexity of automatically accessing and emailing QR code images from the add-on, the difficulty of dynamically embedding QR codes on Google Sites and understanding the limitations of the chosen add-ons. Despite these, I have achieved a functional prototype for automated QR-linked event information.
Accomplishments that we're proud of
I'm proud of creating Automated event info to QR-linked Site pages for future events, and event creating a QR page for Resume Profiles for career networking. Additionally, using a Google Workspace integration that was seamless into a simplified QR generation via add-ons, and rapid prototyping.
What we learned
The key takeaways learned included the power of Google Workspace integration, the utility of third-party add-ons, understanding asynchronous web development flows, basic web concepts with Google Sites, debugging in Apps Script, and the implicit API interactions of add-ons.
What's next for the Event QR Code generator
For the project's future, I'll improve the QR integration on Sites/email with additional features like customizable QR options, UI enhancements, and better error handling. Moreover, I'll explore alternative QR generation methods.
Built With
- anymerge
- github
- google-apps-script
- google-apps-script-apis
- google-cloud-platform-(implicit)
- google-docs
- google-drive
- google-sheets
- google-sites
- html
- javascript
- qr-code-generator
- qr-code-generator-by-anymerge-(google-sheets-add-on)
Log in or sign up for Devpost to join the conversation.