# Unique value for records

**URL:** https://community.thunkable.com/t/unique-value-for-records/2658905
**Category:** Questions about Thunkable X
**Created:** [October 23, 2023, 10:31am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905 "2023-10-23T10:31:20Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)
#### Post date: [October 23, 2023, 10:31am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/1 "2023-10-23T10:31:20Z")

</div>

Ciao!

I have to store an unique value for every record in my customer table.  
I used this escamotage:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/d/8d8a7904ac9df560e335bbfe667583c7d4700dbd.png)  
Is there a better way to do that?  
Grazie  
GM

---

<div class="post-metadata">

### Author: ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)
#### Post date: [October 23, 2023, 11:47am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/2 "2023-10-23T11:47:53Z")

</div>

That’s 1 way

Another would be hitting an api to generate a uuid and saving that to the record

> **[UUID Generator API | UUIDTools.com](https://www.uuidtools.com/docs)**
>
> Free UUID/GUID Generator API. Create single or bulk UUIDs. UUID v1, v3, v4, and v5.

```auto
https://www.uuidtools.com/api/generate/timestamp-first

```

---

<div class="post-metadata">

### Author: ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)
#### Post date: [October 23, 2023, 12:35pm UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/3 "2023-10-23T12:35:27Z")

</div>

![example](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/f/bfbe69ebdc22e670320a79bc546ee893185031ee.png)

What structure are you looking for? Example: 7t89-G14L

---

<div class="post-metadata">

### Author: ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)
#### Post date: [October 23, 2023, 1:56pm UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/4 "2023-10-23T13:56:38Z")

</div>

> [@tthompson41231](#):
>
> What structure are you looking for?

Thanks.

No matter about the structure…  
But, in your example, how we can assure the univocity of the “account number”?

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 23, 2023, 2:49pm UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/5 "2023-10-23T14:49:03Z")

</div>

A simple method would be to initialize a variable to 1 or 10000 or something like that and add 1 to it before you create each row. And then use that as the unique record ID.

---

<div class="post-metadata">

### Author: ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)
#### Post date: [October 23, 2023, 8:39pm UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/6 "2023-10-23T20:39:21Z")

</div>

This is for creating a unique ID. For an account number use Tatiang’s method.

 ![USERIDExample](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/9/596ec5dfa762410892aa4279c3a96468eb6f4dc3.png)

---

<div class="post-metadata">

### Author: ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)
#### Post date: [October 24, 2023, 7:11am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/7 "2023-10-24T07:11:44Z")

</div>

Best to use Supabase

---

<div class="post-metadata">

### Author: ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)
#### Post date: [October 24, 2023, 10:23am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/8 "2023-10-24T10:23:03Z")

</div>

Are you creating rows in a local table or a cloud environment? Most DBs have this value available on records already.

Just was wondering about my question there

---

<div class="post-metadata">

### Author: ![rusticone](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/rusticone/32/163435_2.png) [@rusticone](https://community.thunkable.com/u/rusticone)
#### Post date: [October 24, 2023, 10:28am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/9 "2023-10-24T10:28:23Z")

</div>

> [@jared](#):
>
> cloud environment

Google sheets…

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [January 22, 2024, 10:29am UTC](https://community.thunkable.com/t/unique-value-for-records/2658905/10 "2024-01-22T10:29:01Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
