Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What are the exact steps to reproduce this issue?
Hi All,
I’m looking for a formula to generate a 6-character unique reference number for my row. I’ve already tried using the supported self guide which uses concat + row ID but I want an alphanumeric 6-character unique reference for each line. I was thinking of UUID but I don’t want it to be so long and I don’t want a column with UUID in the table. Any ideas?
There was a webinar about this, I looked up the timestamp for you, here it is 15:26
1 Like
Thank you for your reply. I was actually looking for something alphanumeric. For now I have found a fix that works for me, I’ve added the UUID column and hidden it from my table. Then I use the following formula:
concat("XX", row_id(), upper(left(field('UUID'),4)))
This seems to do the trick for now but it would be amazing if there was a way we can summon UUID directly within the formula without adding it as a column in the table.
1 Like
Ahh I see. Nice you’ve found the way to do it.