Latest Contributions by DougBrowning

Do you have this all in one field or something?  If so that is not the correct way, this statement above just has a function at the front.  Also all of your syntax is incorrect.  You need to split this to 2 fields. Field_1 is format-date(${inspection_date}, '%n')  note set to integer type and appearance as hidden.  Set bind::type to null if you do not want this field in the final schema. Then Field_2 uses the value from Field_1 Easier to read this way and proper syntax if(${Field_1} <= 3, 'Q1', if(${Field_1} >= 4 and ${Field_1} <= 6, 'Q2', if(${Field_1} >= 7 and ${Field_1} <= 9 'Q3', 'Q4'))) Would be a good idea to read up on how if statements work in general.  if(condition, true, false) ... View more

Also needed here.  Thanks ... View more

In the form do you have the Geopoint question in each and every repeat? ... View more

You need to add a geopoint question at each level of the form if you want each of them to be feature classes.  So it sounds like you need 3 total.  Do you have 3?  Posting the form helps a lot. ... View more

Hidden fields do not trigger a constraint on purpose as it would bring the user to an empty spot on the form and not be possible for them to fix.  This is actually something I asked for as it is confusing to the user.  I think what you have there is the best you can do.  Maybe change the messages and field name to make it look better. ... View more

Not sure I follow but I think this is what you want. selected(question, value) Checks whether answer is selected. This function is used for select_one and select_multiple questions. selected(${question_one}, 'a')   See here  https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm  ... View more

Huge upvote for this.  I think the use cases to compare layers are way more common.  I am not sure why I would want to chart just one layer really. Here is a bigger writeup I am sending to @ChristopherAllen  We have field collected data that we create summary indicators for.  We chart these to see how plants change over time. Like this     Our data only goes back to 2014 and we have areas that do not have many points yet.  So to supplement we also use remote sensing data that is created from imagery.     Our users would like to see this on one chart.  They need to see if both sources are aligning or wildly different (which could be a data entry error).  It can be hard to compare these when they are two totally different graphics.     In the future expanding this would be sweet.  One other example is say the chart shows a big drop off in plants.  If we can also chart precipitation on that same chart we could see immediately if it was caused by drought vs some other factor.  Having one chart per layer makes this impossible.  We are looking for causality so we really need to see it all on one chart.  Just seems like there are so many more use cases to have "Map wide charts" vs just a single layer.  Honestly I cannot really see the use case for a single layer chart.  It tells you it changed but not why!   That makes sense right?     The way it is now we have to skip Pro and build our own charts in script.  It is the biggest reason we never really use charts in Pro.    thanks a lot for considering this.  I think it would be a home run!   PS I also really like the way the Multidimensional toolbar temporal charts work.  The interface is much easier to follow than the regular chart one.  The interface really confuses me.       ... View more

If you check the log file in the app it shows thousands of lines that repeat over and over. ... View more

Weird I get mine on integer still.   ... View more

I would add a placeholder field in the form first.  Then use ArcGIS for Excel to view the service in Excel.  There you can add values to the placeholder field that will update the hosted service and be available for the report. ... View more

The 123 team had me try integer type also but my form still displays the warning in Connect.  It could be that I have several repeats and some nested, not sure.  Note the form did seem better at first but if I let the form sit a minute or so in Connect I get the warning here.  I would test this on your form just to make sure. Thanks for all the testing. ... View more

Note if using once(count(${name}))  name must be a field that is always filled out.  So I use a hidden field with a default of 1 and a calc of 1 - you have to have both or it will not work as well.  I use this in 10+ forms now and all working ok now. ... View more

@DPU-SMAMUS This is often caused by special characters in your csv or extra commas at the end.  Look at it in Notepad instead of excel and see if anything jumps out at you. ... View more