DEV Community

Thom
Thom

Posted on

3 2

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

Heroku

Simplify your DevOps and maximize your time.

Since 2007, Heroku has been the go-to platform for developers as it monitors uptime, performance, and infrastructure concerns, allowing you to focus on writing code.

Learn More

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 :)

Heroku

This site is built on Heroku

Join the ranks of developers at Salesforce, Airbase, DEV, and more who deploy their mission critical applications on Heroku. Sign up today and launch your first app!

Get Started

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay