Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2017, 04:44 AM
goldfish1972 goldfish1972 is offline Need word to auto complete from tick boxes etc... Windows 7 32bit Need word to auto complete from tick boxes etc... Office 2013
Novice
Need word to auto complete from tick boxes etc...
 
Join Date: Nov 2017
Posts: 5
goldfish1972 is on a distinguished road
Lightbulb Need word to auto complete from tick boxes etc...

I am pretty sure this can be done although can't work out how, but guess it may need some kind of database somewhere ... ideally via Office 365 online ... I work in the healthcare sector and need to be able to create a word document to allow me to copy and paste the content into a third party app.



What I am trying to achieve is creation of a form that has a set of yes no and drop down options, once the appropriate selections are made I am looking to insert the answers into a pre-formated word document with sentences, paragraphs and headings.

As an example... the following questions could be asked which would then form apart of the paragraph below.

Q1 : Was the person wearing appropriate clothing - yes / no
Q2 : Is the person compliant with medication - yes / no
Q3 : Has the person used illicit substances in the past (drop down with yes no, if yes present option of - 7 / 14/ 28 days

Having answered the questions below the response would form part of the sentences below.

Mr A was wearing appropriate clothing for the time of day and weather OR Mr A was wearing inappropriate clothing for the time of day and weather.

Mr A is currently compliant with medication OR Mr A is non compliant with medication.

Mr A denies illicit substance use OR / AND Mr A has used illicit substances in the last (selected from drop down) 7 / 14 / 28 days.

If anyone can help out that would be amazing as I just don't know where to turn with this.
Reply With Quote
  #2  
Old 11-04-2017, 05:54 AM
gmayor's Avatar
gmayor gmayor is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Unless you want to get adventurous with user forms, the simplest approach would be to use mapped content controls (as in the attached document).

The simplest means of mapping controls, so that they may be cross referenced as with the 'name' control, is to use the second item at http://www.gmayor.com/BookmarkandVariableEditor.htm
Attached Files
File Type: docx Click to enter.docx (31.8 KB, 13 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 11-04-2017, 06:01 AM
goldfish1972 goldfish1972 is offline Need word to auto complete from tick boxes etc... Windows 7 32bit Need word to auto complete from tick boxes etc... Office 2013
Novice
Need word to auto complete from tick boxes etc...
 
Join Date: Nov 2017
Posts: 5
goldfish1972 is on a distinguished road
Default

Well what can I say... that is what I am looking for...

Now the questions is how do I add content so that I can build my own documents, or am I being really thick and missing the obvious.
Reply With Quote
  #4  
Old 11-04-2017, 06:11 AM
gmayor's Avatar
gmayor gmayor is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can type text from the keyboard as in any other document, and insert more content controls, which you will find on the Developer tab of the ribbon.

If you want to cross reference controls (as with the name control) you can insert mapped content controls with the add-in I referred to earlier. You can do it without, but it is much simpler to allow the add-in to do the work for you.

Whatever you insert or select in one mapped control is immediately reflected in the cross referenced control(s).
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Last edited by Charles Kenyon; 11-04-2017 at 07:37 AM. Reason: add link
Reply With Quote
  #5  
Old 11-04-2017, 06:43 AM
goldfish1972 goldfish1972 is offline Need word to auto complete from tick boxes etc... Windows 7 32bit Need word to auto complete from tick boxes etc... Office 2013
Novice
Need word to auto complete from tick boxes etc...
 
Join Date: Nov 2017
Posts: 5
goldfish1972 is on a distinguished road
Default

Thanks... do you know if the add in can be used within the online version of O365
Reply With Quote
  #6  
Old 11-04-2017, 07:31 AM
gmayor's Avatar
gmayor gmayor is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It should do. If you are having contact form on my web site.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #7  
Old 11-04-2017, 08:22 AM
Charles Kenyon Charles Kenyon is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,150
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

My preference is Greg Maxey's version, but that may be simply because I am used to it.
Content Control Tools Both Graham and Greg have far more knowledge of this area than I do.

I believe you would be using a mapped or cross-referenced drop-down content control unless you want to use an IF Field to test the content of the mapped [check box] control and give your desired text.
Reply With Quote
  #8  
Old 11-04-2017, 08:52 AM
Charles Kenyon Charles Kenyon is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,150
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by goldfish1972 View Post
Thanks... do you know if the add in can be used within the online version of O365
Web version? I do not know of Add-Ins working with the web version or the mobile version of Word. That may be more of my ignorance speaking.
Reply With Quote
  #9  
Old 11-04-2017, 10:01 PM
gmayor's Avatar
gmayor gmayor is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Quote:
Originally Posted by Charles Kenyon View Post
My preference is Greg Maxey's version, but that may be simply because I am used to it.
Greg's version is linked from my web page and is indeed a more sophisticated version, but is aimed at a different type of user.

These processes were a collaborative effort. Greg and I have worked together for many years, and so both the add-ins on my site (and Greg's) started from the same general premise, initially revolving around document variables and bookmarks, but later expanded to include document properties and later still content controls.

But we had a difference of opinion on the user requirement for content controls. I felt most users would simply want to insert and cross reference controls and not require the facility to go deeper, so I stayed with an earlier iteration that made that particular task a simple one for users and worked on that. Greg went much further with content controls and if you want that extra capability his version is indeed excellent.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #10  
Old 11-05-2017, 06:08 AM
goldfish1972 goldfish1972 is offline Need word to auto complete from tick boxes etc... Windows 7 32bit Need word to auto complete from tick boxes etc... Office 2013
Novice
Need word to auto complete from tick boxes etc...
 
Join Date: Nov 2017
Posts: 5
goldfish1972 is on a distinguished road
Default

Just to let you know... all is working, although the only way I have been able to create the content is by copying / pasting and then amendeing under the controls properties....

I am sure that this isnt the way to do it, perhaps if you could let me know how it should be done that would be great.

Many Thanks
Reply With Quote
  #11  
Old 11-05-2017, 06:35 AM
Charles Kenyon Charles Kenyon is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,150
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Graham gave a link to the Add-In in his first response. The link to download it is at the bottom of the page. http://www.gmayor.com/BookmarkandVariableEditor.htm
You should read the page before downloading.

There are actually two Add-Ins in the download. I believe you want the one with Content Controls in the title. Once a content control is entered into the document as a mapped content control, you can copy and paste it elsewhere in the document. Changes to one will change all. This may take a little study to get it to work for you but is worth the time.

As Graham initially suggested, a UserForm will do what you want, but it requires vba programming. A Userform would give more options. The userform usually relates to bookmarks in the document; Graham's Add-In is useful for manipulating bookmarks as well.
Reply With Quote
  #12  
Old 11-05-2017, 06:38 AM
goldfish1972 goldfish1972 is offline Need word to auto complete from tick boxes etc... Windows 7 32bit Need word to auto complete from tick boxes etc... Office 2013
Novice
Need word to auto complete from tick boxes etc...
 
Join Date: Nov 2017
Posts: 5
goldfish1972 is on a distinguished road
Default

Thanks... sorry I posted an edited version as wrote that last night... all is good as I can copy and paste although was just looking to do it the proper way LOL

Thank I will figure it out
Reply With Quote
  #13  
Old 11-05-2017, 06:53 AM
Charles Kenyon Charles Kenyon is offline Need word to auto complete from tick boxes etc... Windows 10 Need word to auto complete from tick boxes etc... Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,150
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

If there are only a few items you want to replicate throughout, you could use the built-in document property content controls. However, there are only 14 plain-text controls and one date-picker control available using these, no drop-downs. Both Graham's and Greg's Add-Ins give access to drop-down controls for mapping. Repeating Data Using Document Property Content Controls and Other Mapped Content Controls
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Convert Text. I.E. Abbreviation to Complete Word (Hard to describe) Chrisiztopher Excel 1 01-26-2017 08:38 AM
Table - Allow Spellcheck and tick boxes in certain areas only BarbW Word 10 03-09-2016 01:59 PM
New boxes to complete depending on input jillapass Word 2 01-24-2012 04:36 AM
Create makro that counts the number of checked tick boxes in a survey johannapaj Word VBA 0 09-05-2011 01:51 AM
Need word to auto complete from tick boxes etc... In Outlook 2003 auto complete won't work Meenie Outlook 2 06-11-2009 08:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


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