Happy new year to all,
This workflow has around 30 different queries and 6 fields to update dynamically. With regular dynamic input, it is working. I recently received a requirement that the dynamically updated script should be included to the output. This means I should repeat text/action pair 180 times which it is time consuming and increase the complexity. This is why I created a basic macro. Please see partial work below.
The text inputs have SQL scripts. I union all into one file. This gives me a flexibility when I need a change on any script without interfering the others. Then I used find/replace to change the values dynamically by getting user inputs from text interface tool. .
I created a basic macro to pass dynamically multiple queries through in-database. The blue macro has inDB tool. Please see below.
The macro provides the data and the scripts created dynamically. I tested this and is working.
So, I want to add an additional step that I want the users use their own credentials. I already embedded my credentials, however this should be by the user who runs the app.
As you imagine, I can't update the user credentials outside from the macro. I believe I should do it inside the macro, but I couldn't figure it out yet.
Any suggestions?
