#  Creating Unique ID at the time of formSubmission

**URL:** <https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592>\
**Category:** Ask the community\
**Tags:** question, code, wix-stores\
**Created:** [October 6, 2020, 10:05pm UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592 "2020-10-06T22:05:22Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 6, 2020, 10:05pm UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/1 "2020-10-06T22:05:22Z")

</div>

I have created a form with various fields (connected to a dataset within a data collection). When a user clicks submit all the data is stored in that collection.  
However I wish to create a unique ID if any user submits the data. Can someone help with such a code?  
I need it to be different unique ID to the automatically generated system unique ID.

I have followed this [thread](https://www.wix.com/corvid/forum/community-discussion/creating-unique-id-at-the-time-of-submission) , but am having no luck at all! I just dont know what I am doing wrong! ? Id be so grateful for some help! I am not a natural coder

---

<div class="post-metadata">

**Author:** ![ajithkrr](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/ajithkrr/32/20520_2.png) [@ajithkrr](https://forum.wixstudio.com/u/ajithkrr)\
**Post date:** [October 7, 2020, 1:57am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/2 "2020-10-07T01:57:54Z")

</div>

Do you have any code currently??  
If so, paste it here…

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 7:11am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/3 "2020-10-07T07:11:58Z")

</div>

I took this code from a previous thread but hasn’t made a difference…  
//inside data.js  
import wixData from ‘wix-data’ ;  
export function pec200\_beforeInsert ( item, context ) {  
return wixData . query ( “Pec200” )  
. descending ( “uniqueId” )  
. limit ( 1 )  
. distinct ( “uniqueId” , { “suppressAuth” : true , “suppressHooks” : true })  
. then ( r =\> {  
let lastItem = r . items [0];  
let newId ;  
lastItem ? newId = lastItem + 1 : newId = 1 ;  
return item ;  
})  
}

i wondered if I needed to do anything to the dataset Fields ? Shall I screen shot the pec200 datasheet ?

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 7, 2020, 9:43am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/4 "2020-10-07T09:43:20Z")

</div>

Hi @gergemina and @ajithkrr … 🖐

You can do this with a data Hook ( [**beforeInsert**](https://www.wix.com/corvid/reference/wix-data/hooks/beforeinsert) ).

```javascript
import wixData from 'wix-data';
export async function collection_beforeInsert(item) {
    let id, unique;
    
    while (!id && !unique) {
        id: String(Number(Math.floor(Math.random() * 10000000000)));
        let count = await wixData.query('col').eq('id', id).find().then((result) => {
            return result.totalCount;
        })
        
        if (count > 0) { item.id = id; unique = true; }
    }
    
    return item;
}

```

Hope this helps~!  
Ahmad

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 9:50am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/5 "2020-10-07T09:50:09Z")

</div>

Thanks for this, sadly it hasn’t worked, unless I am missing something?

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 7, 2020, 9:53am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/6 "2020-10-07T09:53:59Z")

</div>

This code must be placed on the backend JavaScript file (data.js).  
I’ve updated the answer, please try again now and let me know how it goes.

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 9:57am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/7 "2020-10-07T09:57:01Z")

</div>

Yes, I inserted it there. However it did not recognise ‘col’. My collection and dataset is called PEC200. The following does not work for me

import wixData from ‘wix-data’ ;  
export async function PEC200\_beforeInsert ( item ) {  
let id , unique ;

```
while ( ! id && ! unique ) { 
    id : String ( Number ( Math . floor ( Math . random () * 10000000000 ))); 
    let count = await wixData . query ( 'col' ). eq ( '_id' , id ). find (). then (( result ) => { 
        return result . totalCount ; 
    }) 
    
    if ( count > 0 ) { item . _id = id } 
} 

return item ; 

```

}

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 7, 2020, 10:00am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/8 "2020-10-07T10:00:53Z")

</div>

“col” is the collection/database name, in your case it must be replaced with " PEC200".

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 7, 2020, 10:01am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/9 "2020-10-07T10:01:32Z")

</div>

Also, update your code with my most recent updated answer above.

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 10:02am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/10 "2020-10-07T10:02:34Z")

</div>

thanks, do I need to create a field in my database to allow for the new autogenerated ID?

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 7, 2020, 10:05am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/11 "2020-10-07T10:05:35Z")

</div>

Yes, it needs to called “id” for the code to work, or just replace the “id” in the orange part in my answer (item. **id** ) to your field key.

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 10:06am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/12 "2020-10-07T10:06:56Z")

</div>

Should it be text field or number field?

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 7, 2020, 10:09am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/13 "2020-10-07T10:09:19Z")

</div>

A text field, also note that if you want to change the field key, you need to change it both from the query and from the value assignment. (Notice the orange parts).

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 1:22pm UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/14 "2020-10-07T13:22:37Z")

</div>

Im so grateful for all your help so far but it still isn’

 ![](https://us1.discourse-cdn.com/wix/original/3X/7/7/77d689b7b6374df9e942143f90714979bb79a154.png)

 ![](https://us1.discourse-cdn.com/wix/original/3X/9/b/9bf30fec3595af85c289ddd2ecc3e6edb3c6af81.png)

 ![](https://us1.discourse-cdn.com/wix/original/3X/9/7/978b590fa72e22c55d2b1e02ea69c9273a64f947.png)  
t working. Here is a screen shot of my code, also my dataset, as well as my form.

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 4:21pm UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/15 "2020-10-07T16:21:26Z")

</div>

Also unfortunately entering this code has meant that the form on my live site does not work at all. When I removed the code it started working again… I was wondering if you could identify whats going wrong here?

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [October 7, 2020, 4:21pm UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/16 "2020-10-07T16:21:40Z")

</div>

@ahmadnasriya

---

<div class="post-metadata">

**Author:** ![anon72313111](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@anon72313111](https://forum.wixstudio.com/u/anon72313111)\
**Post date:** [October 8, 2020, 10:42am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/17 "2020-10-08T10:42:16Z")

</div>

Maybe because you haven’t published the site after adding this code. Try it and let me know how it goes.

---

<div class="post-metadata">

**Author:** ![alexchristophe](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/alexchristophe/32/8180_2.png) [@alexchristophe](https://forum.wixstudio.com/u/alexchristophe)\
**Post date:** [September 2, 2021, 3:02pm UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/18 "2021-09-02T15:02:27Z")

</div>

@gergemina did you find a solution? I have the exact same question…

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [September 3, 2021, 9:24am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/19 "2021-09-03T09:24:20Z")

</div>

Yes I did, I created a data.js file in the backend

 ![](https://us1.discourse-cdn.com/wix/original/3X/9/2/92a7e3a42f9112b5525d1723546706690f199598.png)

---

<div class="post-metadata">

**Author:** ![gergemina](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/gergemina/32/8366_2.png) [@gergemina](https://forum.wixstudio.com/u/gergemina)\
**Post date:** [September 3, 2021, 9:24am UTC](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592/20 "2021-09-03T09:24:55Z")

</div>

and then used this code:

//inside data.js  
**import** wixData **from** ‘wix-data’ ;  
export function PEC200\_beforeInsert ( item , context ) {  
**return** wixData . query ( “PEC200” )  
. descending ( “id” )  
. limit ( 1 )  
. distinct ( “id” , { “suppressAuth” : **true** , “suppressHooks” : **true** })  
. then ( r =\> {  
**let** lastItem = r . items [0];  
**let** id ;  
lastItem ? item . id = lastItem + 200 : item . id = 1 ;  
**return** item ;  
})  
}

[Next page](https://forum.wixstudio.com/t/creating-unique-id-at-the-time-of-formsubmission/32592.md?page=2)
