Using Apps Script to Create ID Numbers in Google Sheets



Using Apps Script to Create ID Numbers in Google Sheets

Using Apps Script to Create ID Numbers in Google Sheets

I use custom IDs a lot in Google Sheets. Instead of having to come up with an ID each time I need one, I have a simple utility script I can use to do it for me.

This is a really simple, easy to understand method for generating semi-random string ID numbers using Apps Script.

If you have questions or want to see specific topics, leave a comment!

=== LINKS ===
Notes on Math.floor(): https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Math/floor
Notes on Math.random(): https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Math/random

Copy the script: https://gist.github.com/bennettscience/0b420f514b165fc0687439824c00d1b4

Comments are closed.