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.

Hi!

I’m going nuts on this one. Hope you guys can help a brother out. 

Every time a “new row” is created (on google sheet) I need to add on “column A” a “unique random number” on that new row created. 

I know I can set formulas on zapier, but I’m struggling doing so. There are a few issues

  1. Random number: If this formula is used each time that any kind of info is placed on the sheet, ALL numbers are “refreshed”. For me this doesn't work since I need to keep the original (first) number.  
  2. I have set a value of “CR-0001-” on that column, so each time a new row is created, “CR-0001-” is placed (this is working just fine). Now. I need to place after this numer: 0001 then 0002 then 0003 and so on, for each “new row” created. 

I’m getting all the info from SHOPIFY (this I manage to do) so I just need to fill this column with this unique number. 

 

I hope I was clear, since english is not my first language. 

Thank you in advance! 

 

 

You can use Storage and a Formatter step to increase the value by +1 each time.

https://zapier.com/apps/storage/help

Would this require a looping step if more than one row is added at a time?

Hi ​@DenverGuzzi,

 

That is correct. Suppose more than one row is added at a time, and you need to increment the value for each row. You will need to use a looping step.

 

I hope this helps! Let me know if you have any other questions.

Reply


Terms & Conditions