Plugin Author
Meitar
(@meitar)
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.
http://ultratrailkathmandu.com/kathmandu-5050/registered/
Plugin Author
Meitar
(@meitar)
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)) {
Plugin Author
Meitar
(@meitar)
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.
Plugin Author
Meitar
(@meitar)
No, when I moved to the new Google Spreadsheets, I just re-created the forms.
OK, many thanks again Meitar.
