# Enforce column value is unique (distinct)
**URL:** https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842
**Category:** Ask for Help
**Created:** [May 11, 2022, 8:12am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842 "2022-05-11T08:12:25Z")
**Posts on this page:** 7
**Page:** 2
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 23, 2024, 12:12am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/21 "2024-09-23T00:12:24Z")
What plan are you on at the moment? Maybe you can help a mirrored table that stores only the added IDs and check against them?
---
### Author:  [@RISCKY\_ALI](https://community.glideapps.com/u/RISCKY_ALI)
#### Post date: [September 23, 2024, 7:38am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/22 "2024-09-23T07:38:51Z")
im still in free plan, and will use the maker plan for this app after im done developing it. If im making a mirrored table isnt it will takes up the row count?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 23, 2024, 2:25pm UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/23 "2024-09-23T14:25:03Z")
Yes, it would count towards your row quota.
---
### Author:  [@RISCKY\_ALI](https://community.glideapps.com/u/RISCKY_ALI)
#### Post date: [September 23, 2024, 11:06pm UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/24 "2024-09-23T23:06:05Z")
is the maximum row count (25k) is applied to row from googlesheet to?
im planning to use mirrored table from googlesheet, where i store all the unduplicated ID from a 3 days data collection. my question is, if my relation action triggered (to check my ID stored in googleshet) do it count as update or the update count just when i sync the stored ID every 3 days?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 23, 2024, 11:27pm UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/25 "2024-09-23T23:27:13Z")
> [@RISCKY\_ALI](#):
>
> is the maximum row count (25k) is applied to row from googlesheet to?
Yes, that’s correct.
> [@RISCKY\_ALI](#):
>
> if my relation action triggered (to check my ID stored in googleshet) do it count as update or the update count just when i sync the stored ID every 3 days?
A “relation” won’t trigger an update, but any changes on the Sheet side will trigger an update (as a sync).
---
### Author:  [@RISCKY\_ALI](https://community.glideapps.com/u/RISCKY_ALI)
#### Post date: [September 24, 2024, 1:31am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/26 "2024-09-24T01:31:59Z")
if the row from googlesheets still count, theres no meaning for using it for my stored ID. i think with my target surveyed around 20k citizen and the mirrored from googlesheets just will eat my row count. So theres no solutions for me to have a individual data with general column for ID checking.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 24, 2024, 1:34am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/27 "2024-09-24T01:34:43Z")
My only thoughts would be to create a separate admin row owner so you can access all rows. Maybe add a collection somewhere in your app that only shows duplicates and add an action to your collection to delete one of the rows. You could do the same thing with a second app that only you have access to, which would have any row owners applied.
[Previous page](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842.md?page=1)