Google Drive Integration - format submission date for custom folder name

  • Profile Image
    bobbyjones
    Asked 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!

  • Profile Image
    jonathan
    Answered 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
    bellwetherstl
    Answered on March 10, 2015 at 08:46 PM

    Great workaround. Thank you!

  • Profile Image
    moddlerA
    Answered 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
    Welvin
    Answered on March 23, 2015 at 04:59 AM

    @moddlerA,

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

    Thank you!