I have a STATUS field in my AppSheet “child” table and added a DREF expression pointing to the STATUS field of the parent table . I expected when the parent table STATUS field was updated the child table STATUS field would be updated with the data from the parent table.
Is this not how the formula works with a standard (non-virtual) field?
If no what is the best solution to allow this functionality.
Thanks everyone
For a given row, a column based on an App formula is only recalculated when the row is edited. Changes to rows in a different table that the App formula expression references don’t trigger recalculation in the referencing column. Techniques to force recalculation include actions (e.g., invoked by the parent table’s Form saved event) that make arbitrary changes to the rows you want to recalculate–for instance, as explained in Quick Update System - How to update records in you… - Google Cloud Community .
