# Row ID Used in Relation not working **URL:** \ **Category:** Ask for Help\ **Created:** [February 25, 2022, 11:39am UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953 "2022-02-25T11:39:05Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 11:39am UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/1 "2022-02-25T11:39:05Z")
I have a very simple app where i need to total and summarise responses to a short survey from All users. I am using Glide tables exclusively. I have an appHome table (where the summary totals will be calculated) with a Row Id column. This AppID is then made available in the users table via an If-Then-Else column. Finally the form that submits a new response record, uses the iteAppID in the users table to update the “AppID” text column in the responses table as the form is submitted. The text field is working in the responses table - it is set correctly for each record created. Why would a relationship field in the appHome table that matches the Row ID in appHome (there is only one record in this appHome object), to the response table field “AppID” not work? The relationship is empty. What have I misunderstood? Many thanks Mark appHome Relationship: ![row id appHome](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/152d39da770d1427afad783653c232176294fbaf.png) responses table: ![row id responses](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a62294884837de19fac8eb5885cbfa7d138ab31d.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 25, 2022, 12:40pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/2 "2022-02-25T12:40:23Z")
Are there any columns in your Responses table with Row Owners applied? Do you see anything different in the Data Editor when you view as different users? ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 1:55pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/3 "2022-02-25T13:55:46Z")
Hi Darren No, there are no row owners applied at all. Responses table, all fields remain unchanged regardless of which user is viewing the table. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 25, 2022, 1:59pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/4 "2022-02-25T13:59:25Z")
What does the ITE column look like? ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 2:34pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/5 "2022-02-25T14:34:03Z")
Hey Mr Petitto I am a big fan - thank you for your willingness to share and post useful vids! Here is the ITE column in user table: ![row id user table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa5eedeed3d57a18ec9613922ae3c240c6a589d3.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 25, 2022, 2:49pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/6 "2022-02-25T14:49:55Z")
Are you sure you didn’t type any extra spaces before or after the RowID in your IF column? It might be better to just use a Single Value column to bring the RowID into the user table. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 25, 2022, 3:15pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/7 "2022-02-25T15:15:53Z")
I agree with Jeff. Regardless of whether it is the source of the problem or not, hard coding the Row ID in that manner is just asking for trouble. Much better to use a single value column. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 25, 2022, 4:12pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/8 "2022-02-25T16:12:09Z")
That’s what I was looking for—there’s no need to use a ITE column here. Use a single value column instead. ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 7:04pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/9 "2022-02-25T19:04:22Z")
Thank you - I will try that - and let you know if resolved my issue. Appreciate feedback from all! ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 7:35pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/10 "2022-02-25T19:35:59Z")
Ok - I changed the value for AppId to a single value column in users table and referenced that in the response submit form. The relationship includes the new record I just added! Thank you. What can i do about the existing records - I need them to be recognised in the relationship too. I copied and pasted values from both sides of the relationship into a text editor to compare and I cannot spot a difference? Why are the older records still not being recognised? Second question @Darren_Murphy why would “hard coding” the value using a ITE be prone to issues over a single value column - just trying to understand principal better so as to improve my Glide “brain”. Once again - thank you all. ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 7:51pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/11 "2022-02-25T19:51:07Z")
Ok I found the issue with why it was not recognised. The very first character is a capital “i” but I had copied it (using a text sniper tool) from the original Row ID with a lower case “L”. Why are we prevented in Glide from copy and pasting a Row ID column value? Thanks again for suggestions - highly valued. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 25, 2022, 7:58pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/12 "2022-02-25T19:58:26Z")
That would do it. 😛 It’s probably not a matter of allowing it to be copied. It’s probably more that fact that RowID’s aren’t meant to be changed, so it’s a protected uneditable column. It’s not usually a typical situation to copy the RowID and manually paste it somewhere. ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 25, 2022, 8:03pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/13 "2022-02-25T20:03:08Z")
understood - thanks! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 26, 2022, 12:40am UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/14 "2022-02-26T00:40:34Z")
> [@mwza](#): > > Why are we prevented in Glide from copy and pasting a Row ID column value? We’re not 😉 You can copy/paste, you just can’t edit. But just because you can, doesn’t mean it’s a good idea. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 26, 2022, 3:47pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/15 "2022-02-26T15:47:53Z")
I stand corrected. 😉 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 26, 2022, 4:06pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/16 "2022-02-26T16:06:36Z")
hehe, one situation where you really do want to be able to copy a RowID is when you are debugging something and need to search for it in another table. I was doing that recently and tried this on a hunch, and was pleasantly surprised to find that it works 🙂 ---
**Author:** ![mwza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mwza/32/43529_2.png) [@mwza](https://community.glideapps.com/u/mwza)\ **Post date:** [February 26, 2022, 5:00pm UTC](https://community.glideapps.com/t/row-id-used-in-relation-not-working/38953/17 "2022-02-26T17:00:38Z")
Great tip - thanks for shining light on that one!