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 |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |