+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    1,005
    Thanks
    39
    Thanked
    591
    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,005
    Thanks
    39
    Thanked
    591
    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
christmas gift guidesee all Red Stocking
WaterWipes
Give your babies bottom a gift this Xmas! They are the only wipe made using just water and a drop of grapefruit seed extract and may help avoid nappy rash. Check out the great reviews on bubhub and see our website for more info and availability.
sales & new stuffsee all
The Health Hub
Give a new mum a fitness boost for Christmas & New Year. Studio-based, small group training sessions - cardio, strength, core, Pilates & boxing. Choice of 16 hrs per week, flexible-arrival feature - bubs & kids welcome! Gift vouchers available.
featured supporter
The MAMA Centre
Pregnancy, birth & beyond care with your very own midwife. Home & hospital birth support, VBACs, antenatal & postnatal care by medicare eligible midwives & holistic health practitioners. Massage, chiro, naturopathy, yoga, counselling & beauty therapy
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!