+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 40
Coding Thread, Creating a form in Coding and Web Development; Hi all, Sorry if i have posted in the wrong place, I need to create a form that i can ...
  1. #1

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Cool Creating a form

    Hi all,
    Sorry if i have posted in the wrong place, I need to create a form that i can host on our intranet. This will be a form that teachers can fill out when incidents have happened in their classroom etc. Whats the best and easiest option of doing this?

    Thanks All !

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,689
    Thank Post
    334
    Thanked 515 Times in 483 Posts
    Rep Power
    179
    Depends how complex you want it to be, we have a few around the schools for different things, from as simple as an Access database with GUI front-end, to Sharepoint built form linked into SQL database etc.

    A lot of it depends on whether you want everyone to have access to see it, only certain people, what platforms you're running (in regards to the web end etc)

    Steve

  3. #3

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Well I want the teachers to fill out the form which is just composed of text boxes to email it when it is submitted , I have looked into Google forms . Has anyone else used these ?

  4. #4

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,096
    Thank Post
    407
    Thanked 310 Times in 262 Posts
    Rep Power
    152
    Quote Originally Posted by lholland421 View Post
    Hi all,
    Sorry if i have posted in the wrong place, I need to create a form that i can host on our intranet. This will be a form that teachers can fill out when incidents have happened in their classroom etc. Whats the best and easiest option of doing this?

    Thanks All !
    what kind of incidents? If its to do with students then surely it should be recorded in your MIS directly. If its IT related incidents then a helpdesk like spiceworks would be the way to go.

  5. #5

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I did think they should be going straight into the mis. According the the pastoral manager they do record incidents into the mis but they do not want to record incidents like late homework /coursework etc into the mis hence why they have asked for some sort of form.

  6. #6

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    I assume they have considered Data Protection and the scenario where a pupil comes back in 5 years time and asks for all documentation recorded against him/her?

  7. #7

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I would like the think so but chances are they haven't :/

  8. #8

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by lholland421 View Post
    I would like the think so but chances are they haven't :/
    Probably not . It's what the MIS is built for.

  9. #9

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,623
    Thank Post
    1,240
    Thanked 777 Times in 674 Posts
    Rep Power
    235
    Quote Originally Posted by lholland421 View Post
    I need to create a form that i can host on our intranet. This will be a form that teachers can fill out when incidents have happened in their classroom etc. Whats the best and easiest option of doing this?
    What does your intranet consist of - a web server of some kind? A simple CGI script that takes input from a basic web-based form and emails it in to a specific address would probebly be the simplest option. Ideally it would submit the data straight to your MIS, but it sounds as though that's proving difficult, so an email would do. Just from a data protection point of view, as pointed out already, a search through your email archive would then find the information about a particular pupil recorded as an email, which should cover you.

  10. #10

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We are running an apache webserver on ubuntu. I want the form to be sent to our local exchange server. Could you point me in the direction for a cimple CGI script? Cheers

  11. #11

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Any help is appreciated

  12. #12

    Join Date
    Jan 2008
    Posts
    93
    Thank Post
    6
    Thanked 18 Times in 14 Posts
    Rep Power
    17
    I did this in Access (split front end and back end) until we were ready to use our MIS. That was for a handful of users though. You could use Google forms, which I like a lot, but whatever you go for if it's not the MIS will get messy over time as staff and students leave/join/go up a year. The potential for data inconsistency is huge. I would definitely use your MIS if you can.

  13. #13

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,623
    Thank Post
    1,240
    Thanked 777 Times in 674 Posts
    Rep Power
    235
    Quote Originally Posted by lholland421 View Post
    We are running an apache webserver on ubuntu. I want the form to be sent to our local exchange server. Could you point me in the direction for a cimple CGI script?
    The following is a Python CGI script I use for our helpdesk submition form. This goes in /usr/lib/cgi-bin/submitProblem.py on our Debian machine (probably the same for your Ubuntu machine), which is owned by www-data:www-data and executable by the user and group.

    Code:
    #!/usr/bin/python
    
    import cgi
    import smtplib
    from email.mime.text import MIMEText
    
    form = cgi.FieldStorage()
    email = form.getvalue("email")
    subject = form.getvalue("subject")
    problem = form.getvalue("problem")
    
    if email == None:
            email = "test.person"
    if subject == None:
            subject = "Test email"
    if problem == None:
            problem = "Test problem"
    
    msg = MIMEText(problem)
    msg['Subject'] = subject
    msg['From'] = email + "@yourschool.domain"
    msg['To'] = "support@email.address"
    s = smtplib.SMTP("mail.yourdomain.com")
    s.sendmail(email + "@yourschool.domain", "support@email.address", msg.as_string())
    s.quit()
    
    print "Content-Type: text/html;charset=utf-8"
    print
    print "<!DOCTYPE html>"
    print "<html lang=\"en\">"
    print " <head>"
    print "         <meta charset=\"utf-8\">"
    print "         <link rel=\"stylesheet\" href=\"/jquery-ui.css\">"
    print "         <title>Helpdesk Submission</title>"
    print " </head>"
    print " <body>"
    print "         <table align=\"center\" verticle-align=\"center\">"
    print "                 <tr>"
    print "                         <td align=\"center\" valign=\"top\">"
    print "                                 <p>"
    print "                                         <span class=\"ui-widget\">Your problem has been reported.</span>"
    print "                                 </p>"
    print "                                 <p>"
    print "                                         <span class=\"ui-widget\"><a href=\"/\">You can now go back to the home page.</a></span>"
    print "                                 </p>"
    print "                         </td>"
    print "                 </tr>"
    print "         </table>"
    print " </body>"
    print "</html>"
    The above is used from a very basic HTML input form that just asks for an email address and some text. Remember you'll need to allow your Ubuntu server to submit SMTP mail to your Exchange server - you'll need to add a security exception to your Exchange server to allow the particular computer (probably by IP address) to submit SMTP email.

  14. #14

    Join Date
    Sep 2013
    Location
    Worcestershire
    Posts
    63
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks , do you need to setup any sort of smtp on the ububtu? Also I know with most forms it just gets submitted as plain text. Is there anyway of getting the form to be submitted in the same template it was submitted in ? Thanks for your help much appreciated

  15. #15

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,623
    Thank Post
    1,240
    Thanked 777 Times in 674 Posts
    Rep Power
    235
    Quote Originally Posted by lholland421 View Post
    Thanks , do you need to setup any sort of smtp on the ububtu?
    No - the Python SMTP library is connecting directly to your Exchange server. You do need to remember to tell your Exchange server that SMTP connections from your Ubuntu machine are okay, though, it won't allow them by default.

    Also I know with most forms it just gets submitted as plain text. Is there anyway of getting the form to be submitted in the same template it was submitted in ?
    You're programming it, you can format the email however you like. What is picking the emails up at the other end - are they being collected from your Exchange server by some automated process, or are they just going in to someone's inbox for them to read? HTML form submissions and CGI scripts are quite basic things, if you haven't used them before then this would seem like an excellent opportunity to learn. The above script should get you started, but you can add stuff to it to do whatever you like. If you just type "HTML form" into Google you'll get a bunch of links to examples and tutorials.

SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. Creating online forms
    By MrWu in forum Internet Related/Filtering/Firewall
    Replies: 11
    Last Post: 4th February 2014, 11:21 AM
  2. Creating application forms
    By SamanthaJane in forum Office Software
    Replies: 5
    Last Post: 31st January 2013, 09:54 AM
  3. Creating a form, web novice, help please
    By mrbios in forum Web Development
    Replies: 27
    Last Post: 1st July 2010, 09:15 AM
  4. Form created with Publisher
    By laserblazer in forum How do you do....it?
    Replies: 5
    Last Post: 28th June 2009, 04:36 PM
  5. Creating a form in frontpage2003
    By park_bench in forum Web Development
    Replies: 2
    Last Post: 24th January 2007, 09:18 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •