# To get the data you want with the Choice function **URL:** \ **Category:** Ask for Help\ **Created:** [August 27, 2021, 12:49am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007 "2021-08-27T00:49:01Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 27, 2021, 12:49am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/1 "2021-08-27T00:49:01Z")
There is a problem. If you select “in progess” or “Complted” in the Choice function in the video, I hope it will be listed below by the status in the inline component below. What should I do? [https://drive.google.com/file/d/10ue-waaRauyksGxm8SV4uBJb4OBgajbj/view?usp=sharing](https://drive.google.com/file/d/10ue-waaRauyksGxm8SV4uBJb4OBgajbj/view?usp=sharing) ---
**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 27, 2021, 1:22am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/2 "2021-08-27T01:22:11Z")
What does your filter look like for the inline list? ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 27, 2021, 2:31am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/3 "2021-08-27T02:31:32Z")
![20210827_113055](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9ac810ba3538c72b43ac0f5e5d8cdfac8c2499f2.png) It looks like this. ---
**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 27, 2021, 2:40am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/4 "2021-08-27T02:40:39Z")
I think you should have your filter set to compare the Status to the Screen Value choice status. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 27, 2021, 7:37am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/5 "2021-08-27T07:37:28Z")
I followed the answer, but it doesn’t work. I would be very grateful if you could attach an image or video. ---
**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:** [August 27, 2021, 8:10am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/6 "2021-08-27T08:10:05Z")
Can you show a screenshot of the columns in the data editor please? In particular, the `Status` and `Completed` columns. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 27, 2021, 8:33am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/7 "2021-08-27T08:33:14Z")
![20210827_173248](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b62a313878d4649157ca18cbf81f5c3d4575b2e.png) ![20210827_173227](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/131c51702167aace3374ca4bdf845988f3f9e1b8.png) ![20210827_173352](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e5ec639968a75d3eeec5917e7963eff249fa33ce.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:** [August 27, 2021, 8:47am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/8 "2021-08-27T08:47:13Z")
One of your filters is `Status is not Completed` Based on the screenshot you just posted, that condition will _always_ be true, because the data in that column contains extra characters. You probably want instead `Status doesn't include Completed` Your other filter was `Completed is not true`. You didn’t show what that column looks like, so I can’t comment on whether or not that is correct. But, as Jeff mentioned, if you are using a Choice component to filter, then you probably need to be filtering using [Screen Values](https://docs.glideapps.com/all/reference/values/screen-values). The alternative would be to target the choice component at a User Specific column and build a filter condition around that. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 27, 2021, 12:55pm UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/9 "2021-08-27T12:55:03Z")
![20210827_215212](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c262c03fb0e2151d95314b88356e2c069e63bc69.png) ![20210827_215157](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/924d231baa305ea0589f08b3b15bef0ec3b399ca.png) Thank you. It seems to have been solved with Screen Value. However, like the image, if you do not select in the Choice function, the whole thing should come down, but it doesn’t appear. How do I get them all out? ---
**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 27, 2021, 4:53pm UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/10 "2021-08-27T16:53:52Z")
Create an empty column in your data that will never be filled. Then add an OR to your filter that will also check if that empty column is equal to the screen value of the choice. If the empty column and the choice are both blank, then if should show all rows. Another thought that I normally use is to create two separate inline lists. One list will have a filter and the other will not have a filter. Set visibility to show each list depending on if a choice is selected or not. So if you do not have a choice selected, it would show the list with no filters. If you have a choice selected, it would show the list with the filter. But actually, I might have to try using that first method myself, since it prevents the need for multiple inline lists. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 28, 2021, 6:45am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/11 "2021-08-28T06:45:58Z")
I don’t know if I did it correctly as you answered, but I’m not sure it’s because I don’t understand. Could you please attach an image? ---
**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:** [August 28, 2021, 8:31am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/12 "2021-08-28T08:31:03Z")
Jeff gave you two options, which one did you use? Is it working? If not, show how you set it up and we can guide you further. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 28, 2021, 11:12am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/13 "2021-08-28T11:12:18Z")
it’s recorded [https://drive.google.com/file/d/1pZIbDu4Z19KxIxMDmQKaUaoUQh-bmtk7/view?usp=sharing](https://drive.google.com/file/d/1pZIbDu4Z19KxIxMDmQKaUaoUQh-bmtk7/view?usp=sharing) ---
**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:** [August 28, 2021, 11:31am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/14 "2021-08-28T11:31:42Z")
Okay, I’ve watched that a couple of times. A couple of observations: - Your choice component is targeted at the Status column in your Projects table. This means that you are most likely overwriting existing values in that table (probably in the first row) every time you make a choice. You should target that at a User Specific column, so that a) it doesn’t disturb existing data, and b) multiple users can use it at the same time without tripping over each other. - I see that you have two online lists on the screen. You only show the configuration of one of them, and it definitely doesn’t look right. But it’s difficult to say what the correct configuration should be as it’s a bit hard to follow. Maybe @Jeff_Hager will see something that I’ve missed. Failing that, is there any possibility that you can make a copyable version of your app available? If I can see it in front of me, I’m confident that I could sort it out fairly quickly. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 28, 2021, 1:53pm UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/15 "2021-08-28T13:53:11Z")
How about a copyable version? Should I invite you? Or do you send me the link address? ---
**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:** [August 28, 2021, 2:25pm UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/16 "2021-08-28T14:25:06Z")
Go to Settings → Sharing, and tick the box below. ![Screen Shot 2021-08-28 at 10.22.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2db22752b81bd6944bca1883a3f28c4be6ce9e27.png) Before you do that, please check to make sure there is no private or sensitive data in your app. If there is, please send it to me privately - this is a public forum, so once you post a copyable link here, _anyone_ can copy your app. ---
**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:** [August 28, 2021, 2:50pm UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/17 "2021-08-28T14:50:30Z")
Okay, here is what you need to do. On that screen, you have two inline lists. The first Inline List: - Remove all the filter conditions that you have now, and replace with a single filter: - “where Status is screen → Status” ![Screen Shot 2021-08-28 at 10.43.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39bcae60895b299ad0c6eb2f9117e5bf97695e58.png) The second Inline List: - Remove all filters - Add a visibility condition: - “where status is empty” ![Screen Shot 2021-08-28 at 10.44.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a492614d280f868607dafc6f4ce2a75656a397bf.png) The effect of this will be: - If you select any status option from the choice component, the first list will be filtered by that status, and the second list will be hidden - If you don’t select anything from the choice component, the first list will be hidden and the second list will be visible, with all projects shown. I believe this is what you were after? I’ll send you a private message with a link to a copyable version with the above changes made. ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [August 29, 2021, 10:11am UTC](https://community.glideapps.com/t/to-get-the-data-you-want-with-the-choice-function/31007/18 "2021-08-29T10:11:26Z")
Finally solved it. Perfect. thank you.