Hi everyone,
I have a Teams table and a Tournaments table.
I also have a Teams in Tournament table (Team ID + Tournament ID).
When I create a new Tournament, I want to automatically add multiple rows in Teams in Tournament. One row for each existing Team, all linked to the same Tournament ID.
I’m on the Maker plan. What’s the best and least costly way to do this? I wish to stick with Glide Tables but open to ways to do this on Big Tables as well.
The cheapest option would be to drop the link table, and store an array of Team IDs in a single column in the Tournaments table (or vice versa).
Do you have any tutorial by any chance? 
I don’t, but I’m pretty sure Bob did one a while back.
It’s basically a variation of the old Trebuchet method, but instead of using Joined Lists, you use arrays.
I tried doing it through Manual Triggers but it was consuming 1 update per row and was taking about 5 - 10 seconds for adding 50 rows. I’m not sure if that’s the easiest approach or there’s something I am missing.
What’s the logic you are using to have the list of teams to automatically add to a tournament? If it’s the same set of teams it can be just fed into the add form, or the add row action.
If it involves logic, I assume you can still calculate that list of teams in advance.
That also assumes you don’t need to store each team’s data in a tournament, and this is only for participation logging purposes.