Is there any way that you can have an enum fi...

[Miranda_Lubarsk]

Is there any way that you can have an enum field default to a value?

For example, if I have an enum list of items, is it possible for the first value on the list to appear by default, but then also give the user the option of changing it if they want?

Thanks!

[Aleksi_Alkio]

You have many ways to do it… let’s take this one as an example. If you use Valid_if with the formula SELECT(Cars[MODEL],[MAKE]=“Toyota”) you can find the first value from your table with ANY(SELECT(Cars[MODEL],[MAKE]=“Toyota”)).

[Stephen_Mattiso]

Also can add the value you want to appear

into the Initial Value of that column.

[Miranda_Lubarsk]

@Aleksi_Alkio @Stephen_Mattison Ok guys, thank you for your help.

Is there a way I can use a reference in the Initial Value field?

I tried typing the expression below into the Initial Value Field, but all it does is show the words “Design Numbers for 2018” in the field when I open the form.

What I want it to do is reference that table to find the tray size.

Thoughts?

=‘Design Numbers for 2018’[Plant].[Tray Size]

[Miranda_Lubarsk]

Ahh!

I got it!

Nm, thank you thank you.

Didn’t realize that I didn’t need to specify the table of the column for app–sheet, apparently it’s smarter than I thought.

That’s pretty darn cool.

Used this:

=[Plant Name (1)].[Tray Size]

Almost too easy!

[Aleksi_Alkio]

You don’t need to use the table name itself because you have that relationship already.

[MARSLI]

only solution is : use Valid_if with the formula :
sheet[column]

and use initial value with formula :
Any(sheet[column])

[mbnumba6]

Ok I’m stuck and having a hard time understanding the answers on here (new to appsheet).

You can see in my screenshot, which two things are connected.

I am trying to set the default value to “3”.

So when someone first opens the app, the “3” is already selected/highlighted, but the user can select “4” if they wanted too. Can anyone help me with this? I’m not sure4 how to use the “initial value” or expressions in the edit column part.

[lubu08]

If you input: 1,2,3,4,5,6,… then set “Base type” to “Number”

[Jeff_Partain]

Set the “Initial value” to “3”