How to save Pdf files in different folder on Drive

[DaGi07]

Hello to everyone,

i'm building an app to manage employees training courses and I would like to save the certificate (pdf files in column "ATTESTATO") in different subfolders within the main folder "CORSI_Files" depending on the course type column "TIPOLOGIA" (project management, languages, job security...). In this moment, all the files are saved in the same folder.

This is the structure of my table;

It's possibile to make this setting?

tks guys

[Suvrutt_Gurjar]

Yes you can create different folders. The below post is about folder names based on date. But you can suitably change. Please take a look at the post and please revert if any more queries.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Different-Folders-each-day-for-attachments/m-p/...

[DaGi07]

Yes, i see that is possibile but In this example that you link me, he also create a bot to send an email. In my case, i have to archive the file in different folder based on course type (column "TIPOLOGIA" of my table) when i attach a pdf file in my app. 

Maybe I have to set an expression in the field Image/File Folder Path. 

 

What kind of expression could i use? 

[DaGi07 · Accepted solution]

in order to help other people i used this formula in folder path; 

IF([TIPOLOGIA]="sicurezza sul lavoro",CONCATENATE("folderpath",[CORSO]),

CONCATENATE("differentfolderpath",[CORSO])

)