Hello, I hope I've found the right place to post this. *If not—if someone could kindly point me in the right direction, thanks!*
I'm trying to figure out how to use a query URL in one sheet to point to another. So far, I've got this working: https://docs.google.com/spreadsheets/d/17c8P5AW3UscUWg5TIe0Wl1zpbtFtH94QnVABiJa-s2E/edit#gid=1145999028 But when I try to do this: https://docs.google.com/spreadsheets/d/17c8P5AW3UscUWg5TIe0Wl1zpbtFtH94QnVABiJa-s2E/edit#gid=414291241 I can't get the expected result, which should look like this http://SWCT-SoldOutEarly.tk My query is *SELECT * WHERE D like '%/%'*, but it's not pulling up anything like it should. To explain what the query is looking at, it's a database of cards and stats. Column C is the card name, D is how many are in circulation. It's either currently unknown like "?/5000" or in progress of selling out "1234/5000" or sold out "5000" and Column E will have an asterisk if that card is sold out. If a card has an asterisk AND has an in-progress type number, then it's considered to have sold out early (hence the short URL, above). What I'm looking for is a URL like this: https://docs.google.com/spreadsheets/d/1kGOaqMf1b2qG1WRpIGON8OKRWdG1rIL-WuDjoU95J4U/gviz/tq?gid=925237019&tqx=out:html&tq=SELECT+*+WHERE+D+LIKE'%/%'+AND+E='*' ...but that actually works, haha. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
