# UUID Field Type or Formula

**URL:** https://community.baserow.io/t/uuid-field-type-or-formula/1877
**Category:** Feature Ideas
**Tags:** data, formula
**Created:** [December 14, 2022, 2:12pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877 "2022-12-14T14:12:28Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![guiolmar](https://community.baserow.io/user_avatar/community.baserow.io/guiolmar/32/866_2.png) [@guiolmar](https://community.baserow.io/u/guiolmar)
#### Post date: [December 14, 2022, 2:12pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/1 "2022-12-14T14:12:29Z")

</div>

Hey Baserowers!!!

I think it would be a great idea to add a UUID field type, or at least, that a uuid could be generated from formulas or in the default text of a field 😆

Greetings to all!

---

<div class="post-metadata">

### Author: ![Peter](https://community.baserow.io/user_avatar/community.baserow.io/peter/32/4551_2.png) [@Peter](https://community.baserow.io/u/Peter)
#### Post date: [December 14, 2022, 8:34pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/2 "2022-12-14T20:34:35Z")

</div>

Here some info about UUID

> **[Universally unique identifier](https://en.wikipedia.org/wiki/Universally_unique_identifier)**
>
> A universally unique identifier (UUID) is a 128-bit label used for information in computer systems. The term globally unique identifier (GUID) is also used.
> When generated according to the standard methods, UUIDs are, for practical purposes, unique. Their uniqueness does not depend on a central registration authority or coordination between the parties generating them, unlike most other numbering schemes. While the probability that a UUID will be duplicated is not zero, it is generally conside...

Some samples how you could generate uuid version 4 in Excel

> <https://gist.github.com/msubel/9c70951a20efe5c72195>

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [December 15, 2022, 6:59am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/3 "2022-12-15T06:59:32Z")

</div>

Hellooo @guiolmar 👋

Thanks for sharing your idea with us, I’ll make sure to discuss it with the team!

@Peter thanks for sending these useful links 👀

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [December 20, 2022, 8:46am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/4 "2022-12-20T08:46:08Z")

</div>

Hello @guiolmar, I have great news: after the internal discussion, we decided to implement your suggestion, here is the issue to track the progress: [UUID Field Type or Formula (#1463) · Issues · Bram Wiepjes / baserow · GitLab](https://gitlab.com/bramw/baserow/-/issues/1463).

---

<div class="post-metadata">

### Author: ![guiolmar](https://community.baserow.io/user_avatar/community.baserow.io/guiolmar/32/866_2.png) [@guiolmar](https://community.baserow.io/u/guiolmar)
#### Post date: [December 20, 2022, 9:07am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/5 "2022-12-20T09:07:39Z")

</div>

Hi @olgatrykush . That sounds great! I am very happy and I will be attentive to the news. Thanks a lot!

---

<div class="post-metadata">

### Author: ![rishi](https://community.baserow.io/letter_avatar_proxy/v4/letter/r/90db22/32.png) [@rishi](https://community.baserow.io/u/rishi)
#### Post date: [January 20, 2023, 6:00am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/6 "2023-01-20T06:00:51Z")

</div>

Hi Team,

Congratulations on the release of 1.14.

I just wanted to know if UUID was added to this release.

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [January 20, 2023, 3:35pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/7 "2023-01-20T15:35:31Z")

</div>

Thanks @rishi 🎊

No, unfortunately, UUID wasn’t added to this release. The feature was accepted, which means we are going to work on it, but we don’t know yet when we will start. I’ll keep you posted 👌

---

<div class="post-metadata">

### Author: ![rishi](https://community.baserow.io/letter_avatar_proxy/v4/letter/r/90db22/32.png) [@rishi](https://community.baserow.io/u/rishi)
#### Post date: [January 23, 2023, 10:35am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/8 "2023-01-23T10:35:25Z")

</div>

Thanks. I’ll follow up later on this.

---

<div class="post-metadata">

### Author: ![glarrain-cdd](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/c2a13f/32.png) [@glarrain-cdd](https://community.baserow.io/u/glarrain-cdd)
#### Post date: [June 20, 2023, 11:14pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/9 "2023-06-20T23:14:39Z")

</div>

For the record: this feature request has been accepted and can be followed in Gitlab issue [#1463](https://gitlab.com/baserow/baserow/-/issues/1463)

---

<div class="post-metadata">

### Author: ![asan](https://community.baserow.io/user_avatar/community.baserow.io/asan/32/2108_2.png) [@asan](https://community.baserow.io/u/asan)
#### Post date: [June 29, 2023, 10:26am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/10 "2023-06-29T10:26:57Z")

</div>

Hi!  
I’m very attentive to the [issue](https://gitlab.com/baserow/baserow/-/issues/1463) about the creation of a uuid field type 🙂 Do you have an idea on the release on which it will be added?  
Is there a mean to simulate a uuid with the formula field? I tried some formulas like uuid = row\_id() \* p + b modulo[n] with n ~ 10⁹ and p and n prime but this is not very convincing.  
Thanks,  
asan

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [June 29, 2023, 7:07pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/11 "2023-06-29T19:07:47Z")

</div>

Hello @asan, unfortunately, we cannot provide you with any estimates. However, all issues on GitLab can now be filtered by weight, which will give you a general understanding of the priority of this feature among all the issues on our GitLab.

Important to mention that weight depends on numerous factors (which we will explain in detail soon), and one of these factors is the number of requests we receive from the community. So it’s great that you and others are voting in this thread and on GitLab. We keep track of all the requests. 🙌

> Is there a mean to simulate a uuid with the formula field? I tried some formulas like uuid = row\_id() \* p + b modulo[n] with n ~ 10⁹ and p and n prime but this is not very convincing.

Let me check this; perhaps my teammates have some ideas.

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [June 30, 2023, 12:26pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/12 "2023-06-30T12:26:57Z")

</div>

Hey @asan, getting back to you on this:

> Is there a mean to simulate a uuid with the formula field? I tried some formulas like uuid = row\_id() \* p + b modulo[n] with n ~ 10⁹ and p and n prime but this is not very convincing.

I asked the team, and we do not think there is a way to simulate a UUID value with the formula field at this time. I will keep you posted if there are any updates regarding this issue: [UUID Field Type or Formula (#1463) · Issues · Baserow / baserow · GitLab](https://gitlab.com/baserow/baserow/-/issues/1463). 🙌

---

<div class="post-metadata">

### Author: ![asan](https://community.baserow.io/user_avatar/community.baserow.io/asan/32/2108_2.png) [@asan](https://community.baserow.io/u/asan)
#### Post date: [August 14, 2023, 1:02pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/13 "2023-08-14T13:02:17Z")

</div>

Hi,  
Thanks for your answers 🙂  
I used the n8n uuid node to generate the uuids and it works perfectly !  
Asan

---

<div class="post-metadata">

### Author: ![glarrain-cdd](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/c2a13f/32.png) [@glarrain-cdd](https://community.baserow.io/u/glarrain-cdd)
#### Post date: [October 19, 2023, 3:23am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/14 "2023-10-19T03:23:37Z")

</div>

Any news regarding the requested features?

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [October 19, 2023, 7:12am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/15 "2023-10-19T07:12:59Z")

</div>

Hey @glarrain-cdd, no news yet. I’ll publish the updates as soon as we have them. 🙌

---

<div class="post-metadata">

### Author: ![williamlee2112](https://community.baserow.io/letter_avatar_proxy/v4/letter/w/ba9def/32.png) [@williamlee2112](https://community.baserow.io/u/williamlee2112)
#### Post date: [October 31, 2023, 12:14am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/16 "2023-10-31T00:14:34Z")

</div>

Baserow badly needs this asap…

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [October 31, 2023, 9:01am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/17 "2023-10-31T09:01:55Z")

</div>

Actually, @bram picked up this issue a few days ago: [UUID Field Type or Formula (#1463) · Issues · Baserow / baserow · GitLab](https://gitlab.com/baserow/baserow/-/issues/1463), and it’s already ready. 🙂

The UUID field type will be released in Baserow 1.22.

---

<div class="post-metadata">

### Author: ![guiolmar](https://community.baserow.io/user_avatar/community.baserow.io/guiolmar/32/866_2.png) [@guiolmar](https://community.baserow.io/u/guiolmar)
#### Post date: [October 31, 2023, 9:13am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/18 "2023-10-31T09:13:58Z")

</div>

I have seen it! Many thanks for your work 🙂

---

<div class="post-metadata">

### Author: ![glarrain-cdd](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/c2a13f/32.png) [@glarrain-cdd](https://community.baserow.io/u/glarrain-cdd)
#### Post date: [November 1, 2023, 9:43pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/19 "2023-11-01T21:43:33Z")

</div>

@olgatrykush This is great news.

I’ve gone quickly over the PR’s code by @bram, and I’m curious why the random UUID (v4) value generation is performed with a [custom DB formula](https://gitlab.com/baserow/baserow/-/merge_requests/1821/diffs#diff-content-3fe42de5cf8e628a873e57868833ffe1a599be6d) instead of just relying on the formula already included in Postgres (`gen_random_uuid`).

The custom formula is pretty complex and there isn’t any information in the code about where it was obtained from, etc

> uuid\_in(overlay(overlay(md5(random()::text || ‘:’ || random()::text) placing ‘4’ from 13) placing to\_hex(floor(random()\*(11-8+1) + 8)::int)::text from 17)::cstring)

---

<div class="post-metadata">

### Author: ![bram](https://community.baserow.io/letter_avatar_proxy/v4/letter/b/9d8465/32.png) [@bram](https://community.baserow.io/u/bram)
#### Post date: [November 2, 2023, 7:08am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/20 "2023-11-02T07:08:37Z")

</div>

Hey @glarrain-cdd, unfortunately, the `gen_random_uuid` function is only available from PG 13, and Baserow supports PG 11 and up. I’ve got the uuid function from this Stackoverflow question: [postgresql - Generating a UUID in Postgres for Insert statement? - Stack Overflow](https://stackoverflow.com/questions/12505158/generating-a-uuid-in-postgres-for-insert-statement). I’ll add a comment in the code to there.

[Next page](https://community.baserow.io/t/uuid-field-type-or-formula/1877.md?page=2)
