Can’t get date and time value

  • Hello,

    1st thanks for the plugin which is great.

    I follow all the steps and I get my form data in Google Sheet.

    But I also need date and time value and they are always empty in my sheet ?

    I tried with the field names ([_date] [_time]) or formula =DATEVALUE(“[_date]”) but in both cases this doesn’t work

    What can I do to solve this issue ?

    Regards

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author moshensky

    (@moshensky)

    Hello @tom13c
    Have you tried to send something else from “special mail tags for submissions”?

    For example [_remote_ip].
    Is it coming?

    Thread Starter tom13c

    (@tom13c)

    Hello,

    I just tried [_remote_ip] and [_user_agent] and I get the data.

    But with [_date] and [_time] still nothing ?

    Regards

    Plugin Author moshensky

    (@moshensky)

    Really strange. I have no idea how this possible, sorry

    Thread Starter tom13c

    (@tom13c)

    OK

    Thanks for your help. I will deal with that.

    Regards

    Plugin Author moshensky

    (@moshensky)

    Do you have a test website (please do not send real one, that could contain sensitive data) where issue is reproducing and you can share it to me to check?

    Other thing – you can install some debug plugins, like: https://www.ads-software.com/plugins/query-monitor/
    (or if you fine with code – enable WP_DEBUG mode, send one test message to spreadsheet and check if any errors/warnings in the log)

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Can’t get date and time value’ is closed to new replies.