Force combination of field values to result in Specific Layout
Hi! Thanks in advance for reading this post..
I'm attempting to have a combination of field values to create a button that will go to a specific layout (there is one table/layout for every combination)
For Example: a user will select an Indicator, such as "Electricity" and each Indicator can be measured with "Preset 1, Preset 2, or Preset 3". So if the user selected Preset 1 for Electricity, when viewing the record they could go to a layout for it (ex. Layout named Electricity_Preset1). I haven't designed the tables yet either, and I also have IDs for each Indicator.
I could list a whole bunch of tabs and have 3 individual buttons within each tab but it wouldn't really narrow anything down for the user.
I've found something similar in which someone Forced a record to go to a specific layout but no info is really revealed: