Latest Contributions by DougBrowning

Wild guess maybe try without the ' || ' ?

I think the way you have it loc_a has an if to prev_loc and that calls loc_a so that is the loop I think. First test just having it show you the value without the calc in loc_a and see if that works. Then go from there. It has been years since I used the code.

Yea it cannot be done this way. 123 works with Names as the way to track fields. So it has no idea that FieldA in repeat 1 is different from FieldA repeat 2. I have been working on this for 6 years now with no luck. Lots of posts out there if you want to look around. Only way I kinda got to work was javascript. But for me my repeat was too big. This post here has links to the two options that I have found. https://community.esri.com/t5/arcgis-survey123-ideas/quot-same-as-last-quot-option-for-repeat-records/idi-p/1213432 Hope that helps

Is there a reason you are nesting all those concats and not just using one? I see no reason for all of those just do one big one. I would try that.

The one posted above should be pretty close. The team here at Community was looking for one also.

Have you tried using calculationMode=whenEmpty? https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-calculation-modes/ba-p/1206967

Do you mean you want them to line up from the repeat like repeat 1 = label 1? If so I would take a look at this function note it may not like this in the label - if it does not make a calculate field with this code then use that. indexed-repeat(question, repeat, index number) Returns the value from a specific question in a repeat record. For more information, see Repeats. indexed-repeat(${room_no}, ${floor}, 3)

Have you tried FeatureSetByName instead? It can get picky. Also the table is in the map right?

Have you looked at using Inbox? https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepareforediting.htm

You can use count() for this. count(${SomeQuestionInTheRepeat}) > 1 should do it.

In the area column I do not think you can list all the options with a comma since it does an exact match search. You need to break this out and list them multiple times, one for each area type. At least I have never seen a comma lookup list work.

My last post there https://community.esri.com/t5/arcgis-survey123-questions/mapping-with-survey123-within-a-polygon-or-admin/td-p/836112 lays it all out. Depending on the project I try to make some meaningful id. We prepopulate our points and have pregenerated ids that are usually State_ProjectName_PlotName type format. Others we may visit multiple times I year so there I use Arcade to add a date stamp to the PlotID in Field Maps and then send that ID over. That one is tricker though since in the past since Arcade is not a real field. But now with the FieldMaps form you can Calculate an ID in FM then send that over to 123 via a URL. My formula is Concatenate($feature.PointID, "_", text(ToLocal($feature.FieldEvalDate), "Y-MM-DD")) For past data you can add the new ID field and the calculate the key based on the join using globalid. You would need to get the relationship class in there though and I am not sure how to do that without republishing. So if you are live time this is all of course much harder and it gets complicated from there. Hope that makes sense its a advanced workflow for sure.

Update to myself. 2 years later and it is still doing it. I finally found a fix. If you set your count field that has a calc of 1 to also have a default value of 1 then the repeats calc properly.

I suggest making a copy of the form and publish that right from 123. Then download that as a GDB and you will see how it wants the structure.

No there is no way to do that. A python script after that fact would be about the only way.

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by DougBrowning

Re: Error message of 'Arithmetic overflow error converting expression to data type int' but for only 3 of 70 field staff

Re: Dependency Cycle - trying to have a calculation for a question reference itself from a previous repeat given certain logic

Re: Dependency Cycle - trying to have a calculation for a question reference itself from a previous repeat given certain logic

Re: Error message of 'Arithmetic overflow error converting expression to data type int' but for only 3 of 70 field staff

Re: Looking for an image that shows all the Esri tools in one graphic

Re: Manually Entered Data in Survey Start Date Field

Re: Set up relevant questions based on number of repeats entered by user

Re: Table won't load in Field Maps Arcade -- error Code = 3072

Re: Have Surveys have multiple contributors

Re: Set up relevant questions based on number of repeats entered by user

Re: Using choice_filter with select_multiple

Re: Integrating Field Maps with Survey123 using globalid and joining in AGOL or ArcPro

Re: once(join()) work differently on the first repeat

Re: Global ID of relationship is in attribute instead of value filled in survey

Re: Select multiple records and submitted records should be individual

Re: Table won't load in Field Maps Arcade -- error...

Re: GlobalID in lowercase from Collector to Survey...

Re: GlobalID in lowercase from Collector to Survey...

Re: Large Dataset - Performance Issues

Re: Set up relevant questions based on number of r...