Course module completion records - ADVICE NEEDED

[anta2]

I have a client base with tables for sales, onboarding, offboarding, interactions and I want to create a table for course completion.

What would be the best practice for this table? I have 250 clients and I can't export the data from my course platform host so our VA will be manually entering the % completed for each client on a monthly basis. Would my primary file be the client and then I create a new record for each client each month and add the % of course completed as a number field?

Is there a way to make creating new records super quick?

[olafjasiniak]

You could create 3 tables:
- Clients
- Client profiles
- Months

Then, each month (via automations of make.com) create a new "Client profile" with Month and the Client linked. This way you can keep track of what was happening with each client during each month