Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2016, 01:06 PM
HellaNoella HellaNoella is offline Auto name form based on field value Windows 7 32bit Auto name form based on field value Office 2010 32bit
Novice
Auto name form based on field value
 
Join Date: Aug 2016
Posts: 1
HellaNoella is on a distinguished road
Question Auto name form based on field value

I have created a fillable form for users that will be available on our Sharepoint site. Once the form is filled out it gets mailed to a specific email address. How do I get the form to auto populate a document name based on a field value? Preferably based on a last name field, first name field.docx.

TIA!!!


Reply With Quote
  #2  
Old 08-01-2016, 08:57 PM
gmayor's Avatar
gmayor gmayor is offline Auto name form based on field value Windows 10 Auto name form based on field value Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
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

The macro required to do this will need to know what type of field you are using and of course you will have to rely on the user being prepared to run the macro as you cannot enforce that.
__________________
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 08-01-2016, 11:19 PM
Guessed's Avatar
Guessed Guessed is offline Auto name form based on field value Windows 10 Auto name form based on field value Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,967
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

The default document name is whatever is in the Title document property. If you were using content controls on your form (and only needed one field to give you the document name) then you could link the name field to the Title document property to get that as your default document name.

If you need to concatenate two separate fields to make the default document name then you will need a macro and could get it to write the values of those fields into the title document property anytime before the user tries to save. It would be best to do this with a content control OnExit macro but that is just one way of doing it.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
document name, field names, macro vba word

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto name form based on field value Form auto fill based on a different field value. stct Word 26 06-15-2019 04:08 PM
Auto name form based on field value Automatically adding new rows based on form field tejaspareek Word VBA 4 04-17-2015 05:35 AM
form control Field - Drop down auto text mrtinfl Word 5 11-19-2014 06:57 AM
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 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 08:05 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