Query for matching text using neoGSheets Plugin command
Quote from Gaev on May 15, 2020, 7:33 pmIn this forum topic ...
https://visualneo.com/forum/topic/neogsheets-google-sheets-plugin
... it says that ...
It is possible to query your Google Sheets using simple query sentences like:
select A, B, C where C <50 order by C asc
Where A, B, C are the columns letters.Everything works as expected when the searching for columns with numbers ... but this does NOT work ...
select A,B,C where A = 'someText'
... even when the cell values in column A are alphabetic.
@luishp discovered that this works ...
select A,B,C where A != 'someText'
... i.e. not equal comparison.
If anyone has managed to successfully query a sheet for matching text values, please post your query syntax here.
In this forum topic ...
https://visualneo.com/forum/topic/neogsheets-google-sheets-plugin
... it says that ...
It is possible to query your Google Sheets using simple query sentences like:
select A, B, C where C <50 order by C asc
Where A, B, C are the columns letters.
Everything works as expected when the searching for columns with numbers ... but this does NOT work ...
select A,B,C where A = 'someText'
... even when the cell values in column A are alphabetic.
@luishp discovered that this works ...
select A,B,C where A != 'someText'
... i.e. not equal comparison.
If anyone has managed to successfully query a sheet for matching text values, please post your query syntax here.
Quote from Gaev on May 17, 2020, 8:49 pmHappy to report that latest update of the plugin from @luishp appears to have fixed a multitude of unexpected results ... thanks.
The ability to access data stored in cells within Sheets of Google Spreadsheets is going to make VisualNEOWeb even more beneficial than it already is ... there are many, many applications of this facility beyond the obvious database Apps ... dynamic loading of ListBoxes, content management, blogs, emails to name a few.
Thanks again.
Happy to report that latest update of the plugin from @luishp appears to have fixed a multitude of unexpected results ... thanks.
The ability to access data stored in cells within Sheets of Google Spreadsheets is going to make VisualNEOWeb even more beneficial than it already is ... there are many, many applications of this facility beyond the obvious database Apps ... dynamic loading of ListBoxes, content management, blogs, emails to name a few.
Thanks again.
Quote from luishp on May 18, 2020, 10:47 amThe ability to access data stored in cells within Sheets of Google Spreadsheets is going to make VisualNEOWeb even more beneficial than it already is ... there are many, many applications of this facility beyond the obvious database Apps ... dynamic loading of ListBoxes, content management, blogs, emails to name a few.
Yes @gaev, probably even more that we can imagine at first. I have just discovered it's possible to import data from anywhere online into Google SpreadSheets and even automate it so the data is allways fresh using a timer:
https://www.benlcollins.com/spreadsheets/google-sheet-web-scraper/
https://hackernoon.com/3-best-ways-to-import-external-data-into-google-sheets-automatically-bw163yxm
And even more:
https://www.lovesdata.com/blog/google-sheets-tipsSo it's also possible to embed a Google Form into our apps and send the user data to a Google SpreadSheet and much, much more. Also almost any Google Drive document can be embedded into our apps.
Regards.
The ability to access data stored in cells within Sheets of Google Spreadsheets is going to make VisualNEOWeb even more beneficial than it already is ... there are many, many applications of this facility beyond the obvious database Apps ... dynamic loading of ListBoxes, content management, blogs, emails to name a few.
Yes @gaev, probably even more that we can imagine at first. I have just discovered it's possible to import data from anywhere online into Google SpreadSheets and even automate it so the data is allways fresh using a timer:
https://www.benlcollins.com/spreadsheets/google-sheet-web-scraper/
https://hackernoon.com/3-best-ways-to-import-external-data-into-google-sheets-automatically-bw163yxm
And even more:
https://www.lovesdata.com/blog/google-sheets-tips
So it's also possible to embed a Google Form into our apps and send the user data to a Google SpreadSheet and much, much more. Also almost any Google Drive document can be embedded into our apps.
Regards.