I have an Airtable base with 17 collaborators.
2 of them are admins that check if everything is good on the base, update records, etc., and the rest of them put each day their working time through airtable forms. These times automatically generate an invoice for each of them at the end of the month with Zapier & Docupilot.
The users are all able to edit their personal times during the month so they can adjust the invoice before it’s generated & sent to the client. But they should not be able to see other’s people times. The fact is, in Airtable, as long as you are part of a table (even in read-only), you can see ALL the views and ALL the tables. So I cannot hide the hours of John for everyone except for him with personal views.
I partially solved this problem with Stacker, as I configured an interface which is different for every user. John will only see his clients and edit his own hours, and he will never see the clients nor the hours of Alex.
It’s pretty good actually, BUT on this tool, there is absolutely no auto update. When you make changes on the Airtable base, it does not automatically show up on Stacker, and if you make changes on Stacker, they don’t show up on Airtable, you need to go to Stacker settings and click on “Start Update” which I’d like to be automatized.
I need the changes to be updated almost in real time (maybe with 1min but not more) since I will have users working directly on Airtable (the admins) and those who’ll just enter and edit their times, who, besides, are far away than being digital natives and don’t really have the habit to use a computer — so it’s really complicated and not sustainable to ask them to update the records after or before making changes on Stacker.
I saw that Stacker is not implemented with Zapier, so I cannot set up a zap which could recognize and run the update automatically when a change is made. So, do you know, maybe, another tool like Stacker which could do the job, or a way to make auto updates on Stacker?
Thank you all