Random list for ENUMLIST

AppSheet AppSheet Q&A
1

Hello Experts,
In my application I would like to display data randomly in ENUMLIST & those random data will be coming from the spreadsheet. For example, in my spreadsheet, the available data in the column is:

3X_6_5_65c4695bb9657163f616259ced37561c8ccbfb75.png
3X_6_5_65c4695bb9657163f616259ced37561c8ccbfb75.png112Ă—251 852 Bytes

Now, when I will execute my application, ENUMLIST will have data from this list but randomly like:

3X_8_7_87ee402f17653445449cd1d31badcb50726441e5.png

Next time it will be:

3X_5_c_5c553fbaa26ea84e5e6e993871dadbae1a0fa5c9.png

Hope I explained my requirement correctly. How could I validate this for my ENUMLIST?

Please suggest me.
Thanks,
Arindam

2

arindam.samanta:

I would like to display data randomly

Display where?

3

The field in the view. The field type would be ENUMLIST. For example, if you consider below screen:

3X_3_c_3c67b8e7f0e0c1f62fd7375816f09cda3e6872f2.png
3X_3_c_3c67b8e7f0e0c1f62fd7375816f09cda3e6872f2.png352Ă—383 8.02 KB

The field Challenges is ENUMLIST and when user will see the appl

Thanks,
Arindam

4

If the values that will be populating your EnumList are values from a table’s key column, you can generate a list of (e.g.) 3 random values using this in the EnumList column’s Valid If expression:

TOP(
  ORDERBY(
    table[key-column],
    UNIQUEID()
  ),
  3
)

(with appropriate substitutions for table and key-column).

If the values that will be populating your EnumList are not values from a table’s key column, you’ll need to add another column to the table with the EnumList column that has the expression above as this new column’s App formula. Then, in the EnumList column’s Valid If, use the expression:

[that-new-column][enumlist-value-column]

(with appropriate substitutions for that-new-column and enumlist-value-column).

1 Like