VERY new here and new to the database world, enjoying AirTable and it NEARLY does everything i want… (im sure the bits it doesn’t do are more down to my incompetence than air tables inability)
I have a question though.
Employee time tracking for an engineering workshop - So i have a base, a list of machines, a list of employees and other relevant data. i have a start and an end time column but my problem is that there maybe say 20 different start and stop times for any 1 job. how do i track the operators time spent on 1 job without having 20 start and stop time fields ?
I almost want a button he clicks that says “im on” then another saying “im off” then those hours are calculated per job, and… i can also see how many hours he has been booked to jobs per week…
I have a feeling this is a very large ask! but any help or guidance would be greatly appriciated