Hello, my form has various fields like imags and files. I want appsheet to upload my images and files directly to GDrive while submitting the form and Gdrive link should be pasted in the respective cell in Google Sheets. If there is a solution, please explain in detail because I am new to appsheet and It would be a great help!! Thank You
This is default behavior.
The relative path (from the base spreadsheet, typically) to the file will be the Text value that is saved in a File/Image column.
Appsheet isnโt going to be able to figure out a GDrive link, because it has no way to access the GDrive file ID (or rather, it has no way to expose it to the user). To do that, youโd have to use a Google App Script or similar.
If youโre just needing a public URL to the file, please review the โExternal URL for Image Filesโ section in this help doc:
I realized something similar to your idea.
After you upload file to appSheet by default appSheet save it on G-drive. You have just one option to get link to file itโs use โ Google Apps Scriptโ.
Use file links more convenient if someone on back have to rename or move file between folders. App still working because access to file by link.
Let me know if you need more about it.
Thank you @VOLODYMYR_TYROL for your kind reply. Can you please breifly guide me on that. Thanks Again.
Any time, AppSheet community help me a lot. I want share it forward.
In database(G-Sheets) I created next columns:
Key, โFile pathโ, โFile Nameโ, โFile IDโ.
Column โFile pathโ - itโs file type in AppSheet. Originally after you uploaded file appSheet write down path to file.(exp. โฆappName/folderName/fileName)
Column โFile Nameโ itโs text type in AppSheet with initial spreadsheet formula (Spreadsheet Formulas | AppSheet Help Center๐ we going to get File Name from column โFile pathโ By SPLIT () and INDEX().
Example we have in column โFile pathโ next data โ appName/folderName/fileNameโ. So our formula looks: =INDEX( SPLIT (column โFile pathโ, โ/โ) ,3).
Column โFile IDโ, will be filled with โ Google Apps Scriptโ with custom formula. Also โ Google Apps Scriptโ Formula have to change column โFile pathโ
to file Url.
I going to share my โGoogle Apps Scriptโ code in couple hours
Using to read Google Drive folder as a table feature, you can get the Google Drive file Ids without scripting the codes now.
Then we can manipulate image/file data, relying on file IDs.
Thank you for your advice, never heard of it before.
This is just for users for those who use Google (drive) as data source. Once we save files, images or other types whatsoever, we are instantly able to get the Google Drive file IDs. Then can consume them to create download URL, create copy, get the unique URL (which is not affected by the location of file) etc.
We deploy some apps to our end users to upload mutiple files to appsheet app using this features as well.
We can do more with this read folder as table feature, althogh we have limited capabilities, such as limited availabiliies for meta data, nor not able to read sub folders etc
Can you please explain more about this part?
The most useful and reliable info source is this.
Thank You @tsuji_koichi for assistance. Can you please help me how should I integrate this in the appsheet?
With which part you need help?
Like how can I get google drive link in my excel sheet.
You mean that you would like have access to each file by link?
All files going to stay in one folder or many?
each row has a seperate folder, which contains 8 files. I want link for each file in a row in their seprate columns.
Do you want use existing files or upload new files?
Only new files.
If I understand right you want create something like for each user or employee folder and each folder have the same number of files?
Hi @sainikhushdeep ,
We donโt have support for nested folders yet, so depending on how many employee folders you need, this drive folder as a table feature may not be feasible right now for you. You would essentially have to add a table for each folder as the app creatorโฆwhich would be very clunky in your app beyond just a few employees.
R,
Scott
@Scott_Haaland
Thanks for improves appSheet.
For my client very important file management on G-drive. All files sorting by 50+ folders. I wrote logical part in โFile Pathโ and itโs sorting good. Just one problem itโs file name. I have change it in โ Apps Scriptโ. I will very appreciate if appSheet team do special field for File name or file name based on column value
Yes, each folder(user) will have same no. of files.
You try do something like That?
Employee Detail:
Employee List:
Why do you think, you need url on file?
@sainikhushdeep
Did you solve your question?
Yes it did @VOLODYMYR_TYROL you have been such a great help. Thank you so much!!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |