moshensky

Ok, unfortunately CF7 creator declined my pull request.
Looks like he want’s to fix this in version 5.2.2, but he haven’t clarified about any term (when it will be).

So I decided to make fix in CF7 Spreadsheets.
I created version 2.3.0, @manuluyten @positivit could you please try is everything fine on this version and respond to me? (I want to be sure is everything fine, before publish it to all users).
You can find version 2.3.0 on “Advanced view” link under the charts.
https://www.ads-software.com/plugins/cf7-spreadsheets/advanced/

Hello @takayukister I got this trouble as well. I created PR on github: https://github.com/takayukister/contact-form-7/pull/133

@manuluyten @positivit
small update: I created pull request to CF7 repository, to fix this bug
https://github.com/takayukister/contact-form-7/pull/133

I’ll keep you in touch!

Hello @manuluyten
Thanks, that’s really helpful!
If you want – you can create PR to https://github.com/moshenskyDV/CF7-spreadsheets

Or, I’ll do it in a 5-6 hours (please write if you want to do it).

What version of PHP enabled on your machine/hosting?

Have you found error after CF7Spreadsheets update, or after WordPress update, or after CF7 update, or maybe after some server configuration update?

Hello @demenyzo
I tried to send email on your website. Everything works well for me, probably because you disabled the plugin. Could you please do a small investigation:

1) Open the page with form and press F12. Find “network” tab and open it.
2) Do your email form request (as usual)
3) You should see new request in that tab with address like: https://YOUR_WEBSITE/wp-json/contact-form-7/v1/contact-forms/44/feedback, click on it
4) Click on subtab “preview” or “response” and send me please the text (if it contains any sensitive data – please hide it by asterisks ********.

Thanks.
PS: sorry for long response, don’t know is it still matter to you?

Hello @positivit
Could you please find some additional information to help me debug your issue:
1) Near browser console tab – find “network” tab and open it.
2) Do your email form request (as usual)
3) You should see new request in that tab with address like: https://YOUR_WEBSITE/wp-json/contact-form-7/v1/contact-forms/44/feedback, click on it
4) Click on subtab “preview” or “response” and send me please the text (if it contains any sensitive data – please hide it by asterisks ********.

Thanks.
PS: really plugin hasn’t been maintained for a long time, I was a really busy. Looks like something wrong in global, because plugin active users amount reduced a lot. Need to fix it asap.

About time – our plugin it’s just a middleware between CF7 and google sheets. It don’t control data, generated by CF7 (in email should be the same date).

I looked into CF7 docs, but unfortunately I haven’t found any tips about timezones.
https://contactform7.com/special-mail-tags/

BTW: I have bitcoin wallet for donations, I’ll configure donation link as other developers do (in left column of plugin page) in future releases.

I glad that you found solution!

Try to make your spreadsheet public for a minute and send form when it’s public.
If form arrives correctly – you have issues with permissions.

W8 for your response.

@stefanando
I’ve just looked to your form and found, that it hasn’t permissions to write to google sheet.
Please, make sure you granted “edit” access to your spreadsheet by service account email.

View post on imgur.com

Yep, actually I don’t see necessary to support multiple google service accounts on one website.

Try to go through this checklist:
1) Make sure Spreadsheet URL and ID is correct.
2) Make sure your service account email added to spreadsheet “edit” access group.
3) Go to console developers dashboard and check if there are any errors (and total amount of requests is correct?)

Hello @stefanando
Have you clicked “Save” button on third tab of plugin? (“output”)

It should be clicked to initialize post_meta. It should be clicked one time for each form in selectbox.

• This reply was modified 4 years, 8 months ago by moshensky.

Hello @juanchopaul23
Thanks for your feedback. Below is explanation, why it’s complicated to configure and why we can’t avoid it.

https://github.com/moshenskyDV/CF7-spreadsheets/issues/9#issuecomment-605608358

@arabtornado thanks a lot for idea. Really with WPCF7_Submission much easier than with $_POST. I’ve done with this feature.

PS: do you want to try new version before I landed it to all users?
I found that wordpress SVN repository is able to store a couple of stable/unstable versions. You can find version 2.2.4 by this link (on the bottom).
I’ll wait for your review for a week, if everything OK – I’ll push this version as stable to all users. Thanks a lot for solution!

Hello. Thanks a lot about issue.

My last changes affected placeholders ??
Here is details.

I did small rollback, so if you update plugin – all going to be all right.
Please notify me if something still wrong.

PS: I won’t close this issue until issue by link is done.