What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Drive Integration - format submission date for custom folder name

    Asked by bobbyjones on March 10, 2015 at 06:11 PM

    I'd like to be able to include the submission date as part of the folder name that is created with submissions when integrated with google drive. I've seen that I can do that by adding {time} as part of the name like below:

    While this seems straightforward, the reason I want to be able to include the date in the folder name is to be able to easily sort the submission folders by the date they were submitted. The folder name that is created, though, has a date format of "dd/mm/yyyy hh:mm:ss" as shown below:

    This format doesn't work for sorting by submission date as it would sort april 9, 2015 ("09/04/2015") prior to march 10, 2015 ("10/03/2015"). I'd prefer a format of yyyy/mm/dd. Is this doable by including another field (a datetime field with default date enabled will not work because this field cannot be used as part of a custom google folder name in the current integration). Is there a way to format the already included submission date?

    I've reviewed these threads (seemingly related), but I still can't find a solution.

    http://www.jotform.com/answers/301785-Google-Drive-integration-Wrong-date-time-for-the-name-of-the-submission-folder

    http://www.jotform.com/answers/405710-Google-drive-integration-include-submission-date-in-custom-folder-name

    http://www.jotform.com/answers/434184-Bug-Report-Date-Field-Does-Not-Sort-By-Date-In-Grid-Reports

    Any help is appreciated. Thanks!

    name format folder name custom folder google drive submission date date format
  • Profile Image
    JotForm Support

    Answered by jonathan on March 10, 2015 at 07:10 PM

    The DateTime field have an output format of yyyymmdd so you can use it in the Textbox you can use as the Google Drive assigned Custom Folder name.

     

    I made a Calculation condition to populate a hidden Textbox that I will use as the Custom Folder Name in GDrive integration

     

    I setup in the integration

     

    The output in the Google drive is like this

     

    You can test submit my demo jotform http://www.jotform.me/form/50686861218462 where I have implemented the method.

    You can check the result in the shared Google folder here.

    Hope this help. Let us know if there is more we can assist you with.

    Thanks.

  • Profile Image

    Answered by bellwetherstl on March 10, 2015 at 08:46 PM

    Great workaround. Thank you!

  • Profile Image

    Answered by moddlerA on March 23, 2015 at 01:26 AM

    How did you get the date info to show up in a single text box rather than 3 individual text boxes? I can't find how to change that.
  • Profile Image
    JotForm Support

    Answered by Welvin on March 23, 2015 at 04:59 AM

    @moddlerA,

    Your question will be answered here: http://www.jotform.com/answers/538453.

    Thank you!