The Creative Genius of Kaostika Studios has struck again. A few years ago, I created a technique to use Conditional Formatting to trigger Merge Variable and display info. It is almost like Display Calculations. Well now I have struck again. You can use SQL commands in the conditional formatting and use SQL (If you have a plugin). So you can set up a layout with out fields and only use Merge Variables.
Here is a use case. I have a client that has multiple addresses. So I want to show just the address they pick from the many they have for a client. To show it on another layout I would need to set up a special relationship or use a filtered portal with a calculation in it. This take a lot of time to set up.
Well those days are gone. I can set up a SQL command like
( epSQLExecute( "
WHERE id=" & epSQLQuote(Var::Id)
So you can have this SQL command to get the correct address based on the conditions you use in the conditional formatting.
Bye Bye Graph!
I enclosed a sample file. It is this easy. You need the custom functions to set the variable and then just put in the SQL. I use SQL runner as the plugin.