• Resolved johan13

    (@johan13)


    I hope to receive some contribution from the WordPress and Forminator community

    I have integrated forminator with google Sheet, but we noticed that it appears in all fields with numbers, one (1) single quote on the left. I would like to know how I can remove it. With that error I cannot generate graphs.

    Here in the example:

    https://prntscr.com/thb0sv

    https://prnt.sc/thb16y

    I appreciate your prompt response

    • This topic was modified 3 years, 9 months ago by johan13.
    • This topic was modified 3 years, 9 months ago by johan13.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Predrag – WPMU DEV Support

    (@wpmudev-support1)

    Hi @johan13,

    I’ve checked submissions on my end and couldn’t replicate the issue with the export file neither in Google Sheets nor in Excel, it could be that something specific in your form is causing this.

    Could you provide us with an export file of your form so we can test it out on our end?
    You can go to Forminator > Forms panel, click on the Gear icon next to your form, export it from there and upload the export to any file sharing service like GDrive or Dropbox and provide us with the download link.

    If you don’t want to share your form publicly you can use our contact form:
    https://premium.wpmudev.org/contact/#i-have-a-different-question

    Send in:

    Subject: “Attn: Predrag Dubajic”
    – Download link to the export file
    – Link back to this thread for reference
    – Any other relevant urls/info

    Cheers,
    Predrag

    Thread Starter johan13

    (@johan13)

    Hi. I did the export directly with forminator to excel and the quote does not appear. It appears to only be reflected when connected to Google Sheet. I am going to share the form in the forminator so that you can take the test. Remember, you need to connect it to Google Sheet for them to see the results.

    https://url2.cl/PVGke

    Thanks, I’ll be attentive.

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @johan13

    I hope you are doing well.

    I’m afraid I couldn’t see the txt file.

    Could you please send the exported form using our secure from?
    https://wordpress.org/support/topic/sending-forminator-data-to-google-sheet-cells-with-numbers/#post-13131036

    Let us know when you sent it.
    Best Regards
    Patrick Freitas

    Plugin Support Dimitris – WPMU DEV Support

    (@wpmudev-support6)

    Hello @johan13

    It’s been a while since we’ve heard back from you so I’m going to mark this topic as resolved. You can still post back any updates and we can continue. 🙂

    Take care,
    Dimitris

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Sending Forminator data to Google Sheet (errors in cells with numbers)’ is closed to new replies.