Jul 14, 2024 05:36 AM
Hello all, I am new to airtable.
I am looking to create a table for a collection management, in each row a new item. In the columns will be item details (image, description, size etc). Those columuns have to be "view only"
The idea is to share the list with other people that they can manage their own collection, so there should be three columns that everyone can individually tick off "in possesion" / dropdown "how many spares" / write in "ordered from".
These individal details should not be visible to everybody else, nor me as the creator.
From time to time I will have to add a new items/rows to the list.
Is it possible to create it in airtable? Thanks for your help
Jul 14, 2024 05:09 PM
This is possible, but it can get costly!
Each person will need an Airtable account and then be added as a collaborator on the base. Each seat will cost. I'd probably make these users as Editors on ONLY the interface.
From here it's quite simple to build an interface that is filtered by the "user". You can even include forms for users to add new items.
If information privacy isn't an issue, you can do a cheaper workaround. Have just one extra account that all users can access. Label each item with a user's name. then, on your interface, make a dropdown filter so that each user can select their name.
Jul 14, 2024 06:36 PM
Yea, @Sistema_Aotearo's solutions would work great
re: These individal details should not be visible to everybody else, nor me as the creator.
As the owner of the workspace you're going to have access to all the data and there's currently no way to prevent yourself from seeing specific records I'm afraid. The best you could do is to make a view filtered to only display your own records and never try to view other people's data
You could do something where you only have half the password of the Airtable account that's the Workspace owner and someone else has the other half or something I guess?
Jul 15, 2024 05:53 PM
Is a form not the answer? Are these numbers dynamic? Like they may need to change their counts? Or is it cumulative; "I added 6 more of x"?