Use a variable in click within a web page

I have a path which runs through 1,000 rows of excel completing a search for each rows on a web browser. For each row I have a first word of the company which is in the initial click function successful, but fails on the second row as it is still looking for the first word of the prior row.

I’ve set a variable for the first word of the company from the excel document, but I cant see how to use this variable in the click step.

I’ve attached a screenshot for example.

Any help appreciated, thank you!

Hi @mellis ,

You must make your selector dynamic; refer to the following.

Regards,
Vinit Mhatre

Thanks for the reply, but I’m struggling to make the connection between your example video and mine.

I am not trying to write text, rather I am trying to click on text which has a hyperlink.

I’ve recorded a short video that might illustrate a little better, where you see it works for the first company (which I used to set up and therefor searching for the word “Carley” whereas it fails thereafter, still searching for “Carley” rather than “Doucet”

Can you show what you have inputted in CV text property of the target activity?
(first screenshot)

It looks like in Your CompanyName variable not clear, when you enter to second loop of the data table.

You can try the below which help you solve the issue

  • 1 Use the Dispatcher and Performer
  • 2 Use the database where you can push all row data and perform activities one by one
  • 3 You update the status in Excel and data table that this row works has been done

@mellis Hope this solves your issue.

Regard
mukesh
https://mukesha.com