Google drive integration is not copying the files and PDF to new folder when the submission is edited

bluefiregroup

Asked on January 9, 2017 at 2:11 PM

Hi - I have a google api connection that posts submissions to GOOGLE DRIVE FOLDER / [project name] - [date/time]

So, if the form is EDITed and re-submitted I end up with multiple folders, which is fine.

The problem is that I am sometimes not seeing all the assets being placed in the new folder each time a new submission is made

When I test it myself, upload images etc - these are all in the first folder - then if I edit some text details and re-submit, I can see all the previously uploaded images are now also in the second version folder and so on.

But when some of my customers are doing this I can see that their previously uploaded images that ARE still referenced in the form (and the PDF) are not being copied to the new folder each time they update their form.
i.e. the new version folder just contains a PDF and no images etc.

Now, I have been modifying the form a lot whilst it has been in production - but the buttons to upload images etc have not been changed.

How exactly should this process work? Should all the assets be copied to the Google Drive every time the form is submitted? If not, is there way way I can force the API to always copy ALL assets associated with the form to the google drive folder EVERY time a submission is made? Or do you have any other comments and observations

thanks!

Page URL: https://form.jotform.com/bluefiregroup/requirements
Welvin Support Team Lead

Replied on January 9, 2017 at 4:55 PM

How exactly the integration is configured? I don't see a field with Project Name as the label as well as DateTime field. I will have to check if I can replicate this problem.

When the form is integrated with Google Drive, all files as well as the PDF copy of the submission are stored in a single folder. When you edit a submission, you should get a new copy of the files/PDF in the same folder.

Basically, what you said is that you have the TIME field selected as the folder name together with the Project Name and that is why you are getting a new folder when you edit a submission? Please confirm.
bluefiregroup

Replied on January 16, 2017 at 7:04 PM

Hi Welvin,

In my form the "Project Name" field is hidden with CSS - so its still readable and used in the form, but because of the CSS rules you just wont see it. (I do this because I use the setting to not submit 'hidden fields' extensively - so to avoid that I use CSS rules in this case)

However, the integration has just stopped working..

The folder structure should be

GOOGLE DRIVE > BFG SOR / [Project Name] - [time of submission]

But I have just been making submissions and I am not seeing these in this folder. I have gone back and removed and then re-set up the integration twice - but each time I am not seeing the folder being created.

I have a google sheets integration and thats working fine. I just did a test submission - worked fine to sheets. But no folder gets created

I just tested also making the Project Name field unhidden but that did not seem to have any affect either. So currently, the integration to google docs is not working.
Kevin Support Team Lead

Replied on January 16, 2017 at 10:54 PM

I have tested the process you mentioned and on my end I can see it creates a new folder when editing the submission, this because either the field used or the time will be different:

Now, regarding to the form not sending submissions to Google Drive, I have moved it to a different thread and it can be found here: https://www.jotform.com/answers/1036260

We will assist you there as soon as possible.