Unique inventory database for each separate store

[sahab]

Hi,
I want to build an app that helps my local stores to post their inventory (image, price, quantity, etc). Each store has a unique database. They should not be able to see other stores or their database. Each store should be able to log in with their unique email/password.

My job is to extract the database and submit it on one website, with local stores and their inventory in our area.

Do I need to create a separate app for each store in my back end? I am going to have up to 20 stores so I rather have one app and switch between stores. Or is it easier just to download the database from the spreadsheet for each individual store? Other selutions?

Thank you.

[Leonardo_Dal_Pi]

One app, a user x = x store (using usermail()) and then a security filter on the table with storename.

[Steve]

For reference:

help.appsheet.com

Security Filters: The Essentials

You can use Security Filters to control which records a user can see and update.

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

[sahab]

Thank you Steve and Leonardo. Now I know where to start my project.

[sahab]

sahab:

I want to build an app that helps my local stores to post their inventory (image, price, quantity, etc). Each store has a unique database. They should not be able to see other stores or their database. Each store should be able to log in with their unique email/password.

My job is to extract the database and submit it on one website, with local stores and their inventory in our area.

so creating such app with up to 30 users/stores should be possible? Do I have to pay per user/shop or this one app?
Thank you once again

[bonameblisto]

solutions.appsheet.com

AppSheet Pricing

Get information on AppSheet pricing for our Pro, Business, and Enterprise plans. Find the right fit for your small team, large team, or enterprise organization.