Here is an interesting idea to consider for triggering processes. As some customers are doing away with network drives because of Work From Home policies, the idea was to trigger a process directly from a button in Excel.
When the button is clicked, the active Excel workbook is saved and closed. The file is then converted into a base64 string and a task is created via the API in the Excel Addin. The Button name is hardcoded but parameters for the Custom wizard ID, Server API URL, credentials, etc can be configured in a config file as shown below.
Multiple custom wizard IDs can be defined in the config file and tied to the respective buttons in the Excel Addin.
Once the robot picks up the process, a .Net Plugin is used to convert the base64 String back into the file. The robot now has a local copy of the Excel file, with which it can start processing.
Here is a brief description of the process shown in the attached demo video.
The business user is working in Singapore but needs to set up a meeting with colleagues across different time zones. The business user sets up an excel file with a list of timings from his/her time zone. The business user enters the desired time zones into the adjacent headers, based on the UTC time. When the process runs and the robot has re-generated the excel file, it takes in the list of timings, loops through the different headers, converts the time, and writes the result into the Excel File.
Some possible enhancements/points to consider:
- Housekeeping of the Excel file after the process has been completed.
- Possible integration with a credential management system to get the login account for the Kryon Studio/Robot.
- This method can only work to trigger Unattended robots.
Best answer by Mark_LimView original