How can I randomize the order of a CSV string in an airtable field?
Topic Labels:
Extensions
0
3788
5
They can handle it.
Here’s an example…
- Create a script block
- Delete all the sample code it includes
- Replace the code with the code provided here
- Click Run
You should see something like this and each time you run it, the result will be different. Note - this doesn’t read the string from Airtable nor does it write the new randomized order back into Airtable. For that we need a little more code and ideally fit to your specific solution.
Script Code
output.markdown("# Shuffle Array");
// create the ordered list
let csvString = "a,b,c,d,e,f,g";
output.markdown("## Ordered List");
output.inspect(csvString);
// parse the string into an array
let myArray = csvString.split(",");
output.markdown("## Ordered Array");
output.inspect(myArray);
// shuffle the array
let myShuffledArray = shuffle(myArray);
output.markdown("## Shuffled Array");
output.inspect(myShuffledArray);
//
// shuffle array
//
function shuffle(array) {
// initialize som needed variables
var currentIndex = array.length, temporaryValue, randomIndex;
// While there remain elements to shuffle...
while (0 !== currentIndex) {
// Pick a remaining element...
randomIndex = Math.floor(Math.random() * currentIndex);
currentIndex -= 1;
// And swap it with the current element.
temporaryValue = array[currentIndex];
array[currentIndex] = array[randomIndex];
array[randomIndex] = temporaryValue;
}
// return the new array
return array;
}
