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.
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.
Can anyone suggest an expression to do so? Thank you!
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.
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...