How to Use a dropdown item to auto populate the fields?

I created a simple test app to figure out the proper way to auto populate fields when selecting an item within a dropdown menu. I read some other Questions but I am confused a bit by the workflow
The App:
The user creates a new Main record and chooses or creates a new item from the Main List drop down menu. If they choose an item from the list, it will auto populate the Main Name field.

What is best practice to do this?

This is what I have so far that references the items data for the dropdown menu. The hard part is connecting the item selected to the Main Name to auto populate. Do I need to use a Lookup?





main_table_DropdownTest
list_table_DropdownTest

An Initial Value expression on the [Main Name] field/column

1 Like

Do you mean like this? Does do anything when I choose an item on the list that already has a Main name associated to it…

What do you want inside [Main Name]??
I strongly encourage you to read the whole docs page

2 Likes

I need to revise this as the current setup does not do what is expected. In order for the fields to be auto populated I need related fields, not the Main Name to be populated since this is the creation name.
I have therefore created an additional column in the List_Table called color which will be auto populated by the dropdown item selected. This makes more sense.

ListItemsColorAdded

With this information the create new main now looks like this:

Essentially, I got it to work using a Virtual Column

Thanks, I will review that. Yes, I can now see how my question is pretty confusing. I was missing another field that would make this question easier to follow. It is NOT the main name that needs to be auto populate but a field related to the List. I therefore created a new field called Color in the List_Table and added a Virtual column to point to the reference.
The question would be revised to ask how to auto populate the color field when an item is selected via the dropdown menu.
My solution was to create a Virtual Column with formula [Main List].[Color].

It all depends on your usecase.
The virtual column will always give you the updated “Color” from the List_Table
If you need to log that value when the main record was created, you could use a normal column and Initial Value expression

I tried what you suggested and now understand what you mean. In this case, the fields get auto populated, logged to the Main_Table and you can change the name if you want.

Would this work the same way if it was an Image being selected from the drop down menu?

Main_TablegSheetColors

Result auto populated colors field which is also still editable…

You could even configure it on “Editable?” to just make it uneditable or let an expression deside

Really? That sounds interesting. How would you go about doing that?

All columns have an option to set if the user should be able to edit the field under it’s config


The thing at the right opens an expression assistant

1 Like

I see, so you add an expression inside here. Do you know of any template apps or tips that can help me understand the correct expression syntax and case uses?