Tracking when fields are linked

Topic Labels: Base design
522 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi - I have a table set up like this:

Contractors (details of people)
Jobs (individual jobs)

Each contractor will have new jobs assigned to them. I would like to know if a job has been assigned more than 5 days ago. What is the best way to do that?

The idea here is that each job has notes on it and if i can see when the job was assigned then I can see if there has been no action taken on it yet and send a reminder. The complexity is that each job could have more than one contractor assigned so I need to know specifically that contractor B has taken no action even though contractors A and C have been making notes.


0 Replies 0