Queck for filled fields in repeats and calculate the sum

947
2
10-10-2016 06:38 AM
Nicole_Ueberschär
Esri Regular Contributor

Hello, 

I am (still - or again ;-)) working on an agricultural survey. I have a repeated group that is asking for the planted crops in a plot. When the number of planted crops is e.g. 3 the survey creates 3 repeats. Each crop is recorded with the according share (e.g. 70/20/10 percent). How can I 

1.) check if all fields were filled for each repeat. I have something in the far back of my head that constraints were / are not working well within repeats. 

2.) check that the total of all crops is 100%?

Thank you people!

0 Kudos
2 Replies
JamesTedrick
Esri Esteemed Contributor

Hello,

What you would want is the sum() operator, which would add up the value of a field across repeats.  We currently do not yet have support for that function.

0 Kudos
Nicole_Ueberschär
Esri Regular Contributor

Thank you James. Is the sum() function somewhere among the things that is planned to be implemented soon?

As I have just seen the constraints should work now within repeats. (Required Fields ignored in repeats · Issue #226 · Esri/Survey123Community · GitHub )  So at least I could check if the fields are not empty. 

0 Kudos