Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2020, 09:44 AM
ssims ssims is offline Auto-populate based on text inputted into a field by user + formulas Windows 10 Auto-populate based on text inputted into a field by user + formulas Office 97-2003
Novice
Auto-populate based on text inputted into a field by user + formulas
 
Join Date: Nov 2020
Posts: 1
ssims is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-30-2020, 12:17 PM
Charles Kenyon Charles Kenyon is offline Auto-populate based on text inputted into a field by user + formulas Windows 10 Auto-populate based on text inputted into a field by user + formulas Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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

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:
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-populate based on text inputted into a field by user + formulas Auto filling a calendar based on dates inputted custhasno Excel 4 07-30-2019 04:17 AM
Auto-populate based on text inputted into a field by user + formulas 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 based on text inputted into a field by user + formulas 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

Other Forums: Access Forums

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