# Relation not being found **URL:** \ **Category:** Ask for Help\ **Created:** [December 6, 2021, 8:28pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593 "2021-12-06T20:28:05Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 6, 2021, 8:28pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/1 "2021-12-06T20:28:05Z")
Hi! I have several relation columns (see image below) that are linking the “Format” columns with the matching record in this same table. As you can see, it finds 1, 2, 3, and 5. But it does not find #4 even though there is a match. It just doesn’t display. I’ve setup all the relations similarly so I’m confused as to why it’s not working. Any thoughts? Thanks! ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c71a7b2043ffec61befe7cbf7372bb995a14f493.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:** [December 6, 2021, 8:57pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/2 "2021-12-06T20:57:01Z")
Can you show your settings for that relation? ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 6, 2021, 8:59pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/3 "2021-12-06T20:59:32Z")
Sure. Here are both the #4 and #5 relation columns. ![Capture4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/29c65cfa907de553157bc85b4496ee57bac971bc.png) ![Capture5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c16dce07e175a13e924dab635ca5f99906714e66.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:** [December 6, 2021, 9:04pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/4 "2021-12-06T21:04:47Z")
Just trying to understand. You mentioned that you are using the ‘Format’ column values for your relation, but I don’t see them being used in your relation. That aside, is there any chance that the value in your ‘Value’ column or the value in your ‘Total Profit’ column has has an underlying unformatted number with decimals beyond 2 decimal places? Is using a calculated value the best way to build a relation? Hard to say without knowing the purpose of the relation. ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 6, 2021, 9:11pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/5 "2021-12-06T21:11:35Z")
Sorry, I’m using the value column as the relation, not the format. 🤪 ![Value](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab13607864390073eac6477e987aa833bab21022.png) The value doesn’t appear to have any decimals. What I’d like to do is find the Ticker symbol that matches the list value. So I’ve sorted all the totals from largest to smallest. Then I’m trying to make a “top 5” list that shows the ticker symbol as well as the profit total. But for some reason #4 is the only one that doesn’t show even though the value is retrieved. So on the UI it would look like this: ![UI](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c763b66a1692c2f7ed81af7293975984d7b8b2e7.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:** [December 6, 2021, 9:16pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/6 "2021-12-06T21:16:44Z")
Where are your Single Value ‘Value’ columns getting their value from? Also, which column is the related Rollup column summing it’s value from? ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 6, 2021, 9:28pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/7 "2021-12-06T21:28:12Z")
I tried to make a video to show how I set it up: ---
**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:** [December 6, 2021, 9:43pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/8 "2021-12-06T21:43:10Z")
OK, I have a theory. I think it has something to do with row 4 being under a different row owner. Your Single Value columns are looking for a specific row position. Because row 4 belongs to a different user, it might not be seeing any value. Glide can be a little weird when Row Owners are applied and you are viewing it in the builder. It will show you all of the data for all users, and sometimes that causes some weirdness with computed values. In reality, those unowned rows would not be downloaded to a user device. Can you try with the published version and see if that makes a difference? I’m guessing that it may work correctly with the published version because those unowned rows would not exist in the published version. ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 6, 2021, 9:45pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/9 "2021-12-06T21:45:09Z")
I do have the app on my phone and that 4th ticker still doesn’t show up. It looks just like the builder view 😟 ---
**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:** [December 6, 2021, 9:48pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/10 "2021-12-06T21:48:42Z")
Is this production data, or just testing? Would you be willing to try either deleting row 4, or better yet, change the email to your email temporarily? ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 7, 2021, 1:56pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/11 "2021-12-07T13:56:49Z")
Hello! So it’s production data (live app), but this tab is visible only to me currently. So after changing row 4 email to mine, or even deleting that row, the issue is still there (no ticker symbol). ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 7, 2021, 8:44pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/12 "2021-12-07T20:44:10Z")
So if I change the value from “3” (to find the 4th value in the Duplicates array column) to “5” (to find the 6th value), then the ticker symbol shows up. So there’s something going on with that’s 4th value. Just not sure what it is… ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 7, 2021, 9:12pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/13 "2021-12-07T21:12:27Z")
So if I pull the third position (864; 4th value in array) from the duplicates, the ticker doesn’t show. But if I choose the first position in the lookup column (which is the same 864 value), then the ticker does show. ![Capture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c4a1463427016f29351f0b4123147604fbb881b.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:** [December 7, 2021, 10:46pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/14 "2021-12-07T22:46:17Z")
Check another thing for me. I’ve made this mistake before. When you are pulling a single value from an array, sometimes you can see the same column in two places in the ‘From’ setting of the Single Value. One is the single array column in the same row, which should be shown at the top of the list when you click on the ‘From’ dropdown. The other place you see it is in the table\>column option in the dropdown, which searches the array of values from the column in all rows. I’m not sure if that’s the case here, or maybe further up the line. That’s why I suspected that maybe your the unowned row was somehow the culprit, but from what you say, that is not the case. Other than that, I’m running out of ideas. What you’ve shown seems correct, unless there is an issue with the Duplicates plugin. I haven’t used a lot of plugins yet, so I’m not very experienced with them. Would you be willing to make a duplicate of your app (duplicating data as well, so you don’t interfere with your existing app), strip out any private data that you don’t want to share, and then share the published url of the copyable version so one of us could take a deeper look? I think at this point I would have to get my hands in there and play around to see what’s going on. ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 8, 2021, 2:43pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/15 "2021-12-08T14:43:45Z")
There were two other places to choose in the “From” dropdown, but they just produced a series of numbers, and not a single value. So I copied the app here for troubleshooting: > **[Trade 5 (Testing)](https://absorbing-jar-4139.glideapp.io/)** > > Keep track of your options trades with this handy app! Designed with the Wheel options trading strategy in mind, this app not only keeps your trade log with you at all times, it tracks how close you are to meeting your monthly trading goal. To learn... Thanks again for your willingness to help out us newbies! ---
**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:** [December 8, 2021, 4:07pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/16 "2021-12-08T16:07:34Z")
Can you enable copying? > **[Copy app as template](https://docs.glideapps.com/all/reference/templates/copy-app-as-template)** ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 8, 2021, 4:36pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/17 "2021-12-08T16:36:35Z")
Oh yeah, sorry about that. I enabled copying… ---
**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:** [December 8, 2021, 9:51pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/18 "2021-12-08T21:51:55Z")
I’ve been looking at this for awhile. For the life of me I can’t see where it falls apart. I will admit, you do have a very elaborate setup. The only thing I keep looking for is a floating point decimal that’s hiding somewhere, but I’m not coming up with anything yet. My other thought is that the plugins are failing or returning a bad value somewhere, but I’m not seeing it. In theory, the relation should find the very first row in the table since it has the matching LCID value. I’ll keep looking, but I’m not having any luck so far. This might be something that will have to be submitted to glide. It’s possible that it’s some kind of internal issue or error that I’m just not seeing. If that doesn’t work, then maybe we need to come up with a simpler approach. I don’t know yet. Just wanted to give you an update. ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 8, 2021, 10:42pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/19 "2021-12-08T22:42:49Z")
Ok, thank you so much. When you say “elaborate” is that a good or a bad thing? 🥴 ---
**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:** [December 8, 2021, 11:11pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/20 "2021-12-08T23:11:55Z")
Hehe, neither. I’m just saying that it’s not a simple app. You’ve obviously put a lot of work into it and there’s a lot of steps and columns to trace through. 😉 [Next page](https://community.glideapps.com/t/relation-not-being-found/35593.md?page=2)