I haven't posted since the name changes, so if this is the wrong spot, please let me know.
I'm back working on my performance management solution and the Gigs layout. Below is the main Gigs layout, which includes a portal to gigs_PERFORMANCES (colored rows) of songs in a performance. Each row also has a set and slot to be assigned which is summarized in the set of one-row portals at the top (circled).
What I have now is fairly straight forward - each summary portal is one row and filtered by Set number. In the set list portal, each row also includes the Roster of who will be performing, where there will be one or more performers.
I'd like to have the summary area look something like this (mocked up) where the same info is there, but in addition, there would be columns for each performer. It's not a problem if the song count is duplicated (i.e., two singers might increment the song count) if I could also show a column where duets (or multi-performer songs) are being performed. The goal is to provide performers with a copy of the list and show them how many songs on which they will be involved. The number of columns would be automatically created based on the singers found in the Roster field of the current gig (and portal row).
Any suggestions? And thanks for input.
Relevant TOs are here: