I’m new to databases and to airtable. Long-time power-use of spreadsheets.
We make pancakes (we don’t, but it’s more fun). When we get a new order, we give it an order number (00001,00002,00003…) and print out the order. The order contains the type of pancake (Strawberry, Blueberry, etc…), quantity, size, customer name, etc… Then we mix the batter. Cook the batter. Package the pancakes. We track the order as it moves through the kitchen. The mixer operator types the order number and the bowl number into his phone’s web-form (the time is automatically captured). The griddle operator types the order number and the griddle temperature into his phone’s web-form (the time is automatically captured). The packager simply enters the order number into his phone’s web-form (the time is automatically captured). How do I show the status of my pancakes on the order? I made a table for my order (which is getting a little wide with 20+ fields). Then I made another table for my mixer, and another for my cook, and another for my packager.
How do I link the status to the order table? I’d like a field in my order table for each status (mix, cook, package) that simply shows the time that it was completed (if it’s already completed) and it can stay blank if it doesn’t find a matching order number. In google sheets I use MATCH and INDEX.
I’ve made a sample workspace and base about these pancakes. Should I share it on the forum as a View Only link? Are there any concerns about me posting the sample as a “creator - invite by link”?
Thanks for any structure or linking advice,