Zoho+Creator+and+Survey+Monkey

toc = =
 * Zoho Creator and Survey Monkey **

=Survey Monkey= [|Link to workshop survey] media type="custom" key="2089255"

Example of Cluster Survey Questions
See the questions I designed for our cluster survey (these should only be considered a guide - you need to decide as a cluster what is important for YOUR cluster to collect information on). To download this word doc, visit the [|Scribd site where I have uploaded it] to grab it from there.

media type="custom" key="2116045"

=Zoho Creator= media type="custom" key="2089321"

Here is the script for restricting numbers in workshops. You will need to go into the script tab and then into Free-flow scripting to paste this in. code if (count(Expo[Workshop_one == input.Workshop_one]) >  18) {   alert "Please reselect as you currently have chosen a workshop option that is full. Until you reselect, you won't be able to submit this form."; cancel submit; } if (count(Expo[Workshop_Two == input.Workshop_Two]) >  14) {   alert "Please reselect as you currently have chosen a workshop option that is full. Until you reselect, you won't be able to submit this form"; cancel submit; }

code NOTE **: the names of the workshop fields need to be the same as the ones you make for your form. ie I made a form which included a drop down menu of options called 'Workshop one'. This appears in this script as Workshop_one. You will need to replace this with whatever you label your field in the form. Obviously if you have more than two workshops, you will need more lines of code.

Zoho Creator Form and View Example
media type="custom" key="2089147"

Here are the results from the form. Note that I have been able to remove the columns with email addresses and ages so that you might feel more comfortable about having this online (you can do this when editing the view for a form by hovering mouse over number of columns to display and clicking edit)

media type="custom" key="2115945"

Zoho Video Tutorials
These show the basics for building and embedding forms (note that Zoho Creator has had a face lift since I made these movies so some things will look a little different but the process is pretty much exactly the same - the slideshow above has more up-to-date screenshots). [|How to create a simple form]

[|How to embed a form and access and download the data entered into the form]