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?