Skip to main content

I have to put into place a secure Data base that I can generate a form from and when it's completed populates the Data base. I would like the feature where for that particular information I can generate a QR code, so if scanned the information associated with that form can be read. when scanning the QR code 2FA authentication is required. Is this possible in Airtable. If so could I have directions as to how to get this going. I want to try and do this myself if I fail I will ask for assistance or a developer to do it for me

Hm, yeah that sounds doable.  The only problematic part would be the 2FA bit I think; the people scanning the QR code would need to be collaborators that you’ve invited to your Airtable base and they’d have to turn on 2FA on their own as you can’t control that

https://support.airtable.com/docs/enabling-two-factor-authentication


@Rodney_Beadon 

I’m not 100% sure that I understand your question, but it sounds like you want to:

  1. Give people the ability to view and/or update Airtable records with a form?
  2. Each record should have its own QR code that the person can scan to allow them to view and/or update that particular record in a form?
  3. After they scan the QR code, they are required to have 2FA to login to that form?

All of this is extremely easy to accomplish with 3rd-party tools:

  1. You can automatically generate QR codes for each record by using Make’s free barcode & QR code tools.

    If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
     
  2. Regarding which URL you will you use for each record’s QR code:

    Fillout’s advanced forms for Airtable lets you view and/or update records through a form, and they will give you a formula that generates a unique URL for each record.
     
  3. For your 2-factor authentication, you would create a login page to your form with your preferred form of authentication.

Alternatively, you could also stick entirely within Airtable to do these things too (i.e. no 3rd-party tools), but there are drawbacks:

  • There are QR Code extensions in the Airtable marketplace, but they can’t be automated.
  • Your users wouldn’t be viewing or updating a record through a form, but rather through an interface page (or through a view in the data layer).
  • Your users would need to be interface collaborators or base collaborators.
  • You would need to give them access to other records as well. This is because you can generate URLs for each record, but you can’t filter down to just a single record by URL.
  • You can’t require 2-factor authentication in Airtable unless you’re on an enterprise plan. 

Hope this helps!

If you’d like to hire the best Airtable consultant to help you set this up — or to help you with anything Airtable-related — please feel free to contact me through my website: Airtable consultant — ScottWorld


Reply