moshensky

Thanks for response, I appreciate it. And thanks for the issue as well.
I published 2.3.2 for all users.

@scottfrontline thanks for your response!
I made a quick fix. Looks like it’s related to jQuery version update inside WordPress core (method .complete was deprecated and removed in jQuery 3).

I haven’t pushed this version to all users yet, I want you @millionleaves @scottfrontline to make sure is everything all right and works fine. You can find version 2.3.2 with this fix on this page (bottom): https://www.ads-software.com/plugins/cf7-spreadsheets/advanced/

Please confirm everything works fine, so I can publish this version to all users. Thanks!

• This reply was modified 3 years, 11 months ago by moshensky.

Hello @millionleaves please provide, what versions of php / wordpress / cf7 / cf7 spreadsheeds are you using?

Fixed in v 2.3.1
Thanks for the issue.
Also thanks @marazmarci your workaround helped me a lot.

Thanks for issue. Right now there are no way to send service account data, but it’s good idea.
I’ll add it probably in the first half of October.

Was it trouble in your code, or something wrong with plugin? (for second option I’ll be happy if you contribute this on github)

Have you tried to use default CF7 button to send this request?

Does your request have this fields (you can check in browser debugger F12 => network):

_wpcf7: 44
_wpcf7_version: 5.2.2
_wpcf7_locale: en_US
_wpcf7_unit_tag: wpcf7-f44-p26-o2
_wpcf7_container_post: 26
_wpcf7_posted_data_hash: 
_wpcf7_recaptcha_response: 'xxxxxxxx'

Hello @jvasquez
Please write the full formula here in \` this quotes (or choose “code” in message commands).
Probably some escaped symbols…

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)

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

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

For example [_remote_ip].
Is it coming?

Try to figure it out somehow with formulas (you can parse string and process it as date.

https://stackoverflow.com/questions/48839999/automatically-convert-date-text-to-correct-date-format-using-google-sheets

Maybe here some useful.
Sorry, nothing more I can help in this case.

It should work as string (with singlequote symbol).

I just tested:
1) Send date as usual string.
2) Select column, Format->Number->Date in menu
3) Value changes to 08/26/2020

Hello. The best way to get this – is to change cells format to “date” directly in spreadsheet (for all column), values will be converted automatically.

Other way – send formula:
=DATEVALUE("[_date]")
But in result you’ll get integer value, so you should convert cells to “date” format anyway.

You not need to uninstall.
Just replace plugin folder.

Thank you too. I’ll publish 2.3.0 as default version to all users tomorrow.