Hey r/Notion, I'm a software engineer by trade and noticed Notion didn't have a capability to generate a unique ID for each database row, so I wrote the following formula which approximates one:

concat(format(mod(mod(timestamp(prop("Date Created")) * 100011979 + 500067713, 900066731) * mod(timestamp(now()) * 800067089 + 800068411, 800053967) + 900067309, 900066571))) + slice(replaceAll(replaceAll(prop("Name"), " ", ""), ",", ""), length(replaceAll(replaceAll(prop("Name"), " ", ""), ",", "")) - 6, length(replaceAll(replaceAll(prop("Name"), " ", ""), ",", "")))

How this works:

• Hash the created date (which unfortunately doesn't include seconds or milliseconds, making it a poor choice for a unique ID on its own)
• Append the last 6 characters of the name, replacing some special characters and spaces

This should be good enough for most use cases. Also, Notion should really add a unique ID feature - ideally just an autoincremented number, but a UUIDv4 would also work fine!

Anyway, just felt like sharing! Cheers