Help! Arcade expression to sum all values per globalid in related table

380
1
04-05-2023 11:37 PM
Labels (2)
andrewtillinghast
New Contributor

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!

0 Kudos
1 Reply
andrewtillinghast
New Contributor

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...

0 Kudos