I’m new and did a couple of hours of learning videos, trying things and reading the forum. I can’t seem to find if this already has been asked.
The title basically sais it all. I’ll add a picture wich should help visualize how the result should work. I belive coda has more power under the hood calculation wise. Neither Notion nor Airtable seem to be suited for the job.
I forgot to add, the Table 1 has at the moment all 3 sub-tables. But depending on the job, some times only 2 sub tables whould be needed. And it’s only 3 sub-tables at the moment but in the end there will be alot more.