Latest Contributions by DougBrowning

‎02-14-2019

My code is the same as yours. But your sheet is doing the same thing for me. occ_names will just display the value of the repeat I am on. So if on repeat 1 it just lists repeat 1 value. If I move to repeat 2 I get just repeat value 2. It changes as I cycle back through the repeats also. I have Connect 3.0.128. ...And so I went and got 3.2.196 and now it works! Thanks

‎02-13-2019

NO_TEST always brought over the common fields just fine for me. I use it a lot actually. I am trying to remember if a Join messed it up.

‎02-13-2019

I found the join(separator, question) function listed on this help page https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm But when I use it I only get the value in the last repeat. No comma or other repeat data at all. It changes to the last value in the repeat whenever a repeat is added. I saw some posts of it not being ready yet but that was back from Nov 2017. Thanks

‎02-13-2019

But would in-version, re-version work? Some of the datasets I want to reorder are 300+ fields so getting it all just perfect will be tough.

‎02-13-2019

FS = Feature Service FC = Feature Class

‎02-13-2019

Depends if you want it in the same record as the Survey123 form. Add a Photo question to the form. When filling out the survey just leave it blank. Then later the user could plug the camera in to the computer. Go into a AGOL web map that has the Survey123 Feature Service in. Click to get the popup of the feature then click Edit. You will see a Add Attachment at the bottom. Add it there. All Survey123 does is enable attachments on the FS - then you can use it anywhere just like regular attachments. You can also have a separate FC just for photos.

‎02-13-2019

Assuming you are offline. A lot of these cameras have Bluetooth now. You could Bluetooth file transfer to the tablet. Maybe you are lucky and the camera uses a SDCard and you have a Samsung with a SDCard reader built in. If not you can also buy external SDCard readers for tablets. There is a slight chance you can use the camera cable and plug into the tablet. If the tablet has a cell card and the camera has WiFi you could turn the tablet into a hotspot and connect to it. Hope that helps.

‎02-13-2019

Has this changed at all in the last few years? I used SSMS in the past to reorder no problem. But I am not sure I ever did it on a versioned table. I mostly used it to change GDBs. I would copy the GDB into SQL, reorder fields, then copy out to a new GDB. Is it the versioning that makes this different? The tables are new on a Dev server so I could maybe un-version, reorder, re-version? Thanks

‎02-12-2019

This does work for me. Thanks. But why not use this function from the help? I tried it but it is not working. It only displays the value in the last repeat for some reason. join(separator, question) Concatenates all answers to a given question in a repeat, separated by the given separator. join(',', ${question_in_repeat})

‎02-12-2019

Add a column to your choice list that has say a 1 or 0 in it - 1 if you want to count it. Have field 2 do a pulldata on the species name that grabs the 1 or 0. Then do a count or sum on that field with the number in it. Opps missed the unique part. You need another field that does a concat to create a list of all values in the repeat. Then add a If on the count that has a contains on this field. So If FieldA contains FiledB then 1 else 0. This a good post about making a field list. https://community.esri.com/thread/189428-summerize-data-within-a-repeat-survey123

‎02-12-2019

It was text but I had it as Read Only. This may work. Thanks I still vote for allowing anything to be copied in the app. thanks

‎02-12-2019

I can display the text just fine. My issue is Survey123 will not let me highlight and copy via Android (so the tablet built in copy/paste). I want to highlight and copy the text to say MS Word on the tablet. Copy seems to be blocked and not sure why. thanks

‎02-11-2019

I have a field where the constraint comes in from Collector. I can use this field in a constraint no problem .>=${GapMin} But if I try to use it in my constraint_message here Gap length must be at lease ${GapMin} cm I get this (it puts /formname/summary_info/fieldname How can I use this number to make my constraint message flexible? Thanks

‎02-08-2019

I have a form where I am tracking all the Unknown Codes entered in a repeat. I then give this list to the user at the end of the form. I want them to be able to copy and paste this list into another tablet program. But if it is a note or read only the tablet will not highlight and copy it. Thinks it is not text I guess. I can make it a text instead but then the user might accidently delete it when trying to copy it. Also on some tablets the copy blacks out the text (instead of the blue highlight). Why is copying blocked? What is the best way to do this? Is there a copy button or action I could use? Like a copy to clipboard option would be sweet. Or maybe even a URL that opens Memo or Word? I need it to work on Android and Apple. Thanks

‎02-08-2019

Do you know why {relationships/1/objected} (with Count option) works in AGOL popup but not in Collector? It works great in a browser but Collector it is just blank. Thanks

Online Status	Online
Date Last Visited	Thursday

My Ideas

Latest Contributions by DougBrowning

Re: Is join(separator, question) supported yet?

Re: Append tool not honoring common fields

Is join(separator, question) supported yet?

Re: Permanently Reorder Fields in Feature Class (SDE)

Re: How to add photos taken from another device, say a under-water camera,to the data record on Survey123 webmap in ArcGIS Online?

Re: How to add photos taken from another device, say a under-water camera,to the data record on Survey123 webmap in ArcGIS Online?

Re: How to add photos taken from another device, say a under-water camera,to the data record on Survey123 webmap in ArcGIS Online?

Re: Permanently Reorder Fields in Feature Class (SDE)

Re: Summerize data within a repeat. Survey123

Re: Counting unique values

Re: Notes blocked from tablet Copy/Paste

Re: Notes blocked from tablet Copy/Paste

How can I use a field in the contraint message?

Notes blocked from tablet Copy/Paste

Re: Can I get/use the number of related records?

Re: how to prepopulate a question from a layer by ...

Re: how to prepopulate a question from a layer by ...

Re: how to prepopulate a question from a layer by ...

Re: how to prepopulate a question from a layer by ...

Re: Roll back the June 2026 update?

ArcGIS Arcade