IN THE PARENT TABLE COUNT NO. OF RELATED TABLES CREATED AUTOMATICALLY

AppSheet AppSheet Q&A
, ,
1

Hi All,

I have 2 Tables:
BUILDPLAN - Parent
PACKING PROGRESS - Child

In the BUILDPLAN Table, AppSheet automatically creates the rows for Packing Progress.

In the BUILDPLAN table i have a Real Column where It will state how many Related Packing Progresss were created. I am currently using below expression:
COUNT([Related Packing Progress])

This is working. But when I add a new item, this new item is not counted in the form view. I first have to save that new item, then it’s counted.

I know that this is not the correct expression to automate the counting. Please need your expert advise on the expression…

2

Computed real (not virtual) column values are only recomputed when the row is saved from a form view or modified by an action. If you want the value to update more frequently, you’ll need to make it a virtual column.