How to customize the sub-folder name in DropBox integration?

  • Profile Image
    piercejohnston
    Asked on April 09, 2019 at 11:20 PM

    Hello!

    I am a mastering engineer and I use my jotform form to collect project info and accept audio files from clients. I've been trying to integrate it with my dropbox to more easily get access to the submitted files, but I've had some trouble figuring it out. The actual integration was pretty easy but I'm having trouble with the naming of the dropbox folder that is created when receiving a submission. Among other things, I collect the artist name and project/song title with my form. I use that info, along with a project ID (PJMxxx) made with a unique ID widget on the form, to make a custom project name.

    The format I use is [Project ID] [Artist Name] - [Project/Song Title]

    An example would be: PJM092 Natie - Something

    How do I set the name of the new dropbox folder to be created using multiple input fields from the form?

    Thanks!



    This is a re-post of a comment on Upload to Dropbox with JotForm

  • Profile Image
    Nik_C
    Answered on April 10, 2019 at 02:27 AM

    You could do something like this:

    1) I assume you have fields where you collect ID, Artist name and Project/Song title from your form? In that case, you can combine them in one field with conditional logic:

    1554877318Screen Shot 2019-04-10 at 8.22

    2) So whatever entered will be combined in that result text field (Folder name):

    You can make the result folder hidden since it is not necessary for the end user to see it.

    1554877369Screen Shot 2019-04-10 at 8.20

    3) You can then use that field in integration:

    1554877437Screen Shot 2019-04-10 at 8.20

    So such a folder will be created:

    1554877518Screen Shot 2019-04-10 at 8.25

    Hope it helps.

    Thank you!

  • Profile Image
    piercejohnston
    Answered on April 10, 2019 at 11:36 AM

    Thanks for responding! All of that works perfect, the only thing not working is the info from unique ID widget isn's showing up in the folder title. What I'm getting now is, [Artist Name] - [Project Title] in the title field. Below I've included screenshots of my conditional logic settings and the individual steps because I can't tell if I'm missing something that I'm doing wrong.

    1554908797Screen Shot 2019-04-10 at 11.0


    This is a view of the bottom of my form, where the unique ID widget is. I've tried it both while the widget is hidden and showing, and it doesn't seem to make a difference. Even when the widget is not set to hidden, it isn't showing up on my form, is that an issue? 

    1554908899Screen Shot 2019-04-10 at 11.0

    The widget info gets put into the title of the automated email I have sent to myself when someone submits the form just fine:

    1554909858Screen Shot 2019-04-10 at 11.2

    Here's the email I get when someone submits (the number is different because it's a later attempt to get it working)

    1554910465Screen Shot 2019-04-10 at 11.3 


    Here is the info inputed to the "Artist Name" and "Project Title" boxes at the top of my form:

    1554909062Screen Shot 2019-04-10 at 11.0


    Here is what the conditional logic is producing in the summary text field, I have it showing on the form just for testing, it will be hidden when I get it working properly:

    1554910368Screen Shot 2019-04-10 at 11.3


    And here is the folder created in Dropbox when the form is submitted:

    1554909691Screen Shot 2019-04-10 at 11.2

  • Profile Image
    Nik_C
    Answered on April 10, 2019 at 01:08 PM

    Unfortunately, you cannot pick up that widget's value, that's why is not visible in your conditional logic.

    I'm not sure if Random Value generator could work for you?

    1554916084Screen Shot 2019-04-10 at 7.07

    Since you can pick up that value and use it further.

    Please advise.

    Thank you!

  • Profile Image
    piercejohnston
    Answered on April 11, 2019 at 05:59 PM

    Thats strange! Then how is it able to be put into the subject of the email it sends me? It's also an option by itself as a folder title:

    1555019908Screen Shot 2019-04-11 at 5.57


  • Profile Image
    Kevin_G
    Answered on April 11, 2019 at 07:33 PM

    You're able to pull the data directly on the integration, but on conditions nor form calculation widgets you cannot get such info.