How to get a random value from Data Store

How To
1

I have a basic Data Store in Make. it only contains the columns “key” and “name”. I’m looking to get a single random value of the names to be used in a later step in a Make Scenario. I saw some documentation on how to get a value from arrays but could not find one for Data Store. how could I achieve this?

3

Hello,

you can try with the random function:

https://www.make.com/en/help/functions/math-variables

For example - Search data store to get all the records, aggregate them in an array and then use the random formula to get a random item from the array. Something like this:

{{61.array[floor(random * (1.__IMTAGGLENGTH__ - 0 + 1))].data.'Name`}}

2 Likes