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:…

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…

So let’s say for 11pm to 12am, you would expect them to fill that hour’s report some time just after 12am?

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.

You could also make a JSON column in Glide data, then use it to forward to several APIs or services.

[image] dizzyaccordion JSON Trebuchet Community Resources wave Hey fellow Gliders! Part two of my Trebuchet series is live! Last week, I posted a tutorial on a new way to create inline arrays using the Trebuchet method Part 2 is a deep dive on how you can Tr…

Populate fillable fields based on user input start and end time

Ask for Help

ThinhDinh July 25, 2024, 12:25am 6

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.

Topic		Replies	Views
Help with a formula (likely going to be in Sheets) Ask for Help	39	1732	November 18, 2020
Fill rows according to date range Ask for Help	1	205	March 22, 2023
I need help to calculate the hours worked Ask for Help	16	321	July 24, 2023
How do I do this math without Google Sheets? Ask for Help	13	276	January 9, 2023
Form Submit hours of operation Ask for Help	16	671	November 5, 2022

Populate fillable fields based on user input start and end time

Related topics