greenemnl

Yes thats what i mean :). Is this possible?

Hi,

I have the same problem, do you recall which plugin caused the problem?

Would greatly appreciate your help!

Regards,

Shanna

Hi Michael,
I was indeed the one with the related question form the other day.
I cannot get it to work with the regular code. It keeps giving the same error “Error: SyntaxError: Unexpected token: ? (line 79)”. When I use the code you suggested, i.e.
‘return content;’

rather than the standard
‘return JSON.parse(content);’

I don’t see an error message any more but rather all the content of the DB in a single cell. Obviously, I made sure that the password and other credentials have not been changed so do not seem to be the problem.

Your latest suggestion above to Cardboardmonet did not work for me. With the standard script I still get the error message “SyntaxError: Unexpected token: ? (line 79)”, while the added function json_parse gives “Error: SyntaxError: Unexpected token: # (line 86)”

Help is much appreciated, but I’ve somewhat given up at this point.

Regards,
Gijs

Many thanks!

Again, thanks for your quick reply.

Hmm. ok. Ive checked the following possibilities:
-doublechecked the login credentials
-doublechecked that the url prefix is correct (i.e. https://www.)
-changed the credentials to only include letters
-logged out of WordPress, and refreshed the sheet
-made sure the appropriate credentials have administrative rights.
-changed the name of the form to make sure it didn’t contain spaces or special characters.

But the exact same error persists.

Is there a way to see the error message in question? Perhaps there is something there to further help…

Regards,
Gijs

Hi Michael,
That was quick!

I am using the latest version of the plugin: 2.8.22.

I am a bit confused: in the export and shortcode builder, I’ve selected ‘Google Spreadsheet Live Data’. When using a limited set of variables, the URL in Google Spreadsheet works. When the generated URL became too long (due to the selection of columns and such), you see the function that Google Spreadsheet calls for. This function is:
‘=cfdbdata(“https://www.zonnigzeker.nl&#8221;, “Aanmeldformulier particulieren huishoudens – Zonnig Zeker Bunschoten”, “<login>”, “<password>”, “show”, “Submitted,aanhef,naam,postcode,huisnummer,contact-email,telefoonnummer,extrainformatie,verbruik,typedak,type_gebruiker,akkoord,Submitted Login,Submitted From,submit_time”)’

Per the instructions, I’ve changed the <login> and <password> in the function, and followed the instructions. In these instructions, I says to copy/paste the ensuing script file into the script editor.

Hope this makes sense…

Hi Daniel,

Just purchased the pro version… but the css you supplied no longer works.
I tried messing around with it to adjust it, but I’m unfortunately too blond for that.

Your help is much appreciated!

p.rating-item .mr-star-rating-select {
display: block;
}

Hi Daniel,

Cool, thanks!
Cheers
Gijs