Show HN: Scan QR codes to check in guests registered via Google Forms

[komlan]

Hi HN!

I made a no-code platform for creating physical data collection apps, using QR codes [1]. It does not yet have a self-service config UI though, which limits adoption.

That's why I recently released a Google Forms™ add-on for QR code check-in, based on the platform. This focused use-case makes it easy to provide a fully self-service config UI.

How it works:

1. Create your Google Form as you normally would [2]

2. Activate the add-on if you hadn't already [3]

3. Craft a confirmation email to be sent to each form responder

Upon each form submission, the add-on will send a PDF with a unique QR code (a V4 UUID) to the responder.

Have guests present this code at the event, and record check-ins in bulk using the included QR scanner.

See here [4] for more information, or try the Google Sheets™ version [5] (which doesn't send email).

[1] https://admin.trak.codes/

[2] https://forms.google.com/

[3] https://workspace.google.com/marketplace/app/qr_code_ticket_...

[4] https://blog.darkaa.com/qr-code-pass-per-response-google-for...

[5] https://workspace.google.com/marketplace/app/qr_code_pass_fo...

[EduardoBautista]

The overview is one of the best descriptions I have ever seen for what an app does and why I should use it. Well done.

[komlan]

Thank you! I stole [1] this structure from "Obviously awesome" by April Dunford.

[1] https://news.ycombinator.com/item?id=38786113

[afandian]

Just a reminder to anyone using Google forms that you may exclude non-Google customers.

My child’s school uses them and it often the forms ask for a login. Google doesn’t necessarily respect your choice to make a form public.

[komlan]

Indeed. This happens when the form is configured to collect "verified" emails.

A form can use a custom field (doesn't require login), user input managed by Google Forms (named "Email", doesn't require login), or the google email of the user ("verified" email, requires login).

This add-on supports every one of these options.

[unmole]

> exclude non-Google customers.

There are literally dozens of them! /s

[alaskamiller]

What's cool also is that this is from the West African tech scene.

[komlan]

Busted! Curious what gave it away, my username?

[oh_sigh]

Is there actually an international West Africa tech scene? Or is it nation by nation?

[onetimeuse92304]

The issue is, at least for me, I consider all QR codes as unsafe. Unfortunately, you don't know where the QR code leads you before you scan it and then it is already too late. So you can't do the equivalent of inspecting the link before you click it.

Recently we were in a restaurant which required scanning a QR code to get served (for some reason asian restaurants like doing this). The codes were labels attached to the menu. I told the waitress "I can't scan the codes because I don't know who put the QR codes there". She told "the codes lead to their website". I told her "I don't know that, it takes a moment to print a label that looks exactly the same to my eye". She told me "it would then not point to their website". I respond if she knows what MITM attack is. She responded "if you can't afford a phone we should leave and go somewhere else".

The funniest is those QR codes left at random in public. I imagine scanning these is like finding a random pendrive and putting it in your computer.

[hnlmorg]

Not only is this the wrong place to vent your annoyances with QR codes (it’s tangential to the Show HN) but you honestly come across as an unpleasant customer if that’s how you interact with your restaurant servers (you could have just said “my camera is broken, do You have an address I can type instead”).

[EduardoBautista]

> Unfortunately, you don't know where the QR code leads you before you scan it and then it is already too late.

iOS shows the domain if it is a URL and you have to tap it. It's no different from tapping on a link on a website, which I would say is more insecure since you don't even get the domain info before tapping.

[beachy]

> Unfortunately, you don't know where the QR code leads you before you scan it and then it is already too late

What are you so scared of? It isn't the 90s where by tricking someone into following a dodgy link their windows machine was instantly pwned.

[simon_acca]

There’s apps that just scan the qr code into a text field no matter what its content is, then you can inspect the URL manually.

Unfortunately there’s a deeper problem in this security model, in that only a tiny tiny fraction of the web’s userbase knows how to assess a URL, and even experts can easily struggle

[ImportOllie]

If you consider all qr codes unsafe then use a tool to check them don't lecture the waitress on man in the middle attacks...

[ho_schi]

I see some valid points.

    1. A restaurant should   provide a menu printed on paper or a panel. Sometimes pictures are used.
    2. Verbal communication serves that purpose also well. And friendly manner.
    3. Some cameras don’t  display the read input properly. Input is always in error until it is validated. Here is user validation required.
    4. You don’t need to invent excuses like “my camera is broken, I forgot my phone, Bad eyesight…”.
    5. You don’t have to carry around a camera, a cellular access terminal and a computer (consider this as description of a smartphone) with you.
    6. The website can load arbitrary data with JavaScript and mine Bitcoin in a sandbox. It is not safe because it will drain the battery.
   

I like QR-Codes. They are analog and digital at same time, printed on paper and machine-readable and nobody ruined it with incompatibility. If possible the payload is printed as ASCII aside the codes.

PS: Similar. To provide a common base, prevent exclusion of unwanted customers and prevent against malicious data processing some jurisdictions require cash payment options.

[precommunicator]

> So you can't do the equivalent of inspecting the link before you click it.

Of course you can. Use an application that allows it.

[chickenpotpie]

IMO this is paranoid behavior and not healthy. Part of existing in society is having reasonable trust that just because someone can take advantage of you in a moment, doesn't mean they're going to. You're getting in an argument with a server because of your fear that a local hacker printed out a sticker, walked into your local restaurant, seamlessly put the sticker onto the table, didn't get caught, you just happened to sit at the exact table they picked, and whatever vulnerability they're trying to exploit is compatible with the exact device you have. Thats not going to happen.

Scan the QR code, dude.

[komlan]

It depends on which app you are using to scan the codes. For Trak [1], the main use case is to scan QR codes you made yourself (or someone from your company made). The scanner simply rejects anything it doesn't recognise as a valid (app-specific) code.

[1] https://admin.trak.codes/

[llamaInSouth]

Android 14's camera shows you the URL and doesn't load it right away...

[jddj]

There are open source QR scanner apps on F-Droid which actually make you tick a box saying "I've checked the above URL and I want to visit that website" before they will open the browser.

[kybernetyk]

Aren't there apps that just show the embedded text inside a QR instead of just opening the URL in a browser?

[Grazester]

My QR code scanner shows me the content of the QR code. This is my Google Pixel phone btw

[dylan604]

Hopefully, the Googster doesn't pull the rug out from under your feet and decide to deprecate whatever product(s) you are using of theirs. It is always something to keep in mind with using anything from G as a central part of your offerings.

[komlan]

Spot on. Fortunately, the underlying platform itself is independent of Google.

The Forms and Sheets add-ons are just customer acquisition channels, just like our Zapier integration [1]. These mostly use our API, and very little of our UI (mostly the scanner).

[1] https://zapier.com/apps/trak-qr-automation/integrations

[rahimnathwani]

I love the README/Overview on the linked page. It's really clear what this is for, why it's better than other solutions etc.

[komlan]

Thanks! I stole this structure from Obviously Awesome [1] by April Dunford, highly recommended.

I just noticed the main submission link goes to the Google Sheets add-on, instead of the Google Forms add-on [2]. Oh well.

[1] https://www.aprildunford.com/books

[2] https://workspace.google.com/marketplace/app/qr_code_pass_fo...

[mlhpdx]

I like this for the “sum is greater than the parts” aesthetic, which keeps the door open to so many applications.

[komlan]

Thank you!

The main platform is currently used by national post offices (physical mail tracking), health organizations (biological samples), banks (fixed assets tracking), manufacturing plants (parts inventory tracking), etc.

QR codes make it easy to avoid data-entry errors in quite a large set of use cases with physical objects.

[digitcatphd]

Kudos for the simplicity and efficacy of your solution

[komlan]

Thanks, please get in touch when you do try it!

[allynalford]

I like this

[komlan]

Thanks, please don't hesitate to get in touch when you do try it!

[zoezoey]

This is awesome!

[samstave]

This is WONDERFUL.

EDIT: nto "But for use for" -- I meant "But in ADDITION" --

But - for tool/item/inventory management in a garage.

Get a cheap label printer [0], create a form of your tools/inventory with a matched set (code on tool, code on location of tool home) - Tool home has a QR code that leads to a tab in the sheet with all the tools that live in that location, container.

Put airtags on the high-value tools, with links in the sheet to those.

but scan a code on a tool - and it tells you tool details, including owner, home, whatever data properties you like.

If you like barcodes/QR codes and GIMP - You will love BarTender (seagull Software [1])

It allows you to make ANY type of barcode you want, QR code, badge, etc etc.

Its AMAZING [Free*] software. (You only pay a cheapo $500 lic if you have a high volume printer for printing thousands of product labels fast - eles; its a super powerful free program with an utterly amazing and knowledgable supprt staf f (no affiliation)

Here is a test I did making "Card Carrying Conspiracy Theorist" badges based on a comment from someone saying they were one. THe QRs go to the /r/ profile - as does the bar code.

The image can be set as a template then do a merge for pics and employee data from a sheet....

https://imgur.com/a/eyAxpcb

(I like Guilloche designs (the swirly woven bits you see on money)) and so I used that motif - but the QR code placement and calc is automatic via Bartender.

I made a bunch of labels for a cannabis company - and I tied the QRs through a tinyURL which did all the geocoding of the QR scanning so that we could send product to a particular place, and then track where and how many people scanned the QR (the QR went directly to the lab test reports for the makup of the cannibis, CBD, etc...

So, then you could measure which market the CBD or THC were drawing most interest - and see how sales were vs scanning.

anyway - QR codes get a bad wrap. They are lame for menues - but a goot idea is to scan a QR code, then just have a folder of scanned links for purusal later - as opposed to launching safari when I clearly dont ue safari. :)

[0] https://www.amazon.com/qr-code-printer/s?k=qr+code+printer&p...

[1] https://portal.seagullscientific.com/downloads/bartender

---

>>>scan a QR code, then just have a folder of scanned links for purusal later

These get submitted to a personal GPT and it develops a learning module for you on your home portal which then gives you the run-down of all it has learned from that location QR or Context QR or Porduct QR.

But without a sticker - it will use either:

1. handheld laser engraver of the QR

2. an AI derived location based on meta data

3. an AI location based on image analysis

(forgive me if I am snowballing too much on HN, but I truly believe we are at an inflection point with a velocity that is being masked from us - SAs and his Ilk are not giving the fold the truth.)

[komlan]

Wow, happy to find another QR code enthusiast here! They simplify a lot of things, indeed.

Great use case! I did a tool inventory management use case once, with the underlying platform [1].

It starts with generating QR codes for sticker papers [2], from the app. Those never expire and are all different (v4 UUID). You can then assign a QR to any new item, then scan it for registration in the app, specifying room, drawer, etc. (and gps, picture, etc. if needed).

You can browse tools per room, drawer, etc., and scan anytime to record an update. Each tool gets a history trail.

You can even make data-entry easier by making special QR codes for drawers; scanning them fills some form fields with presets, so you don't have to manually select stuff and make mistakes.

I mostly see use-cases where other people scan a QR you made, but there are use cases where the QR codes are only ever scanned by you and your staff.

[1] https://admin.trak.codes/ [2] https://share.darkaa.com/!9DXEQQTg2z/trak-qr-codes-demo-hn.p...