Google Drive/Dropbox Integration: Allow to append field values to custom folders and redirect submissions to them

  • Profile Image
    mfaulkner
    Asked on April 13, 2015 at 11:27 AM

    CAN WE GET EXTENDED FOLDER NAME OPTION FOR THE FIRST FOLDER???

    We need a Cloud Folder w/ ALL submission PDF's.

    Dropbox & Drive Plugins OVERWRITE THE SAME PDF FILE EVERY TIME W/ THE SAME NAME.

    We CAN append the name onto the folder to get a unique folder for every submission, BUT:

    THEN it requires separation via a form field {formfield}, IE: Dropbox/{formfield}/UniqueFormName.

    This is impossible because neither dropbox NOR drive allow us to do this.

    WE need:

    :: The FIRST FOLDERNAME FIELD append a FIELD TO IT. IE dropbox/FormTitle+{formfield}/UniqueFormName

    See images here how neither dropbox nor drive integration allow these to be chosen, however, it seems it'd be quite simple to append the formfield into a different area of the foldernames.

     

  • Profile Image
    BDAVID
    Answered on April 13, 2015 at 02:15 PM

    I think you could use the Custom Folder Name option:

    So, each folder will have a sub-id:

    Just make sure to add the Unique ID widget:

    Hope this helps, let us know if you have more questions.

  • Profile Image
    mfaulkner
    Answered on April 13, 2015 at 02:20 PM

    Thank you, HOWEVER:

    The MAIN ISSUE is that I need FOLDERS with ALL FILES from ONLY ONE PARTICULAR FIELD ( {location} ).

    IE: FormTitle/{location}/eachIndivSubPDF (not 1 PDF overwritten every time).

    This way, i can give access to one folder which will have all the files from the {location}, separated.

    So all in all:

    MainFolder:

    -{location1}\eachIndivSubPDFs

    -{location2}\eachIndivSubPDFs

    -{location3}\eachIndivSubPDFs

    -{location4}\eachIndivSubPDFs

    -{location5}\eachIndivSubPDFs

  • Profile Image
    BJoanna
    Answered on April 13, 2015 at 03:48 PM

    Unfortunately it is not possible to do what you want to achieve. To have mainfolder+{location1} you can type the main folder + location1 path into the custom settings for submissions posting.

    If you need some more advanced form of file sharing I would suggest to you that you can write a script that will check the folders and either move or copy the files to a different folder if so needed.

    Let us know if you need further assistance. 

  • Profile Image
    mfaulkner
    Answered on April 13, 2015 at 07:22 PM

    I don't think you guys understand what's needed?

    Why can it be programmed to append a fieldname, IE {location}, to the main folder? Why only the 2nd folder?

    If only it could make different folders based off of the {location}, only making a folder for each field of {location}. Please look into this. There's no way it can't be done.

  • Profile Image
    Charlie
    Answered on April 14, 2015 at 02:59 AM

    Hi,

    I believe this is not possible right now, because the main folder will be the key identifier that the Form is connected with the Google Drive or Dropbox, you can say that it is the main folder for the integration, dynamically changing the main folder will probably break the integration. Another, it would be hard to put all the PDF submissions in one folder, let's say per location, this is because the integration creates new folder for each submission, if we use the same folder name it would replace the PDF inside it when a new submission has been received.

    I hope this helps. We could, however, forward this to our development team, but it will be more of a feature request and it will depend on them if this will be implemented or not and also depending on the current workload that they have.

    Kind regards.

  • Profile Image
    mfaulkner
    Answered on April 14, 2015 at 11:28 AM

    This is possible, I assure you.

    The pdf NAME can include a unique form ID (which will keep it from overwriting files in the same folder).

    At that point the software only needs to place it in the folder with the corresponding {field}.

    PLease, allow me to speak w/ developers about this.

     

  • Profile Image
    Charlie
    Answered on April 14, 2015 at 12:54 PM

    Hi,

    I understand, as I mentioned it is not possible as of the moment because it is not a function or feature of the integration, BUT it can be done on the developers side, however it will be forwarded as a feature request and it will depend on the current workload that they have if this will be implemented.

    Also, before I submit it as a feature request, this is how I visualize it rather that appending field inputs to the main form:

    -Main Folder

    ----Custom Folder + appended field value (ex. Field Value on text box is "Location1")

    --------Submission1 Folder

    --------------Submisison1 PDF

    --------Submission2 Folder

    --------------Submission2 PDF

    ----Custom Folder + appended field value (ex. Field Value on text box is "Location2")

    So, the feature request is to have a custom Folder with field inputs appended on them that will allow to upload the submissions to those folders.

     

    The original request that you have is designed like this:

    -Main Folder name + Field value appended on it

    -----Submission1 Folder

    --------Submission1 PDF

    -----Submission2 Folder

    --------Submission2 PDF

     

    Did I understand it correctly in some way?

    Thank you.

     

  • Profile Image
    mfaulkner
    Answered on April 15, 2015 at 09:43 AM

    Hi Charlie,

    Thank you, yes, that is correct. Also, there is part I'd love added as well which would make it very more functional. I have seen the system name the PDF files by the submission id! So that would seriously help.

    -Main Folder

    ----Custom Folder + appended field value (ex. Field Value on text box is "Location1")

    ---------Submisison1 PDF + {uniqueformid}

    ---------Submission2 PDF + {uniqueformid}

    ----Custom Folder + appended field value (ex. Field Value on text box is "Location2")

    ---------Submisison1 PDF + {uniqueformid}

    ---------Submission2 PDF + {uniqueformid}

     

  • Profile Image
    Charlie
    Answered on April 15, 2015 at 11:27 AM

    Great. I will forward this as a feature request, please do take note, as I've mentioned in my earlier post, this will be a feature request which means this will depend on the developers if this will be implemented, unfortunately, I'm unable to give an exact date for this as this will be handled by a different department, but we will update you when we hear any news on this.

    Kind regards.

  • Profile Image
    mfaulkner
    Answered on April 23, 2015 at 01:12 PM

    Hi :)

    Any Status Update?

  • Profile Image
    Charlie
    Answered on April 23, 2015 at 01:20 PM

    Hi,

    Upon checking the feature request report. It seems like the development team is already aware of this, but this is not in the list of features that will be implemented anytime soon. I believe our developers have a lot of pending task in their hands right now.

    Thank you for understanding. 

     

  • Profile Image
    mfaulkner
    Answered on April 23, 2015 at 01:22 PM

    There's no workaround? Something to be done in the meantime? 

    It's a slight alteration that can massively extend the usability Functions of the dropbox integration.

    Is it possible to do in Google Drive?

  • Profile Image
    Charlie
    Answered on April 23, 2015 at 01:40 PM

    It would be a slight alteration but it will actually affect the major structuring of the folders, so I believe this is more of a major change that will need to undergo phasing in the developers.

    Right now, the existing functions in the integration are the only ones that we can use. I'm not familiar with Google Drive if there's a script that we can use to organize folders, similar to Google Spreadsheet.