topic Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field. in ArcGIS Field Maps Questions

Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Mon, 29 Jul 2024 13:35:02 GMT

Hi there,

New to ArcGIS here, so please bear with me. 😉

I have several lists of coded features (e.g. habitat codes and bird species codes; please see screenshot below) which I want to apply to drop down menus in Field Maps Designer to collect data in Field Maps. I would like to create a dropdown menu for each of the 2 code types which will autopopulate the name in the next field in Field Maps.

Is there a simple way to do this in Field Maps Designer?

Thanks in advance.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

jcarlson — Mon, 29 Jul 2024 13:58:12 GMT

I do not believe such a thing is possible in Field Maps. To my knowledge, dropdown menus there will be based on either a field's domain or a hard-coded list of options.

If you need a dynamic dropdown list, Survey123 is what you need.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

RyanUthoff — Mon, 29 Jul 2024 14:33:33 GMT

This might be possible using contingent values. It allows you to define valid field values that are dependent on values in other fields. It might be tedious to setup though. https://doc.arcgis.com/en/field-maps/android/use-maps/fill-out-forms.htm

You also might be able to accomplish this in Arcade, although it you might end up with a huge Arcade expression if you use a bunch of if statements. See this blog post. https://www.esri.com/arcgis-blog/products/field-maps/field-mobility/common-calculated-expressions-for-arcgis-field-maps/

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

RhettZufelt — Mon, 29 Jul 2024 15:34:11 GMT

How is your list 'related'?

From your question, why can't you just use your coded lists as domains/choice list? These will automatically be available as a dropdown in Field Maps app.

Are you trying to get the code in one field and the full name in the next?

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Wed, 31 Jul 2024 13:56:02 GMT

Thanks @RhettZufelt.

Yes, I'm trying to get the code in one field and the full name in the next. Do you know how I can achieve this?

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

RhettZufelt — Wed, 31 Jul 2024 14:47:42 GMT

If you set up a Domain/Choice List on your first field (I used the NAME field):

Then in the edit Form, I have calculated value for the ALT_NAME field set to:

$feature.NAME

Then, when I add a feature and select the value from the dropdown in the NAME field:

The ALT_NAME field is automatically populated with the full name:

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Thu, 01 Aug 2024 13:37:01 GMT

@RhettZufelt thank you so much for this.

I have followed the first step of your suggestion fine.

However, can I just ask you to clarify where I can access the "edit Form" to get to the second step where I can calculate the value for the ALT_NAME field?

Thanks.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

RhettZufelt — Thu, 01 Aug 2024 16:55:59 GMT

This button in the map viewer will open the Form editor:

Then, highlight the field you want to calculate the value for (in this case ALT_NAME):

and click + New expression. (The check mark next to PopulateFullName means that expression is attached to the selected field)

And this is what my expression look like:

Then Click OK and save the map.

You can also edit the Form in Field Maps Designer:

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

JamieCooper — Thu, 01 Aug 2024 17:17:48 GMT

@RhettZufelt Are you doing this in Field Maps Designer?

@SarahJorgensen Thanks for asking the initial question - I've been needing help on this for awhile.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

RhettZufelt — Thu, 01 Aug 2024 17:25:54 GMT

Yes, or map viewer. See my post here from earlier today (I show both).

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

JamieCooper — Thu, 01 Aug 2024 17:56:36 GMT

Thanks for all your help!

I was able to replicate what you did by creating the Combo Box list using the code values as the list Labels and the full name values as the list Codes.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Fri, 02 Aug 2024 10:33:03 GMT

@RhettZufelt Excellent! It worked! This exactly what I was looking for! Thanks for all your help.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Fri, 02 Aug 2024 10:35:08 GMT

@JamieCooper Thanks for this tip too. It worked perfectly for me.

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Tue, 08 Oct 2024 16:35:45 GMT

Hi again @RhettZufelt,

Thank you so much for the solution to the query in Field Maps a couple of months ago. I have been using it a lot and it works really well.

I have now started using Survey123 to collect non-mapped data and I need to do the same thing i.e. get the code in one field and the full name in the next. I wonder if you would have a solution for that too?

Thanks in advance!

Sarah

Re: Create a dropdown menu of codes which will autopopulate the name from a related list in the next field.

SarahJorgensen — Tue, 08 Oct 2024 16:38:37 GMT

Hi @jcarlson,

You mentioned "If you need a dynamic dropdown list, Survey123 is what you need." I have now started using Survey123 to collect non-mapped data and I need to do the same thing i.e. get the code in one field and the full name in the next. I got the solution to this in Field Maps but would you know how I might do this in Survey123?

Thanks in advance!

Sarah