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.

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! 

Hi @Nico3333 

Good question.

Try using this Zap action: Storage - Increment Value

 

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? 

 

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 

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! 🖐️

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. 

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