I have someone who gathered a bunch of tweets for their research using Martin’s TAGS aggregator. She wanted to show all the avatars. Once I published the spreadsheet, here’s all the javascript needed to make that happen. It’s lightly annotated for your reading pleasure and the functioning codepen example is included below. See the Pen […]
Category: Data
Monthly Reporting, A Gravity Forms to Google Forms Love Story
Well not really but I’ll explain it anyway. Gravity to Google There are a number of plugins that tie Gravity Forms to Google Sheets but most (all?) of them rely on the ability to create an application to get authentication tokens. Many institutional accounts turn off that capability. VCU has turned that off. As a […]
Read More… from Monthly Reporting, A Gravity Forms to Google Forms Love Story
Justify Your Year – 1 Page Front and Back
We’re getting a new supervisor in the near future so we were asked to write up a success/challenges<footnote>See how I made them opportunities? ABC baby. ABC. Or ABC if you’d prefer. I’m good with either.</footnote> sheet to give them an idea of what’s working for our various groups and what’s giving us problems. I thought […]
H Tags and Auto-Constructing an Anchor Index
Origin Story I got a fairly dense Word document that needed to go online in way that people could more easily navigate. After checking it out, it appeared we had a large number of sections but we were lucky in that they were designated by H tags of various levels. Now I could have gone […]
Read More… from H Tags and Auto-Constructing an Anchor Index
Persistent Check Off List
Origin Story We’re doing the Photography is Magic course again this semester. One thing we do the first week is go around and the room and students say a word that has something to do with their major, life etc. We also name some cliche image types from Instagram. We end up with a large […]
Making an Index Using Javascript
Working with a faculty member we had a rather long page that was originally written in Google Docs. It had many sections that were (mostly) designated by H tags of various denominations. The goal was to and put it on a website quickly build an index of anchor links. I did not wish to do […]
Google Sheets Data Flow
This is a pretty specific thing but the concepts ought to be broadly applicable and interesting for the 3 to 5 people who will end up reading this. It’s a fairly amusing blend of less standard Google Functions and a bit of Google Script to do something fairly decent that had been quite a bit […]
Starting to Think Through a Mapping Theme with ACF
We’re working with Dr. Nicole Turner on a mapping site that will accompany her upcoming book. There’s a lot of specifics there which we’re considering while trying to walk the fine line where what we make is also something we’ll be able to use with other people down the road. We want to generalize but […]
Read More… from Starting to Think Through a Mapping Theme with ACF
Social Media Jujutsu
Jujutsu1 is a martial art focused on using your opponent’s momentum against them– clever redirection of force rather than trying to meet it directly. This seems like it might be an option for some of today’s social media woes where people are trying to continue to take advantage of the good aspects of these tools/communities […]
Weather API + Google Sheets
I have many little robot scripts busy saving data to Google Sheets. Here’s one I made based on a little comment from one of my kid’s teachers. It goes to a very kind URL that returns the data structure at the bottom of the page. http://api.wunderground.com/api/YOUR_API_KEY/conditions/q/VA/Richmond.json It’s a pretty nice starter script for anyone wanting […]