Unique random string

Good evening everyone. I am generating a random string of 7 numbers in bubble through the native function “calculate formula” and save this value in the database. However, I would need this value to be UNIQUE, is there a way or a plugin to assign a random string by doing a check that is not already present in my db? And if it is present, make it generate another automatically?

I have created a file which contains unique random characters. Then I uploaded them into a table “shortcodes” and created a second attribute called “used”. This attribute will be set to TRUE as soon as I have used this item. In my case it was first 100.000 short codes.

This topic was automatically closed after 70 days. New replies are no longer allowed.