# Duplicate UUID?

**URL:** <https://community.glideapps.com/t/duplicate-uuid/38939>\
**Category:** Report a Bug\
**Created:** [February 25, 2022, 3:29am UTC](https://community.glideapps.com/t/duplicate-uuid/38939 "2022-02-25T03:29:35Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 25, 2022, 3:29am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/1 "2022-02-25T03:29:35Z")

</div>

I was exporting the data into MySQL and I use the UUID is my unique Identifier. However, I ended up with 4 less rows in MySQL and upon investigation I found that there are 3 instances of the same UUID.

All created at the same time, the ROWID is different and I seem to have different data in the ROWS.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d4c8f028308d7700704736a52c076aa006001a1.png)

Should I be using the ROWID as my unique row identifier ?

What is the purpose of UUID if it cannot be guaranteed to be unique ?  
How did is it possible to have 3 rows created at the exact same time, is that a bug ?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 25, 2022, 3:45am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/2 "2022-02-25T03:45:09Z")

</div>

I wonder if time might be part of the seed value for the UUID. If the the rows were created at the exact same time, maybe they received the same seed and generated the same ID. I’m guessing that there are several other factors, such as device ID and probably other things that factor into generating the UUID, but time might play a big part of it’s coming from the same device.

RowID would probably be safer in this case, since the row number or underlying row identifier is most likely unique to the specific row.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 25, 2022, 3:52am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/3 "2022-02-25T03:52:22Z")

</div>

What does that timestamp in the 2nd column represent?  
Is that the creation time? All 3 timestamps are identical, so that’s a little suspicious.  
Also, at what stage is the UUID generated? Is it generated as part of the Add Row action, or is it pre-generated and then used some time later?

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 25, 2022, 3:55am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/4 "2022-02-25T03:55:55Z")

</div>

You probably right on the time being used as seed, but generally adding salt is standard practice, but even if that is the case it sounds like a bug.

This would have required the user to press the submit button 3 times, however the app is designed that once you submit it goes back, not giving the user the opportunity to submit multiple times.

I also put a post up the other day where a row disappeared.

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 25, 2022, 4:01am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/5 "2022-02-25T04:01:49Z")

</div>

1. creation time, using the create date/time column widget  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85ea68cdeaa0fd829806e4c1249ed0f6b99f66f1.png)

2. Yes.

3. Part of the standard Add function on a standard form  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c27fa086d15c189ba9067cb49a2a408eb73bb0f.png)  
that you get when hitting the plus icon on a list  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5cb06937f34eca022501aab31ce408af6d96be0.png)

No custom actions.

All the initial data that was inserted in the form was duplicated, but then the users were able to go into each ticket and add different data at different times.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 25, 2022, 4:07am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/6 "2022-02-25T04:07:15Z")

</div>

That sounds like a bug to me, so I think I’d be reporting it to Glide.  
Challenge is, they will want to know how to replicate it - and it sounds like it’s a one off?  
Might be a tough one to figure out. But I’d still be reporting it nonetheless.

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 25, 2022, 4:15am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/7 "2022-02-25T04:15:02Z")

</div>

We have about about 4000 records being created per month, I had a similar issue last month but didn’t investigate it. I have JAN deleted the data from Glide but I do have an excel export.

Are you saying you will escalate it with the team or you suggesting I do it ?

Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 25, 2022, 4:17am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/8 "2022-02-25T04:17:54Z")

</div>

No, I was suggesting that you do it. Glide Support will need details of your app. Support link, etc

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 25, 2022, 4:19am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/9 "2022-02-25T04:19:03Z")

</div>

Cool. Thanks I will do it now.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [February 25, 2022, 4:28am UTC](https://community.glideapps.com/t/duplicate-uuid/38939/10 "2022-02-25T04:28:17Z")

</div>

Are you opening the form with a floating button by chance?

> [@bug Floating button w/ show form screen](https://community.glideapps.com/t/floating-button-w-show-form-screen/35798):
>
> My App/Pages Support link: [https://go.glideapps.com/support/6db172e4-6408-4f6b-be08-d75b7ba79b3f](https://go.glideapps.com/support/6db172e4-6408-4f6b-be08-d75b7ba79b3f) Describe the bug: In desktop mode the floating button is still active after show form screen action. Expected Behaviour: The floating button should be disabled while inside of a show form screen (in desktop mode). The other button formats work as expected and are not clickable after show form screen i.e. filled, transparent How to replicate: Open in desktop mode and create a floating button wi…

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 25, 2022, 10:18pm UTC](https://community.glideapps.com/t/duplicate-uuid/38939/11 "2022-02-25T22:18:39Z")

</div>

Hi Eric,

No its not a floating button.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 27, 2022, 10:28pm UTC](https://community.glideapps.com/t/duplicate-uuid/38939/12 "2022-03-27T22:28:16Z")

</div>

Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 27, 2022, 10:28pm UTC](https://community.glideapps.com/t/duplicate-uuid/38939/13 "2022-03-27T22:28:17Z")

</div>



---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 26, 2022, 10:28pm UTC](https://community.glideapps.com/t/duplicate-uuid/38939/14 "2022-04-26T22:28:51Z")

</div>



---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 26, 2022, 10:28pm UTC](https://community.glideapps.com/t/duplicate-uuid/38939/15 "2022-04-26T22:28:51Z")

</div>


