Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2017, 11:50 PM
valdavaux valdavaux is offline Generating text from table selections Windows 7 64bit Generating text from table selections Office 2013
Novice
Generating text from table selections
 
Join Date: Sep 2017
Posts: 4
valdavaux is on a distinguished road
Default Generating text from table selections

Hi guys,
I want to create a parametric template in word that a simple input can change the output. For exmaple, I'll use checkboxes for:

Tests that were done:
Spike Test [ x ]
Rock Test [ x ]


Paper Test [ x ]

How many repeat tests were done in every test:
(Choose a number) - 2

And then I get a word document with the following:


Quote:
Spike test was performed on the device. It was performed twice.
The spike test passed successfully, no faults were found
(blah blah blah....)

Rock test was performed on the device. It was performed twice.
The rock test passed successfully, no faults were found
(blah blah blah....)

Paper test was performed on the device. It was performed twice.
The paper test passed successfully, no faults were found
(blah blah blah....)

How do I go about it?
Reply With Quote
  #2  
Old 10-07-2017, 10:53 PM
valdavaux valdavaux is offline Generating text from table selections Windows 7 64bit Generating text from table selections Office 2013
Novice
Generating text from table selections
 
Join Date: Sep 2017
Posts: 4
valdavaux is on a distinguished road
Default

*bump* Anyone?
Reply With Quote
  #3  
Old 10-10-2017, 08:13 PM
Guessed's Avatar
Guessed Guessed is offline Generating text from table selections Windows 10 Generating text from table selections Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It looks like you are asking for a kind of complex solution and no-one is particularly excited about solving it for you. The question is kind of general and seems to be a fishing expedition. What research have you conducted so far and how do you envisage the user providing the inputs to create the output? Are you expecting a dialog box to manage this or would you want content controls in a form to be how the user selects options?

Also there is complexity hidden in the details here. Converting a 2 into twice is complex because we would need a lookup table to convert
1 to once
2 to twice
3 to thrice
4 to four times etc
5 to heaps and heaps

What if one test was performed more times than the other tests? What if something did fail? What if it failed on the first test but not on retests? What if it failed on the second test but not on the first?

If I was doing it, I would store the individual test blurbs as building blocks in the template. I would probably use a vba userform to ask for the tests list and the repeating number of tests. Then the content would get added to the document based on the form selections.

But you do need to make a start and do some research. If you have done enough research to ask a focused question and can provide some of the inputs so people aren't setting up the framework which may or may not be applicable, you are more likely to get answers here that help you complete the project.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 10-11-2017, 08:46 AM
valdavaux valdavaux is offline Generating text from table selections Windows 7 64bit Generating text from table selections Office 2013
Novice
Generating text from table selections
 
Join Date: Sep 2017
Posts: 4
valdavaux is on a distinguished road
Default

Quote:
It looks like you are asking for a kind of complex solution and no-one is particularly excited about solving it for you.
I see that, but why should the solution be complex? I'm just asking for the mechanism to do the aforementioned example (Did I mention it's an example? I don't really need that specific thing done), i.e. what software/program to use and how to generally go about it. I'm not asking for a step-by-step full on solution.

Quote:
The question is kind of general and seems to be a fishing expedition.
Not sure what you mean by "fishing expedition", but I hope you're not attacking my integrity as a user.

Quote:
What research have you conducted so far and how do you envisage the user providing the inputs to create the output?
I tried googling all sorts of terms and seeing whether it's possible to accomplish it with perhaps visual basics. All the websites I got to didn't have relevant results.

Quote:
Are you expecting a dialog box to manage this or would you want content controls in a form to be how the user selects options?
Not sure what you mean. I want the user to mark checkboxes, or choose something from a drop-down menu (Whether it's done in Word or an "outside program" is not really relevant to me), but the text is to be generated in MS Word.

Quote:
Also there is complexity hidden in the details here. Converting a 2 into twice is complex because we would need a lookup table to convert

1 to once
2 to twice
3 to thrice
4 to four times etc
5 to heaps and heaps
Or simply have the user choose the words "once", "twice" if that's a problem


Quote:
What if one test was performed more times than the other tests? What if something did fail? What if it failed on the first test but not on retests? What if it failed on the second test but not on the first?
Well, once I know what interface I'm using to accomplish it I could program it appropriately.

Quote:
If I was doing it, I would store the individual test blurbs as building blocks in the template. I would probably use a vba userform to ask for the tests list and the repeating number of tests. Then the content would get added to the document based on the form selections.
Quote:
If I was doing it, I would store the individual test blurbs as building blocks in the template. I would probably use a vba userform to ask for the tests list and the repeating number of tests. Then the content would get added to the document based on the form selections.


But you do need to make a start and do some research. If you have done enough research to ask a focused question and can provide some of the inputs so people aren't setting up the framework which may or may not be applicable, you are more likely to get answers here that help you complete the project.
What research? I've googled "How to program parametric tables to generate texts into word"... "coding you can do with MS word"... stuff like that. Nothing led me to a solution. That's what I'm actually asking here-- What interface can I LEARN to use and how to properly conduct research on this topic so I could accomplish that? Not asking for someone to solve this specific example
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Paragraph Layout Selections Never Save krcarroll65 Word 2 05-09-2017 04:35 AM
Generating text from table selections Trying to generate a result from selections Gatorchamp Word 1 03-29-2017 02:31 PM
Generating text output from PowerPoint picture/name slides bornslippy PowerPoint 2 12-05-2013 11:04 AM
add values to dropdown selections and calculate guyhs Word 7 10-24-2012 05:11 PM
Template: group dropdown selections mfoe33 Word 0 10-15-2012 02:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02: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