Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2017, 03:44 PM
Asuryan33 Asuryan33 is offline Form with conditional field. Windows 10 Form with conditional field. Office 2016
Novice
Form with conditional field.
 
Join Date: Oct 2017
Posts: 9
Asuryan33 is on a distinguished road
Default Form with conditional field.

Hello.



I have a question.

I would like to make a form with conditional fields.
I have around 100 differents fields but each time I collect information I use only 12 of them.
So, I would like to start with a radio field to chose between adult and child and then, check box to chose category of informations and finally, the text fields related should appear.

The form should have a submit button that open the mail client and populate the email (to: , Subject , and body) from the field used.

Can you help me with that ??
Reply With Quote
  #2  
Old 10-17-2017, 04:41 PM
macropod's Avatar
macropod macropod is offline Form with conditional field. Windows 7 64bit Form with conditional field. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Without seeing your existing document, it's impossible to know what the best way would be to address the issue. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-18-2017, 07:48 AM
Asuryan33 Asuryan33 is offline Form with conditional field. Windows 10 Form with conditional field. Office 2016
Novice
Form with conditional field.
 
Join Date: Oct 2017
Posts: 9
Asuryan33 is on a distinguished road
Default

Actually, I don't have documents yet.

But, basically.

1) I need a first set of option that will populate the "To:" field of the email.

-Local office
---City1
---City2
---City3
---Etc.
-Central office

2)I need a second set of option that will determinate wich options will be availlable after
-Child
-Adult.

3) I need a dependant (from 2) set of options that will determine wich field to show. Also, the chosen option will populate the first part of the Object of the email.

4) finally, the text fields.
-for option 1)
---First Name
--- Last Name
---File Number:
---DOB:
---Address
--- etc.

-For option 2)
---First Name
--- Last Name
---File Number:
---DOB:
---Name of reference
---Addresse of reference
---Etc

I should have 30 differents options with common field inside, to identify the client and populate the "object". Others options are to send the information by mail to other office. I know it will be way easier to use a database but ... anyway ..
Reply With Quote
  #4  
Old 10-18-2017, 12:52 PM
macropod's Avatar
macropod macropod is offline Form with conditional field. Windows 7 64bit Form with conditional field. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The first item can be accomplished with a simple dropdown, as can the second, but I have no idea what you mean by "that will determinate wich options will be availlable after", or what the third item is supposed to be. Items 4(1) & (2) appear to be essentially the same, except for 'Name of reference' in (2).

As for:
Quote:
Originally Posted by Asuryan33 View Post
I should have 30 differents options with common field inside, to identify the client and populate the "object". Others options are to send the information by mail to other office.
I think you're getting well into the kind of project for which you should be hiring a forms designer/programmer instead of expecting volunteers on forums like this to develop something so complex for you.

You should also consider whether you should use a small number of relatively simple templates instead of trying to shoehorn everything into one complex one that will be much harder for anyone at your end to maintain/update.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-18-2017, 01:21 PM
Asuryan33 Asuryan33 is offline Form with conditional field. Windows 10 Form with conditional field. Office 2016
Novice
Form with conditional field.
 
Join Date: Oct 2017
Posts: 9
Asuryan33 is on a distinguished road
Default

I understand.

Finally, my question is how to make conditional field.

If value of field 1 is B then show field 1,2,3,20,98.
Reply With Quote
  #6  
Old 10-18-2017, 01:51 PM
macropod's Avatar
macropod macropod is offline Form with conditional field. Windows 7 64bit Form with conditional field. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It's not clear whether you're trying to conditionally display another field or just the contents. Then there's the question of what you mean by 'field' - which for all I know could be a content control or formfield.

For some of the issues you might need to deal with, including the above, see:

Fillable Forms:
https://support.office.com/en-us/art...B-AC44937E3A9F

Conditional Insertion of Additional Formfields:
https://www.msofficeforums.com/word/...b-question.htm

Dependent Dropdown Content Controls:
https://www.msofficeforums.com/word-...html#post77762

Hierarchical Dropdown Content Controls:
https://www.msofficeforums.com/word-...html#post94603

Dependent Text Content Controls:
https://www.msofficeforums.com/word-...html#post46903

Dependent Text Formfields:
https://www.msofficeforums.com/word/...html#post46429

Content Control & Formfield Conditional Formatting:
https://www.msofficeforums.com/word-...html#post47254

Creating and Tallying Mutually-exclusive Checkbox Content Controls:
https://www.msofficeforums.com/word-...html#post33489
https://www.msofficeforums.com/word-...tml#post107008

Replicating data in a form:
http://gregmaxey.mvps.org/word_tip_p...ting_data.html

Adding a new row to a table in a document with formfields:
https://www.msofficeforums.com/word-...html#post38312

Adding a new row to a table in a document with content controls:
https://www.msofficeforums.com/word-...html#post87989
https://www.msofficeforums.com/word-...html#post38461

Do note that formfields and content controls were not designed to work together and generally should not be used in the same document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 10-18-2017, 03:45 PM
Asuryan33 Asuryan33 is offline Form with conditional field. Windows 10 Form with conditional field. Office 2016
Novice
Form with conditional field.
 
Join Date: Oct 2017
Posts: 9
Asuryan33 is on a distinguished road
Default

Thx for your help. I will read that.

I just want that some field,with their description
(Exemple: Child name:[Text Field])
Appeared only if I have selected Child before.
Reply With Quote
Reply

Tags
conditional form, form, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Form with conditional field. Macro to autofill a form field ONLY if the form field is blank upon entry Pindar Word VBA 2 01-12-2017 05:03 PM
Form with conditional field. Conditional Field CKTisdale Word 1 04-10-2015 02:41 PM
Conditional formatting in custom field Puddlerunna Project 6 11-05-2014 06:14 AM
Form with conditional field. Form field selection allows entry into form text box David C Word 1 10-24-2012 04:53 AM
Form with conditional field. Form Fields - Create blank form text field with if statement? LAssist2011 Word 5 12-14-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft