Automatically fill in data based on dropdown choice

[Chacal33]

Hi all,

I have 2 tables:
ORDER – OrderID - OrderDate - OrderStatus
ORDERDETAIL – OrderDetailID - OrderID - Product - QtyOrdered - QtyDelivered

I would like the QtyDelivered to be equal to QtyOrdered if OrderStatus = “Complete”

I have tried to add a formula for QtyDelivered like:
if(OrderID.OrderStatus = “Complete”, QtyOrdered,0) in appFormula and initialvalue, but nothing happens…

Any idea?

Many thanks

Matt

[Steve]

Chacal33:

if(OrderID.OrderStatus = “Complete”, QtyOrdered,0)

That’s not doing what you think it is.

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[Chacal33]

Thanks Steve

I am not sure I understand the dereferencing.
I thought I had used it properly in my formula. When I test it, it shows the right result…

[Marc_Dillon]

Column values are referenced with square bracket notation.
i.e [column] not column

help.appsheet.com

Expressions: The Essentials

Learn how expressions can be used in AppSheet and get started with your own.

[Chacal33]

Hi Marc,

The formula i have is as follows:
if([OrderID].[OrderStatus]=“Complete”,[QtyOrdered],0)

Seems to me that dereferencing is used properly and the formula looks correct.

[Steve]

Chacal33:

The formula i have is as follows:
if([OrderID].[OrderStatus]=“Complete”,[QtyOrdered],0)

Chacal33:

I have tried to add a formula for QtyDelivered like:
if(OrderID.OrderStatus = “Complete”, QtyOrdered,0) in appFormula and initialvalue, but nothing happens…

We can’t help you if you misrepresent your app configuration.

[Page]

What if…
1 TABLE “Items”
you want to enter a new item, but check to see if item already exists (maybe compare first entry field in form with that column in items?). If it does already exist then switch to its (the already existing item) edit view instead of adding new item, but if it does NOT exist then continue to add info for new item in form.
please help

[Chacal33]

Hi Page,

I am sorry, but i do not understand your post.

[Chacal33]

Sorry mate but i struggle to understand.
I have seen the Order Capture sample. And I guess i could give it a go, but i am pretty sure it is not going to do what i want.
I want to be able to fill in the QtyDelivered if it is not fully complete.

In what way am i misrepresenting my app configuration?

Many thanks

[Chacal33 · Accepted solution]

Hi,

I eventually found a way to do what i wanted.

Create an action on the order table:
Data: execute an action on a set of rows
Ref table: OrderDetail
Ref rows: SELECT(OrderDetail[OrderDetailID],[OrderID]=[_THISROW].[OrderID])
Ref action: create an action that update the data you want to update.

Done and dusted!

Matt