Google sheets + google drive | file directory entries

I am doing some testing with Google sheets and Google drive integrations.

In my test form I've added some buttons for users to upload images (1 image per button).

For theses columns (in the Google Sheet), I need the file path relative to the Root of the Google drive folder (which is also integrated with the form).

By default I am getting an image entry like this:

=HYPERLINK("https://www.jotform.com/uploads/dbasting/92478177272265/4436033648313005163/ar_0015.jpg";"https://www.jotform.com/uploads/dbasting/92478177272265/4436033648313005163/ar_0015.jpg")

Instead I would like to see the entry as follow in order to automatically process it locally:

/2019-09-06 14_41_12/ar_0015.jpg

Is this doable?

The first folder in this path seems to be generated in the root of the Drive folder by the Google drive integration, using the submission date entry generated by the form.

Unfortunately, that is not possible with the Google Sheets integration. 

Only the Google Drive integration would actually send a copy of the file to your G-drive account: https://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive

Let us know if you have more questions.

Update:

I did some further research, and the I managed to get the local process working perfectly if I replace the URL entries with URLS from my own domain. Using direct URLs would be a much better approach for my needs.

It appears to have issues with the URL's jotform though. When i copy / paste one of the URL entries in to my browser, it shows me the file is hosted on files.hotform.com 

So the URL seems to be parsed. Is there a work around for this?

What is the workaround you found? There is no way to change the domain of the URLs sent to Google Sheets.

I didn't find a work around yet.

Here's some background information that might help understand what I am trying to do:

I am pulling information form the google sheet and loading it in to After effects. It works great with text, but for the images I need a direct URL. I did some testing with images that are hosted on my own domain and that worked like a charm.

Hence my question if it would be possible to generate a direct URL instead of the parsed URL (the way it is set up currently). So have a URL in the sheet that looks something like "files.jotform.com/dbasting/filename.jpg" instead of  https://www.jotform.com/uploads/dbasting/92478177272265/4436033648313005163/filename.jpg

If not, are there any 3rd party integrations that will allow me to upload to my own domain, or a 3rd party domain that support writing a direct URL to the google sheet?

This issue is the last piece of the puzzle to get my workflow finalized so I hope it will be possible somehow using your service.

Hi @dbasting,

I'm sorry but there is no available integration yet that features uploading to own domain. The files are being stored and can be downloaded from Jotform servers only and there is no way to modify the URL.

I haven't tried this yet but you may try Zapier. Here's a link that I thought might be helpful: https://zapier.com/apps/google-drive/integrations/google-sheets

I managed to get it working using uploadcare.com integration instead of the default upload functionality.