![]() You might also want to look at how I’ve used a Google Form for Hacking stuff together with Google Spreadsheets: A simple electronic voting system, at the very basic level you’ve got a free SMS textwall to play with. In the example template I show how you can parse messages to generate a response graph. To receive messages tell users to send a text message to 07786 XXX XXX with ‘xyz and their message’ (where 07786 XXX XXX is the mobile number found in the Trial Service section and xyz is your username created with intelliSoftware). Copy the web app url into the address field and click Save.Click on Forwarding and change, tick ‘Enable incoming message forwarding’ and change forwarding type to http.Now open your IntelliSoftware control panel.Click Update and copy the service url you are given (it will look like /exec.and: – enter Project Version name and click ‘Save New Version’ – set execute web app ‘as me’ – security level as ‘anyone, even anonymously’ Select Run > setup and okay, then Publish > Deploy as web app.Open a copy of this Google Spreadsheet template (also free).Create a new SpreadSheet it will serve as SMS data storage and Octopush account credentials storage. Create an SMS data area Login into your Google account and switch to Google Sheets application. Signup for an account at intelliSoftware (it’s free!) Note: the username you select is also used to direct texts so you might want to use a class or course name) Start sending SMS via Octopush API directly from Google Sheets in roughly 5 minutes by performing 5 simple steps.If you would like to do this yourself here’s how: The method for doing this is relatively simple because the IntelliSoftware gateway has a HTTP interface and you can also use Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method. The main change is to directly ingest SMS messages into a Google Spreadsheet (using 30 lines of code) which makes it easier for manipulation and presentation. It does but I thought I could make it better. I was recently asked if the recipe would still work for this year’s conference. Last year a modified version of this was used to collect votes for the poster competition at eAssessment Scotland 2011. Votes were then extracted from messages from the blogs RSS feed using some PHP code on my server. This recipe automatically forwarded text messages from the IntelliSoftware SMS gateway to a blogger account using posting via email. Two years ago I wrote how you could have a free SMS voting using intelliSoftware SMS Gateway service. This method uses a UK based SMS gateway and most likely not suitable for international use
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |