https://community.esri.com/t5/arcgis-online-questions/help-arcade-expression-to-sum-all-values-per/m-p/1276080#M51320 <P>Hi, I have a hosted feature layer "CCG_Idea_Submission" on AGOL. The layer has a related child table called "CCG_IS_Reactions." They both have records added by Survey123 apps -- "CCG_IS_Reactions" has a field called Support that is populated with a "1" integer every time someone submits a simple survey in another app.</P><P>What I'd like to do is to calculate a field [Support] in the parent table with an Arcade expression that sums up the field per parent feature. I'd like this to occur whenever a new record is added to the child table, not just a one-time static calculation.</P><P>Can anyone suggest an expression to do so? Thank you!</P> Thu, 06 Apr 2023 06:37:20 GMT andrewtillinghast 2023-04-06T06:37:20Z https://community.esri.com/t5/arcgis-online-questions/help-arcade-expression-to-sum-all-values-per/m-p/1276080#M51320 <P>Hi, I have a hosted feature layer "CCG_Idea_Submission" on AGOL. The layer has a related child table called "CCG_IS_Reactions." They both have records added by Survey123 apps -- "CCG_IS_Reactions" has a field called Support that is populated with a "1" integer every time someone submits a simple survey in another app.</P><P>What I'd like to do is to calculate a field [Support] in the parent table with an Arcade expression that sums up the field per parent feature. I'd like this to occur whenever a new record is added to the child table, not just a one-time static calculation.</P><P>Can anyone suggest an expression to do so? Thank you!</P> Thu, 06 Apr 2023 06:37:20 GMT https://community.esri.com/t5/arcgis-online-questions/help-arcade-expression-to-sum-all-values-per/m-p/1276080#M51320 andrewtillinghast 2023-04-06T06:37:20Z https://community.esri.com/t5/arcgis-online-questions/help-arcade-expression-to-sum-all-values-per/m-p/1277031#M51371 <P>Starting to think that what I'm looking for might not be possible using an Arcade expression as a field calculation - because as I understand it this would be a one-time calculation rather than one that would run constantly/whenever new inputs are added.</P><P>&nbsp;</P><P>I didn't give the final intent in my original post - which is to feed this data into an ExperienceBuilder app. Maybe I could accomplish what I'm trying to do as a pop-up expression in a related map and then have the widget pull from the pop-up...</P> Mon, 10 Apr 2023 18:45:18 GMT https://community.esri.com/t5/arcgis-online-questions/help-arcade-expression-to-sum-all-values-per/m-p/1277031#M51371 andrewtillinghast 2023-04-10T18:45:18Z