I’m thrilled to share the latest app i’ve been working on this month!
It is designed to make managing employee timesheets a breeze. Set it up on a tablet at your office entrance and say goodbye to paper timesheets.
I’ve attached a short video to introduce the app
This is not yet fully done. I would appreciate any feedback. I wanted to make it as simple as possible I was planning to send it to the template store.
If anyone is interested in such a template or customizing it for their own use, please get in touch.
Hi Andrew
Currently it just creates a csv file with the data in the timesheets table from the report query.
I’ve already started to update that into a PDF file that you can email or print, just didn’t want to add it to this version of the app as reports usually need to be customized.
Hello, New to this app and forum, looking for some help for an app that I’m building. I would like to keep track of actual time when visiting customers and as such us the time for reports and billing. I have tested the different clock events but can’t find an actual clock input. I can set the data table to only record the “time” but the Form Elements only provide Date & Time or Date input. I’m looking for only Time input. Also it would be nice to fix it to 15 minute increments. such as 8:00, 8:15, 8:30 etc. I’m I missing some thing? Thanks for any help.
There is no Time Only input. You can set the formatting for a date type column to time only, but it still contains an underlying date.
I have two recommendations, and for both, I’d probably recommend storing the value on a basic text column to avoid issues with an unexpected underlying date with a chosen time.
One option would be to create a table that lists all possible times (one per row) and then source a choice component from that table.
The other option is to use the custom AI component to create a time only selector and and have it output to your column.
Thank you for the reply, this is what I was looking at, but thought I would ask be fore heading down that rabbit hole. I find it funny that it look’s like no one want to introduce an actual clock in put, word, pdf, or apps…
While I agree it’s something that’s definitely needed, I also think it gets very complicated in the back end depending on how people intend to use it. Easy to say it’s needed, but the behind the scenes application can get a lot more complicated, and possibly a reason why it doesn’t exist yet.
From what I can see so far with my “sandbox” is I can set the data column to only capture the “time” value, but now the issue is the input. I can only pick the Date and Time Form Element that now adds the required input interface to include the date ( Not required / wanted extra step ) and then the time input that has the hour selection but also the ability to select any of the 60 minutes in the hour. Problem with human input is it adds to the variables of choice. a single fixed selection that is configurable would be nice, so that you don’t need to add rounding up math equations to create a desired result. I hope that makes sense as to what I’m trying to create. bottom line input time at 15 minute increments as simply as possible.
That still leaves the the point that a date column holds a complete date and time regardless of what you set for the formatting. Formatting is just setting how the underlying value is shown on the front end. It does not change what is stored, which is a complete date and time. Even if you could write only a time to it, it’s going to store some sort of default date, whether it’s Jan 1 1970 or today’s date (I’m not sure off the top my head). Thus my open ended questions in the thread I shared above.
Just because you selected Time Only for the format doesn’t mean that a full date and time isn’t stored behind the scenes. Click on the cell in the data editor as if you were going to edit it, or change it to a text column, and you will see what I mean.
I can think of several ways to work around it, but it definitely depends on the use case and how that time is ultimately stored and used in the end. I don’t know what the best way would be for Glide to create a time only input that works for everyone’s use case. Without some proper thought on the design, it might work for a fraction of people, but not everyone. I think some user might want it to be easily joined with a date column. Some might want it to be completely independent from any sort of date. Some might want the literal text value to be stored. Some might want a numeric or decimal value to be stored for easy math with date columns.
Like I said, a choice component or custom AI component will get the results you want as far as limiting what a user can choose. What value you ultimately store and how you use it will depend on your use case. If you want the absolute simplest method, then I would do a choice component with a table that lists all of the possible times and whatever values you want to actually write to the table. If you want to attempt to get a more modern time picker, then try to use the Custom AI component. Personally I would still ultimately store the decimal equivalent that the time represents in respects to one day (ex. midnight=0, noon=0.5, 11:59pm=0.9999). I would do that only because it makes it easier to mathematically add the chosen time to an existing date column that has a default time of midnight (usually what you get with a date only picker). If no math is required to join it with a date, then I’d probably just store the literal text value for the time.
Just to be clear, I’m not against the idea, but I think it takes a lot more thought to do it right when you start to think about how that selected time will be used in your app. Working with dates and times is very tricky when you get into it.
Personally I think Glide would need to also create a new Time type column to compliment a Time picker. Something that would store the decimal equivalent of time, but display the “pretty” version on the front end. It would allow for easy math with other date columns while still being an independent value that doesn’t have a date attached.
I created a template that demonstrates an approach that I’ve used in the past.
A helper table is used to dynamically generate a list of date/time values based on some configurable values. These are then presented as a list of “Time only” values in choice components.
The user selects a date, and then a start time and end time.
When the form is submitted, the date is discarded, and only the start and end times are saved (as date/time values).
Hey, I’d love to get your product. I need to add a field for the person to summarize what they did that day. An EOD report. I’d like it to be searchable by topic later. Can that be done?
