# Help needed to form a "word of the day" app **URL:** \ **Category:** Ask for Help\ **Created:** [February 15, 2021, 5:22pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830 "2021-02-15T17:22:48Z")\ **Posts on this page:** 17\ **Page:** 2
**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:** [February 23, 2021, 9:58am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/21 "2021-02-23T09:58:17Z")
@Ap_Seh - it seems that you have been struggling with this one, so I’ve put together a simple concept app (which is copyable) to help give you a bit of a kick start 🙂 > **[Word of the Day](https://gullible-advertisement-4290.glideapp.io/)** How it works: - In the Users table, there are two key columns… - There are also several computed columns in the Users table. Here is a quick description of each: - The words are displayed using an inline list, filtered by the Next Word ID - You’ll also see that most components have visibility conditions, using the state of the ite-show-word column - The “Got It” button does two things: - Once the user clicks on the “Got It” button, both the word and the button will be hidden, and replaced with a hint component that shows how long until the next word is shown - The “reset” button is there so that you can simulate the next word in the list being shown Let me know if you have any questions. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [February 23, 2021, 10:30am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/22 "2021-02-23T10:30:16Z")
You can never make a lookup column point to a relation, though You can make a relation point to a lookup column. A lookup is the product of a relation, not the other way round. Hence you make a lookup column “relate back to” a relation and a relation “point to” a column. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [February 23, 2021, 10:41am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/23 "2021-02-23T10:41:48Z")
Sorry @Darren_Murphy because of Jeff’s poor choice of words, you had to build an app from scratch 😂😂😂 ---
**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:** [February 23, 2021, 10:49am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/24 "2021-02-23T10:49:11Z")
Jeff _always_ chooses his words very carefully 😀 And his choice of words had nothing to do with my decision to build the app. I just did it for the practice 😂 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [February 23, 2021, 10:51am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/25 "2021-02-23T10:51:24Z")
You didn’t get the joke 😂 ---
**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:** [February 23, 2021, 10:56am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/26 "2021-02-23T10:56:06Z")
I did, but I chose not to acknowledge it 😛 🤣 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [February 23, 2021, 12:39pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/27 "2021-02-23T12:39:47Z")
No still don’t get the joke so stop pretending 🤣🤣 ---
**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:** [February 23, 2021, 1:54pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/28 "2021-02-23T13:54:30Z")
> [@Wiz.Wazeer](#): > > You can never make a lookup column point to a relation, I’m not sure I understand what you are saying. A relation is not a lookup of a single column. Yes it uses a single column in one sheet to link to a single column in another sheet, but it’s still a link to an entire row. The only way to pull out a single column value from a relation is to use a lookup column that references that relation. That’s the point I was trying to make to @Ap_Seh is that they have a relation column but I believe they were calling it a lookup when it isn’t a lookup and doesn’t function like a lookup. You can’t set a value in a component from a relation, because a relation is not a single value…it’s a row or multiple rows. If they add a Lookup column and point it to the relation column, then they can pull the word of the day out of that relation and set the component value to that lookup value. Looking at the screenshots I did not see a lookup column, so I can only assume that there isn’t one. Yes, the my wording is a little vague, but I like to make people think a little bit and ask follow up questions if they still don’t understand something. Just telling someone to add a Lookup column may not heIp them fully understand why they need to do it. If they have to think about what I’m saying or asking, then it’s helps them to better understand how everything works together in the future. “…teach a man to fish…” This is actually a good illustration: > [@Relation "How to" (if it's possible)](https://community.glideapps.com/t/relation-how-to-if-its-possible/23284): > > Hello, I’d like to get a value from a sheet which is not in the main one. As you can see on the picture, i’d like to get a value, and not an inline list (with the Relation Component). Thanks. ---
**Author:** ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)\ **Post date:** [February 23, 2021, 4:41pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/29 "2021-02-23T16:41:34Z")
@Darren_Alderman, Thanks ! I have been trying to figure out your logic in the app. Lots to learn from it. I’ll take my time and revert if I am unable to understand something. Thanks again. ---
**Author:** ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)\ **Post date:** [February 23, 2021, 4:47pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/30 "2021-02-23T16:47:23Z")
@Wiz Thanks. All I really wanted to know was that why isn’t the relation / lookup column displayed as a field / option in the data (of say inline list )where I can choose it, like other columns, to display its value. I think since it does not provide the relation column in the data of the components, it would mean that displaying those values is not allowed. I am just not sure and so wanted to know it. I still really don’t know. Thanks. ---
**Author:** ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)\ **Post date:** [February 23, 2021, 4:54pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/31 "2021-02-23T16:54:39Z")
> [@Jeff\_Hager](#): > > You can’t set a value in a component from a relation, because a relation is not a single value…it’s a row or multiple rows. This I think is what I was really asking. I was thinking that since I am using the count value to lookup the word by relating the count value in Users to sno value in words, that it is a lookup but seems it’s a relation and so cannot be used to display it’s value. So may I ask how I can instead use a lookup that I was trying to create and instead ended up creating a relation field? Thanks. P.S. I know Darren has been great in doing a whole app for me but I still would like, if possible, an answer to the above. The I would be able to create and use my lookup field and not a relation field, to display the value and complete my app immediately. Thanks loads ! ---
**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:** [February 23, 2021, 4:57pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/32 "2021-02-23T16:57:02Z")
[https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column) Relations and Lookups work in combination. You are already half way there and already have the relation, so you just need to add a lookup column. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [February 23, 2021, 11:13pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/33 "2021-02-23T23:13:17Z")
🐟🐠🎏 ---
**Author:** ![Ap\_Seh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ap_seh/32/20809_2.png) [@Ap\_Seh](https://community.glideapps.com/u/Ap_Seh)\ **Post date:** [February 24, 2021, 2:08am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/34 "2021-02-24T02:08:43Z")
Hi Darren, I have understood this to quite an extent. Could you please explain what does this hint template achieve. > ``` > > ``` [data-test=‘app-hint’]{ white-space: break-spaces; } Another thing I cannot figure out is how / where you managed to set the text height of the word in the tile to be as big as it shows up. The inline list allows for me to set the text size to only 3 sizes, small , medium and large. but I am using the free version of glide. The largest value, in my case, sets the height to about half your size. Thank. ---
**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:** [February 24, 2021, 3:12am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/35 "2021-02-24T03:12:17Z")
> [@Ap\_Seh](#): > > I have understood this to quite an extent. Could you please explain what does this hint template achieve. > > [data-test=‘app-hint’]{ > white-space: break-spaces; > } This is just a CSS trick to make the text in the Hint component a bit more presentable. It causes the line-breaks to be respected. If you remove it, you’ll see the change in the Hint component. > [@Ap\_Seh](#): > > Another thing I cannot figure out is how / where you managed to set the text height of the word in the tile to be as big as it shows up. The inline list allows for me to set the text size to only 3 sizes, small , medium and large. The title text is shown inside the tile because the “Show Title when Image is not available” option is selected. As far as I’m aware, you can’t change the style of that (except maybe with CSS). ![Screen Shot 2021-02-24 at 11.09.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fe50404f1240ee63181843265c94fb91966bac14.png) Changing the text size only affects the Title/Details text that is shown below the tile. ---
**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:** [February 24, 2021, 3:18am UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/36 "2021-02-24T03:18:38Z")
``` [data-test=‘app-hint’]{ white-space: break-spaces; } ``` This allows your hint text to be separated into paragraphs. If you don’t use this, the native hint text will group them all into one paragraph. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830/37 "2024-01-17T16:53:18Z")
Closed on January 17, 2024, 4:53pm UTC [Previous page](https://community.glideapps.com/t/help-needed-to-form-a-word-of-the-day-app/22830.md?page=1)