Enum / Enumlist base type ref improvement

[Koichi_Tsuji]

I just noticed an improvement.

In case we set the column type to Enum or Enumlist, with base type ref, we HAD TO add expression which return the list of IDs for the referenced table to generate the dropdown option.

I noticed we no longer need to set the valid if / suggested value expression. AppSheet is generating the list now.

@Steve @Aleksi

@Takuya_Miyai

[Fabian_Weller]

Hey...ENUM and ENUMLIST...Did anyone notice? Questions

Maybe I’m late to the party?? When we set a column to type ENUM or ENUMLIST with a base type of REF, we no longer need to save before we can set the Referenced Table. Yeah!!!

[Aleksi]

Yes that’s true

[TotalSolutions]

I selected the Type as EnumList and Base Type as Ref but the dropdown is blank! Please guide. Thank You!!

[Marc_Dillon]

Did you set a valid_if expression?

EDIT:

My quick test shows that this:

tsuji_koichi:

In case we set the column type to Enum or Enumlist, with base type ref, we HAD TO add expression which return the list of IDs for the referenced table to generate the dropdown option.

I noticed we no longer need to set the valid if / suggested value expression. AppSheet is generating the list now.

…is not currently true. a Valid_if expression is still required.

[TotalSolutions]

Please let me know what do I write in Valid If?

[Marc_Dillon]

your-table-here[this-tables-key-column]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

[TotalSolutions]

Excellent!! Thank You!!

[Steve]

help.appsheet.com

Search results for: dropdown valid_if

[Koichi_Tsuji]

New code roll out, roll back all the time (due to various reasons)

Unfortunately, the behavior we observe before is not available all the time just because of it. (AppSheet Phantom I would say, otherwise due to gaining ages to me. )

[Steve]

Attn @Arthur_Rallu

[Koichi_Tsuji]

I m not sure what is the truth…