I am trying to build a B2B application and I want to keep the logical separation of data between the two customers. Let's say I want to give the ability to my user from Business X customer to choose an employee name from drop down that should be relative to their business. When a user from Business Y clicks the drop down, he should only see the employee names from their own business and not for both Business X and Business Y (which seems to be the current case). It is a privacy issue.
I can manage this manually by creating visibility filters on softr.io or having a separate view on airtable for each customer, but it is not scalable. Is there an easy way to manage that?