Solved: Email attachment path not relative to google sheet - Page 2

Frederik · 02-28-2020 12:49 AM

I have an appsheet app working from a google sheet.
In folders, located in the same folder as the google sheet, I have information about customers - the folder name is the customers name.
When I send an email with a pdf attachment, I would like appsheet to automatically save the attachment in the correct folder.
I have tried to accomplish this by putting [customer]&"/attachment" in the Attachment Folder Path, under my email workflow. Unfortunately, this creates a folder with path appsheet/data/Appname/(customer)/attachment and does not find the folder next to my google sheet.
How can i fix this?
Is there a way to put a folder ID, or some other way to ensure that the files end up in the correct folder.

Koichi_Tsuji

Not exactly sure, but worth checking.

Did you change the relative path on the Info pane, Properties tab as well? in addition to the relative path settings in workflow.

Here you push relative path to your folder googlesheet resides. My understanding is this is going to work as “Root” folder for workflow settings.

Then you add the relative path “counted” from this “root” folder.

My suspicion is you did not change the info/properties tab - Default App folder setting, so you app keep working this default folder as ROOT. Then you change the relative path on workflow, it still within the tree of this ROOT folder, so it will generate the new folders within root folder.

@Aleksi

View solution in original post