Solved: How to retrieve a value from a dependent drop down... - Page 2

rafaelpazsud · 10-15-2024 08:15 AM

I have a dependent drop down menu below (Categories --> Category --> Attribute --> Column Type).
Column type will always display one single value, in the image below it's "STRING".
As you guys can see after selecting "Attribute" "Column Type" appears unselected. I'm having a very bad time trying to automatically selecting it after "Attribute" is selected, however, not able to do it yet. At the moment I can only select "Column Type" clicking on it and I need to be automatically as It will be a hidden property that I will use within an external API, so the user doesn't need to see it.

Can someone please help with that?

rafaelpazsud

I was able to achieve what I was looking for using the formula below, just in case someone also has the same issue:

SELECT(TB_PROFILE_SCAN[COLUMN_TYPE],AND([VALUE]=[Attribute],ISNOTBLANK([_THISROW].[Attribute])))

View solution in original post

How to retrieve a value from a dependent drop down NOT selected in Appsheet