3 Replies Latest reply on Jun 21, 2011 11:25 AM by philmodjunk

    Display Design Questions

    aammondd

      Title

      Display Design Questions

      Post

      Im trying to find a way architect fields used for display purposes. (ie tab label calculation fields etc) so as to not clutter up the actual tables.

      Im looking for some tips on how to do this.

      I currently have a table of Global fields that tracks a specific users environment including layout/table. I was thinking of using some cartesian relationship scheme to this table to collect the layout display fields since I could then relate any calculations needed.

      Any input would be appreciated.

        • 1. Re: Display Design Questions
          philmodjunk

          You might also experiment with global variables inserted as merge text on your layout. This approach avoids defining any field for display purposes.

          It can be a bit tricky, but you can even use a let function inside a conditional format expression to assign a value to such a variable.

          • 2. Re: Display Design Questions
            aammondd

            I tend to stay away from these because they are less "tracable"

            However a design reference table in the app help system might suffice in this case. What are some of the limitations. I know I need to setup the global variables via a script step, so is this best at statup?

             

            • 3. Re: Display Design Questions
              philmodjunk

              Sometimes you don't even need the script step.

              Say you give a layout object this conditional format expression:

              Let ($$Total = Sum ( Relatedtable::Field ) ; True )

              $$Total is then given a value without any script being used.

              Some Developers add the Layout text: "I declare variables", then use a conditional format expression to assign values to the global variables with such a use of the let function. The format applied is one to render the text invisible when not in layout mode so the user does not see this text.

              This way, the layout itself declares the variables. I'm not totally sold on this trick BTW, it can be tricky sometimes to get the variable to update correctly and the "side effect programming" style this requires isn't something I like doing as a general rule.