ArticlesBlog

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

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


Comments (30)

  1. This is exactly what I've been looking for!!

  2. Hi there has been no update video of what's new in docs, sheets and slides.

  3. Portuguese of Brazil??!! REALLY??! What about the real Portuguese??? Portuguese of Portugal

  4. 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.

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

  6. 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

  7. 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)

  8. 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?

    Thanks!!

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

  10. 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

  11. Google forms Offline

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

  13. 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!

  14. 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..

  15. Mohammeb Elhanbaoui555g

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

  17. 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!!

  18. 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?

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

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

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

  22. 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.

  23. 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. ๐Ÿ™‚

  24. 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?

  25. 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?

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

  27. 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)

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

  29. 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?

Comment here