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.
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.
The value I’m trying to pull in is a value that is coming from a query.
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.
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.
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.
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?
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.
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.
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.
Sorry I realised i shared the wrong screen shot - here is shots of boht the query and look up fields.
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.
