How can I make a dropdown option to auto sele...

(Edgar Munoz) #1

How can I make a dropdown option to auto select? there’s only one option but I need it to be auto selected so it can jump to the next dropdown.

(Levent KULAÇOĞLU) #2

@Edgar_Munoz you can assign an Initial Value :slight_smile:

(Edgar Munoz) #3

@Levent_KULACOGLU and how can I do that? I tried ANY(TableName[FieldName]) but didn’t work

(Levent KULAÇOĞLU) #4

ANY(SELECT(TableName[ColumnName],TRUE)) should work

(Aleksi Alkio) #5

Or just write that value like “Option” into the initial value field.

(Edgar Munoz) #6

@Aleksi_Alkio But the value will depend on the previous value but it will only be One value so I want it to be selected automatically so it can go to the next question, not sure if I explain myself.

(Aleksi Alkio) #7

Then you are probably needing something like… SELECT(TableName[ColumnA],[ColumnB]=[_THISROW].[Column]) or LOOKUP([_THISROW].[Column],TableName,ColumnB,ColumnA)