About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Google Sheets Auto Update

  • 6 March 2020
  • 3 replies
  • 77 views
T
Userlevel 2

So I basically want it to where when anyone submits a google form connected to the google sheet, it automatically updates their, let's say duration (time), and adds it on to the duration currently set on the google sheet.


If that didn't clear it up then let's say I have a roster (a list of people) and each one of them has their own duration of how much they've worked (default is 0:00) and they can go on a google form to fill out their name, ID, and the duration of their hours, and as soon as it's submitted it gets updated to the google sheet and their time adds on to their current duration, not replacing it instead, but this can only happen if they filled in a name and ID already pre-set on the roster.


Any help with making this happen?


icon

Best answer by AndrewJDavison_Luhhu 6 March 2020, 20:10

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

AndrewJDavison_Luhhu
Userlevel 7
Badge +10

Hi @toothflood

You can definitely do this with Zapier. How far have you got and/or what bit are you getting stuck on?


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
T
Userlevel 2

Hey, @AndrewJDavison_Luhhu

I have gotten absolutely nowhere.....

I've tried but couldn't figure it out..


AndrewJDavison_Luhhu
Userlevel 7
Badge +10

@toothflood

So, if you just want this built, then experts like myself can definitely help with that (paid).

If you're keen to learn yourself, then getting used to the Zapier basics is the next step. This article is a good place to start:

Create Zaps


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
Terms & Conditions