Random number

[Monsieur_Baillieul]

Hello

Do you know a line of code to make a random number appear in a line?
For example I would like that with each click, a new number appears on my page between 1 and 89 for example? How to do ? Thank you

[Darren_Murphy]

You can use the Dice Roll plugin column for this. Set it up as follows:

• Create a User Specific Text column to hold a “seed” value
• Create the Dice Roll plugin column
  – Use the Seed column as the Seed value
  – Set the number of sides to 89
• Add a Button to your screen with an action that does a Set Column values on your Seed column, using the Unique Identifier special column value
• Add a text component (or whatever) to display the value of the Dice Roll column

[gvalero]

Hola!

Just to complement the Darren’s solution: if you want to have a random value based on time automatically (without pressing some button), all what you need to do is this:

With it, every 10 sec you will have a new value automatically.

Feliz día!

[Monsieur_Baillieul]

perfect thank you very much.
It’s possible to have a different value on each line? If yes, how do ?
thank you

[gvalero]

I think so!

Let me try/look for a smart way.

[Darren_Murphy]

I think the obvious way would be to create a template using the RowID + current timestamp, and then use that as the seed value.

[gvalero]

Here is the solution using Darren’s suggestion:

1. 

2. 

3. 

Saludos!

[Monsieur_Baillieul]

Thanks a lot of!
I wanted to try this to randomize my Swipes but it doesn’t work.
indeed I use the swipe model but it arranges the articles only compared to the table.
do you still have a solution? thank you

[Dilon_Perera]

First of all I’m sorry for replying on this old topic! But thought to share this here that may help!

You can make a Random Swiper using the Roll Dice column that mentioned above by Darren and Gustavo!

Here’s how! : Random Swipe?

Thank you

[Rashmi_Sinha]

Is there a way to change the random values every 10 minutes, can something else be used instead of current time?

[Jeff_Hager]

Try this as a seed value for a random number. It will only change every 10 minutes. ‘now’ refers to the current datetime which you can select as a replacement value.

(trunc(now)*1000)+
(hour(now)*10)+
floor(minute(now)/10)

[Camille1]

Hi I want to know if it’s possible to generate a number per row but not randomly, like 01, 02, 03…?

[Jeff_Hager]

I think you want use case #2 in the attached thread.

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

[Camille1]

Thank you sooo much

[Camille1]

Hi, I think I can’t make this solution because when I use a template I can’t search my value because it’s not in the User table. I don’t know if it’s clear. I wanna make that idea but for my inventory like object 1,2,3 etc but the number never change even I delete an row or add one.
Thanks.

[Dilon_Perera]

@Camille1, could you show your setup with some screenshots or from a video? The method that Darren used ( thanks to @11183 ) in the topic that Jeff linked should work!

[Camille1]

I want to create a number ID for each row of “RAPPORTS” so I create a Row ID but I can’t choose it when I’m in the “assorted-month” table.

[Camille1]

[Dilon_Perera]

You need to display like 1,2,3,… in the RAPPORTS table right? In that table now you can create a Lookup column like this :

and you can create the Row Index column like this :

and finally you can create a Math column like this :

[Camille1]

Thank you for your fast answer! I’m so sorry but I want to make the case 1 with unique ID when I make a new row that never change … But your answer was so clear thank you again