Need your help. I am stuck with an activity - I want to read a table from a website, check the cell of a particular column and based on that reading, I want to tick a check box in that row and reiterate this for the whole. This table is dynamic, i.e. number of rows change every time. I am experimenting with find children/descendants but haven’t been able to find a solution.
thank you, I used UiExplorer to identify the columns. Also used help from this link for using Assign and Get Attribute but the checkbox condition in the while loop is not working - the difference between this sample and my work that I have to select multiple rows: Enabling a checkbox based on text - #7 by Andrew_Callaghan
Put an message box after get attribute and check if the value is coming correctly.
In the if condition it should be strText = status1
And also have you changed the column number in the selector before check activity.because the column 8 is where status is present but for check box you have to change the column number accordingly.
I have tried putting an = sign for if condition, but its not working. that being said, since I am breaking if the condition is met, shouldn’t it be “not equal to” for it to continue? note that I have to check all the checkboxes that meet the requirement.
I have changed the column number (to 1 in my case) but I haven’t used the UIexplorer again (just copied the same address and changed the column number to 1) hope thats not the reason for error. Also, I have used the same variable “strSelector” for checkbox (after while loop) and text column (before while loop), would it be advisable to use a different variable?
@Hammad do you have to check all the check box with the status not equal to “ammed by origin”
And yes check activity works only if you have correct selectors.so yes column number might be a problem,could you please indicate the check box using Uiexplorer and show the selectors.
The error that I mentioned is resolved. There are 21 rows in total (all with same status “ammended by origin”), the count (using message box) only goes to 17 by skipping 4 rows in the middle (not the 4th, but 4 rows). For the first 2 rows, while it counts them but only starts checking from row 3.
Below is the error, this is probably because it does not have more rows to go to, i will manage this using break in else. do you think that will solve it?
@Hammad let’s try to solve this one by one so it may not be difficult,
So you say there are 21 rows in total with the status “ammeded by origin” but it is showing error in 18 th row itself ,is the other rows in the same page or in the next page and also could you Indicate the 18th row manually and see what selectors are coming
It’s skips forst 2 rows - put an message box in else of the if activity and check if it’s coming as “ammended by origin”
In condition put strText.trim.toupper = status1.trim toupper
And also of possible share some more screenshots of the application you are using and some more of workflow with the starting and ending part as well as it is difficult to understand the problem from the provided screenshots.