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!
@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.
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)
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!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.