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.
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.
see my table details
My enum
Valid_If:
FILTER("ENUMLIST", [CHANNEL]=[_THISROW].[Channel])
Initial_Value:
ANY(FILTER("ENUMLIST", [CHANNEL]=[_THISROW].[Channel]))
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |