I'd like to have a column in the sheet which represents the file upload

siouxmaeb
Asked on June 08, 2021 at 09:03 AM

I'd like to have a column in the sheet which represents the file upload URLs from the GDrive integration
How to achieve this?

This is a re-post of a comment on How to Integrate Forms with Google Sheets
Tommaso_F
Answered on June 08, 2021 at 10:02 AM

In which Sheet do you want to add a link to your Google Drive folder? Jotform Sheets?
If so, you can add a new column on the Sheets page of your form and insert a link of your Google Drive folder.
If I did not understand your question correctly, please explain in more detail what exactly are you trying to achieve.
siouxmaeb
Answered on June 08, 2021 at 01:58 PM

Hi
Actually I meant something different:
I have an file upload element in my form and I've also the GDrive Integration active.
Once I upload a file to the form, this file then is sent to GDrive. Next I've the Google Sheet integration active which means that all the jotform form fields are sent to a google sheet.
Since the answer table of my form does only have a column with the uploaded file pointing to an URL from jotforms, also the google sheet column (its values) do point to the jotform file.
I actually wanted a google sheet, which containts a colum for this uploaded file pointing to the gdrive file (which was created by jotform integration and represents the uploaded file)
John

Jotform Support

Answered on June 08, 2021 at 09:50 PM

If you mean you would like to add the Google Drive URL of the uploaded file in Google Sheet instead of the Jotform URL, unfortunately, it's not possible with the current integration we have. There is no way to link the GSHEET and GDRIVE integration as they work separately.
A workaround would be to use third-party applications (e.g. Zapier or Integromat) to integrate the form with GDRIVE and GSHEET. Upload the file first in Google Drive then pass the generated URL to Google Sheet.
Here's an example (I used Zapier):
First, send the upload to Google Drive:
Then create a Google Sheet that has columns corresponding to the fields you have in the form.
Pass the Google Drive URL of the uploaded file in the above steps to a column in Google Sheet:
And that's it! It should work as you intended.