Latest Contributions by DougBrowning

‎01-24-2020

Sorry I edited my post to be more clear. It is in meters I just said feet in generic terms. If you want all the gory details I dug up the post here. https://community.esri.com/groups/survey123/blog/2018/01/10/calculating-distances-between-multiple-geo-points-with-the-haversine-formula It does work though.

‎01-24-2020

In theory you could use the {relationship/0/field} stuff that is available in the popup in the webmap. But if it is 1:M then that is a no go. But I have never got these to work in Collector either. I posted on the Collector board a few times about it but never got an answer. Not sure if is a bug or what. Also see these posts in the Collector forum https://community.esri.com/thread/229709-are-the-arcade-featureset-functions-supported-in-collector

‎01-24-2020

Yep I do this. I use some radians math I found on geonet. I have my design lat/long (where we told them to go) in Collector then I pass that lat/long over to my 123 form. Then in the form I do math and display how far away they are from where they should be. Then I set a field that appears if they are more than 50 meters away to ask if they are moving a plot. Each time they tap the GPS button the distance recalcs. Make sure to use WGS84 for everything. GPS question is GPSPlotCenter Northing - pulldata("@geopoint", ${GPSPlotCenter}, "x") Easting - pulldata("@geopoint", ${GPSPlotCenter}, "y") Then DesginNorthing and DesignEasting come from Collector Distance calc. Field DistanceFromDesign round(acos(sin(${Northing} * pi() div 180)*sin(${DesignNorthing} * pi() div 180) + cos(${Northing} * pi() div 180)*cos(${DesignNorthing} * pi() div 180)*cos((${DesignEasting} * pi() div 180)-(${Easting} * pi() div 180))) * 6371000,2) Then I change my moved question from no to yes using a calc. You could do this as a constraint. if(${DistanceFromDesign} > 10, "Yes","No") You could factor in GPS accuracy if you want. I usually set a constraint on this also so I know they had a good signal. pulldata("@geopoint", ${GPSPlotCenter}, "horizontalAccuracy") Hope that helps works great for us.

‎01-24-2020

For the 5 forms all linked together part you could use the relationship class workflow I outline here Mapping with Survey123 within a polygon or admin unit Have you looked at the Workforce app? It seems like it would be a fit for this.

‎01-23-2020

Did you add a new field to a repeat? There is a old bug that causes this. Trick is to add a dummy field to the main form and then it will publish. Then remove the dummy.

‎01-23-2020

I posted a simpler script here https://community.esri.com/thread/245924-data-driven-image-naming

‎01-15-2020

Formulas—Survey123 for ArcGIS | Documentation

‎01-15-2020

Attribute Idea is here https://community.esri.com/ideas/17868 Another one is Show related records from the Attribute tablet? Have not seen that one. Really looking forward to a new web map! It is getting pretty old now. thanks

‎01-15-2020

There is currently no way to switch from field alias to field name in a web map attribute table. This is especially an issue when viewing Survey123 features since forms often reuse names for multiple fields. No way to tell which Photo Name is which. Thanks!

‎01-15-2020

Weird mine does not scroll up it just sits there. I can get it to move a field or two sometimes but not all the way to the top. Using Chrome. Thanks I would love an order field of some sort. When it gets into the 100s of fields this method breaks down. Adding Esri testing with larger datasets would be great.

‎01-15-2020

After many hours over the years I wanted to see if there was another way or if it can be updated. Arcade expressions always go at the bottom of the pop up. My layers have lots of fields and several related tables. This means in order to move a Arcade expression up near the top I have to click the up arrow hundreds of times. And I have to do this for each one of my Arcades (can not select and reorder a group). I must be missing something here. Then if I go too fast it blanks everything! Is there any other way to order these? We battle this everyday and it is really a time waster at this point. Seems designed for just a few fields - which most enterprise DBs are bigger than that. I wish you could drag and drop them, or it had a order field with numbering, or something. Yes the new map viewer beta can drag and drop but you cannot drag past the top. So with the huge font on these you can only drag up 2-3 fields at a time. Sometimes it will try to scroll once up but it usually does not work. A order number here would be great. I also would really like the option to flip between field name and alias in the attribute table. Thanks for any help

‎01-15-2020

See this post from yesterday https://community.esri.com/thread/246442-survey123-create-a-selectone-using-existing-feature-service-layer-field

‎01-15-2020

Take a look at join(). It will give a list of all your repeat values.

‎01-14-2020

I agree I do not use GlobalIDs at all mostly because of the exporting. Pro does now have an option to maintain GlobalIDs on export but that is new. But the biggest reason is how Arc manages relationship keys. I believe most of us think there are 2 options for relationships classes - managed and unmanaged. Managed means if I delete a parent record all children are deleted. Unmanaged means if i delete a parent then do nothing - right? Wrong! Arc actually goes and turns all the child keys to NULL!! (no one I asked knew this). So if you say need to reload your parents due to a calculation issue or something (happens to me a lot). I first change all my parent keys to the word delete. Then save (and in my case replicate). Then delete the parents. That way when it goes to look for the children it does not find any and nothing gets messed up. Then I can just replace my parents and all good in the hood. If you ever had to reload data and you are using GlobalIDs you are dead in the water. You can not edit or replace any GlobalIDs. Maybe you can as a GUID I guess - I would have to think about it. We export to things like Excel and using a non globalid just seems to work better. Also there is no way to generate them if they get nulled out or anything. We use keys that we can recreate at any time with some info. So lets say Division_Office_Plot_Year or something like that with a meaning that can be understood. Hope that helps. I have 60+ relationships classes so I deal with this a lot.

‎01-14-2020

You can also copy it to the tablet manually then tell 123 where it is in settings. At least I think that still works. Not sure if you can do vector tiles yet?

Online Status	Online
Date Last Visited	7 hours ago

My Ideas

Latest Contributions by DougBrowning

Re: Survey123 & Workforce - Location Validation as part of survey

Re: Pass related data to Survey123

Re: Survey123 & Workforce - Location Validation as part of survey

Re: Create a workflow for multiple persons within a single form

Re: Survey 123 Publish stuck on "Getting form information"

Re: Download all photos in survey123

Re: Survey viewing questions in list

Re: Better way to reorder fields?

Option to show field name in AGOL web map

Re: Better way to reorder fields?

Better way to reorder fields?

Re: Populate select_one question with a values from ArcGIS Rest Service

Re: Survey viewing questions in list

Re: Related Tables for Offline Data Collection

Re: Issues with using .tpk in survey

Re: Alphabetizing responses to a repeat question

Re: Is there a way to return a user submitted answ...

Re: Is there a way to return a user submitted answ...

Re: New Map Viewer is super slow to load when WMS ...

Re: Displaying multiple note using relevant column