I’m comfortable with spreadsheets… not so much with databases.
So, here’s my dilemma:
I have a base with 49 records (names of people is the primary field) - 27 people exiting the program from last year and 22 returning to continue service. There are 18 tables and 31 fields.
This year (which begins August 2020) I also need to know monthly performance (a number) for each person in 5 categories.
Not being able to link tables across bases makes me reluctant to build a new base BUT it seems like I need a lot of new tables and/or fields… 22 (people) X 12 (months) X 5 (categories). And I will need ‘end of year’ performance reports.
I can easily do this in a spreadsheet but I would like to try to use AirTable. Suggestions please.