#1
|
|||
|
|||
Auto-populate based on text inputted into a field by user + formulas
I have combined several intake forms into one longer document for my staff to fill out each time they enroll a new client. There is a lot of information that has to be repeated across sections. From my end, I was able to repeat bookmark fill-in fields to have the grey background and text to fill in by the case manager (for example, right now the bookmark is Client_Name and the greyed-out text field shows "Client First Name LAST NAME", so that they may fill it in with the specific information of the client). I inserted a cross-reference in every location that asks for this throughout the intake packet.
My issue is that I want my staff to be able to easily fill in the client name such (ex. John DOE) and that auto fill in every space that previously said "Client First Name LAST NAME." In other words, where it used to say "Client First Name LAST NAME" in multiple places across the document, I now want it to fill in whatever the staff member has replaced it with, such as John DOE. I do not expect my staff to have to figure out how to insert fields, link, or bookmark. I want to do that from my end so that my staff can save time by just filling in the initial field and that auto-populating to every field I link it to. I have several fields that I will need to do this for, such as: Client Code, Enrollment Date, Exit Date, Case Manager Name; Agency Name, Today's Date. I am sure that a tutorial for this exists but I have been unsuccessful in finding it with the search terms I am using. Additionally - and I am not sure if this is possible in word as it is in Excel - my staff members are required to do 90-day assessments. I have several fields where the case manager must fill in the assessment dates. I would like the "Assessment #2 Date" field, for example, to be "Enrollment Date + 90 Days." Assessment #3 should auto-populate to Enrollment Date + 180 Days and so on. Thank you so much for your help! I hope to safe staff time in repeating redundancies |
#2
|
|||
|
|||
Your first question (repeating information) is relatively simple. The second question (automatic dates) is tougher and will require updating fields or using macros.
Look at:
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto filling a calendar based on dates inputted | custhasno | Excel | 4 | 07-30-2019 04:17 AM |
Auto populate a text field based on Content Control Dropdown List | matthias92701 | Word VBA | 2 | 05-02-2019 03:54 PM |
Auto-populate Text Field When I Click Check Boxes | LobaBlanca | Word VBA | 2 | 03-14-2019 08:10 PM |
Auto populate text box based on drop-down content control and repeat the process via copy paste | helenndp | Word VBA | 2 | 09-27-2018 11:04 AM |
Macro to populate a text form field based on dropdown selection | koloa | Word | 0 | 10-20-2011 11:52 AM |