+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    1,012
    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,012
    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, 14: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
Hills Swimming
Swim with your friends and you will all get a 33% discount!* We have programs to suit all ages and abilities, with small classes held in our warm indoor 25 metre pool. Highly qualified teachers, and award winning programs. *conditions apply
featured supporter
Transition into Parenthood / Calmbirth Sydney
Julie's Transition into Parenthood and Calmbirth courses for pregnant couples will get you ready, prepared and organised for the wonderful birth of your beautiful new baby. Birth Support Doula training provided in 2017 open to all. Call 0401 265 530
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!