English Month in Submit Date

  • Resolved woernib

    (@woernib)


    2 years, 6 months ago

    Although in WordPress Settings->General the Website Language is set to “Deutsch” (German) and the Date Format is “j. F Y”, the submit date is passed as “20. May 2022” (english month name) to Google Sheets. It should be “20. Mai 2022” and should also be formatted as date and not as text. What am I doing wrong?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author westerndeal

    (@westerndeal)

    Hi @woernib,

    GSheetConnector just fetches the posted data submitted by CF7 and saves it to the Google Sheet.

    $submission->get_posted_data()

    Is your front-end date field displays date in Deutsch format?

    If you just need the form submitted date then you can simply add a “date” special mail tag as a header to your Google Sheet. This will display date as per set in WordPress General Settings.

    Hope this helps. Let us know.

    Thanks
    Abdullah

    Thread Starter woernib

    (@woernib)

    Hi @westerndeal,
    Thanks for the quick reply. Yes, I created the first column in the Google Sheet as “date”, the form submission date is also transferred, but unfortunately not with the German month name, as you can see here:
    https://thank-god-its-monday.org/people-first/CF7%20Google%20Sheets%20Connector%20Problem.pdf
    Any ideas?

    Plugin Author westerndeal

    (@westerndeal)

    @woernib

    Make sure both the field names must be different else it will override.

    Just test as below.

    1st change the name of the Date Field added by CF7 as “submit-date” or something that is easy for you to understand.

    2nd place “date” as a header on your Google Sheet( you have already added )

    Lastly, check that it saves date in your language.

    let us know.

    Thread Starter woernib

    (@woernib)

    Problem still exists. But, if in Settings/General I change the date format to custom date “d.m.Y” and in Google Sheet I format the date column to custom format like “5. August 1930” the form submission date will appear as “25. Mai 2022” (as expected).

    I think if CF7 Google Sheets Connector would transfer just a native date without considering the WordPress date format settings it would work much better because you can specify the date format independently in Google Sheets.

    Thanks for your support, I’ll mark the topic as resolved.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘English Month in Submit Date’ is closed to new replies.