How to create a scenario with random cell selection in a table?

Guys, can anyone help with Make AI? I need to implement a feature without using any third-party paid scripts, etc.

There’s a table with cells, and each cell contains a set of hashtags. I need to make it so that one random cell is selected from this table and transferred to another table. With each run, a new random set of hashtags should be selected and inserted into the other table.

I tried doing it through Tools > Set Variable, but it didn’t work; the value doesn’t get passed through.

Hi,
If I understand correctly, then you have a Google Sheet or similar table with hashtags.
If so, the Google Sheets app for example has a module to get a row by its number.
So you could ad a random formula for the row number input.
It will randomly get a row from the sheet.
To do this internally in Make only, you could also use their database and set numbers (1,2,3,4…) as keys.
Then same logic as in Google Sheet.

1 Like

“So you could ad a random formula for the row number input
It will randomly get a row from the sheet.”

How can I add a random formula? Can you help with this? I’m struggling to figure out how to do it step by step.


You should use Make formulas instead.
Like this:

It will give you a random number between 1 and 100

Thank you, but nothing is being transferred anyway. Maybe I set something up incorrectly? The modules are triggered, but no values are being sent to the table.

!

1 Like