nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Open List Retain value when Editing Survey

DominicRobergeIADOT

Hello,

I am following the steps from this post Open List and it's working fine to ge my unique list of values in the dropdown list

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-open-lists/ba-p/1180879

However, when I Edit the survey, I "loose" the original value that was entered. How can I retain the original value when I am in edit mode?

- I've tried Calculated field , not working

Attached the section of the spreadsheet showing above.

The process is working fine with CSVs... I just would like to be able to use the "live" data from the map service as users start to add more options for each dropdowns.

Any help or suggestions would be much appreciated.

Thanks!

IADOT_DataCatalog_Master_ESRI.xlsx

Find more posts tagged with

Accepted answers

All comments

nkittelson.pfmd

@ChristopherCounsell The method posted by Ishmael that he references, does in fact allow for what he is describing. He is trying to do exactly what Ishmael is outlining, with the exception of showing the previous answer. The method actually does allow for editing items in the list as well as adding new entries. This method itself could cause issues in data management, multiple spellings. etc, but it does allow for editing of existing items in a live list.

ChristopherCounsell

It's not possible to have a select_one question that also allows for raw text entry into the same question/field.

The standard solution is to have an 'other' option in the select_one drop-down that has relevancy to a second question/field. Here the user can manually enter the entry not currently available in the list.

Your current form navigates this well for new entries but won't work for editing existing values. Trying to have this setup this way will expose you to logic loops or issues updating the value later on.

I would recommend the traditional approach (select_one field + relevant other field) or just adding the fields in for your existing workflow. Or, have one form for collecting and another method for editing (be it a survey form or map viewer form).

DominicRobergeIADOT

@Neal_t_k , I don't think this is going to work as the calculation over write the existing value with the coalesce formula. I am probably going to need an IF statement there instead...

nkittelson.pfmd

So I think to solve your issue and show what was submitted when edited you would have to unhide your "calculate" field. You could set it as read-only. Your current select-one field would remain blank on edit as it is set to "null" but the read-only field would show as the last submitted entry. However that would update on entry (which I think is the point). I made the changes in the attached.

IADOT_DataCatalog_Master_ESRI.xlsx

DominicRobergeIADOT

Hi @ChristopherCounsell

Yes, I have 2 "dummy" fields as NULL used as place holder (one for the dropdown list and one for the "Other" option). I do not want to created true fields has I want to use this process for the entire survey and I have about 10 questions with dropdown list.

The current process work GREAT if I create a new entry from scratch. How could I make use of the search functionality to populate a dropdown using live data from the map service, with an Other option in case of a new value for that dropdown and retain the existing value.... all that without having to create 2 extra fields in the layer.

Thanks!

nkittelson.pfmd

the WEI_DBMS field is not null, it is string and is the coalesce calculation where the data should be stored.

@ChristopherCounsell Nevermind, I see what you are saying. The field that appears in the form is not being saved! Hence why it appears blank in the form on edit.

It still appears the answers are being saved to a different feature/field then they are being pulled from though.

ChristopherCounsell

It's a dummy field

It's field binding is null

nkittelson.pfmd

Are you pulling your list from the same feature layer that you are writing your answers to? Your field that the answers are being written to is "WEI_DBMS" and you are searching a field titled "SDBMS". It appears, if I am following the "Tricks" post correctly that those two fields should be the same and that you are searching from and writing to the same feature.

ChristopherCounsell

Your field binding is null for the question. You're using this and a calculation to populate the actual field that's hidden in the form.

It means that no field is created for the question with the drop down. No value is submitted for that question, and won't appear again when editing.

You need to consider:

Removing the null bindings (create a field to store the user interface value)

You could also review the whole setup, use calculation modes, but I think it'll get messy and introduce loops. Adding the field is the most straightforward solution if you are editing these values later

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.