Random number

Is it possible you to give a small example of what you need to achieve? Seems like I didn’t understand well, what you need :slightly_smiling_face:

Ok I try again, I know it’s a little bit difficult to understand my question, I’m french :sweat_smile:.Ok so, I want : when I create a row of informations about an item, these informations make a report and this report as a number to create a bill in exemple ( I don’t wanna create this bill in GLIDE but it’s for create a link)

Correct? : brave_RGnY0kORfG.mp4 - Google Drive

Not exactly, @Jeff_Hager answer early with two videos of @11183 but you explain the case 2 but I want to make the case 1. A unique number for each information. Thank you for your speed answer

Roll Dice column generates stable number of any range based on anything. Link it to Row ID (it’s always unique), and give it a range of for example 1–999999.

Then if you want you can use Pad Text column to add some zeros at the beginning of your numbers to give them equal number of characters (note that in this case it will be not a number anymore but a string).

UPD

I just tried this and no, unfortunately numbers in Roll Dice column are not unique(

I have 487 rows and Rollup with Count unique gives me only 387.

This method is not for you Im afraid

Thank you for your answer i will try to search again