+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    1,011
    Thanks
    39
    Thanked
    599
    Reviews
    0
    Achievements:Topaz Star - 500 posts

    Default Computer Geek Help please ...

    Please bear with me while I try to explain ...

    I need to create an electronic form that when you answer a question, a whole list of other options appears (that aren't visible unless you tick a certain field).

    For example:

    Do you require a vehicle for your site visit: Tick Yes Tick No

    If you tick no, nothing happens and you go to the next question, if you tick yes another list of fields such as "Do you require a 4WD?" etc appears.

    I'm not sure which program to use and unfortunately don't know what this is called to google a "how to"?

    Thanks in advance!

  2. #2
    Join Date
    Jun 2010
    Location
    Sunshine North
    Posts
    859
    Thanks
    64
    Thanked
    223
    Reviews
    5
    Achievements:Topaz Star - 500 posts
    Is this going to be a form displayed on a web page or can it be done in excel? And how do you want the answers to come back to you?

  3. #3
    Join Date
    Apr 2011
    Posts
    1,011
    Thanks
    39
    Thanked
    599
    Reviews
    0
    Achievements:Topaz Star - 500 posts
    It's for internal use, for a job safety form before going to site. It's not for a website, it can be done on excel (or pretty much any standard office program) and it generally gets pdf'd and saved into a project file. I'm not sure if it's even possible outside the website environment, but I'd get major kudos if I could find out. You rock happygrl!

  4. #4
    Join Date
    Jun 2010
    Location
    Sunshine North
    Posts
    859
    Thanks
    64
    Thanked
    223
    Reviews
    5
    Achievements:Topaz Star - 500 posts
    You should be able to do it in excel using "IF" statements and drop lists, eg

    cell A1
    Do you require a vehicle for your site visit?

    cell a2
    create a drop list (see http://www.wikihow.com/Create-a-Drop-Down-List-in-Excel)

    Cell b1
    type:
    IF(A2="yes","Do you require a 4WD","")

    I'm not entirely sure how to add a second conditional drop down list in b2 - I'll be able to figure it out with a bit more time (it's been a while since I used excel like this).

    It might actually be easier using a "mailto" form on a webpage that has the questions and emails the answers when it is submitted.

  5. #5
    Join Date
    Jul 2011
    Location
    Adelaide
    Posts
    90
    Thanks
    9
    Thanked
    14
    Reviews
    0
    Try google "survey monkey" its an online survey tool. Not sure of cost bur we use it at work. It lets you setup conditional questions like you described.

  6. The Following User Says Thank You to Addiegirl For This Useful Post:

    hongkhoa  (06-10-2014)


 

Similar Threads

  1. Damn beauty and the geek. How do I get dd out of this behavior now?
    By MonkeySeeMonkeyDo in forum General Chat
    Replies: 8
    Last Post: 20-10-2013, 12:14
  2. Beauty and the Geek
    By Mellie29 in forum Movies / Music / Books / TV Chat
    Replies: 15
    Last Post: 17-10-2013, 14:17
  3. So you're an 8-year-old catwoman-loving geek girl...
    By SassyMummy in forum General Chat
    Replies: 10
    Last Post: 11-06-2013, 15:34

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
free weekly newsletters | sign up now!
who are these people who write great posts? meet our hubbub authors!
Learn how you can contribute to the hubbub!

reviews
learn how you can become a reviewer!

competitions

forum - chatting now
sales & new stuffsee all
Obstetrician, Gynaecologist, IVF Specialist
Dr Terry Sheahan - Brisbane Obstetrician, Gynaecologist, IVF Specialist
Dr Terry Sheahan is a highly respected Obstetrician, Gynaecologist and IVF Specialist on Brisbane's Northside. To book an appointment or for information about his Affordable Low-Gaps Obstetrics please call his rooms on (07) 3353 3100
featured supporter
GymbaROO
GymbaROO offers activities for babies & toddlers in a fun learning centre, focussing on developmental education. Classes are available Australia-wide. Enrol today & help your child to reach their full potential. Visit the website to find out more.
gotcha
X

Pregnant for the first-time?

Not sure where to start? We can help!

Our Insider Programs for pregnancy first-timers will lead you step-by-step through the 14 Pregnancy Must Dos!