# Relation not Working **URL:** \ **Category:** Ask for Help\ **Created:** [May 6, 2026, 1:46pm UTC](https://community.glideapps.com/t/relation-not-working/87017 "2026-05-06T13:46:22Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 6, 2026, 1:46pm UTC](https://community.glideapps.com/t/relation-not-working/87017/1 "2026-05-06T13:46:22Z")
I’m trying to make a relation between the row ID of one table (table 1) and an if then else column in another table (table 2). when i make the relation in table 1, it doesn’t work and all the cells are blank. when i make it in table 2 in the reverse order, though, it works. Does anyone know what could be causing this? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/76216a5efd2d18072aa296af5619c84da1dab16e.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/265ad1b48f28e95cb1d86c9332bbbfc91a3f8c1c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/479f7ceff540ab002f792043ccdb890adf5e404e.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:** [May 6, 2026, 2:00pm UTC](https://community.glideapps.com/t/relation-not-working/87017/2 "2026-05-06T14:00:15Z")
I assume you are only expecting a match for the rows that have ven-001 based on your screenshots? I can also tell by the grayed out rows that you have row owners applied. Are you trying to match to a row that the user you are previewing as doesn’t have access to? What kind of data sources are you using? Glide Table, Big Table, Other? What does the configuration for your other relation look like? ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 6, 2026, 2:20pm UTC](https://community.glideapps.com/t/relation-not-working/87017/3 "2026-05-06T14:20:08Z")
1. For this particular example, yes, but the other row ID values will get filled in based on user inputs. 2. Yes, I just started using Glide so I’m not sure what row owners is or how to enable it, but the row I’m trying to match to is the ID that’s automatically assigned when a row is added in Table 1 (Row ID) to the column in table 2 that inputs the Row ID when a user fills out a form. 3. The data is from a form in Glide 4. please see the picture below ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/73d60dc06a7caae3c9a69056c4e1317d08e81ebd.png) ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 12:37am UTC](https://community.glideapps.com/t/relation-not-working/87017/4 "2026-05-07T00:37:56Z")
It appears to be because it doesn’t like that I’m using a (current date/time - submitted time) calculation in my if then else column. When I set it up so there is no date/time calculation, it works as intended, but when the date/time is involved it doesn’t work. I think it works when I make the relation in table 2 because that is where the date/time calculation is occurring and when it’s the other way around it doesn’t like pulling that data from another table. Do you know if there is a potential workaround to this? ---
**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:** [May 7, 2026, 3:18am UTC](https://community.glideapps.com/t/relation-not-working/87017/5 "2026-05-07T03:18:14Z")
The current date/time is a constantly changing value, so that’s never going to work in a relation, which attempts to exactly match two values. Can you explain at a high level what your end goal is? It could be that you need to use a query rather than a relation. ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 11:14am UTC](https://community.glideapps.com/t/relation-not-working/87017/7 "2026-05-07T11:14:53Z")
So I created a form that allows users to rate something 1-5 and also gets the time they submitted the form at and which “Row ID” it relates to in table 1. I want to filter out the forms that were submitted more than 2 hours from the current time. I set up an if then else to filter out the old forms by only displaying the “Row ID” value for forms less than 2 hours old and leaving the rest blank. But when I try to use that column in the relation to table 1, it doesn’t work ---
**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:** [May 7, 2026, 11:45am UTC](https://community.glideapps.com/t/relation-not-working/87017/8 "2026-05-07T11:45:43Z")
I wouldn’t bother with a relation. I’d do it like this: - Create a math column using the following formula: `Now - 2/24` (this will give you the date/time 2 hours ago) - Now create an if-then-else column: – If Submission Date/Time is before 2 hours ago, then `true` - Use the if-then-else column as a filter (only show rows where it is checked) You could even skip the if-then-else column if you wanted to, but personally I find it better practise to keep filtering logic inside the Data Editor. ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 12:09pm UTC](https://community.glideapps.com/t/relation-not-working/87017/9 "2026-05-07T12:09:40Z")
I set it up as you described but I switched the if-then-else column to be true if submission date/time is after two hours ago. When I create the filter, though, no rows show up when the filter is set to “is checked” but when set to “is not checked” it leaves all rows, even the ones with checks. I also tried it with it being true if submission date/time is before two hours ago and same result. Please see the screenshots below. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e85bc2e2650cd5f20dbcede93154490543f4b59.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee3f392e92eac6e393a3a3c3074f0ecf285b1d91.png) ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 12:22pm UTC](https://community.glideapps.com/t/relation-not-working/87017/10 "2026-05-07T12:22:42Z")
Also, I should explain what my true end goal is. I want to take the ratings that were submitted with the form and stored in table 2 to be put into an average rating for each Row ID that is in table 1 and that average rating will be displayed with its corresponding row ID in the layout. I’ve gotten it to work for all ratings that were submitted, I’m only having trouble trying to filter out the 2 hour or older ratings. ---
**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:** [May 7, 2026, 12:54pm UTC](https://community.glideapps.com/t/relation-not-working/87017/11 "2026-05-07T12:54:28Z")
Try ‘On or After’ (which accounts for time) instead of ‘Is After’ (which only considers days, ignoring time). edit: I might have that backwards ---
**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:** [May 7, 2026, 1:24pm UTC](https://community.glideapps.com/t/relation-not-working/87017/12 "2026-05-07T13:24:14Z")
Show your math column. Trying to understand where you are calculating 2 hours. ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 1:34pm UTC](https://community.glideapps.com/t/relation-not-working/87017/13 "2026-05-07T13:34:52Z")
Using “On or After” worked, it now filters out reports older than 2 hours. But it still counts the rows that are filtered out in my relation in table 1, is there a way to make it so it doesn’t? Here is my math column: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16ec1bc09c04395f25c89db0a455c8a882415bb4.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:** [May 7, 2026, 1:41pm UTC](https://community.glideapps.com/t/relation-not-working/87017/14 "2026-05-07T13:41:22Z")
Why is your Math column referring to another Math column? That’s not necessary, you can refer directly to the special “Now” value, like below: ![CleanShot 2026-05-07 at 21.39.54@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27eb64d747eb11a035f46e6d2db3e6fe640bded4.png) ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 1:48pm UTC](https://community.glideapps.com/t/relation-not-working/87017/15 "2026-05-07T13:48:34Z")
Changing to the Now value fixed the relation in table 1, thank you guys! ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 4:39pm UTC](https://community.glideapps.com/t/relation-not-working/87017/16 "2026-05-07T16:39:42Z")
I lied, actually. My relation only works if I use “On or after” instead of “is after”, but when I do that, it doesn’t clear out the reports older than 2 hours as I intended, presumably because it only considers days, as Jeff mentioned. Do you know why this is or if there’s a workaround? ---
**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:** [May 7, 2026, 4:53pm UTC](https://community.glideapps.com/t/relation-not-working/87017/17 "2026-05-07T16:53:41Z")
I feel like I’m missing a piece of the puzzle that explains why you are having problems, but try flipping your thought process a bit. Instead of calculating 2 hours from Now, add 2 hours to your SubmittedAt column instead. Then change your IF column or filter to compare where the math value ‘Is After’ Now. It might be a lot less calculation intensive because it won’t be recalculating the math column every 10 seconds when Now updates. Instead, each math cell will calculate once against the submitted date and then compare against a single Now value instead of hundreds of Now values that are continuously changing. ---
**Author:** ![Jarettbv5](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jarettbv5/32/87901_2.png) [@Jarettbv5](https://community.glideapps.com/u/Jarettbv5)\ **Post date:** [May 7, 2026, 5:45pm UTC](https://community.glideapps.com/t/relation-not-working/87017/18 "2026-05-07T17:45:45Z")
That appears to have solved it! I think you’re right that the constant calculations with the now updates made it not work. Thanks again for the help!