Time Punching Web Application in Google Sheets
Вставка
- Опубліковано 5 вер 2024
- Hey folks! 👋 Ready to dive into the world of Google Spreadsheets and create your very own time-punching web application? 🕒💻 In this video, I'll guide you through the process of building a slick system where you can easily log your working hours with just a click.
We'll explore the magic of time-punching buttons - each click records your entry or exit time seamlessly. Ever wondered how to keep track of your punches? I've got you covered! On the right side, you'll find a nifty display of all your recent time punches. Plus, we've spiced things up with a cool calendar view. Navigate through days and months, and witness the power of data aggregation.
But that's not all! I'll spill the beans on how to harness the potential of Google Spreadsheets and scripting to craft a web application that syncs effortlessly with your data. Marvel at the transformation of raw spreadsheet info into a neat JSON format using JavaScript magic (thanks to the reduce method).
Want to create your own calendar? Buckle up as we delve into HTML and CSS tricks to construct a sleek calendar that seamlessly integrates with your data.
Excited yet? You should be! I've even provided a demo link in the description, but stick around till the end for a detailed code walkthrough. We've built this project using the Buefy framework on top of Vue.js and Bulma CSS - and I've dropped all the references in the description for your further exploration.
Ready to punch out? Hit that "time out" button, and watch the magic happen! Your recent punch durations are neatly logged, and you can keep the rhythm going with more punches in and out.
Don't miss out on this knowledge-packed journey!
Links:
🚀 Check the demo link below, and let's explore the coding wonders together.
script.google....
Spreadsheet Link:
docs.google.co...
Bulma CSS for for tiles: bulma.io/docum...
Buefy for tables : buefy.org/docu...
Vue JS framework: vuejs.org/guid...
Happy coding! 🤓💻 #Timesheets #timepunching #appsscript #googlesheets #timelogging #timeentry
This is very cool. Thank you for unselfishly sharing your knowledge and sharing the code as well. Great work! Oh, by the way this is better to also capture the user who made the punches.
Thinking of making it user based also. Capturing user is very simple. But to display it across different views will require considerable amount of extra codes. That's why I left it for the next part.
@@tech-lever Right, its like a comprehensive view for admin monitoring time stamp.