-
moduli471Asked on March 1, 2021 at 4:31 AMI connect the form upload files with drive. OK.
But it would be nice to have (in the drive sheet) the link to the drive file instead to the download link of jotform. Is this possible? with this arrengement i can see the file upload by te user that complete the form with a preview, also is fast to open, i dont have to download, and duplicate files...
Many Thanks and best regards,
-
Sam_GReplied on March 1, 2021 at 4:43 AM
Hi Manuel,
Unfortunately, the link to uploaded files would be in Jotform.
Currently, google sheet links are from the submission uploads.
We do have a guide that will help you integrate your form into your Google Drive. Please check this link: https://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive.
If you have any questions, let us know. Thank you.
-
moduli471Replied on March 1, 2021 at 5:07 AM
Hi Sam,
Thanks.
Unfortunately, the link to uploaded files would be in Jotform. OK, i see, no problem with this.
I make the integration with google drive, to store all there. But if i want to see the document from jotform link, i must first download.. so at the end i am making 3 files of the same: 1 in jotform, 1 in drive and 1 in my pc.
My question is: There is method to convert this link:
to a drive link of the file... Meaning; when you create the google drive folder, you can "copy" the link and inform me that one, or both?
-
Sam_GReplied on March 1, 2021 at 6:50 AM
Hi Manuel,
Once you integrate it to Google Drive it would show all the files uploaded.
Related guide: https://www.jotform.com/help/192-how-to-integrate-a-form-with-google-drive
-
moduli471Replied on March 1, 2021 at 7:04 AM
Hi Sam.
Thanks. Yes I understand that.
What i am asking is:
- when somebody upload 1 file(we will call it file X) , in the google sheet, you provide me a link to this file. This link is from Jotform.com No problem with that, but if i want to see the file, i must download. An also, i already conect files with Drive. So at the end: We have 1 file X in jotfrom, 1 file X in drive and 1 file X in my pc because i must download. So we have 3 files, that are the same.
IF instead of inform me the link (in the google sheet) of jotform, you inform me the drive link i dont need to download...
and also, when in google sheets you have a link of drive, you can see a preview. Very usefull.
Best Regards,
Manuel
-
Lorenz JotForm SupportReplied on March 1, 2021 at 8:46 AM
Greetings,
There's actually an option in the JotForm table to change the view to uploads, which allows you to quickly preview the uploads.
Here's a guide: https://www.jotform.com/help/1005-how-to-add-an-uploads-view-in-jotform-tables
IF instead of inform me the link (in the google sheet) of jotform, you inform me the drive link i dont need to download.
I'm quite not sure what you meant by this, can you please elaborate? Do you mean to show the drive's link to Google Sheet instead of the upload link from JotForm? If so, that is not possible. If you are referring to something else, kindly please provide us more details.
We will wait for your response.
-
moduli471Replied on March 1, 2021 at 9:18 AM
Hi lorenz,
When somebody use my form and upload a file. When i go to the google sheet, i saw the link of that file. That link is a link to jotform. and when i click, i muts donwload to see the image.
If instead: you inform me the link of drive to same file (i already have made the integration with drive); i can avoid downloading (time + local space)
for example:
Somebody complete a form and upload a foto.
This is how i see in google sheet the link:
here the link so you can see:
but also, as i already make integration of Jotform with drive; the photo is in drive: under this link:
https://drive.google.com/file/d/1Jya4NziOhuImM53fajYt2dTu5tFBagsg/view?usp=sharing
SO, my question is:
In the google sheet, were i see all the forms that people complete, can you show me the drive link of the documents instead the jotform link?
-
Jovanne JotForm SupportReplied on March 1, 2021 at 10:18 AM
Hi,
There is a preview of the image because a copy of the image file was uploaded to your Google Drive. The file source is now on your Drive. However, on the Google Sheet integration, a file is saved on JotForm's server, so the source link is sent to the sheet.
I'm afraid that it is not possible to change the file source link from your Google Drive in the Google Sheet integration.
Let us know if you have further questions.