Skip to main content

Formranger - a look at what you can do with the new Google Forms Add-on

Formranger allows you to populate multiple choice type questions in a Google Form with lists of possible responses in a Google Sheet. In addition, it allows you to repopulate the list after form submission - so the options you have for the next respondent can change based on the previous responses.

This might be used for bookings or options for events. So examples might include booking time for a parents evening or students picking activities with limited numbers of spaces per option.

I've done a brief demo of how you can do this and some of the formulas you might use in the video below:
The first example is for a parents evening booking system - the formulas I used are shown below.

Clearly, you would need to add this for each member of staff involved - but hopefully it illustrates the principle.

The second example  is for students picking from a list of activities where there are a limited number of places per option. Its far simpler not to have the remaining places appear on the form - but I thought it was worth demonstrating how it can be done.
Link to sheet

You could also use this add-on alongside Autocrat to email out a document showing people appointments. Formmule could email parents their appointments an teachers who is coming. Lots of possibilities.

Popular posts from this blog

Delete a specific email using GAM

If a user send an inappropriate email to a loads of people or get stung by some sort of email exploit you can quickly delete the email from all of the recipients using a GAM command.
Step 1 - get the email header Go into Google Vault and search for the offending user or someone known to have got the message.
Click show details and grab the email ID. This will be a long string of characters followed by
Step 2 - find out who has the email Go into Google Vault and find the original message sent by the offending user. Look at the details to see who got it. Copy the list and dump it into a spreadsheet. Clean up to just a list of emails with a column header 'mail'. Save as a csv file.
Step 3 - delete messages with GAM Put your CSV file in your GAM folder - this e.g. assumes its called mail.csv
gam csv mail.csv gam user ~mail delete messages query rfc822msgid:MESSAGEIDHERE doit

The alternative nuke option is:
gam all users delete messages query rfc822msgid:MESSAGEI…

ClearOS 7.1 as a Windows Domain Controller

I've been a long time user of ClearOS for gateway, DNS,DHCP, backup and a variety of other services. It is a Linux distro that is backed up with a marketplace of great apps that can be easily managed via a web config (although you can drop into cli whenever you want more control). The new samba directory app allows ClearOS to behave as a full on Windows Domain controller and file server without the cost of Windows Server.

So this is a demo from installation to a working DC and files server. Its about 40 mins for the full job - so skip though bits - gives you an example of what you can do. Please note the the Samba Directory App is currently in beta - but I've not spotted any bugs in a my test setup yet.

How to push bookmarks to users in Chrome via the management console

With the release of Chrome and ChomeOS 37 an update to the management console has arrived that allows you to push bookmarks to users.

Under Device Management > Chrome > User Settings > User Experience you will now find the option to add managed bookmarks.

In the example above, the bookmarks are applied to the sub-OU of 'students' - so all our students will get these bookmarks. Simply add your url and the bookmark name, click the + and save. These will appear in a folder called 'yourdomain bookmarks' - see below:

Be aware that to get these bookmarks applied on a Windows/OS-X device the user must be signed into Chrome. Update: if you install the latest group policy template you can push the bookmarks via policy on PCs - details are given here.
Video Guide: