Restricting interface filter element so one client cannot view other client data

[adrian-wsa]

Hi all

I'm trying to create an interface (dashboard) that uses a report Filter on client ID (eg. so that client A can only see client A data on the dashboard) (https://support.airtable.com/docs/interface-element-filter).

I have shared the interface to a test user as readonly, however the test user can simply change the value in the filter on top of the dashboard, then he can see any client's data.

What I'm looking for is to grey out the dashboard filter value, so it says client = "client A" for client A, and client = "client B" for client B etc).... I know I can create a different view for each client, however this is a lot of manual work as the number of client increases...

Any suggestion would be much appreciated! 

[Dimitris_Goudis · Accepted solution]

Hey @adrian-wsa, 

You have to create a unique interface per customer and share each of them with the client you refer. While this seams to be painful and time consuming as a solution, as I have already done it I recommend the following steps: 

1. Create one interface and filter you data in data source and not on "record picker element". In this way by default the interface will include data only for that specific client and the record pricker element will show again only his related records. 

2. When you finalize the interface start duplicating it and the for each duplicated just update the filer in data source 

3. When you do updates in interfaces, you can create the new page in one of them, and then duplicate the page by adding it other's client interface. 

Last but not least, I you have a table with all your client data, I would recommend you so save there the link for their interfaces because you can use them in email notifications with automations, so then in emails you can include the url for interface. 

For any further question feel free to post on Airtable community. 

Yours sincerely, 
Dimitris Goudis  

[adrian-wsa]

Thanks a lot for your help! 

[byzaaaaaa]

Hey Dimitris, I'm suffering from the same problem, and I think I understand what you're asking to do, however, I cannot find a way to 'filter the data in the data source'...

My data source is a table of all my users, and the users belong to specific clients. So client A has user 1, 2, 3, and client B has user 4, 5, 6. The interface is connected to this specific table.

So I really need the filter to do what it's intended to do....

Do you have any other workarounds?

 

[Dimitris_Goudis]

Hey @byzaaaaaa,

At this point dynamic filtering isn't available? 

Thanks

[byzaaaaaa]

Is that a question or a statement? 

[Dimitris_Goudis]

@byzaaaaaa, 

I am asking if at the point of your screenshot if the dynamic filtering is aloud. btw where do you try to add this filtering setting? 

Thanks

[byzaaaaaa]

Not yet on a paid plan so don't have access to dynamic filtering. I am unsure if dynamic filtering changes this though (will make it work)...