I am using pulldata in survey 123 calculate column to sum the number of entries in a layer under the same feature service but filtering by an id (patrol_id) selected in the survey. I can see this is possible and survey123 is not returning any issues with the syntax but no values are being returned when there should be.
I am using the following syntax:
| pulldata("@layer", "getValue", "attributes.sign_count", concat("https://services7.arcgis.com/ljSgek0qJg42y4Ln/arcgis/rest/services/QCT_Patrols/FeatureServer/1",'?outStatistics=[{"statisticType":"count","onStatisticField":OBJECTID","outStatisticFieldName":"sign_count"}]'), concat("patrol_id = '",${patrol_id},"'")) |
I am unsure why it is not working.
Any help would be greatly appreciated.
Pulldata doesn't do well with calculation inside them. Try pulling out your two concats calculations into helper fields.