Skip to main content
Best answer

How do I generate an ascending file number for each lead in a table using Zapier?

  • September 19, 2023
  • 5 replies
  • 128 views

Forum|alt.badge.img+1

Hi Community,

 

I’d like to do the following: 

  1. A lead is received in an external tool (Heyflow) and sent to Zapier
  2. The data stored in a table
  3. An ascending file number is generated for each lead (e.g. “AZ_DL_[NUMBER]”. 

How can I do that?

 

Cheers and Thanks a ton!

Best answer by ssielmannBest answer by ssielmann

Achieved it - could just use the “Update Record” feature. 

View original
Did this topic help you find an answer to your question?
91% found this helpful
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31139 replies
  • September 19, 2023

Hi @ssielmann 

Good question.

One approach would be to use Airtable to log the data.

Airtable has these field types:


Forum|alt.badge.img+1
  • Author
  • Beginner
  • 21 replies
  • September 22, 2023

 

Thanks :) Can I do this without using Airtable? 

 

This approach is where I am right now: 

  1. Create an own table with only a count
  2. Increment this number each time a value is added to the list of cases 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • 21 replies
  • September 22, 2023

…this works so far. 

Now I want to use this number to create the file number: AZ_DL_[NUMBER]

 

The only thing that I would need to do is extract this newly updated number from the helper table and put it into the case table. But - this I don’t manage to do. 🤔


Forum|alt.badge.img+1
  • Author
  • Beginner
  • 21 replies
  • Answer
  • September 22, 2023

Achieved it - could just use the “Update Record” feature. 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6466 replies
  • September 25, 2023

That’s great news @ssielmann! Glad to hear you were able to get it sorted!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊