I have a requirement to look up a particular record (identified by data contained in a variable) from a dynamic list displayed in a browser window. It seems like a common scenario for which I can’t see a solution - so I’m looking for inspiration.
Specifically, on a regular basis I have to pay beneficiaries contained in a list in a spreadsheet using an online banking app. whose payments window displays a list of all available beneficiaries. I need to:
- select each beneficiary in turn, and the amount to pay, from the spreadsheet,
- go into the banking app’s payments window in the browser,
- select the beneficiary by name from the full list of beneficiaries to activate their custom link,
- in the beneficiary’s payment form presented, I have to enter the amount to be paid and then confirm the transaction.
The list of beneficiaries is not static, new ones are added regularly and old ones removed.
I can populate the beneficiary and amount from the spreadsheet and loop until the list is exhausted. But I can’t see a way of achieving the look-up easily, since the “Move Mouse” and “Click Mouse” actions require an image of the beneficiary name to perform the look-up and selection. Co-ordinates of each name in the beneficiary list will change each time the list is updated so can’t be used either. Is there a way of achieving the look-up, possibly by selecting a beneficiary link using the underlying mark-up rather than its rendition?