Unique Reference Formula

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.