topic Re: Field Maps coded value domains/choice lists from hosted CSV? in ArcGIS Field Maps Questions

Field Maps coded value domains/choice lists from hosted CSV?

EvanR — Wed, 18 Oct 2023 21:28:50 GMT

In Survey123, you can define a choice list as a hosted CSV file, which makes it easy to share a single list (park codes, observers, species, etc.) across multiple surveys, and means you can update the list without needing to re-publish each of the individual surveys that use it. Is there a way to do the same thing to define choice lists/coded value domains for Field Maps forms? My searches have turned up nothing so far, but it sure would be useful. If it's not possible currently I will submit a feature request.

Thanks,

Evan

NPS

Re: Field Maps coded value domains/choice lists from hosted CSV?

LayerItOn — Tue, 05 Dec 2023 17:39:27 GMT

Hi @EvanR, not as far as I know, but I would love this feature! Perhaps someone else may have some insight.

What I end up doing is have a master list in google sheets that I keep updated. Every time I have new updates to the list I download it as a .csv. Then in field maps I click the combo boxes that need updating > click on "edit list" > then drag and drop the .csv into the list editing pop-up window.

But I need to repeat this step 20+ times since I have multiple combo boxes that use the same dropdown list.

Re: Field Maps coded value domains/choice lists from hosted CSV?

EvanR — Tue, 05 Dec 2023 17:51:36 GMT

Thanks for the suggestion - that's an improvement on our existing workflow. Does the csv just need "code" and "label" fields in order for the tool to recognize it?

I think pulling from a hosted csv should be submitted as an "Idea" for a feature request, as I haven't found any way to do that (including asking an ESRI rep). I will work on that when I have a chance, or would be happy for someone else to submit the request and I will support it. @LayerItOn, sounds like you have an even stronger use case for this feature than I do.

Re: Field Maps coded value domains/choice lists from hosted CSV?

LayerItOn — Tue, 05 Dec 2023 18:11:57 GMT

Woo! Glad to help 🙂

So technically: label is what the data collector sees and then code is what gets recorded in the attribute table. However, even though I set it up this way, my attribute table still records the label value and not the code. I am assuming this is a bug- Documentation about form configuration and list of values

Anyways- the .csv needs to be formatted a specific way for the drag & drop option to work. More info about it here.

Ultimately what I do is create a two column list in Google Sheets. Do not include headers (it will turn into a list option). Even if you want the label and the code to be the same value, you still need two columns for field maps to read it correctly.

Make sure to organize the list A-Z (or however you need to organize it) prior to dropping it into field maps so it is easier for your field data collectors.

Then in google sheets I go to file> download > .csv.

Then I drag and drop that badboy into the field map's "edit list" pop-up window.

Hmmm, it may have already been requested as an idea for Field maps (I think I have seen it before but not sure), but I would totally support it too!

Re: Field Maps coded value domains/choice lists from hosted CSV?

LayerItOn — Tue, 05 Dec 2023 18:25:22 GMT

@EvanR It doesn't look like it has been a suggested idea yet for Field Maps. Added it- https://community.esri.com/t5/arcgis-field-maps-ideas/hosted-csv-choice-list-for-field-maps/idi-p/1357026/jump-to/first-unread-message

Re: Field Maps coded value domains/choice lists from hosted CSV?

EvanR — Tue, 05 Dec 2023 18:47:24 GMT

Great, thanks! And thank you for the additional details about the CSV drag-and-drop option.