submission time discrepancy

  • Profile Image
    lovehaniorg
    Asked on July 01, 2021 at 10:23 PM
  • Profile Image
    Billy_G
    Answered on July 02, 2021 at 07:20 AM

    Hi there!

    I hope you're doing well and thanks for reaching out.

    Please elaborate on your inquiry further so we can be of help. Are you saying that the submission date captured in the table is 4 hours ahead?

    Would it be okay with you if we submit dummy data into the form so we can further investigate? Additionally, please confirm what timezone you're in.

    We'll be waiting for your response.

  • Profile Image
    lovehaniorg
    Answered on July 02, 2021 at 08:57 PM

    My time zone is GMT+9


    https://www.jotform.com/tables/210484150467453

    My form says


    at the top green zone : Last updated at 8:43 AM


    but

    the #1 (most recent) answer shows " July 3, 2021 12:43", which should be 8:43 as above.


    Please help..


  • Profile Image
    lovehaniorg
    Answered on July 02, 2021 at 08:59 PM

    1625273951_60dfb65f84ae9_fromKorea.png

    "all changes saved at 8:43" was seen just before I took this screen shot..


    "Are you saying that the submission date captured in the table is 4 hours ahead?"

    --> yes.. time stamp from the future..


    "Would it be okay with you if we submit dummy data into the form"

    --> okay

  • Profile Image
    Billy_G
    Answered on July 02, 2021 at 10:24 PM

    Thanks confirming.

    The time in "All changes saved and Last updated" includes any changes to the tables.

    This doesn't only include receiving new submissions but any changes made to the tables.

    Here are some screenshots for your reference:

    1625278761_60dfc9298cf3d_changes.png

    1625278776_60dfc9386402c_changs2.png

    Let us know if you need further assistance.

    Best regards,

  • Profile Image
    lovehaniorg
    Answered on July 03, 2021 at 01:29 AM

    1625289836_60dff46c3efaf_제목 없음.p


    sorry you don't get the point yet..


    if you see the 4 recent post(top left)

    and downloaded excel file(rignt)

    and check the exact time(bottom left), where i'm on(GMT +9) : which is 14:22:44


    so, the 4 recent post should be

    2021/07/03 13:42:52

    2021/07/03 13:36:01

    2021/07/03 12:25:47

    2021/07/03 11:50:13


  • Profile Image
    Vanessa_T
    Answered on July 03, 2021 at 05:37 AM

    Since your form receives submissions from time to time, the top 4 submissions on your screenshot may no longer be the top 4 submissions when we check your form.

    As such, kindly share the submission ID alongside the submission date.

    https://www.jotform.com/help/1014-how-to-show-and-hide-columns-in-jotform-tables

    https://www.jotform.com/help/549-where-to-find-the-submission-id

    In the meantime, I have cleared your form cache. Kindly check as well if the issue still persists.

  • Profile Image
    lovehaniorg
    Answered on July 03, 2021 at 06:50 AM

    ok.. thanx for your support but i don't have any change..

    i've using Jotform since Feb.2021, and I had no such discrepancies at all.


    whenever i receive new submmision,

    it has 4 hours future time (GMT+13)

    on both Jotform table and google spreadsheet connected,

    whereas I'm living in GMT+9 areas,

    from 2 days ago..


    try dummy data and fix it please...




  • Profile Image
    Billy_G
    Answered on July 03, 2021 at 08:07 AM

    I've just tried sending a dummy data and it seems to be fine when I view it:

    1625313984_60e052c0b0f79_

    You are just an hour ahead of me. Please check it from your end again.

  • Profile Image
    gerardw
    Answered on July 05, 2021 at 09:22 AM

    We had an issue with the submission time and have received an update from our developers that the issue with the submission time has been fixed.

    Please check and let us know if you are still facing any issues.

  • Profile Image
    lovehaniorg
    Answered on July 05, 2021 at 07:14 PM

    yeah..working good now..thanx...