I have a project that includes reading data from a database and currently, the credentials are saved inside the sheet itself which is not the right way to do it but it is fine as I am the only one testing it.
the project is now ready and I need to give it to my team where each one will need to use his credentials and I am asking if there is a way to prompt for query password inside excel before it attempts to run the query!
There are many way to provide input like credentials before even executing
Let’s go one by one
These are very simple steps and one time step
Using Input arguments
If your developer are using robot assistant
They can pass the credentials of their user id before triggering the bot
Have a view on this on how to do it in UiPath
Go to start → search as UiPath assistant and there need to perform this configuration also ensure that you have created IN type argument in your mail xaml named in_credential of type string and that process should be published to orchestrator
** once after publishing to orchestrator, go to assistant and right click that process or click on three dots and select install, this will install the new version which has you in type argument**