# Issue with Rich Text field pulling in Custom Value from my Data Tables **URL:** \ **Category:** Ask for Help\ **Created:** [August 31, 2025, 4:10pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119 "2025-08-31T16:10:29Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\ **Post date:** [August 31, 2025, 4:10pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/1 "2025-08-31T16:10:29Z")
In one of my apps I’m using a Rich Text component and trying to pull in data from a column called DailyMantra. For some reason when I search for this column value it doesn’t come up. In my other project I’m doing a very simlar thing and it’s working fine so I’m struggling to understand why in this instance it’s not working. If someone can help me diagnose what is causing this that would be great. ![Screenshot 2025-08-31 at 16.38.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d325a65219f1586ada6d8f55bcf93aa9fd9aefb0.png) ![Screenshot 2025-08-31 at 16.39.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/11299709874b281fb6aef3ef95a9d86695d0fd6b.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:** [August 31, 2025, 5:18pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/2 "2025-08-31T17:18:30Z")
The lookup column is an array. You can tell by the bubbles. Arrays can contain thousands of individual items. You are trying to place that lookup array into something that can only display one item. Where is that Lookup coming from? A relation, query or directly from a table? A table will always return an array. a relation or query can be changed to only return a single row, and thus the lookup would return a single item as opposed to an array. ---
**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\ **Post date:** [September 1, 2025, 4:56am UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/3 "2025-09-01T04:56:36Z")
The value I’m trying to pull in is a value that is coming from a query. ![Screenshot 2025-09-01 at 06.51.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/340b9b6116f11b8afd65d1a3e3ab6edbee4b3a73.png) I’m trying to show 1 positive affirmation per day and found that to create a screen specific for this I had to create a table specific for it. So I have a table that has a positive affirmation by date (see screenshot) and then another that just pulls in today’s date and the corresponding positive affirmation. ![Screenshot 2025-09-01 at 06.55.11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d0354af46c441647834276348ae6b3be1d7483d.jpeg) Should i potentially be trying to pull this value directly from the table that has the full list of affirmations - I was just struggling to figure out how to update it per day. ---
**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:** [September 1, 2025, 5:36am UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/4 "2025-09-01T05:36:28Z")
Ok, my mistake. The query and lookup column icons look very similar. The query is good, but queries and relations returns rows of data. They do not return a specific column. You only told it which rows to retrieve. You need a Lookup column to retrieve a specific column from that queried row. ---
**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\ **Post date:** [September 2, 2025, 12:05pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/5 "2025-09-02T12:05:03Z")
Thanks Jeff, I’m trying to understand are you suggesting that because of the way I’ve set up this separate table for just the daily affirmation of today the field i’m now pulling in is not a static value do I can’t pull it into a Rich Text field. So rather then me setting up a separate table i should actually be pulling this value from the main table that has all the affirmations by the date and with a Lookup I can pull in the correct one for the right day? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 2, 2025, 11:44pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/6 "2025-09-02T23:44:37Z")
He means what you’re retrieving with the query is a “pathway” to the data, not the data itself. To display what you want as text, you would need a further lookup column on top of the query to retrieve the value. ---
**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\ **Post date:** [September 4, 2025, 9:52am UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/7 "2025-09-04T09:52:23Z")
Thanks Thinh, I tried added a second look up column now just referencing that value but still not able to retrieve it from my Rich Text field. Do I need to convert it to just a value of text? Or am i not doing this step correctly. ![Screenshot 2025-09-04 at 11.01.58](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/7799d15537368689df560d18345d39fd6db7e84d.jpeg) ![Screenshot 2025-09-04 at 11.04.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df16ffde8bfdfc7ca90f759df71deca2fbc621e0.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:** [September 4, 2025, 10:50am UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/8 "2025-09-04T10:50:16Z")
That’s not a lookup column, it’s a query column. ![CleanShot 2025-09-04 at 18.49.38@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/35de8b8389f935a52664c99da352e2156c552f9e.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:** [September 4, 2025, 12:41pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/9 "2025-09-04T12:41:18Z")
Please show us the configuration of the ‘DailyMantra’ **Query** column and the configuration of the ‘Daily Mantra Text’ **Lookup** column. In your last post, you are showing the same column as two different types of columns. Please verify which one it is. The first screenshot shows it as a Query column. The second screenshot shows the same column as a Lookup column. It should be a Lookup column. ![1000005790](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2b7ed9a6b2b91a98b73a0b1ffe2e60fee6ecac19.png) ![1000005791](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/21613cd78f1de67f04e5a730effc755ba7ae34c9.png) ---
**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\ **Post date:** [September 4, 2025, 12:58pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/10 "2025-09-04T12:58:00Z")
Sorry I realised i shared the wrong screen shot - here is shots of boht the query and look up fields. ![Screenshot 2025-09-04 at 14.55.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/961db99f395e8236ef84e57cffd867f6e690a9be.jpeg) ![Screenshot 2025-09-04 at 14.55.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7ce5c963504aa75b78bfd6339171fc457fd5e9f.jpeg) ---
**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:** [September 4, 2025, 1:12pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/11 "2025-09-04T13:12:29Z")
You need to change the lookup column. You have it pointing to the table and essentially returning the same query back into the table through the lookup. The lookup is returning the exact same result as the Query because you are just returning the query column itself through the lookup. Change the Lookup column to point directly at the Query Column because you want to retrieve a value **from** the Query. You do not want to retrieve the Query itself. Ultimately you should be pulling back the Mantra column through the query. ![1000005794](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08bb727e4810d3a12c567678eb0020e7e7b4d3d2.png) ---
**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\ **Post date:** [September 12, 2025, 1:48pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/12 "2025-09-12T13:48:01Z")
> [@Jeff\_Hager](#): > > You need to change the lookup column. > > You have it pointing to the table and essentially returning the same query back into the table through the lookup. The lookup is returning the exact same result as the Query because you are just returning the query column itself through the lookup. > > Change the Lookup column to point directly at the Query Column because you want to retrieve a value **from** the Query. You do not want to retrieve the Query itself. Ultimately you should be pulling back the Mantra column through the query. Thanks that resolved the issue ---
**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:** [September 19, 2025, 1:48pm UTC](https://community.glideapps.com/t/issue-with-rich-text-field-pulling-in-custom-value-from-my-data-tables/84119/13 "2025-09-19T13:48:18Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.