#1
|
|||
|
|||
Creating AutoFill form - AutoFill information depending on a selection.
Hi,
I have joined this forum primarily to get a solution to my problem at the moment. But will stay on for future help and guidance as and when it is needed. So hello and thanks in advance for taking the time out to hopefully help me out. I am currently in the middle of designing a word document with autofill functions. However it is not that easy as I would like to autofill pretty much the entire document depending on a few variables. Back Story: The document I am currently designing is a Risk Assessment for working on site. There are a few variables which I want to effect what information is inserted in various sections of the document using the auto fill function. I would like to insert an auto function to insert the information in my chosen places but cannot use the simple auto fill as this (as far as im aware) will only allow you to insert one piece of information per autofill field. What I want to do is be able to select a number variables from drop down menu's which instructs the auto fill function what I would like 'autofilling'. Using one example for ease of understanding: Variable: [Machine Lay] or [Hand Lay] So selecting one of the above variables will link that variable to autofill information and insert it in the required areas of the document. Selecting [Machine Lay] will insert pre determined information in various sections of the document such as Plant Required, Method Statement etc. and selecting [Hand Lay] will insert different pre determined information in the same sections. I hope I have explained it in a way you can understand. Many thanks in advance |
#3
|
|||
|
|||
Quote:
IF Field definitely solves the problem of having 2 different autofill records depending on the [machine lay] / [hand lay] options within the form. I should've explained what I would like to be inserted in the autofill field. If [machine lay] is chosen then I would like it to insert a list format of machinery needed to complete a job. Same with [hand lay] but it would list less machinery. For example: [machine lay] Paver Roller Chipper Deadweights There will probably be a maximum of 6 items to list. Should I insert an autofill field for each item and have them reference the IF field to include the correct items dependant on the primary option? Thank you for your help. It is definitely the start I need to get the ball rolling with this function. |
#4
|
|||
|
|||
You can have each item show up as truetext in response to an IF comparison or if the list isn't too long, you can include the entire list that you want to show up as the truetext in the IF field.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autofill | Stacybug1 | Excel | 2 | 01-28-2015 01:04 PM |
Autofill Address | dazwm | Outlook | 13 | 08-21-2013 09:28 AM |
Autofill Automation | Parkiee1981 | Excel | 4 | 03-15-2013 01:24 PM |
Autofill a form which is contingent on a dropdown selection. | biffle0764 | Word | 2 | 05-09-2012 12:54 PM |
AutoCorrect Or AutoFill | Johnny thunder | Outlook | 0 | 05-02-2011 03:37 PM |