My client wants the app to put a copy of the file that’s uploaded to be saved on the company’s cloud storage. This should also apply to the files made through bots/workflows/reports.
I know that files made through bots are saved to the “Default app folder” under Info → Properties.
I also know that there is a security measure in order to prevent someone having access to the cloud storage where the app is located to delete a file that was uploaded through a form. This would break the app’s link to the file.
That’s why I think the best way is to have an option to make a copy to a place of our choice where we could select a folder, similar to how we look for a worksheet to add it to our app, and then create a formula to make the folder path starting from the folder we have chosen.
So, add an option called “Second copy attachment folder” that we can select similar to how we look for a workbook and then “Second copy folder path” allowing an expression.
This should be under this part of the bot/task:
The same thing under this part of files from forms:
So, to have a second copy of files from bots and from forms where we can select whichever folder we want from the company’s cloud storage (Sharepoint, for example) and then we can create an expression to complete the folder path dynamically. This second copy shouldn’t have the limitations that the first copy has like “just folder path relative to the worksheet” or “folder path relative to ‘Default app folder’”, instead, full custom folder path
Hope this makes sense to someone else