Hi, I have a parent table and a child table....

[AndreiT_Vlad]

Hi,

I have a parent table and a child table. In form mode i can add multiple child rows to the reffed parent row.

Now a column in the child row is calculated based on a value from parent row. Something like this =[ParentID].[ParentColumn].

The problem is if i change the value from parent row the child rows are not updating the column calculated based on the parent value.

Is there a way to trigger this?

Thank you!

[Aleksi_Alkio]

One way is if you make that calculation with a virtual column. Now you are doing it with normal column and app formula but it will be recalculated only when you open and save the record.

[AndreiT_Vlad]

Thanks! There is no other way around to automatically update?

[Aleksi_Alkio]

Check this sample app that I have created. The name is Event Action. It’s the opposite… when child record is updated but the principle is the same. appsheet.com - - portfolio of mobile apps created with AppSheet - portfolio of mobile apps created with AppSheet appsheet.com

[AlejandroCamach]

Hi Aleksi, I was copying the event action How to update parent record when child record is updated app and so far I have tried everything and double checked but it still doesn’t work. Does it have something to do with the fact that the price I want to be updated depends on a formula in GSheets? I mean, the Sum function is taking values from a formula in the database (Prices*Quantities).

Thanks for your help!

[Fusion_Incense]

@Aleksi_Alkio Hello Mr Alkio, I have 2 tables, parent table is Order, child table is OrderDetails, that’s say I have many order details within 1 order, order has OrderID and order details has OrderDetailsID.

What I want to do is, when Order Status changes to ex, new order, packing, shipping, delivered, paid…ect , then individual OrderDetails status details change to same thing.

In the Behavior - Actions,

what the formula should look like? now I use a sheet formula and it become very slow when loading and syncing.

Please help, Thank You

[Aleksi_Alkio]

I would create virtual column with a simple deref expression like [OrderID].[Order Status]. Then action is not needed.

[Fusion_Incense]

@Aleksi_Alkio Thank you for reply, I forgot to mention, the reason I use real column instated virtual column because I need that column to do the security filter

[Aleksi_Alkio]

You could basically use the same syntax for your security filter. What is your existing formula for your security filter?

[Fusion_Incense]

@Aleksi_Alkio my current security filter as follow switch(LOOKUP(USEREMAIL(), SalesRep, Email, Permission), “Distributor”, [Area] = LOOKUP(USEREMAIL(), SalesRep, Email, Area), “Sales”, and([Area] = LOOKUP(USEREMAIL(), SalesRep, Email, Area), [Email] = USEREMAIL()), True) I have the same security filter for the Order and OrderDetails Table, and I want to add OrderStatus as other security filter for the OrderDetails Table

[Aleksi_Alkio]

You could read the status from the parent table for your security filter like NOT([OrderID].[Order Status]=“Delivered”)

[Fusion_Incense]

@Aleksi_Alkio great, thank you for instant reply, I’ll give it a try