Query debug?

pls note that the backticks have been formatted out!

The two examples are shown here. Thank you for an assistance you can give.

https://www.dropbox.com/s/4x5v54e8pve2ec3/Screenshot%202014-11-23%2006.07.33.png?dl=0

https://www.dropbox.com/s/y5rmkiiniugi49g/Screenshot%202014-11-23%2006.08.06.png?dl=0

With column names that complex and with that many special characters, I’d suggest you use their positions instead of their names. In other words, try using a query value more similar to select A, B, C where A, B, and C are the letter-positions of the columns in your spreadsheet. (A is the left-most column, B the column to its right, and so on.)

Like this?

query="Select B, Q, T?order by Q desc"

Still not working for me and it is outputting the full range of columns.

https://ultratrailkathmandu.com/kathmandu-5050/registered/

Hmmm. Okay, thanks for providing a link to the page where this is an issue for you. I’ll take a closer look at this either tonight or tomorrow (I think/hope), and I’ll mark this as unresolved in the mean time.

Many thanks. This line (40) is returning false clearly.

if (preg_match('/\/(edit|pubhtml).*$/', $key, $m) && 'http' === substr($key, 0, 4)) {

Oh, your spreadsheet is using the “old” Google Sheets. The query attribute is only supported on new Google Sheets. Update your sheet to Google’s new implementation and replace the key in your shortcode with the full URL as described by this plugin’s README.

Sorry for being such a fool and wasting your time!

I am trying the upgrade. One question: have you any idea how to copy an old form over to a new sheet? Can’t find documentation for that.

Thank you again.

No, when I moved to the new Google Spreadsheets, I just re-created the forms.

OK, many thanks again Meitar.