Aug 02, 2016 02:01 PM
Perhaps I’m missing it, but how do I generate random numbers? I am missing “randbetween” and “rnd” from Excel.
Thanks for any and all help.
Solved! Go to Solution.
May 26, 2019 11:07 PM
You can Try using function like this : RIGHT(RECORD_ID(),5)
Jul 15, 2019 07:31 PM
Since this thread is still seeing traffic, I should add a link to this recent post, which outlines some ways to generate unique, random[ish] values.
Dec 11, 2019 09:16 AM
I’ve got a similar issue I’m trying to resolve. I would like to be able to pull text entries from another table by LOOKUP or ROLLUP and then randomize the order of those entries, i.e. not alphabetical. Here is the use-case:
We have an episode table, a show table, and a sponsor table. Each show record is first pulling sponsor data from the sponsor table, each episode record is then pulling the aggregated sponsor data from the show table.
Episode 123 - of - Show ABC - has - Sponsor X, Sponsor Y, and Sponsor Z
I would like each new episode record to randomly order the sponsors as it is created. For example:
I’m also utilizing Zapier for some other automation tasks, but haven’t found a great solution there either. Any feedback/help would be greatly appreciated. Thank you!
Dec 11, 2019 04:15 PM
You actually may have a useful randomizing tool there in the Code by Zapier app. You (or someone you know/hire) could write a quick bit of code that randomizes the sponsor assignment for a later step to apply in Airtable.
Mar 11, 2020 01:36 PM
This is my first post, so forgive me if this isn’t helpful. But a workaround I use for generating random numbers is to set up the key column with this formula:
DATETIME_FORMAT(CREATED_TIME(),‘mmsss’)
It pulls the current minute and second the entry was created and displays a set of random digits. This has worked pretty well for my purposes!
Mar 11, 2020 02:09 PM
Doesn’t work for me as most of my items are essentially created at the same time :frowning:
May 18, 2020 07:52 AM
@Daniel_Robbins @Jonathan_Southgate Instead of trying to build the number manually by combining minutes and seconds, you could try using the “x” format specifier, which is a UNIX timestamp that includes milliseconds. Depending on how quickly the records are made (mainly in your case, @Daniel_Robbins), that might do the trick.
May 19, 2020 11:04 AM
You can use the Batch Update Block to generate random numbers for your records. See screenshot below.
Interestingly, the same block can also be used to generate random names & email addresses!
Jun 25, 2020 02:00 PM
Here’s a way to generate random number using formula field in airtable
first choose a MIN and MAX range for your random numbers then use the following formula:
(VALUE(DATETIME_FORMAT(CREATED_TIME(), ‘0.smh’))*(MAX-MIN))+MIN
this generates the following:
Aug 12, 2020 09:45 AM
We’ve built an extension that allows you to generate a random number or ID. You can choose how many characters it should have and whether to include letters or not.