Need help filtering value from Glide table

[Dilip]

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

The Get all rows output from Glide table is as follows

$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

[samliew]

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 will save you lots of time and frustration using Make.

[Dilip]

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

[Msquare_Automation]

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

[Dilip]

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

[Msquare_Automation]

Hi @Dilip

Try hardcoding like this: {{3.rows}}

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

[Dilip]

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

[Msquare_Automation]

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

[Dilip]

Hi @Msquare_Automation

Is the number represented by the circled portion in ss below ?

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

[Msquare_Automation]

Hi @Dilip
Exactly

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

[Dilip]

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

But it is giving me only one tick mark symbol rest are all red with crossed circle

Is this expected behaviour?

Thank you for your patience.

Regards,
Dilip

Regards,
Dilip

[Msquare_Automation]

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

[Dilip]

Thank you for your help @Msquare_Automation

This module is working now. Although I have to close and re-open.

Regards,
Dilip