# \[Solved\] To add Unique records to new table
**URL:** https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137
**Category:** Questions about Thunkable X
**Tags:** solved
**Created:** [December 25, 2021, 5:46am UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137 "2021-12-25T05:46:52Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)
#### Post date: [December 25, 2021, 5:46am UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/1 "2021-12-25T05:46:53Z")
Hello Thunkers!
How can we add only unique records to a table.
The image above has following textboxes. The textboxes in circled area are client data. The unique value in this textbox is GSTIN number, which is also a searchbox.
Now what I want is, if client is new, admin has to manually type the data. This data has to be stored in two tables i.e., Order Report and Client Report.
Now client report table should only add record if gstin number is unique i.e., there has to be no other records with same gstin number.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 25, 2021, 10:03am UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/2 "2021-12-25T10:03:27Z")
When you say **unique** , do you mean to check for no duplicates?
The code that you are showing makes a list of GSTIN in Client\_Report table but remember that this is done when you start the app so it will be correct for the first entry. If you try to check for the same client again then you will still find it as new.
---
### Author:  [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)
#### Post date: [December 25, 2021, 6:14pm UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/3 "2021-12-25T18:14:22Z")
Yes, there should be no duplications of same client in client report table.
After adding first item it does exactly you stated!
---
### Author:  [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)
#### Post date: [December 26, 2021, 5:31pm UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/4 "2021-12-26T17:31:16Z")
?? No one to help me out? Or should I be more clear?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [December 26, 2021, 6:07pm UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/5 "2021-12-26T18:07:30Z")
You can search the data source for the client name and use an if/else block to create a new record only if the name does not exist.
Which part do you need help with?
---
### Author:  [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)
#### Post date: [December 27, 2021, 4:19am UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/6 "2021-12-27T04:19:51Z")
Searching part is done. All I need is adding record into the table.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 27, 2021, 7:06am UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/7 "2021-12-27T07:06:33Z")
You need to add a block like this
In here
This should fix the issue.
---
### Author:  [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)
#### Post date: [December 27, 2021, 4:14pm UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/8 "2021-12-27T16:14:45Z")
Thank you Sir! 😄
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [March 27, 2022, 4:15pm UTC](https://community.thunkable.com/t/solved-to-add-unique-records-to-new-table/1660137/9 "2022-03-27T16:15:44Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.