Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Nice reporting through layers of relationships

2104 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Richard_Willia1
6 - Interface Innovator
6 - Interface Innovator

Hello

I have a base structure of:

EVENT → VENUE SLOTS → STAFF ALLOCATIONS

Whee an event can have a number of venue slots (ie each day’s activity) and each slot has a number of staff allocated to it

I would like to be able to produce a report which shows all of the staff that have been allocated to an event, but I can’t see a way to do this. I can only insert a table for children of the master record - I can’t seem to go any deeper?

I was wondering about somehow exporting the data to google sheets but can’t see a great way to do this?

5 Replies 5

Hi @Richard_Williamson

I assume you are linking all those tables via Linked Record fields?

If so, you can just use a Rollup field in Event table (using ArrayUnique(values)) to get all the names of the Staff

Thanks - the problem though is I would like to be able to get a rollup of all the information (name, start time, finish time, cost) - I suppose I could create a calculated field in the staff_allocations table and report on that but it seems pretty ugly

Grunty
7 - App Architect
7 - App Architect

You need a direct connection between Event and Staff, bypassing Venue.
This way you’ll be able to use Page Designer to list the relationship.

Richard_Willia1
6 - Interface Innovator
6 - Interface Innovator

Urgh thanks - I suppose would need to be an automation which updates a field. Airtable is so frustrating how it’s almost great but falls down so badly on the reporting

Grunty
7 - App Architect
7 - App Architect

Yes an automation would do Event :link: Staff.
And yes, reporting capabilities are rather poor. That’s why they called it Page Designer and not Report Designer.