Latest Contributions by DougBrowning

Using Arcade is a good way to go.  While they are not "real" fields they can do must things.  Eventually Attribute expression may be more what you want but they are not here in AGOL yet (heard soon so look them up also).  You can also go old school and run a nightly script. You will want to look in to the Arcade FeatureSet functions.  They allow you to look into the related records and grab info. For Ops Dashboard take a look at Data Expressions.  They combine Arcade expressions into new data. Below is some sample code and check out these links. https://community.esri.com/t5/arcgis-online-documents/using-featuresetby-functions-in-arcade-to-drill/ta-p/918691 https://www.arcgis.com/home/group.html?id=ba3070ceede54f1981012811c51b7f78#overview https://www.esri.com/arcgis-blog/products/ops-dashboard/announcements/introducing-data-expressions-in-arcgis-dashboards/ There was also a great post on this to calculate days past and such but I cannot find it. Sample Ops data expression lookup var p = 'https://arcgis.com/'; var tbl = FeatureSetByPortalItem(Portal(p),'d14444449',9,['UnknownCode'], geometry = false); var dups = [] var Dict = { 'fields': [{ 'name': 'dups', 'type': 'esriFieldTypeString' }], 'geometryType': '', 'features': []}; var index = 0 var last = '' for (var f in OrderBy(tbl, "UnknownCode")) { if (f.UnknownCode == last) { Dict.features[index] = { 'attributes': { 'dups': last, }} ++index } last = f.UnknownCode } return FeatureSet(Text(Dict));    Hope that helps ... View more

That makes more sense but it still wont work.  It is because all select one must be string.  So even though you give it a 0 and 1 it is really "0" and "1".  123 tries to help you when all three are filled out and gifts you the conversion.  This will prob not work at all on the web. Best thing is to make a second set of if(value, 1, 0) and then count those just like you do for Choice_T.  I think it is the best way.  int("") is what is causing the non calc. Other option that may work is to use  coalesce("", 0) and put that inside the int.  Then it should give you 0 if it is sitting on blank. Hope that helps ... View more

I only use the app so it may be different but the word field needs to be in there like this arcgis-survey123://?itemID=032af44444488&field:PointID={PointID}&field:EvaluationID={expression/expr0}&field:CollectTNTP={expression/expr13}&field:CollectTurbidity={expression/expr14}&field:Project={Project}&field:ProtocolType={ProtocolType} ... View more

If it is a draft that is much harder since it is not in the service at all and only on the device.  So it will be some manually copy of the data to get it off the device. One way would be to use recovery from the device.   See here https://support.esri.com/en/technical-article/000024617  ... View more

Ah it was a simple mix up.  In count_problems_Solved you were adding up the Yes No questions and not the numbers field.  You were trying to add the strings. You have int(${Choice1}) +int(${Choice2}) +int(${Choice3}) when you want int(${Choice1_T}) +int(${Choice2_T}) +int(${Choice3_T}) Note you can take those int() out of there now since you set the bind field. Also I would set the Choice1_T and the count solved fields to calculate vs hidden so they update better. Works for me now I think you just got tripped up. ... View more

I did not get a chance to test but I bet it is the bind. For your 3 hidden counts like Choice1_T set the bind::type to int.  That way it is treated as a int in the form.  I know you have the esri bind there but that really just sets the service field and does not set the type while in the form.  I also see you use int later on most of them but you missed... count_Problems   try setting that field bind type to int also. So right here ${count_Problems} - int(${count_Problems_Solved})  count _problems is still a string. I think that should do it. It is easier to just set the bind column vs using int all the time.  Hope that does it. ... View more

@SamuelSchneider   Sure send me you form or info in PM.  My email is in there. ... View more

These posts are for ideas that we want 123 to add.  It is not implemented yet.  Please upvote the idea. ... View more