Yes, there is a “Google Live Data” export options. Essentially you put a formula in the Google SS that pulls data from the WP site.
Hello Michel firstly thanks for this great plugin and your quick reply on this, I used it and it works very great,
My issues is with when i tried to submit the new data sheet is not get auto update , Is there any specific changes for auto update once form submitted
This is a Google SS issue. It updates intermittently when it feels like it. The only way to force it to update is to change the formula then change it back.
So what you trying to saying is we need to update this formula :
=IMPORTDATA(“http://test.com/wp-admin/admin-ajax.php?action=cfdb-login&cfdb-action=cfdb-export&form=Contact%20Us&username=test&password=test”)
manually over Google SS once we got to know the new form is submitted right?
I am ready for the launch tomorrow , Is there any short solution to fix this ?
What I’m saying is Google will update the data, but not necessarily when you want it. It caches the data.
To force an update, edit the formula to put in an invalid password for example, hit ENTER, then change it back to the right password and hit ENTER. That should trick Google into thinking it is a new formula and it needs to refetch the data.
Ha really a good one for my exact requirement, Thanks for the long look Michael.
