I have a question regarding scalability and establishing the right workflow. I'll provide as much information as I can for clarity. For context, our company is involved in the distribution of chemical liquids. We handle the pouring of these liquids directly at our warehouse. To manage our inventory effectively (among other reasons), we are considering the development of a custom software solution. While AppSheet seems like an almost perfect fit for our needs, I'm somewhat puzzled about how its security filters function.
Our plan is to maintain a several MySQL database and tables. To illustrate:
- 1st database: Contains all orders.
- 2nd database: Details all items from these orders.
- 3rd database: Dedicated to fulfillment.
At present, we have approximately 37,000 orders (sourced from Shopify) that need to be transferred to the 1st MySQL database. I estimate that the 2nd database will have roughly 5 * 37,000 = 185,000 rows. Additionally, we have other sources of orders, such as those from private clients or B2B, where orders are processed manually, among others. The 3rd database, which is for fulfillment, will likely be the largest, with an estimated 500,000 rows.
While I have viewed several tutorials on YouTube, most of them address straightforward use-cases, like displaying data specific to a user profile. I'm clear on that aspect. However, I'm seeking guidance on more complex scenarios, such as:
- Loading all unfulfilled orders.
- Reviewing all fulfillments from the previous day.
- Viewing all orders for a particular month.
- Analyzing data for a specific liquid.
- And so on.
I anticipate approximately 30-40 different filtration scenarios. My primary confusion lies in how to incorporate all of these into a single security filter setting within AppSheet. Please, can someone explain me this part?
Thank you!
LinkedIn
Twitter
