Hey,
So I want to change the menu view name based on a drop down from another view.
For example, user picks Countries by continent from a drop down in a form. Once saved the view named โCountriesโ on the menu view changes to โCountries by continentโ.
Do I use a behavior for that? Confused as to what formula to use or if Iโm linking to another page.
Thanks
Solved! Go to Solution.
Hey Ivy.
In the view thereโs a section (Display) and inside it youโll find โDisplay name.โ
You can either use regular text (like you see in the image below) or if you hit the toggle you can use a formula:
Inside the formula space you can build your formula there, some kind of IF() statement.
Where is this dropdown? In Usersettings? If so, an example of what that formula would look like is this:
IF(
ISNOTBLANK(usersettings(Countries_By_Continent)),
"Countries by continent",
"Countries"
)
If your dropdown is a selection of continents and you wish to include that specific continent name in the view title, your formula would look something like this:
IF(
ISNOTBLANK(usersettings(Countries_By_Continent)),
concatenate("Countries by ", usersettings(Countries_By_Continent)),
"Countries"
)
Hey Ivy.
In the view thereโs a section (Display) and inside it youโll find โDisplay name.โ
You can either use regular text (like you see in the image below) or if you hit the toggle you can use a formula:
Inside the formula space you can build your formula there, some kind of IF() statement.
Where is this dropdown? In Usersettings? If so, an example of what that formula would look like is this:
IF(
ISNOTBLANK(usersettings(Countries_By_Continent)),
"Countries by continent",
"Countries"
)
If your dropdown is a selection of continents and you wish to include that specific continent name in the view title, your formula would look something like this:
IF(
ISNOTBLANK(usersettings(Countries_By_Continent)),
concatenate("Countries by ", usersettings(Countries_By_Continent)),
"Countries"
)
Thanks, how about if the column is not in user settings but just a random table?
Just replace the โusersettingsโ table name in the example with the name of the โrandomโ table. I assume itโs not actually random
Not quite @Mike, @ivyberries youโll need to change the syntax:
IF(
ISNOTBLANK(Table[Countries_By_Continent]),
concatenate("Countries by ", usersettings(Countries_By_Continent)),
"Countries"
)
If you need to find something based on the USEREMAIL(), replace the part inside the ISNOTBLANK() with a LOOKUP():
LOOKUP(USEREMAIL(), Users, User_Email, Column_You_Want)
@MultiTech_Visions - oops! I donโt use usersettings much yetโฆ
@Mike yeah, tried that. Failed but made me think.
@MultiTech_Visions That worked like a charm, thank you very much.
Sorry, I donโt understand why I cant wrap my head around this. Now I cant pick any other choices from the dropdown to display as View Name except countries by continent.
I try comparing inside the if (), I get this error โCannot compare List with Textโ. Is there a way to compare, check if true(Selected by User) and pick that option from dropdown to display as View Name?
How are you storing this data? It would help to have a little understanding of how youโve put things together, then I can give you a formula example more directly related.
Are these controls in UserSetting or a table?
So I have my country sheet blank except for my heading, [Name].
In data, I put column [Name] as enum and placed my choices on that. So the view has my dropdown, about 6 choices. Depending on what the user picks I want the view name to change. The formula above is great only it gives me one choiceโฆhope I make sense.
How many people will be using this app, and will each user get their own record in the โCountryโ sheet?
Sounds like youโve got a โcontrolโ sheet, this is a good setup, we just need to dial in for one or many people.
If youโre the only person using the app, and there will only be one record in the Country table, then you could simply wrap the table part of your formula in a ANY() - this pulls 1 record out of a list.
ANY(Countries[Name])
But if youโre going to have multiple people using the app, and youโre not using private tables, it might be a better idea to move this control into UserSettings, this way itโs always user specific.
User | Count |
---|---|
31 | |
25 | |
22 | |
22 | |
15 |