Question about a form view: I have a depende...

(Diogenes ASBL - VZW) #1

Question about a form view:

I have a dependent dropdown structure: EG:

[Continent]: where you select the continent [Country]: where you select the country of the selected continent.

In the form view you will only see the [Country] dropdown appear when you selected a continent.

Is it possible to select somewhere that the [Country] dropdown is always visible?

thx Bram

(Aleksi Alkio) #2

Maybe like… IF(ISBLANK([Continent]),{Continent not chosen},TableName[Country])

(Diogenes ASBL - VZW) #3

Hi @Aleksi_Alkio

In fact what I tried to do is this Valid_if formula for the dependent dropdown column:

=SELECT( List Countries[Country], OR( [Continent]=INDEX(Parametres[Continent],1), [Continent]=INDEX(Parametres[Continent],2), [Continent]=INDEX(Parametres[Continent],3), [Continent]=INDEX(Parametres[Continent],4) ) )

This with the purpose that you can select the countries of multiple continents.

Problem is that the form view only popups the country when you make a traditional dependent dropdown with an enum column for continent in stead of an enumlist

Strange thing is that when you make this kind of Valid if formula in the Usersettings … than it works fine!

But when you make the same thing in a table than it’s not working…

thx for all your help …