I am trying to implement a different way to view data on our system. We are assigning staff members to a booking via a portal. Each booking will have a minimum of 1 staff, usually 3 staff and upto probably around 6. In order to make assigning staff to various projects on the same day easy we currently use a spreadsheet outside of Filemaker and then input the data manually into each records portal.
I assume there must be an easy way to view the Filemaker data like our spreadsheet but I am a little stuck. Any help and advice would be greatly appreciated! I've attached a couple of screen shots below.
Screenshot 1: Information as it is displayed in the portal on 'parent_table's record page
Screenshow 2: example of information in spreadsheet outside filemaker
column 1+2 are dates and cities from parent talbe
column 3 to 5 are the musician names who are playing fiddle, piano and drums in portal table
column 6 onwards alternate between an "extra musician name" and the "extra musicians instrument"
Thanks in advance for any help - you guys are such a great group!