When one trigger than count down set number every one -1
i mean it so
start number is 100
Than one triger = -1
The output is 99
And then every time -1 finish=0
When one trigger than count down set number every one -1
i mean it so
start number is 100
Than one triger = -1
The output is 99
And then every time -1 finish=0
Hi there
Yes, when we have created a new customer that he writes in den chate how many customers are still missing and he should start at 100 every day
If you wanted an easily displayed countdown, you could use google sheets and multiple zaps. In the below solution, it is also set up to keep track of what day it is.
I.e.
First, Set up a google sheet with the countdown number at 100. You will need a static lookup column.
You could use Day but then you will need to add an extra step to determine what day it is.
in the below, my key is current_day, the day is filled with a formula =today() and countdown starts at 100 every day.
First Zap:
Trigger: Whatever your trigger step is.
Action: Look up Zapier Row from the bottom up
Action: Update Row in Google Sheets
Zap 2:
Trigger: Schedule by Zapier (this should be set to run every night/morning you would want to reset the countdown
Action: Create new row in Google Sheet
Let me know if you have any questions!
Thanks,
Tim @ GetUWired
Hi
Another option is to use Storage by Zapier: https://zapier.com/apps/storage/help
You’d have 1 Zap that triggers on a Schedule (e.g. midnight daily) and resets the value to 100 each day.
Yep! Storage by Zapier can also work in a similar fashion! You just miss out on the functionality of easily being able to reference the values.
Hey
Were you able to get this solved using Google Sheets or Storage by Zapier? Or did you find an alternative solution here?
We’d love to know how you got on with this!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.