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:
+4Hey,
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 🙂
+6
For these scenarios, I normally use a bot field, and my logic is this:
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.
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
+6It'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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.