- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 14, 2024 09:11 AM
We assign employees (N=65) to Job Type (N=5) and Job Title (N=many) every six months.
Before we begin, we know the employees and the job titles.
There are two phases: assignments and distribution.
Assignment:
- I assign individual employees to individual job types and titles.
Distribution:
- Employees get sent a list of their job assignments for the work period.
We need to:
- Make sure that every employee has a job type and title.
- Make sure that every job title has an employee.
What is the best set up for this kind of task? Is it just one big table? is it two tables (employees, jobs)?
I FEEL like this is a job for linked records, but no matter how hard I try, I can't figure it out--I've been doing this on a spreadsheet but there's gotta be a better way (particularly because I have to do this twice per year).
-Scott
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 14, 2024 08:41 PM
Hmm, I think I'd have 2 linked tables:
1. Employees
- This would also include a "Job Type" single select field
2. Job Titles
In "Job Titles", I'd have a view set up which displayed all the records that have no linked record to "Employees"
So during the assignment, I'd just need to make sure that all the records in "Employees" had a "Job Type" value, and all the records in "Job Titles" are linked to a record in "Employees", does that make sense?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 19, 2025 10:14 PM - edited ‎Jan 26, 2025 02:01 AM
For something like this, I do think linked records could be a good way to go. I use a system that’s kind of similar, and breaking it into two tables (employees and jobs) has been a lifesaver for me. Each employee gets linked to a specific job title, and that way, you can easily track who’s assigned to what without all the manual work of a spreadsheet. On a totally different note, I’ve been looking into becoming a dog groomer recently. A dog groomer’s income depends on several factors like location, experience, and the size of their clientele, but I think it's a cool career. It’s kind of funny, but I guess it’s another example of where good systems and planning can make all the difference!
