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

Key:

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!

Outcomes