Update Output Tool - How to save data to a chosen excel file with specific ranges

Question

Hi All,

I'm creating an app with the drop down options allowing you to choose where the source data comes from, but I am having issues trying to choose where I can save the data to once it has been manipulated.

I need to save the data I create to an excel template saved onto mine or anyone else's hardrive, as it is saving to a set template I need to save the data to specific ranges within the spreadsheet, I can do this manually by adding "$B6:R" to the end of the file destination in the Output tool interface however I cannot appear to update this through the Action tool.

Below is a quick screenshot to help show what I'm referring to:

I would be happy to provide test workflows if more info is needed but any help would be greatly appreciated.

Kindest regards,

B.

danilang · Accepted Answer

Hi @Brytsyt

You should be able to get what you're looking for by configuring the action tool like this

Check the "Replace a specific string" and leave only the range in replace text box.  Any range that the user enters will replace the existing one.

Dan