Given three tables:
Default Rooms
Rooms
Sessions
The Rooms table is linked to the Sessions table. So each session has up to 40 or so rooms based upon the Default Rooms table.
Default Rooms has about 40 or so records.
I want to copy all the default rooms into the rooms table. As each room is added I also want to include a link from the session table. So the results in the Rooms table would look like this:
Session_Link | Room
July 1, 2026 7-Day | SE 1A
July 1, 2026 7-Day | SE 1B
July 1, 2026 7-Day | SE 2
July 1, 2026 7-Day | SE 3
etc.|etc.
The action button is the Sessions detail. The problem is in the workflow when I choose “For each item in a list”, it only gives me an option for the Trigger which is the Sessions table. Basically that’s a dead end.
I can do it in Airtable or SmartSuite. How can I get this to work in Noloco?