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
Maybe like… IF(ISBLANK([Continent]),{Continent not chosen},TableName[Country])
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 …
Bram
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |