# Relations Broken

**URL:** <https://community.glideapps.com/t/relations-broken/57196>\
**Category:** Ask for Help\
**Created:** [January 27, 2023, 9:08pm UTC](https://community.glideapps.com/t/relations-broken/57196 "2023-01-27T21:08:38Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jason\_Palmer1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_palmer1/32/43557_2.png) [@Jason\_Palmer1](https://community.glideapps.com/u/Jason_Palmer1)\
**Post date:** [January 27, 2023, 9:08pm UTC](https://community.glideapps.com/t/relations-broken/57196/1 "2023-01-27T21:08:38Z")

</div>

Any one having issues with relations on a Glide Sheet suddenly not working?

---

<div class="post-metadata">

**Author:** ![Jireh\_Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jireh_lee/32/52727_2.png) [@Jireh\_Lee](https://community.glideapps.com/u/Jireh_Lee)\
**Post date:** [January 27, 2023, 9:15pm UTC](https://community.glideapps.com/t/relations-broken/57196/2 "2023-01-27T21:15:52Z")

</div>

Here too! suddenly the lookup column doesn’t parse the column type and my conditions stopped working. I needed to grab the date from another table and create a condition “before today” but now it only shows the options “is empty / is not empty / contains / does not contain”

---

<div class="post-metadata">

**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:** [January 27, 2023, 9:38pm UTC](https://community.glideapps.com/t/relations-broken/57196/3 "2023-01-27T21:38:40Z")

</div>

@Jason_Palmer1 can you explain what “not working” means?

@Jireh_Lee those condition options seem to indicate that the relation is a multiple relation and the lookup is returned as an array. You only have a few options for conditions when working with arrays. Can you verify that the relation does not have ‘multiple’ checked, and verify that the column your lookup is returning is not an array?

Screenshots can be useful to see what’s going on.

---

<div class="post-metadata">

**Author:** ![Jireh\_Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jireh_lee/32/52727_2.png) [@Jireh\_Lee](https://community.glideapps.com/u/Jireh_Lee)\
**Post date:** [January 27, 2023, 9:49pm UTC](https://community.glideapps.com/t/relations-broken/57196/4 "2023-01-27T21:49:47Z")

</div>

This is an old button with the right conditions set in place before the recent error:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2b0759c07007f7de12fde822608976c8556300b2.png)

This is me re-creating the button again to find the conditions missing:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9345360425c3050b355e28da2f6d497dacc85d50.png)

I even removed the conditions from the old button to try and redefine the conditions and found that the once available time conditions are now missing. Haven’t touched any column settings since. Any ideas? Or what would you need to see from my end to figure this out?

---

<div class="post-metadata">

**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:** [January 27, 2023, 9:53pm UTC](https://community.glideapps.com/t/relations-broken/57196/5 "2023-01-27T21:53:51Z")

</div>

Can you show the configuration for the Relation column? Also, can I see some of the data in the Lookup column?

---

<div class="post-metadata">

**Author:** ![Jason\_Palmer1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_palmer1/32/43557_2.png) [@Jason\_Palmer1](https://community.glideapps.com/u/Jason_Palmer1)\
**Post date:** [January 28, 2023, 2:13am UTC](https://community.glideapps.com/t/relations-broken/57196/6 "2023-01-28T02:13:10Z")

</div>

Hey Jeff.  
Quite simply the relation column that links to user data & other sheets, no longer works despite it working perfectly a couple of days ago.  
This level of constant bugs is causing trust issues with glide as a product.

 ![Screenshot 2023-01-28 101343](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e43ec5478f38bd9d12667582c548e964e3d0163a.png)

---

<div class="post-metadata">

**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:** [January 28, 2023, 2:19am UTC](https://community.glideapps.com/t/relations-broken/57196/7 "2023-01-28T02:19:38Z")

</div>

Can you confirm that the value in the JobID column has a matching RowID value somewhere in the Jobs table?

---

<div class="post-metadata">

**Author:** ![Jireh\_Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jireh_lee/32/52727_2.png) [@Jireh\_Lee](https://community.glideapps.com/u/Jireh_Lee)\
**Post date:** [January 28, 2023, 5:52am UTC](https://community.glideapps.com/t/relations-broken/57196/8 "2023-01-28T05:52:11Z")

</div>

Hey Jeff… I looked into the links deeper and found that you are right about the array. It seems like I created another column when I was working on some other component in my app and I didn’t reference it for the new button so it it broke. It’s working now. Thanks

---

<div class="post-metadata">

**Author:** ![Jason\_Palmer1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_palmer1/32/43557_2.png) [@Jason\_Palmer1](https://community.glideapps.com/u/Jason_Palmer1)\
**Post date:** [January 28, 2023, 7:25pm UTC](https://community.glideapps.com/t/relations-broken/57196/9 "2023-01-28T19:25:15Z")

</div>

I will check

---

<div class="post-metadata">

**Author:** ![Jason\_Palmer1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_palmer1/32/43557_2.png) [@Jason\_Palmer1](https://community.glideapps.com/u/Jason_Palmer1)\
**Post date:** [January 28, 2023, 7:53pm UTC](https://community.glideapps.com/t/relations-broken/57196/10 "2023-01-28T19:53:46Z")

</div>

I seem to have fixed it some how. Not entirely sure how.  
Thanks for helping Jeff

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 29, 2023, 7:54pm UTC](https://community.glideapps.com/t/relations-broken/57196/11 "2023-01-29T19:54:50Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
