This automation for Airtable generates a random number or alphanumeric ID based on settings that you define, such as: how many characters and whether or not to include letters.
💡For people coming from Excel: this tool is not quite a replacement for “RANDBETWEEN” and “RND”, but it might be good enough in a lot of use cases.
Note: random does not mean unique
Use Cases
This automation can be useful in a lot of scenarios. You can use it to generate:
- Confirmation ID
- Pin
- A quiz question
- Password
We want to use the Random number generator used only when an option of a single select (or checkbox) is selected.
To only generate a random number when some sort of filter is applied, you should select an Airtable view. It’s an optional field in the extension settings.
It generates a new number for every record within that view. Is there a way to generate the new records only? This view is tied to the view needed for these random numbers already.
The way the extension works is that it will fill any empty field within that selected view. So if you don’t want to have some specific cells filled with random numbers, you just have to fill it with something (anything). They cannot be empty, otherwise they will be filled.