# Crosscheck Over Row Owner **URL:** \ **Category:** Ask for Help\ **Created:** [May 26, 2023, 8:04am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163 "2023-05-26T08:04:26Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [May 26, 2023, 8:04am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/1 "2023-05-26T08:04:26Z")
Hello, I’ve Got an Issue here. I want to have sales input leads to my apps, and also recheck the duplicate phone number but the problem is, when i set row owner on each sales’s input, it doesnt detect the duplicat how do i solve it ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 26, 2023, 8:14am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/2 "2023-05-26T08:14:36Z")
Create a second list for phone numbers and users’ rows ID that has no row owner… if you keep your data in Google Sheets… then there is no problem at all, run a function there. ---
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [May 26, 2023, 8:19am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/3 "2023-05-26T08:19:32Z")
second list ? what does it mean ? another table ? i only use glide table, since gsheet consume too much sync update ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 26, 2023, 8:20am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/4 "2023-05-26T08:20:43Z")
Yes, another table… GS consumes precisely the same amount of updates as GT… and some cases even less 😉 ---
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [May 26, 2023, 8:26am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/5 "2023-05-26T08:26:32Z")
another table did you mean, whenever an input occured, they need to input it to another table also ? or can we created a computed column/relation to this new table , and then we create another relation to check duplicate? sorry, because my last app was using gsheet, and it consumes twice, table update and sync update between GS 😅 thats why i want to solely/only used glide table. hehe correct me again if im wrong ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 26, 2023, 8:29am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/6 "2023-05-26T08:29:46Z")
My apps do not consume any updates… Yes… when your users input new data… add a record to the separate table… they don’t need to input it twice… just action after submitting. ---
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [May 26, 2023, 8:34am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/7 "2023-05-26T08:34:17Z")
i already had 7000 record before, do i have to create another table with 7000 row also ? or can it just 1 row, but an array of it ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 26, 2023, 8:35am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/8 "2023-05-26T08:35:51Z")
Yes, 1 row, with two arrays… one for user ID, one for Numbers… each time append a new value to the array… and check for duplicates ---
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [May 26, 2023, 8:39am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/9 "2023-05-26T08:39:52Z")
im sorry, what does User ID here does ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 26, 2023, 8:41am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/10 "2023-05-26T08:41:05Z")
If you want to track whom the number belongs to (optional) ---
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [May 26, 2023, 9:38am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/11 "2023-05-26T09:38:06Z")
how to add a record to separate table , when im inputting new data in Table1, but need to create a new action (set a column value) to another table ? created relation, but it doesnt make it to there. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 26, 2023, 9:49am UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/12 "2023-05-26T09:49:54Z")
Why? ---
**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\ **Post date:** [August 31, 2023, 1:04pm UTC](https://community.glideapps.com/t/crosscheck-over-row-owner/62163/13 "2023-08-31T13:04:58Z")
im still stucked, since i got 13k row of phone number, whenever i drag an array of phone numbers into one single cell, it always loads slower