Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Tracking when fields are linked

Topic Labels: Base design
220 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Thanks!

0 Replies 0