Making Google Scripts & Google Sidebars Talk

flickr photo shared by Internet Archive Book Images with no copyright restriction (Flickr Commons) Sometimes you want a Google Sidebar element to be able to pull variables from a Google Script. The key element is google.script.run.withSuccessHandler. I’m still not entirely sure I have this in my head deeply/correctly but this is functional and might help […]

Read More… from Making Google Scripts & Google Sidebars Talk

Interactive Google Sheets Dashboards

It’s pretty easy to put a bunch of data and charts in a spreadsheet and call it a dashboard. It became a more interesting challenge to make those charts change to reflect variables chosen via dropdown cell menus. The key it turns out is using =query. I can do some really powerful things with query […]

Read More… from Interactive Google Sheets Dashboards

Spreadsheet Karma

=QUERY({C:C,C:C},”select Col1, count(Col2) where Col1 ” group by Col1″,1) This is just so handy for getting all the unique values from a column and spitting them out with the counts of their occurrences.1 I can’t tell you how many times I’ve done this a much harder way. I saw the function above as an answer […]

Read More… from Spreadsheet Karma

Weekly Web Harvest for 2016-10-09

Monday Night Raw To Host Presidential Tables, Ladders, and Chairs Match —ouch. The school also plans to host various social media workshops focused on teaching people how to effectively communicate via social media. These seminars will cover subjects like, do’s and don’ts of Facebook (with an emphasis on posting “like a mom”), what all the […]

Read More… from Weekly Web Harvest for 2016-10-09

Weekly Web Harvest for 2016-10-02

The mystery of the ‘ghost trees’ may be solved – SFGate Redwoods can also clone themselves, further complicating scientists’ understanding of them. Vast rings of related plants communicate via their roots, and during the hard months of winter and early spring, they’ll distribute nutrients evenly among themselves. Scientists have spilled dye onto trees at one […]

Read More… from Weekly Web Harvest for 2016-10-02

Setting Cell Values – Google Forms/Sheets Workflow

flickr photo shared by Internet Archive Book Images with no copyright restriction (Flickr Commons) Often, people really like the workflows enabled by Google Forms but they’d like it to go one step farther . . . like adding up two submitted items, or running a particular function/formula against the submitted data. You can certainly go […]

Read More… from Setting Cell Values – Google Forms/Sheets Workflow

Weekly Web Harvest for 2016-09-25

Size Matters – Futility Closet Olives counting 120-135 olives per pound: Standard Olives counting 105-120 olives per pound: Medium Olives counting 90-105 olives per pound: Large Olives counting 75-90 olives per pound: Extra Large Olives counting 65-75 olives per pound: Mammoth Olives counting 55-65 olives per pound: Colossal Olives counting 45-55 olives per pound: Giant […]

Read More… from Weekly Web Harvest for 2016-09-25