G Gems 32: If you're Appy and you know it...

If like so many people,  you'd love to be able to set up your own app but don't have a clue where to start Glide might be right up your street.

Glide works with google sheets to help you create FREE apps within minutes.

This could be used for all manner of purposes including:

• PE Club Timetables
• Revision Session Timetables
• Holiday/Weekend Session Timetables
• Subject Apps with links to key resources
• Directories
• List of students and staff for trips
• many more uses

Here's a very basic screenshot of the sheet I used to test this out.  

I've included the type of social media platform and the link to them in separate columns. This is the result.

Pretty simple to do.



Here is how it appears in the app - I chose the dark mode setting but light is also available.


Click here to go to the live app




In your dashboard it's really easy to control and you can update your google sheet via the dashboard or in sheets itself.

Why not give it a try? You can be up and running in minutes!

G Gems 31: Just a quickie

It's been quite a while since I've had time to sit down and write a blog. There's been a lot going on in my real world of work and family so it's been hard to take the time to do anything lengthier than a quick twitter or Facebook post.

GMAIL updated

Overall I'm liking the new update to gmail app but the very white interface has certainly divided opinions. One thing I really like now is the right click option on an email that allows you to use the "find emails from" and "find emails with this subject" feature.




This has already proved very useful and has sped up my workflow.


Embed videos into Google Drawings

If you want to embed videos into Google Drawings, here's how to do that in this much under utilised tool by using google slides first.
(link: https://youtu.be/LhIruVqFZ1g)

Google Sheets for Education Support Staff

As I work very closely with a team of educational support staff, I'm always on the lookout for ways to make their lives easier in G Suite.  I've put together a Youtube playlist of google sheet videos and gifs that my team have found useful which you can view here: Google Sheets Playlist

The list includes topics like using sparklines, combining data from 2 cells into 1, conditional formatting based on contents of other cells and more...

(link: https://www.youtube.com/watch?v=Ixx0avkvY7I&list=PL6keua9v6pp3mZtPQxS_z9uPbm6nG3VHY)

If you or your school is interested in some bootcamp style training specific for Educational Support Staff, why not contact @Appsevents1 and see what can be arranged? 

If you are a member of Educational Support Staff, join my Facebook group too or follow the hashtag #googleESS for updates, tips and tricks. 

Thanks for reading, stay tuned for more.

(link: https://youtu.be/LhIruVqFZ1g)