AnsweredAssumed Answered

View Portal data in a 'global' type spreadsheet

Question asked by mdc91 on Jan 18, 2019
Latest reply on Jan 18, 2019 by onefish

Hi there.


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!