Latest Contributions by DougBrowning

I cannot get the Show Relates to do anything.  I think I set it up correctly just nothing happens when I click on it. What I really was hoping to do is map all the Features that have a certain value in a related Table.  So I am searching in a non spatial table but want to display those features that are related to the table records found from the search.  Not an easy one to solve.  I can do it in ArcMap with Subquery but have found nothing for online.  For example PrimaryKey IN (SELECT PrimaryKey FROM SpecDetail WHERE SpeciesList = 'ARTR2') I tried going from table to Relate FC and the reverse but just nothing ever happens.  What should happen?  Get a list, selects in the attribute table? Any more guidance on this? Thanks a lot ... View more

I was able to poll SAML using this code here.  https://github.com/DOI-BLM/requests-arcgis-auth My script does not "sync" it just sends a request to download a GDB, then renames and adds that GDB to a local directory each night. ... View more

Anyone know if there is pulldata support for pulling vertexes, centroids, etc?  Can't seem to get it. Thanks ... View more

Just posted a way you can kinda do it yesterday https://community.esri.com/thread/191518-remove-an-entry-or-item-from-the-dropdown-list-after-it-has-been-picked-once  ... View more

Thanks Phil I actually did not know you could do that now.  Sorry about that. This is actually really cool and it totally changed how I may layout my schema now.  It may really help me get around some table support issues in ArcMap and AGOL.  (As you can see by all the crazy stuff I tried above.) Thanks! ... View more

I have an old school way using data driven pages that I came up with 3+ years ago now.  Full code is here https://community.esri.com/thread/170563  In my new job we flat out told people we cannot spend our limited resources developing ways to print out a piece of paper that will just go into a file cabinet never to be looked at again.  Moderate success at that, esp in government.  But at some point people need to move on from paper.  Usually when we provide a more modern solution we get them to convert. ... View more

 James Osundwa   Floyd Bull I was able to at least simulate this now.  My project has 8 fields all with the same drop down but that only show once the one above gets a value.  A value should never repeat across the 8.  I cannot remove the choice from the list but I can yell at them if they pick it again. Use a Constraint that checks the other fields. Example Field2 has a constraint of .!=${Field1} Then just expand .!=${TopCanopy} and .!=${Lower1} and .!=${Lower2} and .!=${Lower3} and .!=${Lower4} and .!=${Lower5} and .!=${Lower6} You can even make exceptions with a If (surprised but you can use If in a constraint) this says if my choice had a XXXX pattern in it then it IS ok to repeat but everything else cannot repeat. if(not(contains(${Lower1}, "XXXX")), .!=${TopCanopy},1) What about across repeats? Harder one where I have a field that does a join() on a repeat to get a list.  I then check my field against this list using contains.  That way I can see if a choice has ever been used across the repeats.  The trick is that the second you pick the last option, it adds to the list, then yells at you.  So for that I did a substr to take off the last 3 chars (since my codes at 3-5 digits) then I do a contains on that substr.  It works great UNLESS a user goes back in a repeat and tries to change a value.  The search will find it and complain.  I just teach my users to delete a repeat and then add a new one at the end.  Was ok for me.  This would be a lot easier if survey had a contains that returns the number of times the string was found not just a yes/no. With these tricks I was able to get the checks in there that I needed. Hope it helps. ... View more

This turned out to be commas and other special chars in the list!  Thanks to Esri for finding. It seems like you cannot use != in a choice filter.  If I do layer != ${nonplant} I get nothing. Thanks ... View more

A Repeat will always be a table.  There can only be one GPS point in the form and that becomes the FC. I have a bunch of tables in mine and mapping an attribute of a repeat table if rather hard.  You need to make that table spatial somehow. Table support is spotty. Here are some options. Form -You can add a Lat and Long to the repeat table and have it calc in from the main part of the form.  Then use these via XY event layer to turn them into FCs.  Again not dynamic. -If it is a specific field (like species for me) then outside the repeat add a field that has a list of all the values from the repeat.  The new join () is perfect for this.  join(", ", ${repeatfield}).  Then you can do Def Query on the FC - for example ListField contains "Value". If in AGOL  -Do a Join features from the table back to the FC (Feature Class).  This is of course static and would need to be redone on each add. -You can use Arcade in a web map to query the related table and display results in a popup.  But it is popup only and you cannot change colors based on the field or anything.  Also it will show in a attribute table put you must click each one to show the value. Code is like this - I found a better way to write it but I cannot find it var tbl = FeatureSetByName($datastore,"LayerName"); var sql = "SpeciesList = 'JUMO' And PrimaryKey = '" + $feature.PrimaryKey + "'"; Console(sql); var species = Filter(tbl, sql); var cnt = Count(species); return iif(cnt > 0, "Yes", "No") In ArcMap IF it is brought into a SDE or GDB  -You can use subquiers which are pretty slick PrimaryKey IN (SELECT PrimaryKey FROM tblDetail WHERE SpeciesList = 'ARTR2') Ops Dashboard you can do it kind of.   Hope it helps.  I beat on this for a day or so and never really got it to what I wanted.  Once it is a table you are pretty stuck.  In the end I am going with the List in the FC using join() but not fully tested yet. ... View more

Thanks for the answer.  Hopefully this will get added soon.  My users keep telling me that the old Access on a tablet has it . ... View more

I second that vote - in fact I posted on this yesterday.   Some may want to be able to advance pages while some of us want the validation to occur.  This is very important with later parts of the forms need that value to continue.   Just add it as an option that can be turned on and off per page - that way we all win. Thanks ... View more

Just do ${FieldName} in the calculation column  no put needed ... View more

I was just working on this today actually.  And what Mike listed is what I did. Field 1 - outside of repeat gets calc max(0, max(${repeatfield}))  the 0 is to handle the very first one. Field 2 - inside the repeat gets once(${Field1})  That way when a new repeat is added it gets the held max value just that once.  Then when max() changes no biggie.  Once a new max is entered Field 1 changes and then in turn is used on repeat 3. In once case I went ahead and filled in the last value for the user.  In others I left the field viable so the user can see the value from the last repeat right there.  I am still a bit concerned about users going 3 repeats back and "fixing" something.  This may then fall apart. ... View more