Auto save with conditions

AppSheet AppSheet Q&A
1

Hi!

I edit my post because my first post (attached below) is not reflect actual basis.
I am writing an order management app, in this app, the employees less touch to the smartphone.

There are 2 tables,
-“Order” with [Order ID]
-“Order detail” ref with [Order ID].
One “Order” record may have some “Order detail”.

“Order detail” has “item” columns for purchasing items(beer, wine etc,.)
“item” will be recorded via scanning the barcode(EAN code) with smartphone.

(1) Tap “NEW” for adding “Order”
(2) Move to “Order Detail” using DEEPLINK.
(3) Purchasing item barcode scanned.
(4) After all item scanned, back “Order” to see the total cost.

Move (3) to (4), I would NOT like to touch the screen.

My idea is that I generate special barcode (called for “YYYYY”) in advance.

IF the scanned item is NOT YYYYY, “auto save” and “auto reopen”,
IF the scanned item is YYYYY, back to the Parent Order form.

It will be OK no matter how (3) and (4) will be proceed without touching the smartphone.

I hope you will understand what I describe.

(Below is previous edition of my post)

I am writing an order management app.

There are 2 tables,

-“Order” with [Order ID]

-“Order detail” ref with [Order ID].

One “Order” record may have some “Order detail”.

“Order detail” has “item” columns, user can input beer, wine, hamburger etc,.

Normally, “Order detail” will “Auto save” and “Auto re-open”.

I would like to move to “Order” form, under the special conditions.

Here is an example.

“Order detail form”

1st record “item” [beer] … auto save and auto re-open

2nd record “item” [wine] … auto save and auto re-open

3rd record “item” [YYYYY] … move to the “Order form” (parent record)

This mean [YYYYY] is the trigger for special condition.

(YYYYY is never change and only one “item” for this trigger.)

Is there any good way to solve my question?

2

This should happen already IF you have your Order Detail table set as a child of the Order table AND you have started from the Order Form to add the Order Details.

In other words if you start form the Order Form and tap “New” to add a new Order Detail, turning on auto-save and auto-reopen should bring you back to the Order Detail Form each time you Save it. Then simply tap “Cancel” and you should be taken back to the Order Form. Tap Save on the Order Form to Save the Order and ALL of the Order Detail rows added.

2 Likes
3

Thank you for your advice.

I try to edit my post for clarify what I want to do.

I apologize that I explanation was not good.