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.

Question

V-Number always add +1 when a new entry comes in

  • 12 September 2022
  • 4 replies
  • 221 views
C

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

 

 

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

4 replies

rachael.silvano
Userlevel 5
Badge +7

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

nicksimard
Userlevel 7
Badge +11

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?

C

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

 

christina.d
Userlevel 7
Badge +9

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