Hi! New to AppSheet, coming over from Coda where performance has become a real issue, and looking for a place to start from. The Coda app I have is an internal app for a juice bar, tracking customer cleanse purchases. This is what it currently does and what I’d like to reproduce with AppSheet:
- Create a Client Record, which includes basic info like phone, email, etc.
- Create a Cleanse Record (separate table), which includes the Client, cleanse type (1 of 3), duration, start date, etc…
- From the Cleanse Record, auto-create multiple rows in a 3rd table for each day of the cleanse based on the duration (3 days = 3 rows). Each row’s columns specify the products included that day, which auto-populate based on the cleanse type but are also able to be manually overridden.
- Change the status of each day based on prep/pickup/delivery status.
The primary table we use is the Pickup Schedule (#3 above) that displays days and products, as customers will pickup a day or more at a time and that needs to be scheduled. The reset is reference. Again, it’s an internal tool, not customer-facing, no purchasing, communication, etc.
If there’s anything you know of that may be a good framework to work off of, I appreciate the tips!