I’m trying to be smart about setting up a base design, but might be overcomplicating it:
I have 9 product teams, who at the end of each sprint will send out a form to their respective partners, asking them to review the working relationship and progress (so two parameters). I have set up a base for a single team with a form collecting the reviews in one table and an other table calculating the average per parameter, per sprint.
Ideally, I’d like to have all of the teams in one base, since I can’t sync more than 7 on the pro plan. Is there a good setup for this? The product teams need to have separate forms, as they have different partners and different sprint dates.
Could I potentially have all teams in the same base, and let them send out their survey from their respective table? I’m afraid it’ll be a mess since I want the product teams to feel ownership of the reviews, but perhaps I could create different table permissions?
Thanks in advance!