# Need help filtering value from Glide table **URL:** \ **Category:** Questions\ **Tags:** filters\ **Created:** [September 16, 2024, 12:02pm UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122 "2024-09-16T12:02:55Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 16, 2024, 12:02pm UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/1 "2024-09-16T12:02:55Z")
Hi Guys, I have a scenario where I schedule getting Glide tables every day at 6PM IST I get all rows in the table. But I want to filter where Status column is “Not Started” or “In Progress” or “Delayed” the column keyword is “lgfkM” I have put the condition as shown below ![Screenshot 2024-09-16 at 5.30.04 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/d/cd77e10530a19c2742be247786cc2d31720fe490.jpeg) ![Screenshot 2024-09-16 at 5.30.27 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/2/327c327670d7a0bf766d8a90f6e8384f7d81febb.jpeg) The Get all rows output from Glide table is as follows ```auto $rowID Jj2efBnXTES-ZCl2ZAkoiw $rowIndex XA2 Name Get the deck designed - submit to design team 1efVG Vinanth rJdNM Ranjani - Proactive For Her O5yhk September 23, 2024 12:00 AM lgfkM Not Started DGh5o PFHPilot zS8z7 Sanya Menon 4Gjdk RAF By Aflog V6xmb August 13, 2024 11:54 PM eNlzt Sanya Menon gpMaY fd6mc08iuan7meref015mpb8k0 FBHdW Low Priority ``` What am I doing wrong and why am I not getting the filtered out out? thank you in advance for helping Regards, Dilip ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [September 16, 2024, 12:15pm UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/2 "2024-09-16T12:15:50Z")
You have to click on the variable to insert it, not manually type it out. Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 17, 2024, 3:20am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/3 "2024-09-17T03:20:54Z")
Hi @samliew , thank you for replying. I tried selecting it. It’s not getting selected. I tried manually typing it out **its done in screenshot which says set up filter** Please find the screen recording below But when I run it though there are values with Not Started and In Progress I get nothing in response it gives red circle with crossed mark Please help me. Regards, Dilip ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [September 17, 2024, 4:15am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/4 "2024-09-17T04:15:27Z")
Hi @Dilip If you’re hardcoding, enclose the variable name along with the module number in double curly braces, like this: {{3.rows[].Name}}. This mapping will only evaluate the first item in the array. To apply the filter to all rows retrieved from a “Get a Row” action, you need to iterate through the array before applying the filter. **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 17, 2024, 4:21am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/5 "2024-09-17T04:21:32Z")
Hi @Msquare_Automation , Thank you for replying. Yes I will need to iterate through every item gotten from “Get Rows” action. I have not put an Iterator module just after Get Row I still am not able to select the Row as an input into this iterator Not able to figure out why my selection is not able to select elements Please find the attached screen recording Kindly let me know if I am doing something wrong. Regards, Dilip ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [September 17, 2024, 4:22am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/6 "2024-09-17T04:22:43Z")
Hi @Dilip Try hardcoding like this: {{3.rows}} **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 17, 2024, 4:25am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/7 "2024-09-17T04:25:40Z")
Thank you for your reply @Msquare_Automation , Just so I understand, {{3.rows}} **Does it mean rows which has index value 3 in the items list?** Is my assumption correct? Also why isn’t selection available. I have other modules where this selection is working. Regards, Dilip ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [September 17, 2024, 4:26am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/8 "2024-09-17T04:26:39Z")
Hi @Dilip The number 3 refers to the module number. Run the “Get a Row” module alone once, then try mapping the values afterward. **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 17, 2024, 4:28am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/9 "2024-09-17T04:28:46Z")
Hi @Msquare_Automation Is the number represented by the circled portion in ss below ? ![Screenshot 2024-09-17 at 9.57.25 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d07f81f184fd51e968e24a4edf7e9d224e80866.png) **Also I tried applying filter to array iterator** Even now it is not letting me select the values. Is there something wrong I am doing? Regards, Dilip ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [September 17, 2024, 4:29am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/10 "2024-09-17T04:29:13Z")
Hi @Dilip Exactly **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 17, 2024, 4:30am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/11 "2024-09-17T04:30:16Z")
Thank you for your reply. @Msquare_Automation I tried applying filter after that. Still not able to select values, Is there something wrong I am doing? I followed your previous answer and applied {{8.name}} to it and it gave me the element PF SS ![Screenshot 2024-09-17 at 10.02.10 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/3/0320a5ea97d69075407b287b273a6010d5ba1228.jpeg) But it is giving me only one tick mark symbol rest are all red with crossed circle **Is this expected behaviour?** ![Screenshot 2024-09-17 at 10.03.03 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/5/d568cb87d942ed551fdb44707f3c1c960b8cea33.jpeg) Thank you for your patience. Regards, Dilip Regards, Dilip ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [September 17, 2024, 4:35am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/12 "2024-09-17T04:35:57Z")
Hi @Dilip This could be a bug. Try saving your work, then reopen the scenario and test it again. **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Dilip](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@Dilip](https://community.make.com/u/Dilip)\ **Post date:** [September 17, 2024, 4:44am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/13 "2024-09-17T04:44:45Z")
Thank you for your help @Msquare_Automation This module is working now. Although I have to close and re-open. Regards, Dilip ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [October 1, 2024, 4:52am UTC](https://community.make.com/t/need-help-filtering-value-from-glide-table/55122/14 "2024-10-01T04:52:22Z")