There are three tables.
a) Persons b) Events c) A table to link them, one in each row (Meaning one person is linked to one event in a row)
I want to run a report, which would show the list of persons in an event.
I have another sheet for that, namely a ‘report trigger’ sheet with columns Key, Type (Event, Group etc), Name (name of event, group), set to trigger a worflow upon add, and with additional condition checking, if Type is equal to ‘Event’, which is added to by an action of the events table.
Now I want a report to display the list of persons in an event, along with their information, in a table.
That requires to retrieve the key values of persons from the table, first.
I’m not being able to locate a starting point for this.