Selected Date Not Correct When Using Appointment Form and Time Selected was key in Opposite

  • Profile Image
    nadhrahpazlii
    Asked on October 21, 2020 at 05:05 PM

    Hi, I had use the appointment features. My timezone that was selected is Kuala Lumpur +8. I already set at my account setting. and I also set the appointment form features as well. However when i Implement it my website, and let say I select date of 28 October 2020 at 8AM, It will stored in my database as 27 October 2020 at 20:00 (24hrs) which basically is 8:00PM. could you please fix this issue asap.. Below attached the printscreen of the issues.1603314234_5f90a23ab2e27_1603314309_5f90a285dcda6_


  • Profile Image
    jherwin
    Answered on October 22, 2020 at 01:40 AM

    We are sorry for the inconvenience this may have caused. Is the issue related to this form?

    https://form.jotform.com/202852988733468

    If so, could you please let us know if we can send a test submission to test it from our end?

    I also see three (3) appointment fields on the form, does the issue occur for all appointment fields?

    Looking forward to your response.

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 01:49 AM

    Yes that's right. Its related to that form as stated. Sadly yes, the issue occur for all of those 3 appointment fields. I've been trying to fix it multiple times until my view form almost end the limit for this month already.

  • Profile Image
    jherwin
    Answered on October 22, 2020 at 03:13 AM

    I was able to replicate the issue to your form. However, when I clone it, it works as expected on my end.

    Can you please try cloning this form: https://form.jotform.com/202951260211947 and send a test submission and see if the date and time are working as expected?

    Give it a try and let us know how it goes.

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 03:50 AM

    1603352976_5f9139904c094_Screenshot 2020As you can see when I select 5:00PM, it stored in sqlite database as 05:00 which basically mean 5:00AM

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 04:00 AM

    I would like to request for reset back the forms views as because of the issue i'm facing now the form views already reach 1000. and i cant no longer will be used this form

  • Profile Image
    jherwin
    Answered on October 22, 2020 at 06:07 AM

    Your form views are now reset to 0, please check and let us know if the over-limit message still shows at your end.

    Also, Have you tried cloning the form I mentioned?

    You mentioned SQlite, can you please tell us how you send the data there?

    Looking forward to your response.

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 06:25 AM

    Another issue I'm facing is that whenever if i change to Time format of 24 Hours, and i tried to do booking, it keep stated that the appointment has been booked. It happen for all of the 3 appointment type. I dont know why its happening like that.


    1603362233_5f915db9a4a4a_Screenshot 2020

  • Profile Image
    jherwin
    Answered on October 22, 2020 at 07:40 AM

    By the way just to inform you that I'm using Kuala Lumpur time zone.

    I have the same timezone as you so there should be no difference when trying out the form.

    When I tried to book using the appointment form again, the same issues will arise. The issue about the date always happens like if I choose 24 October 2020, it will store 23 October 2020.

    The clone form still works as expected on my end. I submitted the form several times using the method you mentioned, but I was unable to replicate the issue. Is there any way you can take a short clip of the problem? We can send that to our developer for further checking.

    Another issue I'm facing is that whenever if i change to Time format of 24 Hours, and i tried to do booking, it keep stated that the appointment has been booked. It happen for all of the 3 appointment type. I dont know why its happening like that.

    We do not recommend editing the appointment field once you have submitted appointments or submissions. That may only cause a conflict in time slots and appointments. How about setting the time format to 24 hours before submitting and see if you can still replicate the issue?

    Can you please screen-record this as well so we can review and forward it to our devs if necessary?

    Thank you!

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 09:51 PM

     https://form.jotform.com/202951260211947 just to let you know, when I'm using your cloning form, the issue of date is resolved. however if I'm using my own form id, the issue still did not resolve.

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 10:02 PM

    However when using your clone id  https://form.jotform.com/202951260211947, sometimes the when choosing different doctor to book for an appointment, the date didnt came out. here attached the video for you to see it.1603418524_5f92399c59c4f_Screen-Recordin


    I also noticed that the time and date that i posted here also not tally with my current date and time now. Like today is 23 October 2020 and 10:02 AM, but this post was posted, it stated that 22 October 2020 , 10:02PM

  • Profile Image
    nadhraaaa
    Answered on October 22, 2020 at 11:15 PM

    This one I'm using my own ID. New issue arise, it looks like the format of date is not follow as what i had set via jotform which is Y/M/D. and if you see the last doctor, the date even start with M/D/Y .
    1603422899_5f924ab362349_Screen-Recordin
  • Profile Image
    jherwin
    Answered on October 23, 2020 at 12:37 AM

    Thanks for the screencast.

    Just to let you know, when I'm using your cloning form, the issue of date is resolved. however, if I'm using my own form id, the issue still did not resolve.

    I reviewed your form and it has no submissions yet because it is still in develop mode. Can you please try to clone the form in your account and use that instead because the clone form works as expected?

    Sometimes the when choosing different doctor to book for an appointment, the date didnt came out. here attached the video for you to see it.

    • I can't replicate this issue on my end. Please try clearing your browser cache and cookies for Jotform first before testing the form.
      1603427495_5f925ca78add1_ed8R5pp3Uf.gif

    I also noticed that the time and date that I posted here also not tally with my current date and time now. Like today is 23 October 2020 and 10:02 AM, but this post was posted, it stated that 22 October 2020 , 10:02PM.

    • Jotform's servers use US Eastern Standard Time (New York time) and that is what our support forum uses.

    This one I'm using my own ID. New issue arise, it looks like the format of date is not follow as what i had set via jotform which is Y/M/D. and if you see the last doctor, the date even start with M/D/Y.

    Thank you.

  • Profile Image
    nadhraaaa
    Answered on October 23, 2020 at 12:40 AM

    Ok here's the issue where I said once when I change the setting from AM/PM to 24Hour, whenever i select the time, all it showed that time has been booked.1603428014_5f925eaebe6b7_Screen-Recordin

  • Profile Image
    jherwin
    Answered on October 23, 2020 at 01:58 AM

    Ok here's the issue where I said once when I change the setting from AM/PM to 24Hour, whenever i select the time, all it showed that time has been booked.

    That's your form, correct?

    The clone version of your form is working as expected, here's my screencast on my end.
    https://drive.google.com/file/d/19NF1LcrsSvNJJ2-vE5KnHm9Ymyk5kvZI/view

    If you wish, I can transfer this clone form to your account so that you no longer have any issues in the appointment field. Or, try deleting the appointment fields on your form and see if it fixes the issue.