Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 13, 2024 05:36 AM
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.
Solved! Go to Solution.
Aug 13, 2024 05:43 AM
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.
Aug 13, 2024 04:53 PM
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.
Aug 13, 2024 05:43 AM
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.
Aug 13, 2024 11:34 AM
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.
Aug 13, 2024 04:53 PM
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.
Aug 14, 2024 12:08 PM
Hi. Thanks. I've completely forgotten that we can give that specific user access only to one of the views.