. As such, it simply ports over the core function: ulid
Bare Formula
=ulid()
Using the function with no arguments returns a single ulid:
01G0JCBACTHTW54C671R594Q0W
Using a seed
=ulid(1469918176385)
Sometimes you might want to provide a seed value, maybe this comes from a date you already have in your table, or maybe it’s just your favorite number:
ulid
Seed
1
01ARYZ6S41ATRW9SFCA70NDAYP
1469918176385
2
01ARYZ6S41ATRW9SFCA70NDAYP
1469918176385
3
01ARYZ6S41ATRW9SFCA70NDAYP
1469918176385
There are no rows in this table
Note how, despite using the same exact seed value, we still get different id’s. Their time component is shared, but the randomness is unique to each invocation.
More Info
For more information, please check out the ulid spec on GitHub: