# \[SOLVED 2/1/24 6:05 AM EDT\] Creating Unique Order ID **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner, help\ **Created:** [January 31, 2024, 11:01am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670 "2024-01-31T11:01:08Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![minasmith123](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@minasmith123](https://community.thunkable.com/u/minasmith123)\ **Post date:** [January 31, 2024, 11:01am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/1 "2024-01-31T11:01:08Z")
Hello to Everyone! I am new to Thunkable and I am trying out some new functions. I was wondering if someone knew how to generate a unique order ID for each order placed in the thunkable app and saved into Google sheets? I am not sure if this is something I should do in Thunkable or if it should be configured in google sheets? Thank you for your help. Have a great day! ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [January 31, 2024, 11:34am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/2 "2024-01-31T11:34:53Z")
Yes , of course. What kind of ID you are looking for. You did a search in the community? 👉 [HERE](https://community.thunkable.com/search?q=create%20a%20unique%20id) ---
**Author:** ![minasmith123](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@minasmith123](https://community.thunkable.com/u/minasmith123)\ **Post date:** [January 31, 2024, 7:56pm UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/3 "2024-01-31T19:56:50Z")
Thanks for the link I will check it out! ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [January 31, 2024, 8:10pm UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/4 "2024-01-31T20:10:30Z")
Anyway when you use google sheet as database , when you create a new row the block itself give you a unique id for that row **Edit** @minasmith123 ![row](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/9/79928c77f11c239ed55ecca9b37968afbf973fcd.jpeg) ---
**Author:** ![minasmith123](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@minasmith123](https://community.thunkable.com/u/minasmith123)\ **Post date:** [February 1, 2024, 8:39am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/5 "2024-02-01T08:39:58Z")
I am wondering if there is a way to generate a unique ID for each order placed in the app. When the order is placed it will be stored in google sheets with a unique ID generated. When the user logs in they can see only their own Orders from that google sheet. I don’t know if this makes sense, I would just like to know if this is possible or if I should be looking at other ways? Thanks for your help! ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [February 1, 2024, 8:56am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/6 "2024-02-01T08:56:39Z")
Hi, if your problem is the unique ID you can use The unique ID provided from Google sheet or create a new one as you like (only number , alphabetic, alphanumeric, etc ) . If your problem is to show only the order of a customer you have only to make a search to find the right customer and get the data . Probably Google sheet is not comfortable to store this kind of data because is a sequence of rows , you can’t organise a lot . Firebase or a dictionary let you store data in a different way, you can store data under a key (like a folder) so you can create a unique ID and inside save all data (name, mail, order, etc ) ---
**Author:** ![minasmith123](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@minasmith123](https://community.thunkable.com/u/minasmith123)\ **Post date:** [February 1, 2024, 9:38am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/7 "2024-02-01T09:38:26Z")
I will try to use Firebase in this case. Thanks for your help! ---
**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:** [February 1, 2024, 11:05am UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/8 "2024-02-01T11:05:08Z")
Firebase is a great option. Until we get the ability to set constraints on the db calls, Honestly, I would use supabase or xano for something like this. Specially if you want to return filtered results or not all at once. Firebase will definitely do what you need though, at a base level ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [February 1, 2024, 8:41pm UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/9 "2024-02-01T20:41:57Z")
> [@jared](#): > > supabase or xano Very interesting, thanks to share, I see you did some work and guide about them , very useful ---
**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:** [May 1, 2024, 8:42pm UTC](https://community.thunkable.com/t/solved-2-1-24-6-05-am-edt-creating-unique-order-id/2812670/10 "2024-05-01T20:42:00Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.