Skip to main content

Posts

Showing posts from 2020

How To Create An Android App That Posts Pictures To Google Sheets

I used the MIT App Inventor site to create an Android app that... Uses the camera to take a picture and saves it to the device's gallery Let's you select a picture from the gallery The image is converted into base64 and uploaded to a web app Additionally, it also sends rotation and lat/lng coordinates and lets you add a textual comment as well. This Android app sends it to an Apps Script web application inside a Google Spreadsheet here . The web application saves the image to Google Drive, makes a thumbnail of the image then gets the latest 3 thumbnails from the sheet and returns it.  Inside the Android app is a WebViewer component that displays those images, that gets updated once the image is uploaded. It's not pretty but it works. This app wouldn't be possible without the TaifunFile, TaifunTools and SimpleBase64 extensions. Thanks, all. The App Inventor code is here .  You can import an .aia file directly into MIT App Inventor. There was some tricky stuff, having to

Using Google Sites As Portfolio Projects

Just completed another project where 40 students used (old) Google Sites (because they are Apps Scriptable) as Portfolio Sites. Each student gets a copy of a template site. After they have worked on it, and the deadline has arrived, they are given a COPY of their site (and made EDITOR), and they are removed from their original site. If the student wants to invite a personal Gmail account to this new site, and then that personal Gmail account makes a Copy of it, it is removed completely from the york domain - meaning when the student leaves, it won't be deleted. They can keep it forever. They THEN can, if they choose, upgrade their site to New Sites and make it look a bit fancier. If you want to do this, make your Template Site in Classic Sites, then... File > Make a copy , fill in your students https://docs.google.com/spreadsheets/d/1qojHKcmaMyxyzHd8HNxgm2OEMSgBbg_i4PmYT53qkQU/edit?usp=sharing   edit the code Tools > Script Editor where it says CHANGE_THIS  Here are the ins

What's Going On?

About me   My Work At University of York A list of old projects here including a Marking App,  an iPad app and 3Sixty installation. Scraping "Sugar Tax" information from UK Government sites then running with semantic and sentiment analysis. Playing with scraping Box of Broadcast transcripts, and automatic MoviePy editing.   Chapbooks in the Borthwick on Glitch in Django Remix here:  https://glitch.com/edit/#!/chapbooks Including the Augmented Reality Christmas Jumper Orchestra.

A Working Booking System In Google Sheets

Working with Andras Sztrokay we had another go at a booking system. This time it was to enable staff to book out a number of iPads over a number of days. You select the days you want, then select the Booking menu. Andras did an amazing job. It even creates a daily bookings sheet so you can see who has which iPads. To see this in action, go  here  and  File > Make a Copy (I won't be able to support you this is just provided to maybe give someone else a leg up, good luck!)