LinkedIn
Twitter
1 ACCEPTED SOLUTION
The simplest way would be to do the following:
- Remove the app formula from your average column
- Create an action to set the value of the average column
- Create a ref update action, to gather the list of records to be updated then enact your average action
- Use this ref update action in the Form event, so when someone saves a new record this action fires off.
Here’s some screenshots of how I set this up in an app of mine to update LineItems on an invoice:
In the “Referenced Rows” space you’ll want to do something like:
select(table[TableID], [Group] = [_thisrow].[Group])
Then for the “Referenced Action” space, you’ll enter the average action you created.
If you look under the hood of this sample app, you can get a sense of how I got about updating all children records triggered off updates to the parent.
https://www.appsheet.com/samples/How-to-use-Actions-to-copy-data-from-parent-records-to-all-related-...
Your case is similar - in the sense of how you’ll go about building it - so seeing the setup might help.
