-
bobbyjonesAsked on March 10, 2015 at 6: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/434184-Bug-Report-Date-Field-Does-Not-Sort-By-Date-In-Grid-Reports
Any help is appreciated. Thanks!
-
jonathanReplied on March 10, 2015 at 7: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.
-
bellwetherstlReplied on March 10, 2015 at 8:46 PM
Great workaround. Thank you!
-
moddlerAReplied on March 23, 2015 at 1:26 AM
-
Welvin Support Team LeadReplied on March 23, 2015 at 4:59 AM