Skip to main content
Solved

Restrict access to a record when a specific option is chosen


Forum|alt.badge.img+6

Hi. 

I'm working on creating an AirTable base with complaints. The form is made with Fillout.
I wanted to know if it's possible to restrict access to a record if the user selects a certain option in a single select field. 

We'll have several people having access to the base and I wonder if I can hide certain records for an user A when a single select field has a specific option chosen.

Thank you.

Best answer by Mike_AutomaticN

Hey!

Is the "User" you are describing working on Fillout or Airtable? In other words, where should the record be hidden? In Fillout or in Airtable?

If in Airtable, you can create different interfaces (with different filters) for each user.
Please provide some more context, and I'd be happy to help out.

View original

Mike_AutomaticN
Forum|alt.badge.img+21

Hey!

Is the "User" you are describing working on Fillout or Airtable? In other words, where should the record be hidden? In Fillout or in Airtable?

If in Airtable, you can create different interfaces (with different filters) for each user.
Please provide some more context, and I'd be happy to help out.


Forum|alt.badge.img+6
  • Known Participant
  • August 13, 2024
Mike_AutomaticN wrote:

Hey!

Is the "User" you are describing working on Fillout or Airtable? In other words, where should the record be hidden? In Fillout or in Airtable?

If in Airtable, you can create different interfaces (with different filters) for each user.
Please provide some more context, and I'd be happy to help out.


Hi. The user would have access to the AirTable base not the Fillout backend so we'd need to hide the record in AirTable. 

Thank you.


Mike_AutomaticN
Forum|alt.badge.img+21

You can always create multiple views for a given table in Airtable, and ser different filters for it. 

e.g. View A; filter to show records where Status (single select field) is not “Pending”. 
You would provide this view to the user to work on. 

You can have as many views as needed, filtered differently. 


Forum|alt.badge.img+6
  • Known Participant
  • August 14, 2024
Mike_AutomaticN wrote:

You can always create multiple views for a given table in Airtable, and ser different filters for it. 

e.g. View A; filter to show records where Status (single select field) is not “Pending”. 
You would provide this view to the user to work on. 

You can have as many views as needed, filtered differently. 


Hi. Thanks. I've completely forgotten that we can give that specific user access only to one of the views.


Reply