Hello all! I want to create a shift report that our staff will complete hourly. Ideally, at the beginning of their shift, they’d enter their scheduled start and end time, and the app would populate one field for each hour within their shift. For example, 11:00 pm to 7:30 am. would populate 9 fields: 11:00 pm to 12:00 am, 12:00 am to 1:00 am…7:00 am to 8:00 am. This is a 24-hour business with shifts starting and ending at different times on a daily basis.
At the end of each shift, they submit their report and record it in one row. Any
suggestions on how to best structure this so that it populates the hour and a field for each entry? Thanks in advance!
You’d need to use something external like Make or Zapier to determine the number of ‘hour’ rows to create and which hours to do it for then recursively work through adding the rows via Add Rows API call.
You’d likely have a table for start and end times submissions (I’ll call it shifts) and another big table that would hold the hours with a relation back to the shift.
Then when pulling up the shift you could see all of the hours waiting to have whatever fields they need to fill in upon each hour.
That’s correct. They’re to document their activities, their whereabouts, etc. on an hourly basis and is generally done shortly after the named timeframe. Some choose to document their activities as they do them but either way is okay.
I think a variation of this approach should work. You would have dynamic start and end times based on the current time of the user’s device. Let’s say it’s 12.01am, then you would have two math columns to have the “start” being 11pm, and “end” being 12am, then record them to a multiple files column.