Please post the function that you are using in your spreadsheet (but remove your WP login information).
Does it work when not using orderby? Please post that as well.
Thread Starter
TMNR
(@tmnr)
Hi,
Yes, it works just fine without ordering.
Here’s what I want to output:
=cfdbdata(“http://www.verslopraktikos.lt”, “Registracija į Verslumo laboratorijas new”, “<user>”, “<password>”, “orderby”, “Submitted,hidden-842,hidden-844,hidden-843,klausimas-1,klausimas-2,klausimas-3,klausimas-4,klausimas-5,klausimas-6,klausimas-7,tvirtinu,Submitted From”)
Thanks,
Rokas
It looks correct.
Tell me more about how it does not work. What happens? What do you see in the cell after the formula is entered?
This might help to show errors:
In the cfdbdata code, replace this line
return JSON.parse(content);
with this:
try {
return JSON.parse(content);
} catch (e) {
// If exception, just return the content error message
return content;
}
Thread Starter
TMNR
(@tmnr)
Hi,
This is what it looks like with the formula I provided above.
If I choose only couple of filters, say, Submitted,hidden-842,hidden-844,hidden-843 – the output is no different as with no filters at all.
Also, could you please clarify where to put the code? I have tried to add it to the CFDBGoogleSSLiveData.js file, it looks like this, but I just get the same error.
Thanks,
Rokas
You are confused. You have to add the javascript code to the script editor of your Google Sheet, not the WP plugin file. That javascript code runs in the Google Sheet.
Follow the instructions (change YOUR_SITE):
http://YOUR_SITE/wp-admin/admin-ajax.php?action=cfdb-export&enc=GLD&form=FORM_NAME
Thread Starter
TMNR
(@tmnr)
I am. You’ll have to give me a better explanation.
When I open script editor in Google spreadsheets I only get the following:
- Code.GS file with
function myFunction() {} – there’s nothing to replace
- When I change url to proper site name and form name I just get this error:
You do not have sufficient permissions to access this page.
Replace “myFunction() {}” … paste the script code as stated in the instructions.
Thread Starter
TMNR
(@tmnr)
Hi,
I have no idea why, but today output is ordered properly without using ordering function.
Thanks for your time 🙂
Regards,
Rokas
