Updating File Input Path based on a Calculated Field

[cletts3]

Hello everyone,

I have a question regarding using Action tools in order to update file paths in a normal File Input tool. I currently have an application that uses a File Browse tool to allow a user to select which file they want to upload into the application and a Text Box tool that allows a user to enter in a particular ID associated with the file.

Recently, I have been fleshing out an SQL database to store information brought in by this and other applications, and I realized that I can Join the ID that is input by the user to one of those SQL tables to get the last part of the file path. So, I want to get rid of the File Browse tool and have the workflow grab the correct file based on only the ID that is entered in the Text Box tool.

The issue that I have encounter is an Action tool (which is how I naturally thought about changing the end of the file path) can only be attached to tools with Question outputs (and technically Conditions as well, but I didn't think that would be useful). However, I need to use the input ID with a Join plus a Formula tool to correctly format the string to be equal to the file path. Is there a way (roundabout or otherwise) to connect the output of a Formula tool to an Action tool, or more generally, convert a calculated field in the workflow back into a Question output?

Thanks

[OTrieger]

@cletts3 
First in Action tool you can set a formula to do what you want.

You can set any path that you wish with any variables and then get a batch macro to open the new full path.

[OTrieger]

If you will select in Action tool Update with using Formula you can set whatever formula you wish.

[cletts3 · Accepted solution]

Thanks for the response! If the was a macro that I was using in workflows and not application, I think the Batch Macro suggestion would have been perfect. However, I struggled to figure out how to implement the Batch Macro properly into an application. 

Thankfully, I was able to find a solution using a Dynamic Input tool, so problem solved