+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    1,025
    Thanks
    40
    Thanked
    608
    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,025
    Thanks
    40
    Thanked
    608
    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, 13:14
  2. Beauty and the Geek
    By Mellie29 in forum Movies / Music / Books / TV Chat
    Replies: 15
    Last Post: 17-10-2013, 15: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
FEATURED SUPPORTER
Sarah Tooke Childbirth & Parenting EducationProviding private, personalised antenatal childbirth & parenting education to expectant parents in the comfort of their ...
FORUMS - chatting now ...
Do people suck...?General Chat
When should I test? TTCPregnancy Tests & Help / Support with Results
❤Joyous June/July TTC!❤Conception & Fertility General Chat
I want C-section 1 day after due date!general c-section discussion and debate
REVIEWS
"Made bed time less anxious"
by Meld85
My Little Heart Whisbear - the Humming Bear reviews ›
"Wonderful natural Aussie made product!"
by Mrstwr
Baby U Goat Milk Moisturiser reviews ›
"Replaced good quality with cheap tight nappies"
by Kris
Coles Comfy Bots Nappies reviews ›