DEV Community

Thom
Thom

Posted on

Input forms challenge from rpachallenge.com with ServiceNow RPA

Out of fun I tried myself at the rpachallenge.com 'Input From' challenge (first one).

The challenge is to fill out a web form with data from an excel. The twist is, that every time you submit the form, the position of the field on the form change.

To bypass that problem we just need to identify the input tag with another attribute ng-reflect-name.

Image description

The hole bot process is pretty simple, open the excel and then make a loop from row two to eleven and get all the row value with the 'GetRowValues' action. To fill out the fields we have a method on the chrome connector called 'SetFields' where we can set all the input fields from the excel. Last step is to use the click method on the submit button, thats it.

Image description

Top comments (2)

Collapse
 
jayantrajwani profile image
Jayant rajwani

Awesome!! Just one thing the end component should be connected to the control out port of the loop rather than after submit click.

Collapse
 
23thom profile image
Thom

Thanks for the hint! Going to change that :)