Data correct in expression result but the value not return

[harrypcw]

Hi i am trying to sum up the value from the child data and return in parent table. From the expression result the data is correct but it still does not set the value in the spread sheet. Can anyone know the reason?

thanks for your help

[harrypcw]

now i realize the data only show after i press edit, is that anyway it can show instantly?

[Suvrutt_Gurjar]

You could use reference actions to set the parent table column values whenever child record is saved. Actions can be executed on app events such as form saves.

Reference Actions - AppSheet

Get started by using the sample apps - AppSheet Help

View events - AppSheet Help

Actions: The Essentials - AppSheet Help

Or alternatively if it is fine with your application, you could use a virtual column to display that sum. A VC value will NOT be stored in the backend spreadsheet though.

Use virtual columns - AppSheet Help