[Plugin: Contact Form 7 to Database Extension] Pull data in Google docs spreadsheet

the trigger runs the function when you open the document..

cant figure out hte line 66 bit ??

That https://object object suggest some javascript object that is not a string. Also the form=undefined…suggests undefined javascript reference.

I’ve been playing with refresh, here is a trick that seems to work.

1. Add a bogus additional input parameter to the functions. Example add a “1”:
=CF7ToDBData(“https://your-site.com”, “Contact form 1”, “”, “user”, “password”, 1)
2. Then when you want to force it to update, change that variable (change 1 to 2 for example). This tricks the SS into thinking the formula changed even though it ignores that last input.

i too cannot use this feature.
is possible schedule one time to view online and talk by google or skype?

I am using wpCAS to authenticate instead of the WordPress username and password. This prevents the live data connection. Is there a way to just check against username? I tried deleting the references to password with no luck.

If you have a different authentication method, you would have to change the Google script for the spreadsheet that the plugin provides. You would change the fetchCF7ToDBCSVResponse() function. In there it posts like it is the WP login form with “redirect_to” parameter to the actual URL it is trying to get to. You would need to do something similar.

In regards to wpCAS, I don’t it is possible to combine CAS authentication with the Google Live Data. It looks like by default the post method is blocked on our server end. Oh well. Thanks for the response.

I don’t know much about CAS. Conceivably the Google Spreadsheet could post to a CAS service to authenticate, maybe get a ticket (or some credential if it works that way), then submit that ticket to WP along with the request to get to the page. I don’t know if its worth the effort to figure it out.