I am new to Airbase, having used spreadsheets for many years.
I am trying to create a learner progress tracker, but have hit a brick wall and need some guidance please. I think I have structured the base incorrectly to be used efficiently.
I am trying to set up a base that will have learners who are linked to a qualification which contains multiple units that contain multiple criteria that have to be passed twice for each criteria.
I have so far created linked tables for learners, qualifications, units and criteria. These work fine for one learner.
My issue is that when I add a second learner, I have to duplicate the a copy of the units and criteria tables and manually link it to the qualification table.
As I have over a hundred learners this will get quite large. In a spreadsheet I can split cells to form sub headings, but I can not do this in Airtable.
Any ideas would be greatly appreciated.
Thank you in advance.