# Choice Component Issue - Replaced Values **URL:** \ **Category:** Ask for Help\ **Created:** [November 13, 2021, 2:52pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461 "2021-11-13T14:52:30Z")\ **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:** [November 13, 2021, 2:52pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/1 "2021-11-13T14:52:30Z")
Hi! I have a choice component that is selecting months, but when I select a month, it disappears from the table. Then it’s no longer there to choose from? Then the selected month (or no month) now populates the table. I’ve attached a picture of how the choice component is setup. I’m obviously missing something here, but I’m not sure what it is? Thanks! ![Screen Shot 2021-11-13 at 9.51.44 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1871bbf13b1aab59fec0ce9bfa6acc6cc12abd35.jpeg) ---
**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:** [November 13, 2021, 2:53pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/2 "2021-11-13T14:53:00Z")
I’d like to use this choice component as a selector to display data from a current month. ---
**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:** [November 13, 2021, 2:56pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/3 "2021-11-13T14:56:19Z")
You are writing the selected choice to the same column that is the source of the choice list. They should not be the same column because it’s going to overwrite itself every time you make a choice. ---
**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:** [November 13, 2021, 3:02pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/4 "2021-11-13T15:02:11Z")
> [@Trading\_5\_Talents](#): > > I’d like to use this choice component as a selector to display data from a current month. The usual way to do this is to target the Choice at a User Specific Column, and then use the value in that column to drive the filtering. The next step depends on how you have things set up. In some cases you might use it directly as a screen value to filter. In other cases you might use it to construct a dynamic relation. It depends. ---
**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:** [November 13, 2021, 3:32pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/5 "2021-11-13T15:32:59Z")
Thank you! ---
**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:** [November 13, 2021, 3:36pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/6 "2021-11-13T15:36:25Z")
Ok, so if I make a new, user-specific column, would this be in its own table to contain choices? If so, then do I just need to add rows for upcoming months? Also, what do you mean by, > and then use the value in that column to drive the filtering. ---
**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:** [November 13, 2021, 3:43pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/7 "2021-11-13T15:43:37Z")
> [@Trading\_5\_Talents](#): > > Ok, so if I make a new, user-specific column, would this be in its own table to contain choices? If so, then do I just need to add rows for upcoming months? No, it needs to be in the same table that the current screen is connected to. > [@Trading\_5\_Talents](#): > > Also, what do you mean by, > > > and then use the value in that column to drive the filtering. I mean that you can then use that value in a filter. Have a look at [using screen values to filter inline lists](https://docs.glideapps.com/all/reference/values/screen-values#filtering-inline-lists). This might be all you need in this case. ---
**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:** [November 13, 2021, 4:06pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/8 "2021-11-13T16:06:31Z")
Ok, I got the user-specific column setup for the selector. However I’m not sure the screen filter would work. Here’s what I’m trying to use the selector for. ![Screen Shot 2021-11-13 at 11.04.36 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d711aa8a80e617cd0c870cc2c6d06e8eea3afe9a.jpeg) But when I select another month, the data doesn’t change. @Robert_Petitto made a video on he does it, but I guess I’m not understanding how the relation is setup in the table. Let me know if you need screenshots of the tables. Thanks again! ---
**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:** [November 13, 2021, 4:23pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/9 "2021-11-13T16:23:15Z")
Okay - I’m just going to make an educated guess here based on your earlier questions 😉 I’m guessing that the User Specific column is in your Users table, and the Choice component is writing to that? And you’re using those rollup columns that you showed earlier as the source for the Progress Bar? If I’m right so far, then what you need to do is build a dynamic relation using the User Specific column. So you’ll need to make sure that the value that gets written to the User Specific column (year month) will match a column in your Trades table. Then you need to modify that earlier relation that you had to use the User Specific Column as the source in your Users table - or create a new relation. If you create a new relation, then you’ll need a second set of rollup columns based on that relation. If my assumptions are correct, that should get the job done for you. ---
**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:** [November 13, 2021, 4:55pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/10 "2021-11-13T16:55:29Z")
Ok, I think I got this part down…I think 😅 The user-specific column was actually in my Goals table, but I made a new relation with the Trades table and now I can control the progress bar (and the details table on the bottom) with the selector - Thanks! But, the other thing that doesn’t update properly is this hint component in the middle (see images). I’m using template text, but since there are no trades for Oct or Nov, it still displays the data from Sept even though the table displays the correct text. Should I be using a different component? ![Screen Shot 2021-11-13 at 11.53.39 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/955e3849a4daf4fb03f5283bf0478e40d2a33fe8.jpeg) ![Screen Shot 2021-11-13 at 11.54.07 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b218e0de12dc32a08fa146c21b853c3edd418bd.jpeg) ---
**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:** [November 13, 2021, 5:05pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/11 "2021-11-13T17:05:18Z")
Is the template for your hint component also reading the values that come through the dynamic relation? One thing to be aware of (and keep in mind) is that with the dashboard screen you have there is that you’re operating on a single row of data (the first row, unless you have a filter somewhere), and all data shown on the screen will be read from that row. So when you switch months using your choice component, that doesn’t change the row you’re looking at. Rather, it changes the data in that first row based on the value that’s written to the User Specific column and the associated relations and rollups. ---
**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:** [November 13, 2021, 5:17pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/12 "2021-11-13T17:17:09Z")
Hmm…I don’t see where I can choose a relation for the hint component. ![Screen Shot 2021-11-13 at 12.13.56 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d596de6ea8ecb6e9847c85a250179dfd74f1b3f.jpeg) So when I use the choice component, the progress bar and table below all update properly. I imagine it’s because I’m going through the relation. ![Screen Shot 2021-11-13 at 12.15.26 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c367826e3a190b45fc246b68bd2993dd394f9cb1.jpeg) But I don’t see this option for the data that displays in the hint component. ![Screen Shot 2021-11-13 at 12.15.49 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/453389235274369dd6450bb68d7cbd8311009b1a.jpeg) ---
**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:** [November 13, 2021, 5:20pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/13 "2021-11-13T17:20:13Z")
> [@Trading\_5\_Talents](#): > > Hmm…I don’t see where I can choose a relation for the hint component. No, that’s not what I meant. You’re using a template column as the source for your hint component, yes? You need to ensure that the replacement values in that template are coming from the rollups that are attached to the dynamic 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:** [November 13, 2021, 5:28pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/14 "2021-11-13T17:28:34Z")
I think I know what you mean, but I don’t see that when I click on the replacement text. ![Screen Shot 2021-11-13 at 12.26.48 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/76deaa18a8ccc2563c753882958eae9ba681f22a.jpeg) I would’ve thought the relation would be here? Now that I write this, the value I’m trying to get is in this same table though. Would I need to make a relation within the same table then? ---
**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:** [November 13, 2021, 5:39pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/15 "2021-11-13T17:39:34Z")
So is it possible to use this selector to read from different rows if the dates match? ---
**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:** [November 13, 2021, 5:42pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/16 "2021-11-13T17:42:34Z")
> [@Trading\_5\_Talents](#): > > I would’ve thought the relation would be here? Now that I write this, the value I’m trying to get is in this same table though. Would I need to make a relation within the same table then? You can’t read a value directly from a relation. I was working on the assumption that you already had the value you needed via one of your rollup columns. I have to admit that I’m getting a little lost with all your tables and relations and rollups and how they fit together. Any chance you can make a [loom.com](http://loom.com) video and show what you have? ---
**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:** [November 13, 2021, 5:46pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/17 "2021-11-13T17:46:07Z")
I’m sorry, I think I’m getting lost too 🥴 I’ll make a video showing what I have and what I envision and post it shortly. I really appreciate all your time and help with this! ---
**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:** [November 13, 2021, 5:59pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/18 "2021-11-13T17:59:17Z")
I hope this is clear. If not, I can make another video. [Loom | Free Screen & Video Recording Software](https://www.loom.com/share/eddb2b012c0b4d05af9f1c8d49d3cf8c) ---
**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:** [November 13, 2021, 6:27pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/19 "2021-11-13T18:27:14Z")
Okay. A suggestion that I would make is to create another table, and use that table to drive your dashboard. I think the fact that you’re trying to build the dashboard on top of your Goals table is leading to some of the confusion. It can work the way you have it, but it’ll just be cleaner if you separate it. So… create another table, let’s call it Dashboard 😉 That table will just need a single row - you’ll need to enter a dummy value in one column to make it useable (Glide needs at least one row with data in it). From that table, you can build out the similar relations and rollups that you currently have in your Goals table. The user specific column that you’re using for your selector value should also be in this table. The idea is that as you change the selector, all the data that you need for the selected month will be dynamically pulled into that single row. And you can use that data in your various dashboard components. It’s quite late here, so that’s as much as I can offer for now. But give that a go and post any follow up questions that you have. If somebody else doesn’t jump in, I’ll take a look in my morning. Good luck 🙂 ---
**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:** [November 13, 2021, 6:34pm UTC](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461/20 "2021-11-13T18:34:20Z")
Awesome, thank you so much for your help and expertise! I’ll try what you suggest. Have a great night! [Next page](https://community.glideapps.com/t/choice-component-issue-replaced-values/34461.md?page=2)