I was able to build the first task but was unable to test it as I get a 404 on the xlsx file links. I instead compared what I had built against the solution and was pretty much identical.
The second task was more successful as the CSV was available.
All in a great set of activities. Really validated what I have been learning so far.
I was able to set the workflow up correctly but after the first iteration of typing into each of the form fields I received an error that states that all fields need to be filled in before pressing the âSave Detailsâ. If I press âOKâ on the error the automation continues as normal but then I get the error again. I was using Chrome as my browser and am assuming this is a glitch of some sort.
Yes, I am getting the same error at the time of submit. if we force click on the OK, the program starts to process the next record, however i am afraid the previous record was never saved or submitted ( as in the case of all the records which populates this error).
Looked at the page source and it seems some validation is happening but not sure what exactly - as in the screenshot below
Solution provided too results in the same issue.
Any workaround or help on this is much appreciated.
I had the same issue with the current record not being fully submitted before the next record began to populate. I tried a few things. What eventually worked for me was to use a Tab and Enter Keyboard Shortcut from the last field instead of the Click to submit the record. I also added a 2 second Delay for good measure.
For the 2nd task, I added a 2 second delay as well at the start of the loop, but somehow still got caught off guard by one of the data not entering before the next one being entered. Perhaps thereâs a better way but I was thinking of adding a delay on each step, some milliseconds.
Same here. I have to added 5s delay to avoid the error of not all info being filled or canât find the Social number. I moved the report file from download folder to project folder to make it clean.
If you add a delay in it may prevent the error. I saw that my automation would start filling out the fields before the page updated from the last entry so the first couple fields were blank. Adding a 3 sec delay solved it for me.
I was able to complete both exercises with no errors. On the first part though I was able to add the list of emergencies in the word document in a table but without headings for each column. I ended Up writing the headings in the excel file one by one with a Write Cell action which did the job but is not as clean. Did anyone found any other workaround?
I don`t know what is the problem with the task of Handling patient Information. I am stuck with the part of when It copies to the excel the link to download from each patient.
The last task when it add the patients, sometimes it jumps the patient social number and the error occurs.
I am running into similar issues as the others. My work looks like the solution, but the solution does not work. I understand what the bots are supposed to be doing, but without a working solution, Iâm not sure what my error is.
Manage to complete the 2x tasks/exercises:
a) Forward Appointment Information: a nice use-case, like the combination of Extract Table Data, download of files, checking and extraction (Excel) of content, Word document as template and use of Outlook.
b) Fill the National Insurance Planning tool: a good use-case on a bot filling up a Web-App form, had issues with âmissesâ, particularly at the start with âSocial Numberâ and the error/s were spotted for âretryâ. Added 2secs delay seems to resolve the issue.
when I do the first project 'forward appointment information", if I use âextract table dataâ to get the download links into scratchpad, I always get the first header row in the file which made project stop as the column B is not the download address. I canât see how the solution file use this âextract table dataâ function to remove the header line? who can tell me how to do it?