0 Replies Latest reply on Jun 6, 2015 12:32 PM by dsimonson

    Turning mini-portals into a virtual list



      Turning mini-portals into a virtual list


      My previous anesthesia record solution used “mini-portals” to display observations on the record.  I have attached a screen shot of the layout in Browse and Layout modes.  The lower, layout mode shows one of these items selected.  It is a portal with one row showing.  

      As you can imagine, the processing that goes on to show all of these portals is intense - the screen refresh time on an iPad is unacceptable.  What I would like to do is use a “virtual list” to show these values rather than all of these portals.  

      So - I figure I need a calculation that takes all of the records visible through the filtered portal relationship and assembles them into a tab-delimited format that I can then display arrayed across the layout in a similar manner as these little boxes.  I could insert pipe characters in between the values and somehow create a much similar display, but the layout would not have to refresh all of these little portals each time.

      I am thinking of a creating a SQL statement that gathers the records into a list, and then replaces the pilcrow character with a tab character and (perhaps) a pipe, and finally displays that in one single line but very wide text field with appropriate tab stops.

      Some problems I foresee is the quirkiness of text and fonts screwing things up between devices (although this is meant for iPad and will be tested there).  I also worry about blank records, which will need to be place marks and not ignored.

      Also, should I try it by creating a calculated field, or fill a field with the results of a script?


      Dan Simonson