Latest Contributions by DougBrowning

You are near the 31 char limit for field names but should be ok.  Maybe try shorter then I am not sure.  Unless you got a formula in there or the copy paste went wrong.  Maybe try a new form. ... View more

Often it is because the note is over 255 chars.  Set the bind::esri:fieldLength column to something big like 1,000.  Also you can set bind::esri:fieldType to null then it will not make the field in the service if you do not need it. ... View more

Check out pulldata   https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415   ... View more

Something like join("\n", concat(once(count(${Species_Name})), " ",${Species_Name})) may work ... View more

You can add a or to your constraint that links to a override field.  Something like new > old or override != "" - have the override field relevant if new < old. I tend to use a note field with a font color red and big font Warning that pops up.  Then have a question appear asking why they had to override.  Constraint that override field cannot be blank.  That way they have a huge warning they are under the old value and must consciously select a reason why.  Some crews still skip our huge red warning but that is users for you. ... View more

I dont use this much but this example has a concat? pulldata("@layer", "getValue", "attributes.TotalCount", concat("https://services5.arcgis.com/jMCHJcLe13FaKCFB/arcgis/rest/services/US_Counties/FeatureServer/1", '?outStatistics=[{"statisticType": "count","onStatisticField": "objectId","outStatisticFieldName": "TotalCount"}]'), concat("STATE_NAME = '", ${state_name}, "'")) https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3  ... View more

I think the issue is IT installed it manually.  Then later it was added as a managed Add-in.  But it seems its now stuck on the manual one.  ... View more

Tested again and it seems to be a size issue.  I did not see this popup before since there is a delay on it.  What is weird is I have Save to AGOL turned off but it still tries to make something?  Pretty much all of my use cases would be more than 10,000 records and most users do not have publisher rights so cannot create layers.  Creating a layer is required? Next I reduced the size of the data in Excel but it immediately tried to sync the deletes which was scary actually (good thing my test set is read only - I think that would trip users up).  But then it ignores the new data.  So it seems to be doing the aggregation on the server side vs in Excel.  I guess that makes sense.   I also add an issue where it cannot add data past the feature service record limit.  We have to set ours low from IT so almost all our services are over the record limit.  Pro can grab in batches.  Is that something that may come later? Overall pretty low record limits. thanks   ... View more

mmm I wonder of the json is really long.  I have seen that.  set the bind esri length to something big like 1000 chars Also try setting a relevant on match_calc where EMAC_ID is not empty or string length > 0 If all of that does not work set a calculation mode of always on match_calc just to see.  ... View more

Are you logged in on the browser? Maybe try a relevant on the json pull that the pulldata above is not empty. ... View more

On the note field I would check against the match_id field for relevant instead as there is no reason to call pulldata twice.  The webform does temp to run calcs in a different order than the app.  pulldata tends to be last.   In match_id you seen to be missing a comma  pulldata("@json"Nocommahere${match_calc},"attributes.EMAC_ID") Test that first. ... View more

I would use FeatureSetByRelationshipName instead.  Here you are just giving it the name 1 which I doubt its called that.  I am also not sure if a calculated value fires right away or on submit.  You can use just a note field to display it as well.  ... View more

@BenGunnewijk  I met with the ArcPro team in person at DevSummit and they are looking at it. Maybe @KoryKramer can update.    Did confirm there is no standards board at Esri and there really should be.  All companies struggle with consistency of course and it leads to a lot if interoperability issues. ... View more

Also no luck getting the Spatial Aggregation by Polygon to work.  Just get the error not found in AGOL.  Tried having it make a layer and not.   ... View more