How to Restrict User Access by Table, Field, or Row in Airtable?

You might want to check out the miniExtensions Portal for this use case. It gives you full control over which data different types of users can access, all without giving them any access to Airtable at all. Essentially, they’d only see what you specifically want them to see. By default, they’ll also only see records that are related to them, but that can be changed, if needed, to let them see more records, for example based on specific filters.

Is there any way to implement real column-level permissions?
For viewing, Interfaces would be the way to go.  For editing, this is usually handled within the specific Interface where we set whether the column is editable or not:

Within the data layer you can also set field permissions:

Is there any way to implement true row-level permissions?

Visibility wise, yeah.  If you set up your data so that each record is linked to a user in some way via their email that gives you the ability to filter by the logged in user’s email:

To give them the ability to view a record without editing it you’d set every column in the Interface to not be editable

---

Are interfaces the only recommended approach to hide fields and restrict access?
 

Hmm, as an Airtable native solution, yeah.  There are various third party portals that connect to Airtable that you can look into, such as Softr, Zite, Noloco etc that you can check out that might help if Airtable gets too pricey

​@brunofbrsilva 

Yes, everytning that you want to do can be done natively within Airtable by using Airtable’s interfaces.

The trick to getting record-level permissions to work is that the user must be attached to the record with either a user field, an email field, or a lookup of a user or email field.

Note that there is no reason to use external apps to get any of this functionality.

However, if you are interested in using an external app, here are some of the most popular portal apps for Airtable:

The most popular 3rd-party portals that are currently available for Airtable are:
Noloco, JetAdmin, Softr, Pory, Glide, and MiniExtensions. And Fillout is 100% free, but it only offers editing one record at a time along with its associated line items.

I gave an entire one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable, although I don’t usually recommend Noloco as a first choice because it’s very complicated to setup.

But as I mentioned above, all of this can be done natively within Airtable, without needing external apps.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld