Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

An action to have a pop up screen?

Hi again

I am trying to make an action that allows me to make a sidejob before continuing the main process. Let me express the idea with a bakery recipe. (As some of you will remember, it is actually paint mixing but cooking or baking recipes might be easier to understand).

So, lets suppose I am following a recipe on my app where I am tracking every step. The recipe calls for 4 measure of flour, 2 of sugar, 1 measure of milk, 2 eggs and half a measure of "flavour mix", a secret ingredient of the brand, which might very well be just a combnation of the same ingredients, as to not have everybody know the "secret formula". Certain day, I, the boss, am following the recipe but I suddenly notice I ran out of the "flavor mix", so I have to accomplish that first, and i want to make enough for the whole batch, not only the current mixture. 

The app has 3 leveled tables: batch, cake and cake_detail. So, I am in the middle of the making of Vanilla Cake, Batch 1, Unit 1 (ID: VC-01-01), but the emergency makes me to start the process of Vanilla Cake Mix with the date of today (CK-0925). After I accomplish both processes, my 3 tables should look like this:

CorneliusH_0-1727291584880.png

I have tried with varios action types and with inputs but they dont work. I still do not grasp exactly how actions and the system generated forms work. I would suppose what I need is 

- an action "add a new row to this table"
- an action "set some colums in this row" for the part of table Batch (as most of the info is the same as in the main process)
- an action - an action "add a new row to table" Products
- an action "set some colums in this row" for the part of table Product (as most of the info is the same as in the main process)
- fill in manually the data for the third table
- have a way to be back where I started. 

Is there something I am missing, not seeing, or doing wrong?

CH




0 1 104
1 REPLY 1

To make things easier and to make use of AppSheet's built in functionality...

I would recommend a 4th table - Mix Product Detail.  It would be a Child table of the Product Detail table.  You might find it useful to create a "Mix" Slice, on the Product table for any Ingredient notes as a Mix, that is used as the Parent table to the Mix Product Detail.  This just ensures the the Mix Product Detail rows are assigned valid Parent rows from the Product Detail table.

You will get by default a "Related Mix Product Detail" column that you can show on Mix Ingredients to drill down to see what each Mix is comprised of.  It also allows you to separate the Products List as there are likely some Products that are used ONLY in Mixes

I hope this helps!

Top Labels in this Space