Hard to scale subsidiaries/affiliateds/branches

[danieldonadel]

I rent bicicles.
I have 5 stores (subsidiaries/affiliated/branches).
Each store has 1 manager and 2 attendants.
Each store has its own stock.
Each user should see only its own branch stock.

So far I designed 1 datapage for each "type of user" for each "subsidiary". It happens that it quickly reaches more than 50 datapages.

All stores are exactly the same. They could use the same datapage. On the other hand, I have to split each datapage in 5 datapages, so I can manage users Authentications, so each user sees only the own stock.

If I need a minor change in 1 datapage, I have to change equaly 5 datapages.

I can not scale my company this way.

I imagine all retailers with more than one "local" have similar issues.

How can I manage it? Is there a special feature for that? Any App example I could benchmark?

Thank you.  
Daniel

[Hastur]

@danieldonadel

Hello!
You can use Record Level Security to restrict the access to data based on the User Role (type of store in your case)
Check these articles to get familiar with this concept :

https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/
https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/create-a-workflow-using-record-level-security-and-filtered-dropdown/
https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/
https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/filter-lookup-dropdown-or-listbox-based-on-user-or-role/