Explore

Shuffle Column

You can shuffle a column by loading the values in, shuffling them, and writing them back to the table. Here it is shuffled by a column formula, and by a button.

⁠

Shuffle Rows!

⁠

Shuffle Time!

Shuffle Time!

Fruit

Shuffled by Formula

Shuffled by Button

Apple

Grapefruit

Huckleberry

Banana

Huckleberry

Elderberry

Cherry

Banana

Fig

Elderberry

Fig

Cherry

Fig

Apple

Grapefruit

Elderberry

Apple

Huckleberry

Cherry

Banana

There are no rows in this table

⁠

Shuffled by Formula

[Shuffle Time!].Fruit.ShuffleText()

.WithName(

ShuffledList,

ShuffledList.Nth(

thisRow.RowId()

)

Get the Shuffle Time table’s Fruit column

Shuffle the values in that list

Store that under the name ShuffledList for now, using

WithName()⁠

⁠

Go through that ShuffledList, and grab one of the values with

Nth()⁠

. Which value? Whatever row we’re on (so if we’re on row 5, thisRow.RowId() will be 5, and we’ll grab the 5th value from the shuffled list)

Shuffled by Button

[Shuffle Time!].Fruit

.ShuffleText(Now())

.WithName(

ShuffledList,

[Shuffle Time!].FormulaMap(

ModifyRows(

CurrentValue,

[Shuffled by Button],

ShuffledList.Nth(

CurrentValue.RowId()

)

Get the Shuffle Time table’s Fruit column

Shuffle the values in that list, with a seed of Now() (so it’s different every time we press the button)

Store that under the name ShuffledList for now, using

WithName()⁠

⁠

Go through every row in the Shuffle Time table, and do the following to each... (

FormulaMap()⁠

)

Modify the current row we’re on

Modify the Shuffled by Button column

Go through that ShuffledList, and grab one of the values with

Nth()⁠

. Which value? Whatever row we’re on (so if we’re on row 5, thisRow.RowId() will be 5, and we’ll grab the 5th value from the shuffled list)

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.