Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Allow users to create personal views but not see other user's personal views

161 0
cancel
Showing results for 
Search instead for 
Did you mean: 
highondefi
4 - Data Explorer
4 - Data Explorer

Since personal views cannot be restricted to 1 user, I'm looking for a workaround.

I'd like our users to be able to create their own personal views based on a master table.

I don't want them to see anyone else's personal views (which AT currently doesn't allow).

I need to set up automations based on each user's personal views (so I don't believe we can use interfaces).

The solution I came up with was a master DB 1-way automatically syncing with multiple bases, but the problem there is the sync feature is unreliable. AT claims it's an "instant sync" but it is not. Many of the child bases do not get updated data for minutes or longer. 

I've been trying to find a solution for almost a week but haven't had any success.

1 Reply 1
MJen
6 - Interface Innovator
6 - Interface Innovator

Hello,

completing your task can be challenging, but you can try this:

1. Create a User Filters table where each record corresponds to a user, containing fields for their filter criteria (status, project, etc.).
Then link these filter records to the master table.

2. Set up an automation that checks the User Filters table when a record is updated. This can apply the filter logic dynamically by adding tags or fields to the master table, reflecting each user’s criteria.

3. While interfaces can’t directly automate views, you can use them as dashboards personalized for each user by applying filters based on the "User Filters" table.

4. Use Airtable’s API to mimic real-time syncing for your child bases. A script could check for updates in the master base every few seconds and push changes instantly to user-specific bases. This bypasses the sync delay.

5. If Airtable’s limitations persist, consider integrating 3rd-party tools like Zapier to automate data routing more reliably across user-specific bases or views.

This approach should help

Mary Jennings