Date Picker: Value with different date format is not validated properly and is saved as empty

  • Profile Image
    Kontiki1
    Asked on August 01, 2017 at 08:18 AM

    Some submissions are ok but some submissions 

    even though they have filled in the Date Picker field do not appear on Google Sheets or Google Drive.

    The date Picker field which I use for DOB's are very important.

    Any help would be greatly appreciated.

     

    Kind Regards

     

    John.

  • Profile Image
    Chriistian
    Answered on August 01, 2017 at 11:26 AM

    I cloned your form and integrated the cloned for to Google Spreadsheet but I was not able to replicate the issue you are encountering. The DOB field value was properly recorded on the spreadsheet.

    Can you try to reintegrate (remove current integration and integrate again) your form to Google Spreadsheet and see if this will fix the issue? If the issue still persists, can you share the Google Spreadsheet integrated to your form to us so we can further investigate the issue?

  • Profile Image
    Kontiki1
    Answered on August 01, 2017 at 12:43 PM
    blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } Thanks for the reply. I think I've found the problem. A conflict between hyphen and oblique between dates. The form is set for hyphen. Some people used / which the form allows but the Google spreadsheet doesn't recognise. 
    Sent from Yahoo Mail for iPhone
    ...
  • Profile Image
    Chriistian
    Answered on August 01, 2017 at 02:07 PM

    I checked this on my cloned form and I was able to replicate the issue you are reporting. The Date field in the form accepts dd/mm/yyyy format even if the field is set to dd-mm-yyyy format.

    When I checked the submission page and the Google Spreadsheet the value for the Date field is set to empty.

    It seems the issue is the validation of the Date field, as when I try to change the Date Separator of the field to /, the data was properly captured on my Google Spreadsheet.

     

    I will escalate the issue to our development team for further investigation. Will inform you on this thread any updates to the issue.

  • Profile Image
    Kontiki1
    Answered on August 01, 2017 at 02:44 PM
    blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } Many thanks for your time and advice.Another option is to use a small text field.  
    Best Regards. 
    John. 
    Sent from Yahoo Mail for iPhone
    ...
  • Profile Image
    Chriistian
    Answered on August 01, 2017 at 04:17 PM

    Did you mean Short Text Entry field? Indeed it is an alternative. You won't have a picker for dates though. But you will be able to restrict the field to accept the format dd-mm-yyyy by applying input mask as shown below.

     

    Do you specifically require the form dd-mm-yyyy? If not, you can also try some of our date widgets and see if one of them works.

  • Profile Image
    NeilVicente
    Answered on August 08, 2017 at 09:03 AM

    This should be fixed now. Date should be validated properly from here on out.

    Kind regards,