Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hey guys, i searched everywhere but didn’t find an answer. 
I would like to add something like a ID which in my case is the “V-Nummer”. 
The problem is that i want the number to add plus one when a new entry is made.

For example V5000 and then V5001 and then V5002 etc. 

 

I would be very thankful for your help :-)

 

 

Hi there @Can Commerce ! 

 

So looking at just the first section of what you have posted here, a Google Sheet page, you certainly can add one to that number with a formula, there is a pretty straightforward walkthrough here: https://webapps.stackexchange.com/questions/145384/how-can-i-add-1-to-numbers-in-specific-cells-in-google-sheets

 

If you’re trying to add the number in another part of your Zap that we don’t see above, let me know and I’d be happy to keep troubleshooting!

Best-

Rachael

Hi @Can Commerce!

If you’re looking for a way to create new rows in Google Sheets when something else triggers your Zap, you can use Storage by Zapier’s Increment Value option to add 1 each time:

 

Each time the Zap runs, the number at your specified key (you can name this whatever you want...I chose v-number) will increment by 1. Then you map that value into your Google Sheet row.

Could that work for you?

Hi @Can Commerce!

If you’re looking for a way to create new rows in Google Sheets when something else triggers your Zap, you can use Storage by Zapier’s Increment Value option to add 1 each time:

 

Each time the Zap runs, the number at your specified key (you can name this whatever you want...I chose v-number) will increment by 1. Then you map that value into your Google Sheet row.

Could that work for you?

 

Thank you for your answer.
But I would like to get the V-Number V5002 under the cell of V5001 so if someone buys a product and the zap triggers I want that the new entry has a V-Number which is V5003 if the V-Number in the Cell above is V5002. I hope you understand my Problem now.

For Example:

V5001 | Fake | 29€ 
V5002 | Test  | 65€ 
V5003| King. | 199€ 

So that the V-Number for the new entry is unique.

Thank you for the Help :)

 

Hiya @Can Commerce! Thanks for clarifying! I think Nick’s recommendation should still do the trick since it’s taking the cell above (EX: V5001) and increasing it by a single increment. 🙂

That said here’s another thread with a few other suggestions that may be useful!

Please keep us posted how you decide to approach this!

 

Terms & Conditions