/*
 * Author       : gccjason
 * Generated on : 24-Nov-2009 13:39:02
 * Version      : 3.0
 */
application "survey"
{
    type = public
    allow html = true
    date format = "dd-MMM-yyyy"
    time zone = "America/Los_Angeles"
    section survey_Home
    {
        displayname = "survey Home"
        form  form_34489000000003019
        {
            displayname  =  "CHURCH IT SURVEY"
            
            plain
            (
                type  =  plaintext
                value = "<DIV id=ted><SPAN style=\"FONT-WEIGHT: bold; TEXT-DECORATION: underline\">Welcome to the Church IT Survey</SPAN> .revA<BR><BR><SPAN style=\"FONT-WEIGHT: bold; TEXT-DECORATION: underline\">Purpose</SPAN>:&nbsp; Ever wonder what churches similar to you are doing IT wise?&nbsp; How many computers do they support?&nbsp; What's their IT staff size? Do they support multi-site, etc?&nbsp; Or what about those churches several steps ahead of you - what's their IT makeup look like?&nbsp; How should you plan now to be at that size in the future?<BR>What about trying to find churches around you with experience in VoIP, Virtualization, etc?&nbsp; Wouldn't it be sweet to have a resource that helped shed some light on these questions?&nbsp; Hopefully this survey can at least get you started in the right direction.<BR><BR><SPAN style=\"FONT-WEIGHT: bold; TEXT-DECORATION: underline\">Instructions</SPAN>:&nbsp; Be as detailed as you can.&nbsp; The more data you provide the better this resource will be for everyone.&nbsp; I'm still working on a way to allow future updates to your entries.&nbsp; <SPAN style=\"FONT-STYLE: italic\">Comments</SPAN>?&nbsp; Send them to Jason Powell (jasonpowell.net) via <SPAN style=\"FONT-STYLE: italic\">gccjason(at)gmail<BR></SPAN><BR>Export survey data to <A href=\"http://creator.zoho.com/gccjason/xls/4/\">XLS</A><BR>Export survey data to <A href=\"http://creator.zoho.com/gccjason/csv/4/\">CSV</A><BR><A href=\"http://creator.zoho.com/gccjason/rss/4/\">RSS feed</A> for survey submissions<BR></DIV>\n"
            )

            Church_Name
            (
                displayname  =  "Church Name"
                type  =  text
            )

            City
            (
                type  =  text
            )

            State
            (
                type  =  text
            )

            Web_Address
            (
                displayname  =  "Web Address"
                type  =  text
            )

            Average_Weekend_Attendance
            (
                displayname  =  "Average Weekend Worship Attendance"
                type  =  number
                width  =  20
            )

            Number_of_sites_campuses
            (
                displayname  =  "Number of sites/campuses"
                type  =  text
            )

            If_your_church_supports_a_school_how_many_students
            (
                displayname  =  "If your church supports a school, how many students"
                type  =  number
                width  =  20
            )

            Number_of_staff_including_part_time
            (
                displayname  =  "Number of church staff including part-time"
                type  =  text
            )

            Number_of_Part_time_church_staff
            (
                displayname  =  "Number of Part-time church staff"
                type  =  text
            )

            Number_of_computers_supported
            (
                displayname  =  "Number of computers supported"
                type  =  number
                tooltip  =  "total including desktops, laptops, macs, etc"
            )

            How_many_of_those_are_laptops
            (
                displayname  =  "How many of those are laptops"
                type  =  number
            )

            How_many_of_those_are_tablets
            (
                displayname  =  "How many of those are tablets"
                type  =  number
            )

            How_many_of_those_are_Macs
            (
                displayname  =  "How many of those are Macs"
                type  =  number
            )

            Supported_Desktop_OS
            (
                displayname  =  "Supported Desktop/Laptop OS"
                type  =  checkboxes
                values  =  {"Win 95",   "Win 98",   "Win 2000",   "Win XP",   "Win Vista",   "OSX",   "Linux"}
            )

            Do_you_have_a_Mac_support_policy_Yes_No_Briefly_explain
            (
                displayname  =  "Do you have a Mac support policy?  Yes/No?  Briefly explain."
                type  =  textarea
            )

            If_your_church_supports_a_school_how_many_of_the_above_PC_s_are_part_of_the_school
            (
                displayname  =  "If your church supports a school, how many of the above PC's are part of the school"
                type  =  text
            )

            Number_of_Servers
            (
                displayname  =  "Number of Servers"
                type  =  number
            )

            Supported_Server_OS
            (
                displayname  =  "Supported Server OS"
                type  =  checkboxes
                values  =  {"Win NT",   "Win 2000",   "Win 2003",   "OSX Server",   "Novell",   "Linux"}
            )

            If_Linux_what_flavors
            (
                displayname  =  "If Linux, what flavor(s)"
                type  =  text
            )

            What_is_your_email_solution
            (
                displayname  =  "What is your email solution"
                type  =  text
            )

            What_is_your_anti_spam_solution
            (
                displayname  =  "What is your anti-spam solution"
                type  =  text
            )

            What_is_our_database_solution
            (
                displayname  =  "What is your database solution"
                type  =  text
            )

            Other_server_solutions_you_re_taking_advantage_of_sharepoint_WSUS_etc
            (
                displayname  =  "Other server solutions you're taking advantage of (VMware Server, VMware ESX/VI3, SharePoint, WSUS, etc)"
                type  =  textarea
            )

            What_Church_Management_System_are_you_using_ACS_F1_Shelby_etc
            (
                displayname  =  "What Church Management System are you using (ACS, F1, Shelby, etc)"
                type  =  text
            )

            Server_space_being_utilized
            (
                displayname  =  "Server space being utilized"
                type  =  text
            )

            Using_a_SAN_What_make_model
            (
                displayname  =  "Using a SAN? What make/model?"
                type  =  text
            )

            Server_Backup_Software
            (
                displayname  =  "Server Backup Software"
                type  =  text
            )

            Phone_System_and_number_of_phones
            (
                displayname  =  "Phone/VMail System and number of phones"
                type  =  text
            )

            Internet_Bandwidth
            (
                displayname  =  "Internet Bandwidth"
                type  =  text
            )

            Public_Website_Host
            (
                displayname  =  "Public Website Host"
                type  =  text
            )

            Do_you_stream_your_services_What_media_encoder_What_streaming_host
            (
                displayname  =  "Do you stream your services? What media encoder? What streaming host?"
                type  =  textarea
            )

            Anti_virus_solution
            (
                displayname  =  "Anti-Malware solutions"
                type  =  text
            )

            Help_Desk_solution
            (
                displayname  =  "Help Desk solution"
                type  =  text
            )

            Event_management_solution
            (
                displayname  =  "Event/facilities scheduling solution (EMS, EventU, etc)"
                type  =  text
            )

            Staff_Intranet_solution_SharePoint_etc
            (
                displayname  =  "Staff Intranet solution (SharePoint, etc)"
                type  =  textarea
            )

            Do_you_develop_software_inhouse_What_purposes_What_platform_NET_PHP_etc
            (
                displayname  =  "Do you develop software inhouse? What purposes? What platform? (.NET, PHP, etc)"
                type  =  textarea
            )

            Current_IT_Positions_indicate_if_part_time
            (
                displayname  =  "Current IT Positions - indicate if part-time"
                type  =  textarea
            )

            Brief_history_of_when_positions_were_added_indicating_of_PC_s_supported_at_that_time
            (
                displayname  =  "Brief history of when positions were added (indicating # of PC's supported at that time)"
                type  =  textarea
            )

            of_General_Budget_for_IT
            (
                displayname  =  "% of General Budget for IT"
                type  =  text
            )

            Other_info_that_might_be_helpful_like_do_you_outsource_IT_roles_unique_situations_technology_etc
            (
                displayname  =  "Other info that might be helpful like do you outsource IT roles, unique situations/technology, etc"
                type  =  textarea
            )

            Survey_Completed_By
            (
                displayname  =  "Survey Completed By"
                type  =  text
            )

            Survey_Completed_on
            (
                displayname  =  "Survey Completed on"
                type  =  date
            )

            your_email_address_for_future_verification
            (
                displayname  =  "your email address for future verification ... suggest blah(at)blah(dot)com"
                type  =  text
            )

            What_s_your_person_blog_website_address
            (
                displayname  =  "Got a personal blog/website address"
                type  =  text
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                        on success
                        {
                            sendmail
                            (
                                To       :  "jpowell@gccwired.com" 
                                From     :  zoho.adminuserid 
                                Subject  :  "new survey data entered" 
                                Message  :  input.formdata 
                            )
                        }
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  survey1
        {
            displayname = "survey"
            show  all  rows  from  form_34489000000003019 
            (
                Church_Name as "Church Name"
                City
                State
                Web_Address as "Web Address"
                Average_Weekend_Attendance as "Average Weekend Worship Attendance"
                Number_of_sites_campuses as "Number of sites/campuses"
                If_your_church_supports_a_school_how_many_students as "If your church supports a school, how many students"
                Number_of_staff_including_part_time as "Number of staff including part-time"
                Number_of_computers_supported as "Number of computers supported"
                How_many_of_those_are_laptops as "How many of those are laptops"
                How_many_of_those_are_tablets as "How many of those are tablets"
                How_many_of_those_are_Macs as "How many of those are Macs"
                Supported_Desktop_OS as "Supported Desktop/Laptop OS"
                Do_you_have_a_Mac_support_policy_Yes_No_Briefly_explain as "Do you have a Mac support policy?  Yes/No?  Briefly explain."
                If_your_church_supports_a_school_how_many_of_the_above_PC_s_are_part_of_the_school as "If your church supports a school, how many of the above PC's are part of the school"
                Number_of_Servers as "Number of Servers"
                Supported_Server_OS as "Supported Server OS"
                If_Linux_what_flavors as "If Linux, what flavors"
                What_is_your_email_solution as "What is your email solution"
                What_is_your_anti_spam_solution as "What is your anti-spam solution"
                What_is_our_database_solution as "What is our database solution"
                Other_server_solutions_you_re_taking_advantage_of_sharepoint_WSUS_etc as "Other server solutions you're taking advantage of"
                What_Church_Management_System_are_you_using_ACS_F1_Shelby_etc as "What Church Management System are you using (ACS, F1, Shelby, etc)"
                Server_space_being_utilized as "Server space being utilized"
                Using_a_SAN_What_make_model as "Using a SAN? What make/model?"
                Server_Backup_Software as "Server Backup Software"
                Phone_System_and_number_of_phones as "Phone/VMail System and number of phones"
                Internet_Bandwidth as "Internet Bandwidth"
                Public_Website_Host as "Public Website Host"
                Anti_virus_solution as "Anti-Malware solutions"
                Help_Desk_solution as "Help Desk solution"
                Event_management_solution as "Event/facilities scheduling solution (EMS, EventU, etc)"
                Current_IT_Positions_indicate_if_part_time as "Current IT Positions - indicate if part-time"
                Brief_history_of_when_positions_were_added_indicating_of_PC_s_supported_at_that_time as "Brief history of when positions were added (indicating # of PC's supported at that time)"
                of_General_Budget_for_IT as "% of General Budget for IT"
                Survey_Completed_By as "Survey Completed By"
                Survey_Completed_on as "Survey Completed on"
                your_email_address_for_future_verification as "your email address for future verification"
                Number_of_Part_time_church_staff as "Number of Part-time church staff"
                Do_you_stream_your_services_What_media_encoder_What_streaming_host as "Do you stream your services? What media encoder? What streaming host?"
                Staff_Intranet_solution_SharePoint_etc as "Staff Intranet solution (SharePoint, etc)"
                Do_you_develop_software_inhouse_What_purposes_What_platform_NET_PHP_etc as "Do you develop software inhouse? What purposes? What platform? (.NET, PHP, etc)"
                Other_info_that_might_be_helpful_like_do_you_outsource_IT_roles_unique_situations_technology_etc as "Other info that might be helpful like do you outsource IT roles, unique situations/technology, etc"
                What_s_your_person_blog_website_address as "Got a personal blog/website address"
            )
            filters 
            (
                Supported_Desktop_OS
                Supported_Server_OS
                Survey_Completed_on
            )
            options
            (
                display rows = 100
            )
        }

    }

}