When using orderby Google Live spreadsheets returns Unknown function: 'cfdbdata'

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.

Hi,

Yes, it works just fine without ordering.

Here’s what I want to output:
=cfdbdata(“https://www.verslopraktikos.lt&#8221;, “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;
    }

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):

https://YOUR_SITE/wp-admin/admin-ajax.php?action=cfdb-export&enc=GLD&form=FORM_NAME

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.

Hi,

I have no idea why, but today output is ordered properly without using ordering function.

Thanks for your time ??

Regards,
Rokas