Skip to main content
Solved

Issue with Duplicate Reference Numbers for Rapid Entries in ManyChat

  • January 20, 2025
  • 5 replies
  • 41 views

Maveric1289

Hi, I’m working on a ManyChat automation where users input some data, and at the end, they receive a unique reference number (folio). However, I’ve noticed that when two entries are submitted almost simultaneously (e.g., within one second), the generated reference numbers saved in Google Sheets end up being the same.

How could I fix this. Thanks in advance

Best answer by Gustavo Boregio

It's your logic :)

Set a User Field with the value in the first action (when you increment the Bot field), and then use the user field to upload the data to the Google Sheet, and it'll be sorted!

Check this for reference:

https://community.manychat.com/preguntas-y-respuestas-58/como-enviar-cupones-unicos-con-manychat-y-google-sheets-4507
View original

rodrigo_silvano
Forum|alt.badge.img+3

Hey, ​@Maveric1289 

 

Have you tried to use randomizer block and smart delays block? 

Something like this:

 

This way, you make sure that the entries aren’t submitted simultaneously.

Tip: By default, Manychat has set the minimum value to 10 seconds, but you can create a bot field and set it up to 3 seconds, for example.

Let me know if this helped 🙂


Gustavo Boregio
Forum|alt.badge.img+6

@Maveric1289 how are you creating the reference numbers?

For these scenarios, I normally use a bot field, and my logic is this:

  • Increase the bot field value
  • Set a User Field with the bot field value
  • Use the User Field as the folio number - and push this info to the Google Sheet.

I've not had issues with this setup so far, and I've been using it for years!

 

I've also done logics with composite values (for example, {User ID}-{counter}, and this way you can ensure that you'll never have duplicated - but to be honest you probably don't need this in your scenario.


Maveric1289

This is what happen, as you can see in the date & time column, when two or more entries comes in a very short time between each, the folio in Google Sheets sets as the same, however the user recieves a different one. (In this case I’m using a Bot Field increasing by one)

 

 

 

This is part of the automation

 

 


Gustavo Boregio
Forum|alt.badge.img+6

It's your logic :)

Set a User Field with the value in the first action (when you increment the Bot field), and then use the user field to upload the data to the Google Sheet, and it'll be sorted!

Check this for reference:

https://community.manychat.com/preguntas-y-respuestas-58/como-enviar-cupones-unicos-con-manychat-y-google-sheets-4507

Maveric1289

@Gustavo Boregio Thanks! It works!! :)


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings