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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

generating incremental numbers in Google Sheets

  • 9 November 2022
  • 6 replies
  • 755 views
N

Hello!  I have a very simple WPForms → Google sheets zap set up.   Somebody completes my form on a website, a new row is generated in Google Sheets. 

I will create another zap that will take the info in that row and email it to the customer and to our office.  I want to create a unique identifying number in each row so we can say, “Your reference number is 10001”

The next zap that populates the next row would show that reference number (+1) so in the above example the new reference number would be 10002. 

WP forms does have a field called “ID” that increases by 1 with every new entry but those numbers start at “1” so my next reference number would be “2”, etc..  We’d prefer if those numbers started at 10000. 

 

If Formatter is my answer then I believe that would require a multi-step zap (and a PRO account), is that correct? 

Thanks! 

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

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Nico3333 

Good question.

Try using this Zap action: Storage - Increment Value

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
N

Thank you Troy,  where would this fit in my zap?   Would using this make it a multi-step zap requiring me to upgrade to a pro account? 

 

MohSwellam
Userlevel 7
Badge +8

Hi @Nico3333 

 

Yes, that would make it a multistep zap. 

 

Alternatively, you can just pass the number you are getting from WP Form and create a simple formula in Google Sheets that adds the 10000. (this however requires some work on the google sheets side to make the sure the formula is populated every time a new row is added in google sheets.)

 

I would suggest using Airtable instead as it can do that easier than google sheets using a similar formula. But in Airtable would wouldn't need a work around to fill the formula for each record that populates 

Founder of GeekyAir.com
R
Userlevel 4
Badge +7

Hey again @Nico3333!  As Moh mentioned, that would require a paid plan to use something like this with the Storage by Zapier Increment Value action, but spreadsheet formulas outside of Zapier would be excellent as well. 

If you can modify the data before it gets to Zapier, that would help you save on the number of Tasks you need as well in your workflow. 1 Task in Zapier = 1 Successful Action performed in a Zap.  More on that here: https://zapier.com/help/plans-pricing/#task

You can see the plans we offer you here -- any paid plan would let you access multi-step Zaps: https://zapier.com/app/billing/plans

Let us know if you have any more questions! 🖐

GetUWired
Userlevel 7
Badge +12

Hi @Nico3333 

just use the value from Wordpress and when you pass it to Google Sheets pass it as a formula

so instead of passing just the id on the create row step pass a sheets formula like

=10000+{{INSERT THE iD FIELD}}

Sheets will recognize the formula and perform the math calculations for you, this will leave your zap as a single step and thus you do not need to upgrade. 

christina.d
Userlevel 7
Badge +9

Hey there @Nico3333! It looks like you have some options here to try out!

Troy recommended:

...using this Zap action: Storage - Increment Value

It’s worth mentioning this route would require a multi-step zap, which is offered under any paid Zapier plan. You can check out some of the options for that here: https://zapier.com/app/billing/plans

@MohSwellam and @RALaBarge suggested using spreadsheet formulas to reduce Zapier task usage:

Alternatively, you can just pass the number you are getting from WP Form and create a simple formula in Google Sheets that adds the 10000. (this however requires some work on the google sheets side to make the sure the formula is populated every time a new row is added in google sheets.)

If you can modify the data before it gets to Zapier, that would help you save on the number of Tasks you need as well in your workflow. 1 Task in Zapier = 1 Successful Action performed in a Zap.  More on that here: https://zapier.com/help/plans-pricing/#task

 

@GetUWired even outlined what that would look like here:

...so instead of passing just the id on the create row step pass a sheets formula like

=10000+{{INSERT THE iD FIELD}}

Sheets will recognize the formula and perform the math calculations for you, this will leave your zap as a single step

Let us know if you decide to go this route! We’d love to know how you’re getting along. 🤗

Terms & Conditions