Hi, I’m struggling to build a double entry table.
I need to have a matrix of people(rows) and events (columns), where each cell would show the availability of that person for the relevant event. What complicates things is that I have to be able to add either new people (by row) or events (by column).
I tried with nested repeating group, but I’m not able to source the parent’s repeating table element (e.g for a person’s row, I would select the relative column’s event).
My data structure looks like:
- Person (name)
- Event (name)
- Booking (person; event; status)
The output would be something similar
How would you structure your data? How would a nested repeating group work?