I’ve got a pretty cool thing working, as a result of Airtable’s handy tutorial. In a Slack channel about video games at work, you can type “/gamerec,” followed by either the platform (Switch) or person recommending (Tim), it searches our collaborative Airtable spreadseheet of game recommendations, and then it kicks back 3 of those results to you, inside the Slack channel, all nice and pre-formatted. Yay!
But I want to make it better. I want you to get 3 random results from that search, so that it’s a bit more of a roulette wheel. If Tim has recommended 25 games, you shouldn’t get the same 3 games all the time.
There’s currently no intrinsic random[ish] number generator within Airtable. There are ways of getting more-or-less unique, albeit non-random, values out of the platform, values that can be converted, through the application of various arbitrary numeric functions (think ’MOD() by a prime and the like), into something that looks relatively random if you squint hard enough. (Put it this way: I wouldn’t trust it as the seed for an encryption package, but it would probably be reliable enough for a utility that spits out video game recommendations.)