Kuovonne's Guide to Airtable

Share

Explore

Kuovonne's Guide to Airtable

Kuovonne's Guide to Airtable

Techniques for limited access

Prefilled forms + Automations

⁠

⁠ Tip Jar ⁠ Thank Kuovonne for creating this content! ⁠ ⁠ ⁠

⁠

⁠

Set up a formula field that generate the url for a prefilled form that identifies the record you want to update and how you want it updated. Send this url to your users. When the form is submitted, have an automation that finds the original record and performs the update.

You can send the url for a prefilled form in an email or you can have an Open URL button in a

shared view⁠

or read-only

interface⁠

.

Pros

This can be free (not including your Airtable subscription fees).

Users do not need log in to submit updates (unless you want them to)

Cons

Record history does not show who actually made the edits (unless you collect respondent email addresses automatically, which requires users to log in)

The user experience can be very clunky.

Users cannot see formula results.

The link for the prefilled url can contain obsolete data.

Limited ability to update attachment fields and long text fields.

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

⁠

Share

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.