komlan

no profile record

Submissions

Show HN: Ensure actionable Google Forms responses using automatic feedback

workspace.google.com

2 pointsby komlanil y a 29 jours0 comments

Show HN: Kyran – App Builder for Google Sheets (Apps Script Without the Pain)

workspace.google.com

1 pointsby komlanil y a 11 mois0 comments

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

workspace.google.com

115 pointsby komlanil y a 3 ans64 comments

comments

il y a 2 ansdiscuss

This is the fundamental weakness of every self-check-in system. QR codes are just information, and information can already be transmitted instantly and faked (GPS, etc.) if needed.

If you care about reliability, there's no way around scanning the codes yourself (instead of making attendees scan), so you can be sure that each scan maps to an actual attendee, and you're not getting 30 scans from 10 people actually present.

I guess self-check-in became popular in zoom calls during the covid area, but people that need reliability instantly prefer the alternative, when available.

Shameless self-plug: this is precisely why my Google Forms/Sheets check-in plugin is named "Qr code ticket per attendee" [1], because the unique ID per person is what makes it more reliable than self-check-in.

Yes, people can still send friends, but most of the time, you don't care, and it's too much of a hassle for the attendee. People sometimes worry that check-in won't be quick, but QR code reading is very fast [2], and you're only limited by how quick people move.

[1] https://qr-code-ticket.com

[2] https://www.youtube.com/watch?v=-fkgCX3H7so

il y a 2 ansdiscuss

Ah, I was assuming numeric data rendered as hex, like UUIDs. Decimal works wonders for those, because the numeric mode of QR codes is the most efficient.

il y a 2 ansdiscuss

Hex is worse, see here [1] for UUIDs

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

il y a 2 ansdiscuss

This is particularly useful for numeric data that is usually displayed in hex, like UUIDs [1]

I used this for digital QR code tickets [2], and it made the codes so much easier to scan, even with bad lighting.

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

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

il y a 2 ansdiscuss

I'm building a point/credit/voucher tracking tool for QR code member cards.

https://workspace.google.com/marketplace/app/qr_code_loyalty...

You create a new member by filling a Google Form (they receive a digital member card with a QR code by email), and add or subtract points by scanning the QR code.

il y a 2 ansdiscuss

That's neat, especially for arbitrary binary data!

il y a 2 ansdiscuss

Physically bigger pixels help a lot indeed. The encoding mode also helps make pixels bigger.

This is very convenient when you control the QR reader and need to represent long numeric identifiers like UUIDs.

For example:

  9728983f-7d7d-4189-b624-f92781e36650 (lowercase UUID):
    => length=36, 15 pixels between markers
  JWM9GFVXFN0RKDH4Z4KR3RV6A0 (base32 UUID):
    => length=26, 11 pixels between markers
  9728983F-7D7D-4189-B624-F92781E36650 (uppercase UUID):
    => length=36, 11 pixels between markers
  200924207194334734815443970355691218512 (decimal UUID):
    => length=39, 7 pixels between markers

The uppercase UUID has bigger pixels because it used a different encoding, and gets the same results as the shorter base32 uuid.

The decimal UUID is a longer string, but results in much bigger pixels because it can use numeric encoding.

I have a QR code base attendance tracker [1], where attendees show the code [2] on their phones (glares, etc.), in bad lighting conditions, etc. Bigger pixels means scanning stays quick. Same with parcel tracking [3] where field agents might need to scan QR codes in barely-lit hallways, etc.

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

[2] https://share.darkaa.com/!qntvtzNPWJ

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

il y a 3 ansdiscuss

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

il y a 3 ansdiscuss

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

il y a 3 ansdiscuss

Thanks tchalé ;) Btw, my parents never managed to decide if they were Togolese or Ghanaian

il y a 3 ansdiscuss

Mostly nation by nation, but key hubs like Nigeria/Ghana (English) and Senegal/Ivory Coast (French) draw other countries in, due to the presence of a larger pool of investors.

il y a 3 ansdiscuss

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

il y a 3 ansdiscuss

Indeed; I didn't expect this level of interest, to be honest. The HN demographics didn't seem to match my target market.

il y a 3 ansdiscuss

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/

il y a 3 ansdiscuss

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...

il y a 3 ansdiscuss

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

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

il y a 3 ansdiscuss

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.

il y a 3 ansdiscuss

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...

il y a 3 ansdiscuss

Ah indeed ;)

il y a 3 ansdiscuss

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.