I have an automation to input a data from excel to website. Is there anyway for the robot to input the data and delete the inputted data until it’s done?
For example, 20 data need to be inputted into a website
first 7 data inputted and then an error happens. So there is 13 data remaining to be inputted, the robot will start entering the rest 13 data.
if there’s an error, the step will be repeated until all data inputted. Is it possible?
Ok, this is do able by refreshing the site, but how did the robot read the data that are done inputted and not yet inputted to the website? The data is from excel file
Does that mean you need to add data from excel to same field in the website or to different fields in the website?
If you need to pass it to one field, then you can join with comma and then use TypeInto.
Else if you need to Type Into multiple fields and an error is happening between entering, then I hope you need to refresh the application and perform the same task again. This can be done with a Flag value and a Try catch.
Flag value to check whether the data inserting was successful for all fields.
@Rhys18
Yes. Or you could keep data for traceability and amend your workflow by adding an additional column to your excel. Let’s say a new ‘Status’ column.
This can’t be done because the number of data that are needed to be inputted to the website can be 5,10, 30, 45, 60… So I guess I will just use delete rows 1 by 1.