Enum Drop-down Menu

AppSheet AppSheet Q&A
, , ,
1

I have to make an auto select dropdown menu. I want that if the start value matches with my data sheet, then it should be selected in the dropdown in front of it. Even if there is no value match.

So the dropdown menu should be shown in the form, so that I can select the dropdown myself.

2

Hi @Sayad

You may want to consider this for the dependent dropdown part:

https://help.appsheet.com/en/articles/961554-dependent-dropdown

and use an initial value expression for your “auto-select” part.

Without more context, I suggest a combination of:

https://help.appsheet.com/en/articles/4742175-startswith

https://help.appsheet.com/en/articles/2347632-any

https://help.appsheet.com/en/articles/2357308-filter

It could be something like:

IFS(
  ISNOTBLANK(
    FILTER("yourSourceTable",
      STARTSWITH([descriptionColumnInSourceTable],LEFT(yourCriteria],5))
    )
  ),
  ANY(
   FILTER("yourSourceTable",
      STARTSWITH([descriptionColumnInSourceTable],LEFT(yourCriteria],5))
    )
  )
)

Note: for future posts, please provide screenshot/context.

1 Like
3

see my table details

My enum

enum
enum595Ă—252 8.8 KB

startswitch valur table
startswitch valur table607Ă—499 16 KB

4

Valid_If:

FILTER("ENUMLIST", [CHANNEL]=[_THISROW].[Channel])

Initial_Value:

ANY(FILTER("ENUMLIST", [CHANNEL]=[_THISROW].[Channel]))
1 Like