Solved: File Column Should Store Google Drive URL - Page 2

Markus_Malessa · 10-28-2020 08:26 AM

I am having a hard time grasping the File type column concept as it relates to how Appsheet treats a file when it is stored on Google Drive. It appears that Appsheet creates a file path to the file that essentially opens an encoded URL that allows the file to be uploaded and viewed from the application.

What I need, is the file upload capability however the actual column should store a URL of the file in Google Drive. I need this capability because I have other programs where I need a URL that could be opened by someone whereas currently that column shows a file path only and does not actually open a file. The other program I am using is Google Data Studio and for that I would need a URL so I can open it from GDS.

Could someone clarify this for me? Thank you.

Marc_Dillon

Please double check that all 3 of these Security Options are turned off:

EDIT: Below info was not applicable to this scenario, but I’m leaving it here because it could be useful to someone in the future…maybe?

My thought was that the fileName parameter in the URL needs to be a relative path to the location of the file where tableName is in. Here is something you can try:

Create a new GSheet in the folder directly above “TempWaterUseAgreements_Files_”
Just put “id” into cell A1, and “1” into cell A2 (or similar, just so it isn’t blank)
Load that as a new table into your app.
Modify the URL to replace the tableName argument with the name of the table you just loaded.

Although I’m not sure if that is going to work since I just did a test on an app where I have created public file URLs where I just changed the tableName argument, and got an error different from just “Bad Request”:

View solution in original post