Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 16, 2024 07:53 AM
I'm creating a platform for project and task management.
I have multiple users and multiple interfaces.
One of those interfaces is an Admin section where projects would be assigned to users via a dropdown menu. I'd like this Admin interface to only be accessible for select users. But it appears that users who aren't given access to this Admin interface cannot be selected in the project assignment dropdown.
For now, I've given those users read-only access to this Admin interface, but I'd prefer that this interface be hidden for them entirely.
Is this possible, either on our current Team plan or any of the other account levels?
Sep 19, 2024 03:49 AM
Hey @jcx1028! Rather than having a User field type for assigning the project, try the following:
1. Create a table called Users (with their corresponding Name as primary field).
2. Create a Users field on such table, where you would obviously select the corresponding user for each corresponding Name of the user.
3. Replace your User field from your original table with a linked record field, linking to your Users table
4. Create a lookup field in this original table, looking up the User field from the linked user.
5. In your interface you will now be able to select from any record found in the User table, without missing on the functionalities that having the user type field used to allow you.
Making so many references to "user" "user table" and "user field" might sound confusing, but it is pretty straight forward. Just let me know if you need further clarification!
Mike, Consultant @ Automatic Nation
Sep 19, 2024 05:30 AM
I considered that option, but had concerns about scalability. Would there be any way to automatically add Users to this Users table when they are added to Airtable? If not, it would mean more manual work for me (not a ton, mind you, but every minute counts).
And if I'm selecting from a lookup field of users instead of from an actual list of Users, what additional steps would be needed to ensure that these users are being notified via email when they're added to projects?