Google Sheet, column with date()

  • Resolved Alex 六十 Karpov

    (@justsmilepeople)


    4 months, 1 week ago

    Hello Forminator team,
    I noticed a small issue when integrating a form with Google Sheets: when data is sent to a date column, an apostrophe (‘) appears before the actual date value. I understand this might be done to preserve the text format of the date, but in my case, the Google Sheet is already correctly formatted to use the Date type.
    It would be great if there were an option in the integration settings to disable adding this character, so dates could be transferred directly as proper date values without the extra symbol.
    Thank you for your great plugin and the work you do!

    https://i.vgy.me/ZT8XyW.png

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    4 months, 1 week ago

    Hello @justsmilepeople

    Hope you are doing well today.

    This is expected behavior beacause Forminator adds the apostrophe to tell Google Sheet don’t convert these to number and treat them as text/string.

    Sometimes it can break and modify the date while it is automatically sent to Google sheet, you can create script or help column to fix this but I will ask our developers to see if we can do anything about it in our end.

    The following example formula can help remove the apostrophe from date field:
    =DATEVALUE(SUBSTITUTE(A2,"'",""))

    Best Regards
    Amin

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    4 months ago

    Hi @justsmilepeople,

    Since we haven’t heard from you for a while. I’ll mark this thread as resolved for now. Please feel free to re-open this thread if you need any further assistance.

    Best Regards,

    Nithin

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.