Digital Time Card using Forms and Sheets | The G Suite Show

About this tutorial:

Video duration: 4:34
Kevin and Heather tackle time tracking using Forms and Sheets in today’s episode. This process can be helpful for smaller teams or projects when allocating time and budget.

Using forms, you can track when an employee or contractor begins working or working on a specific project. These responses will cumulatively be added to a Sheet where a manager has full visibility.

For more tips and use cases, check out the Transformation Gallery. Now in 5 languages!

Want to take full advantage of the existing The G Suite Show video library? Check out the following resources:

Incoming search terms:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

27 thoughts on “Digital Time Card using Forms and Sheets | The G Suite Show

    Brooks Nunez

    (October 23, 2019 - 7:50 am)

    Is there a way without making another form that I can have the agents submit their clock out time at the end of the day?


    (October 23, 2019 - 7:50 am)

    Filling out the log in is ok but how to capture the log out?

    Caite Lynch

    (October 23, 2019 - 7:50 am)

    This is great but suggested additions: how to factor in a one hour lunch? how to use timestamp to calculate hours? how to design it so employees enter time in in the during and time out in the afternoon (instead of logging the day's hours all at once). how to feed the total hours from each day into a master attendance document (i'm using this for classroom attendance for a full school year)

    All Is Pretty

    (October 23, 2019 - 7:50 am)

    How can you as the manager retire employees from the roster without going into the excel/Sheets?

    Misto Babaoglu

    (October 23, 2019 - 7:50 am)

    Scenario: I have created a G Form on my G Suite account. I want the form to be deactivated on a specific date automatically. I know I can manually close it. But I want the automatic function. How do I do that?

    Farcella Marcellus

    (October 23, 2019 - 7:50 am)

    Hi I have a question, I have tried doing this but due to high unethical signing in, co-workers assisting other co-workers to clock in or clocking in while "on the way" to work, essentially hiding the the fact that they are late to work. Is there a way for track their location?

    Norm Harding

    (October 23, 2019 - 7:50 am)

    I love the potential for me to track time with clients, but the blank form I have does not exactly show all that is in the 2017 demo here. The Settings for the form I could only see above, found it after not finding the settings accessed in vid. Not a big issue, but what is a little more confusing, as one new to Forms, is how the section for time in and time out came into the form. It was a great presentation, I just need more step-by-step info being new to this app. ๐Ÿ™‚

    Ashley Smith

    (October 23, 2019 - 7:50 am)

    This is not great as employees can falsify the time they actually got into work. E.g. enters 9am even though they actually got there at lunchtime. The time entry on the sheet needs to be automatically entered into the sheet when the user presses submit to avoid any employees attempting to not follow rules.

    Wendy Lechner

    (October 23, 2019 - 7:50 am)

    This sounds good, but I've never used Google sheets and I can't figure out where to start. Guidance?

    Annu Singh

    (October 23, 2019 - 7:50 am)

    ใ€๏ฝก_๏ฝกใ€‘ cะฝฮตฮฑฯ sฮตัvฮนcฮตs ะฝฮตัฮต #GSuiteGoogleEmailHosting ใ€๏ฝก_๏ฝกใ€‘

    Bruce Sedlacek

    (October 23, 2019 - 7:50 am)

    ๐Ÿˆน๐‡๐ž๐ฅ๐ฅ๐จ ๐†๐ฎ๐ฒ๐ฌ๐ฌ, {๐†๐ซ๐ž๐š๐ญ ๐’๐ž๐ซ๐ฏ๐ข๐œ๐ž}
    ๐๐จ๐ฅ๐Ÿ• ๐†๐ข๐ฏ๐ž๐ฌ ๐๐ž๐ฌ๐ญ ๐’๐ž๐ซ๐ฏ๐ข๐œ๐ž ๐Ž๐Ÿ ๐† ๐ฌ๐ฎ๐ข๐ญ๐ž.
    ๐๐จ๐ฐ ๐ฒ๐จ๐ฎ ๐œ๐š๐ง ๐ฉ๐ข๐ง๐  ๐ฆ๐ž ๐จ๐ง ๐ฌ๐ค๐ฒ๐ฉ๐ž๐ข๐ : ๐‡๐„๐Œ๐€๐๐“_๐Ÿ๐Ÿ‘๐Ÿ” , ๐€๐ง๐ ๐–๐ก๐ญ๐ฌ๐š๐ฉ๐ฉ : ๐Ÿ—๐Ÿ ๐Ÿ•๐Ÿ–๐Ÿ‘๐Ÿ–๐Ÿ–๐Ÿ–๐Ÿ– ๐ŸŽ๐Ÿ–๐ŸŽ , #GSuiteGoogleEmailHosting

    Antonio Tate

    (October 23, 2019 - 7:50 am)

    Hello, I have created the time sheet successfully, adding on the amount an employee makes, calculating their daily total. How do I add and calculate a column/question for employee break(s) in sheets and forms, respectively, along with sending the employee their time for the week from sheets?

    Meg Jones

    (October 23, 2019 - 7:50 am)

    I love having a time stamp for our employee to clock in… is there a way to have google sheets do conditional formatting when they clock in after 9:05:00 AM? but before 12:00:00 pm (cause of half days) I thought it would be simple "greater thans" or even "timevalue" formulats but they are not working and after scouring the internet I cant get it to work!!

    Moses Kamayagl

    (October 23, 2019 - 7:50 am)

    The App Show is an awesome show. Question: How can I use Forms and Spreadsheets to track recruitment and auto acknowledge receipt of resumes?

    Mohamed Handwi

    (October 23, 2019 - 7:50 am)

    Mohammeb Elhanbaoui555g


    (October 23, 2019 - 7:50 am)

    please help me i m little bit confuse abount gsuite if i buy enterpise plan for 1 year how many can i create user and also tell me i see on price list USD $10
    per user per month..

    Kevin Amy

    (October 23, 2019 - 7:50 am)


    Paulo Seixas

    (October 23, 2019 - 7:50 am)

    The Google spreadsheets are great, however, the lack of zoom, in my view, is a defect that needs to be repaired urgently by the developers. The absence of this function makes the application uncomfortable and unattractive to Excel users. I also noticed in browsing the help forums that this is an old demand, but with no solution. If you want to get more users to your platform, start thinking about deploying this improvement in your spreadsheet application. Hugs!

    Juan Ricardo Flores Pizarro

    (October 23, 2019 - 7:50 am)

    Want to ask how can we setup especific hrs for particulary activities?

    Joaquin Rdz

    (October 23, 2019 - 7:50 am)

    Google forms Offline


    (October 23, 2019 - 7:50 am)

    Great job, guys!

    I've been implementing many management tools with google docs even when they didnt exist like Google Fusion Table linked to Google Maps and now this Digital Time Card.

    There's a LOT of basic things to implemment in Google Forms! A LOT!
    Why, until these days, G Suite Team doesnt implement in Google Forms or Google Sites a simple box that allows users to upload basic files, with limited sizes (like .JPEG .PDF), from a PC or even from a mobile camera, to a SHARED Google drive folder?

    Basic things missing in Google Forms:
    *Files Upload Options
    *Captcha to prevent spam
    *No E-Signature but it could be solved with File upload options (in a certain way)

    More people uploading files to Google servers by the google forms would demand manager's users to Upgrade their accounts and give Google more money!

    Thank you
    Push like if you agree
    Sorry about english

    Step Up For Mental Health

    (October 23, 2019 - 7:50 am)

    Great will try this, as soon as I can figure out the Transformation gallery. ๐Ÿ™‚

    andrew storm

    (October 23, 2019 - 7:50 am)

    Hi Gsuite team! I want to migrate our tennis club from a free gmail account to a paid Gsuite account. Is there any discounts for non profit organisations like a sports club?



    (October 23, 2019 - 7:50 am)

    I'd love to see a different layout options. The current flow is bad. I'd like to be able to create a form that looks good on a pc screen (16*9 ratio) and then turns into a current flow if opened up on a mobile device)


    (October 23, 2019 - 7:50 am)

    I need my office wifi to identify my google form via my mobile and capture the entry and out every time my wifi connects and disconnects – is it possible

    Malcom Clark

    (October 23, 2019 - 7:50 am)

    hey I really want to know but to the people watching this , do you have a current usecase for this technique?

    Weilies Chok

    (October 23, 2019 - 7:50 am)

    how would it deal withโ€ฆ
    * Worker submit attendance on behalf of another workers?
    * Worker submit remotely(at home) where they not even in factory
    * submit as HR dept but they actually from Finance department
    * Track the LUNCH IN and OUT

    the above problems cam be resolve if the company hire a supervisor/administrator and ensure things work as expected (extra cost+no automation)

    I think google trying to showcase in best scenarios, where things work perfectly. We evaluated many solutions end up we have to get a fully dedicated time tracking system with finger print scanning and fully linked up with their sys wrote in aspx , so there is totally no google tech involved

    personally I like google but they have to try hard when we talk about enterprise solutions.

Leave a Reply

Your email address will not be published. Required fields are marked *