I’m trying to use a single Base to store all my business workflow information.
I have the following tables:
- Employees
- Clients
- Jobs
I now want to track timesheets which link to these three tables. That is, I want my employees to enter timesheet information into a new Timesheets table where:
- They select their name from a linked field tied to Employees table
- They select the relevant client from a linked field tied to the Clients table
- They select the relevant job from a linked field tied to the Jobs table
My issue is that I have 25 employees who are each recording 12+ timesheet entries per day (they work on many jobs for many clients each day).
As a result, I quickly approach the record limit for the Pro plan due to the size of the timesheet ledger.
I’m puzzled by how to proceed here. Can anyone think of a way to set this up where I don’t run into record limits for at least a few years?
My thoughts were to give each employee their own base for timesheets, but then I won’t be able to link up the existing workflow tables to their personal base timesheets (or could I?)
Or perhaps I could summarise the timesheets from a ledger format into individual records which shows the employee and the total time spent by job? Im not sure how to do this though (or if I even should).
I have no issues with data being visible across employees.