DateTime Single Widget: Data is not forwarded to Google Spreadsheet - IF HIDDEN

  • Profile Image
    AgilityAssoc.Canada
    Asked on May 17, 2018 at 01:24 PM

    I added a new widget date field. It is hidden and is showing current date. I just had an entry and when I look at it in the inbox the field is there but blank. What is wrong with my new field?

  • Profile Image
    Richie_P
    Answered on May 17, 2018 at 01:32 PM

    I have cloned your form, integrated it with Google Spreadsheet and I was able to replicate the issue.

    It seems that the DateTime Single widget, is not pushing its data into the Google Spreadsheet.

    I will forward this issue to our back-end, so that they can check it further.

    We will let you know via this thread if updates are available.

    Thank you.

  • Profile Image
    AgilityAssoc.Canada
    Answered on May 17, 2018 at 02:15 PM

    HI,

    Darn... OK then I will try another date option. Thanks for verifying.

    Robert

  • Profile Image
    Richie_P
    Answered on May 17, 2018 at 03:24 PM

    For the meantime, you could use DatePicker  or Mini Date Picker.

    Thank you.

  • Profile Image
    AgilityAssoc.Canada
    Answered on May 17, 2018 at 05:34 PM

    HI,

    I used date picker, mini date picker has no to-days date option... to bad that is my preferred widget. Every time I change this field I have to create a new integration and the links to it.

    Waiting for the next submission...

    Robert

  • Profile Image
    AgilityAssoc.Canada
    Answered on May 18, 2018 at 09:05 AM

    Hi,

    Well again a failure.... Had three submissions with no current date using Date Picker. My thought is these widgets need to have a selection made before they actually work... Bummer

    Robert

    1526648720noDate.png

  • Profile Image
    AgilityAssoc.Canada
    Answered on May 18, 2018 at 09:55 AM

    Hi,

    I made a test form 81374144314956 with all the 10 widgets and the regular date picker, and integrated it. Only two of the widgets actually record to-days date without any input.

    Localized Calendar, and Date Picker

    I tried Date Picker in one of edits and it didn't work as I show above.

    1526651226goodDates.png

    These two dates format correctly on integrated sheet as: 18 May,2018.

    Any thoughts why Date Picker works on one form and not the other? Could it be because it was hidden... I should test that...

    Any suggestion as to which I should use?  Help Required ... Again!

     

    Thanks Robert

  • Profile Image
    AgilityAssoc.Canada
    Answered on May 18, 2018 at 10:04 AM

    After further testing the conclusion is, hidden fields do not record dates...

    So now if I make it display: none instead of hidden will it work? ... more testing...

    After further testing the conclusion is, display: none fields do record dates.

    Joyful sounds can be heard.

    Thank you, Thank you..... Robert

  • Profile Image
    Richie_P
    Answered on May 18, 2018 at 11:56 AM

    Thank you for testing the issue further. I have tested the widgets as well and the Datepicker widget values will not be forwarded to the Google Spread Sheet Integration when it is hidden.

    But If you use the css code: Display:none; It will only hide the text but not the values.

    Please let us know if you need further assistance.

    Thank you.

  • Profile Image
    AgilityAssoc.Canada
    Answered on May 18, 2018 at 02:30 PM

    So your test results were the same as mine... That verifies my results. That is good news and good to know.

    My test results.

    1526667921integrationDate.png

    Note values in RED did not format as, dd mmm, yyyy, which is the sheet format setting indicating they are actually text and not numerical date values. As you can see there are 4 elements that do not work and 1 that shows 1 May, 2018. I may have entered that in error. 

    best Robert 

  • Profile Image
    Richie_P
    Answered on May 18, 2018 at 03:13 PM

    Thank you for the additional information.

    Please let us know if we can be of further assistance.

    Thank you.

  • Profile Image
    widgets
    Answered on June 21, 2018 at 09:41 AM

    Hi, we apologize for the delayed response. First of all any widgets that were set to be hidden by default will not be initialized in the first place so it will appear that the widget did not started at all. Unless there's a condition that will show it later on then it will work.

    Also, make sure that the form settings "Clear Hidden Field Values" should be set to "Don't clear" if you want to catch hidden fields when the form submits. Please try those changes and let us know.

    Regards,
    Widget Team

  • Profile Image
    AgilityAssoc.Canada
    Answered on June 21, 2018 at 10:37 AM

    Hi Widget Team,

    Thank you for getting back to me. As things stand right now I'm getting the results I want.

    But there is still an issue with some of the date widgets and for that matter the submission date. When integrated with Google sheets. The dates are transferred as text not as a date so they do not format correctly. I have reported this at least 3 times and have sent detailed reports but it appears I can't convince anyone that the problem exists. In some cases it flips the day and month values so that the 1st of Jun. shows up as 6th of Jan. It is impossible to work with or use these dates for sorting correctly on sheets.  

    Can you please look into this. I'm willing to work with anyone to show what the problems, issues are. 

    All the best, Robert

  • Profile Image
    Richie_P
    Answered on June 21, 2018 at 11:53 AM

    Hi Robert,

    Good to know the issue has been resolved. Regarding the issue on the submission date,

    I have moved your question to a new thread, so that we can assist you better.

    Please follow this link - https://www.jotform.com/answers/1505417

    We will respond to your thread shortly.

    Thank you.