Menu and Submenu

Hello 

I want to slice app menu with the formula in Row filter condition

OR([UX]="SETTINGS",
AND([GROUP]="HOME",IN([UX],LOOKUP(USERSETTINGS(LEVEL),"SETUP","LEVEL","MENU"))),
IN([UX],LOOKUP(USERSETTINGS(LEVEL),"SETUP","LEVEL","SUBMENU"
)

in application "A" the formula can run but I try to apply it in application "B" the formula does not work. What the problem is?

0 2 142
2 REPLIES 2

We need more details. 

For starters, what does "does not work" mean?   Do you get an error? Is it just doesn't return the result you want? What specifically occurs?

Thanks WillowMobileSys for responding to my question

Before my app was blocked by appsheet, this formula worked,

OR([UX]="SETTINGS",
AND([GROUP]="HOME",IN([UX],LOOKUP(USERSETTINGS(LEVEL),"SETUP","LEVEL","MENU"))),
IN([UX],LOOKUP(USERSETTINGS(LEVEL),"SETUP","LEVEL","SUBMENU"
)

menus can be displayed based on user level, and when the submenu is clicked, the next menu will appear

now my application is not blocked by appsheet but the menu display doesn't match

 

Top Labels in this Space