/*
 * Author       : jdfan
 * Generated on : 22-Nov-2009 21:32:35
 * Version      : 3.0
 */
application "Indie Friendly Radio Database"
{
    type = public
    allow html = true
    date format = "dd-MMM-yyyy"
    time zone = "America/Los_Angeles"
    section View
    {
        list  Complete_list1
        {
            displayname = "Complete_list"
            show  all  rows  from  Indie_Friendly_Radio_Database_Form 
            (
                Station_name as "Station name"
                Frequency
                Formats
                Type
                Address_line_1 as "Address line 1"
                Address_line_2 as "Address line 2"
                City
                State
                Zip_postal_code as "Zip/postal code"
                Country
                Office_phone as "Office phone"
                Fax
                Request_line as "Request line"
                Email
                URL
                Contact_s_name as "Contact's name"
                Contact_s_job_title as "Contact's job title"
                Contact_s_email as "Contact's email"
                Contact_s_phone as "Contact's phone"
                Comments
                radioid
            )
            filters 
            (
                Formats
                Type
                Country
                "Just US"  :  Country == "US"
                "Non US"  :  Country != "US"
            )
            options
            (
                display rows = 20
            )
        }

        form  Indie_Friendly_Radio_Database_Form
        {
            displayname  =  "Radio Stations"
            
            radioid
            (
                type  =  number
                width  =  20
                maxchar  =  99
                tooltip  =  "Web application"
            )

            must  have  Station_name
            (
                displayname  =  "Station name"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Frequency
            (
                type  =  decimal
                width  =  20
                maxchar  =  99
                tooltip  =  "Web application"
            )

            must  have  Formats
            (
                type  =  picklist
                values  =  {"FM",   "FM Streaming",   "Podcast",   "FM AM",   "Streaming",   "Streaming Podcast",   "AM Streaming",   "AM",   "FM Lowpower",   "Cable",   "AM Lowpower",   "AM Streaming Lowpower",   "FM AM Streaming",   "FM Streaming Lowpower",   "AM Streaming Cable",   "FM Streaming Podcast",   "FM Streaming Cable",   "Streaming Cable Podcast",   "Streaming Cable",   "FM Podcast",   "FM Cable"}
                sortorder  =  ascending
                tooltip  =  "Web application"
            )

            must  have  Type
            (
                type  =  picklist
                values  =  {"Community",   "Commercial",   "Indie",   "Other",   "College",   "HS",   "PR"}
                sortorder  =  ascending
                tooltip  =  "Web application"
            )

            Address_line_1
            (
                displayname  =  "Address line 1"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Address_line_2
            (
                displayname  =  "Address line 2"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            City
            (
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            State
            (
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Zip_postal_code
            (
                displayname  =  "Zip/postal code"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Country
            (
                type  =  picklist
                values  =  {"Australia",   "Austria",   "Belgium",   "Canada",   "England",   "France",   "Germany",   "Internet",   "Ireland",   "New Zealand",   "Scotland",   "Sweden",   "US",   "Wales",   "Yugoslavia",   "New"}
                tooltip  =  "Web application"
            )

            Office_phone
            (
                displayname  =  "Office phone"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Fax
            (
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Request_line
            (
                displayname  =  "Request line"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Email
            (
                type  =  email
                width  =  25
                tooltip  =  "Web application"
            )

            must  have  URL
            (
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Contact_s_name
            (
                displayname  =  "Contact's name"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Contact_s_job_title
            (
                displayname  =  "Contact's job title"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Contact_s_email
            (
                displayname  =  "Contact's email"
                type  =  email
                width  =  25
                tooltip  =  "Web application"
            )

            Contact_s_phone
            (
                displayname  =  "Contact's phone"
                type  =  text
                width  =  25
                tooltip  =  "Web application"
            )

            Comments
            (
                type  =  textarea
                width  =  5 , 25
                tooltip  =  "Web application"
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

    }

    section New
    {
    }

}