Generating Random Numbers from 1 to 30 in a Blank Table

Pierre L.

·

How to generate a list of random numbers from 1 to 30 starting from a blank table

2 comments

· Sorted by Oldest

Channeled
APP
·
·
To generate a list of random numbers from 1 to 30 in a blank table: 1. Create a new table: Click +Create New > Table > Use Template, then choose a blank template. 2. Add a formula column: Click Add Column and select Formula. 3. In the AI Formula Generator, type: "Generate a random number between 1 and 30". 4. Click Generate Formula, review the output, then click Save Formula. 5. Repeat the formula for as many rows as needed. If you need further assistance, please request human help by clicking "Talk to a person".
Sources: Formulas Create a Table from a Template
Stefano
·
·
Hi, thank you for reaching out. One free way to carry out this task, is through the use of " Formulas" enrichment. In order to add a formula column, select "Add Column" and then from the drop-down menu select formulas, as shown below:
(104 kB)
After selecting this, you'll be able to either use an AI prompt in the first box or JavaScript to instruct Clay on how to process the results from a column. An example of what this looks like is shown below:
(228 kB)
In this case, I recommend using the first box to specify what you want Clay to do. In this case tell it to randomly generate a number from 1 to 30. Then, click on "Generate Formula," which will create a JavaScript formula for you and show the results that would be generated if the formula were applied. If you're satisfied with the results, simply click "Output Is Correct, Save Formula." Please let me know if this helps!

Channeled
APP
·
·
To generate a list of random numbers from 1 to 30 in a blank table: 1. Create a new table: Click +Create New > Table > Use Template, then choose a blank template. 2. Add a formula column: Click Add Column and select Formula. 3. In the AI Formula Generator, type: "Generate a random number between 1 and 30". 4. Click Generate Formula, review the output, then click Save Formula. 5. Repeat the formula for as many rows as needed. If you need further assistance, please request human help by clicking "Talk to a person".
Sources: Formulas Create a Table from a Template
Stefano
·
·
Hi, thank you for reaching out. One free way to carry out this task, is through the use of " Formulas" enrichment. In order to add a formula column, select "Add Column" and then from the drop-down menu select formulas, as shown below:
(104 kB)
After selecting this, you'll be able to either use an AI prompt in the first box or JavaScript to instruct Clay on how to process the results from a column. An example of what this looks like is shown below:
(228 kB)
In this case, I recommend using the first box to specify what you want Clay to do. In this case tell it to randomly generate a number from 1 to 30. Then, click on "Generate Formula," which will create a JavaScript formula for you and show the results that would be generated if the formula were applied. If you're satisfied with the results, simply click "Output Is Correct, Save Formula." Please let me know if this helps!