I need to use the dynamic input in a macro, but it is trying to make the connection before the macro is run. So in this case it is trying to make ODBC call to database with incorrect credentials, before the user has ability to provide the credentials. And it returns a nice bright red error message.
Is there a way to tell the Dynamic Input tool to not try to connect to it's data source until run time?
Solved! Go to Solution.
Unfortunately, there isn't a way to do this. We've run into the same issue internally when building dynamic tools.
@StephenW - Is it submitted as an 'Idea' yet, do you know?
Also, would it be possible to capture the error and supress the error message from users?
For those searching for this same issue, I'm adding the idea I submitted for the Dynamic Input tool - https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Add-option-to-prevent-Dynamic-Input-tool-fro...