Solved: Upload pdf file to different folders created on dr...

adiboo_adib · 07-26-2020 10:28 AM

Hi
I want to know if it possible to upload scanned pdf from my pc to choosed folders created on google drive.
for exemple : pdf1.pdf to folder3
pdf2.pdf to folder1
Can you please tell how to do that.
thanks

adiboo_adib

i found the good expression to change the folder CONCATENATE("/foldername")
thanks

View solution in original post

Aleksi

@adiboo_adib You can set the subfolder name from the file column’s definition. The option name is “Image/File folder path”. You can use a formula to create that folder name. If that folder doesn’t exists, your app will create it.

adiboo_adib

thanks for your reply, but how to choose the folder on app?
can you explain me please

LeventK

@adiboo_adib
In your column’s definition, there exists an option named Image/File folder path as @Aleksi had already stated. You can enter a conditional expression here as per your requirements. You can use expressions i.e. SWITCH(), IFS() or IF(). You don’t need to choose anything, the expression will automatically arrange it for you.

adiboo_adib

Thanks for your fast relpy,
Have you a demo app that use this fonction please, i want to use appsheet because i’m not a coder
thanks

LeventK

@adiboo_adib
This is not related to being a coder or not actually. I’m afraid there’s no demo app for that either as it’s totally user specific. This way or the other you will need to use AppSheet expressions to achieve many requirements that your app might have or need. So I may advise reading documentation, make your hands dirty and come up provided you can’t achieve the desired result.

adiboo_adib

I found how to add file folder path, now can you give me the right expression for SWITCH for choosing folder, for exemple if i have folder1 and folder2
Thanks

LeventK

adiboo_adib

Sorry to disturb you, but can you give me an exemple please for real syntaxe SWITCH(folder1, folder2) for exemple.
thanks

adiboo_adib

Please help for switch expression, i want to save file upload on a different existing folder .
For exemple the the column name “Formations scan” i want to save all uplaoded pdf files to an existing folder (/appsheet/data/appname/pdf1/) not the default folder.
Thanks

adiboo_adib

i found the good expression to change the folder CONCATENATE("/foldername")
thanks

LeventK

Excellent

adiboo_adib

Hi Everyone
I have a question, it is possible to use file type to upload multiple pdf file?
thanks

LeventK

Nope. If you want to upload multiple files, you need to create an additional table for uploaded files and connect it to your table as a reverse ref (with isPartOf set to ON)

adiboo_adib

Can you explain me or give me a link to see how to do that please.
thanks

LeventK

Take a look at my community sample app below. On the Deck View choose Frank McGee. In form, there is an ENUM field at the end and choose Yes and see how it works. You can download the app from my portfolio here > https://www.appsheet.com/portfolio/245151

adiboo_adib

It’s not that i need, i explain again sorry for my bad English
i have a row where i upload pdf , it look like this

but when i use the same row i upload the new file but doesn’t display the old one.
Can you tell me how to display all attached files using the same row please.
Thanks

LeventK

I believe I couldn’t be able to grasp your idea here. You want that when you edit a certain record to upload a new file to a certain column, do you want that the existing file record in that column shall be empty? Or what?

adiboo_adib

i want upload files on an existing record and display both fileslike here

LeventK

Unfortunately you can’t have such a thing in your detail view

adiboo_adib

OK thanks
I have another question please, it’s possible when i upload a file (pdf for exemple) on a rom, to send an email with the attached file. If it’s possible can you show me how please or give me an exemple please

LeventK

Upload pdf file to different folders created on drive