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?
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