October 22, 201114 yr I have a database with many different layouts. grouped into two folders. I would like a drop down menu pretty much identical to the in built Layout drop down menu found at the bottom left of the status toolbar. Reason being once I create a runtime solution, there won't be any status toolbar so this menu to hop between layouts needs to be in the GUI. Making 20 buttons with scripts to take the user to the specified layout is only going to clutter the screen. Thanks so much in advance.
October 22, 201114 yr Create a calculation field Layouts= LayoutNames(Get(FileName)). Create a value list using all values from Layouts. Create a global field g.layout, and put that field as a dropdown list on your layouts. Attach a script trigger to the field triggered by OnObjectModify. The script should be Go To Layout (Layout Name by Calculation)(Layouts). Keep in mind that this will allow users to access every layout in the file, even utility layouts. Also, if a user has to navigate to 20 different layouts, that's an indication that there might be something wrong with your data model or your user interface model. Offering 20 layouts to a user in a runtime will most likely lead to a lot of really confused users. Are you sure that you can't lead the user through the maze with judicious use of Next buttons? Or, at least, one Switchboard layout that has the 20 buttons, and every other layout has a Return to Switchboard button.
October 22, 201114 yr Keep in mind that this will allow users to access every layout in the file, even utility layouts. Well, you could use a custom value list - listing only the layouts you do want them to access. A calculation field using LayoutNames is problematic anyway, since it should be unstored - but then it's not so easy to base a value list on it.
October 22, 201114 yr Author Thanks for the posts. Let me see how I get along with these ideas and I'll let you know.
October 22, 201114 yr Author Sorry, Just one quick question. I don't really understand the calculation required once I have selected Go to Layout --> Layout Name by Calculation. I really don't know what formula to type in the calculation box. Thanks so much for your assistance.
October 23, 201114 yr I really don't know what formula to type in the calculation box. The field name of the calculation field (the one I previously called Layouts).
October 23, 201114 yr No, it should be the name of the global field - the one with the selected layout name.
Create an account or sign in to comment