Scroll down and click every row when certain condition met

Help Studio
, , , ,
1

Hi all,

I’m currently creating a studio workflow that tries to do below things:
Click the check box of every row where column B start with BBB, and since there are so many records, the tool need to scroll down while clicking the check box. Do you have any idea what activity should be used to do this? Thank you so much

image

2

And the activity should be on a website, here I use a excel screenshot just as an example, thanks.

3

@Paddi

Try using Hover activity before the click

Or use click with simulate

If these does not work then use mouse scroll with click in try catch and loop till found on the site

cheers

4

@Anil_G Thanks for your answer, and I also want to know how can I keep clicking all the check boxes start with “BBB”, do I need to use a loop or other activity with same function is available. Thanks.

5

@Paddi

You can use for each ui element activity it has filter options where you can include BBB as filter for innertext

And inside look we can use click…

Another way is to find a selector for check box and increment the idx value to move to each row containing BBB in the value

Cheers

6

Hi @Anil_G,

I tried a “For Each UI Element” activity, and indicate the whole area shown below as the CurrentElement, indicate checkbox column as CurrentLable_1, indicate Column B as CurrentLabel_2.

I use the Configure filter to ensure that only rows with “BBB…” in column B would be clicked, and When I put the “click” activity in the Do sequence, it failed to indicate the target on the screen. I’m wondering what changes should I make to solve this problem, thank you.
image

7

@Paddi

What are you passing in the click activity?

Ideally you should be indicating the row in for each which is correct

And in filter you would filter for BBB in the innertext even this is correct

Next you can do a get/find children on the current element and then get the first child …mostly the first child would be the uielement of the checkbox

So pass that as input element to click outputVar(0)

Hope this helps

Cheers

8

Hi @Anil_G ,

I tried to indicate the first row, but it seems that only single field can be indicated. Do we have any other way to indicate a row?

9

@Paddi

Indicating row is correct…you need to do get children to get the checkbox selector and then use it in the click aactivity

Cheers

10

Hi @Anil_G ,

My issue would be, the first row cannnot be indicated. Do you know how to deal with this?

11

@Paddi

Is it not able to indicate only first?

Did you check the selector tree to check if you are able to find the row selector in it?

Cheers

12

Hi @Anil_G

It failed to indicate any row independently, how can I check the selector tree? Is it an activity?

13

@Paddi

Open ui explorer and on left top you would see it

image
image930×597 43.3 KB

cheers

14

Hi @Anil_G ,
Thank you, now I can indicate a row, but when I tried to indicate a label it shows error: cannot determine a pattern, please indicate another sample dement.

I need to indicate this label as a filter.

Do you know how to deal with this? Thank you.

15

@Paddi

As the error states it is not able to identify a pattern may be the label is not prt of the table

May I know why you want to indicate some labe which is not part of table ?

More details would help here

Is that label inside one of the cells of table?

If yes then use get children and filter on the label tag

Cheers

16

Hi @Anil_G ,

The label is one cell inside the table, so what I need to do is:

  1. Use the For each UI Element (Indicate the rows for the table) as Current Element
  2. With its Do sequence: Use the Find Children (get the cell value as a label for filter)

And where should I use the filter? Is it after the “Find children”?

17

@Paddi

Yes After find children

you can use loop through the output of it and then use a if condition to check for the required children based on tag or any other value you need…and in the then side your matched element would be coming

Hope this helps

cheers