My workflow includes reading two columns which is field1 and field2.
I have to search the field1 in a web application and update the value of field1 with field2
I searched for field1 using ctrl+f but when I do that the similar words which are almost equal to field1 are also selected.
I tried using anchor base but in for each loop it doesn’t work as intended.
Can anyone suggest how to select the exact field1 and update it…
I might not be able to share the application.
Just an example:
String1 will have some value in the text box.
So string1 and it value is pulled from Excel and then I need to search for String1 and append its value in the text box with the new value.
If the list in the excel is changing what you can do is you can create a switch case. So if the value from excel is string3, then it has first read the value from string3 filed and then use a assign activity to append with the value from excel. Then use typeinto activity to write.
first thing what you need to do is , inspect on any 2 fields and check whether some attributes are there which shows the label name. like aaname=String1 or aaname=String2.
Yes the excel list will change. There are only two columns in Excel with the string and its value but rows are indefinite.
So it should search for each string(from Excel) in the web application and update its value (from the excel).
it should search means it should identify the field. So you need to idenfy the attribute which can be used in the selector.
As you confirmed the list is not static , you will have to dynamically identify the fields to TypeInto.
So use uiexplorer and inspect on the field and share the ss here.
I used for each row in datatable and Find Element activity and tried to click on the element and do a tab to go to the text box to update the value .
But it doesn’t work .
For the selector part I did aaname=* which is unique in this
I might not be able to send the selector. The aaname is the only field which is unique I updated it as * .
But it goes to a different text box and updates the value. It doesn’t select the exact match instead selects any word which is similar.
The aaname=Horizontal is the value what I see in my selector .
If string1 I need to update its value but in the same web I have string1_la string1_la2 . I should be able to select string1 only irrespective of its occurrence .Is there any method which can do that ?
I tried the below steps:
1.Read the excel which has the text and its value.
2. For each row in datatable , search the Text in Web and double click on it .
3. Tab to the corresponding textbox and update it.
But the issue is if there are similar texts like string1,string1_1,string1_2 so it randomly clicks on any of them wherein it has to select only string1 and update its value which is expected.
So if i set the occurrence property=1 it takes up any similar string which comes first and clicks on it.