Hi everyone. Need help to create a workflow using do while loop that check if the first column is equal to current date +1
if equal check if AM slots is not equal to zero then select that slot
if AM slots is zero proceed to check PM slots
check if PM slots is not equal to zero then select that slot
if PM slots is zero proceed the next column
loop this for 10 repetitions
if all shown dates have zero click on the forward arrow to view the next dates then continue checking until the 10 repetitions is done
Hello @Henson_Ibon,
How does your selector looks like?
If your selector have column name, row name then you can make your selector dynamic and use get text activity to get number of slots, if the date doesn’t exist in the screen you can use click on next arrow.
Thanks,
Karthik
Did you try table based extraction, that provides option to extract till last page. See if that works it will be more easier for this usecase.
can you please provide workflow for this solution?
Hello @Henson_Ibon,
On which application you are trying to automate this?
Thanks,
Karthik
@Henson_Ibon
Step1: Use table extraction to get all the content in table.
Step 2: instead of while use For each loop (use dataTable.Columns)
Step 3: in body of For Each loop, check/match first column first row value, if valid do check AM slot, if found break loop else check PM slot, if 0 continue else select slot and break loop
Note for step 3: you need to build dynamic selector using wildcards (* and ?), and variable (values from table/column) to make it dynamic.
You can change strategy as per your requirement.
Happy Automation
this is the selector look like
this is inside an CRM application
Hello @Henson_Ibon ,
You are showing up the selector for date but we need to make the selector dynamic for alots. please identify the selector for slots number (0 or any number) that will show us row name / column name.
Thanks,
Karthik
Since we won’t have access to this website we cant create and share the workflow.
