Picking random values from a list within a formula

#1

I have several data sets that are simply lists and want to use random values from this list in a formula.
e.g.: concat( “xyz”, from_dataset(“setname”))

When using the from_dataset() function it complains about missing parameter (which is true, as there are not any that I can supply - I am working on a list)
Any idea on how to do this?

Maybe like from_dataset(“Listname”, “dummy”,“random”)

Thanks Achim

#2

In that case it’s better to use the Dataset Column data type with an inline formula (the f(x) button) of concat(“xyz”, this).