Guys, I need help.
I’m making an app where multiple employers can register, add different stores and in turn register their employees. Employees can also log in to the app with their credentials.
I’m creating this app through the tables of the appsheet db, it’s right as what?
Do I have to log in to the app with a provider? for example Google ?
Otherwise, since the app is already built on the principle described above, how should I adapt it?
Thank you very much
First, I will assume this is a secured app where each user is authenticated. The app can be set to any provider since you don’t really know what accounts each user might have but the users do need to use one of the supported providers - Google, Microsoft, etc.
This design is called a “multi-tenant” app where each business is a different individual tenant and uses the app as if they are the only users of the app. AppSheet was designed with this kind of usage in mind.
The easiest way to accomplish this is by using Security Filters. These allow the app to filter the data in each table only to what is required for that user. The setup will require a Users table that allows users to be identified as belonging to the business. Additionally, each data row in core data tables needs to be assigned, when it is entered, with the user and business it is associated with.
The idea is this, when the app is launched, the user is looked up to get his/her associated business. This can be used to filter rows down to only that business. You can also filter by the user, if needed. And yes, you can have a mix where some tables are filtered by business while others are filtered by the user. And there will surely be some tables that are shared by all tenants that are not filtered at all.
It should also be mentioned that you can apply Data Partitioning for extra security around data. Partitions allow you to physically separate the data into different duplicated tables by tenant. The app operates only on a single partition preventing any accidental cross-contamination of data between tenants. Partitions do require Enterprise Plans.
I hope this helps!!
Thank you so much , finally i created this.
I have 2 app: first by security filter and another one by slices.
I have organized by this relationship:
administrator can have multiple store.
all of clients , product , and all have a foreign key of the store.
Employees have foreign keys of administrator and store, the have a role: operator or responsible.
if responsi le can exit/view/add data.
Now i don’t know ho create a method payment, because i want to publish application on App Store and play store. I watt ad 3 payment plan to use the app. Free , monthly payment or annual payment