Random generator with google sheets

(yohan) #1

Hello,

Is it possible to replace for example the number 1in:
{{list_rows.results_+_gsx:type 1}}

With the result of the random generator ?

{{generate_random_number.result}}

or an attribut or an answer ?

thank you

(Karen Barker) #2

Hi Yohan,

Unfortunately no it isn’t possible to use a variable inside another variable I’m afraid. I’ll pass this on internally as a feature request and please keep an eye on our roadmap for upcoming features. :slight_smile:

(yohan) #3

Thanx karen,

I’ve found a solution

I’m very impressed by the possibilties of your product

Best,

1 Like
#4

Hi @yohandarosa, would you please share your solution ?

The easiest solution I’ve found is to use the Google Search Rows action instead.

(Lex Luter) #5

Hi all, would somebody please get workaround for this case?
Very need.

(Daniel Beckett) #6

Hi @Lex_Luter

For similar functionality you could include a column in your spreadsheet for ‘Number’ and then list them in order, i.e. 1,2,3,4. When you generate a random number you can then search for that by using Google Sheets > Search Rows.