Forum Discussion
Ensuring a Random Number is not Re-picked
This one might be for the javascript experts in the community, but open to all.
I think someone (and it might have been Owen Holt) posted how you can use javascript to create a random variable and...
Yeah I do like the idea of the Base64 and actually is one I tried myself but couldn't get it to work - so will definitely try Scott's solution. What's neat about using Base64 is that there is (from memory) an exsisting formula within Google Sheets that easily reverts strings "back" from Base64 - so that would be cool. If I wanted another layer of encryption I guess Base64, then a randomiser a'la Owen, and that would be pretty hard to break but fairly easy to reverse/unencrypt.
Scott & Owen - thanks!
