Hi,
I am trying to output a file to a location of the users choosing.
anyone have any tips on how to make this work or make this process better?
Hi @wonka1234 ,
Can you provide a screenshot of the action tool please?
@wonka1234 your filepath should end with :
filepath/filename.xlsx|||Sheetname
Can you click on the output tool and make sure that it's configured properly so a sheet is specified?
This is what I can see from my side, and I believe that's the way to configure the action tool so it only replaces the filepath but leave the filename intact
thanks, but then how do you configure this part in the server?
the user will have to do C:/Users/me/desktop/file.xlsx|||sheetname ?
@wonka1234 If you want to allow your users the flexibility to change the filename and tab name then I presume yes. If you don't want those to change, you have to make it clear that they should only type something equivalent to "C:/Users/me/desktop/"
However, that filepath should be somewhere that your server has access to like a shared drive I believe. If you want to save the file on the desktop of your local machine then that's probably not possible as the server won't be able to access that filepath. If that's the case, your users can download the output instead after your workflow has finished running