<< Click to Display Table of Contents >> USERFIELD (output user info) |
Syntax:
USERFIELD(FieldName)
Description:
This returns the content of one of the fields with your user information (name, address, etc.) entered in PlanMaker's settings dialog.
Note: You can edit your user information by choosing the command File | Options , switching to the General tab and clicking on the User info button.
FieldName is the name of the field to be returned (see table below).
It is not case-sensitive. Note, however, that FieldName must always be enclosed within double quotation marks (") – as in USERFIELD("User.City").
FieldName can be one of the following text strings:
User info field |
Field name |
Title |
User.Title |
Name |
User.Name |
Initials |
User.Initials |
Company |
User.Company |
Department |
User.Department |
Address 1 |
User.Address 1 |
Address 2 |
User.Address 2 |
State, ZIP |
User.ZIP |
City |
User.City |
Country |
User.Country |
Phone 1 |
User.Phone 1 |
Phone 2 |
User.Phone 2 |
Phone 3 |
User.Phone 3 |
Fax |
User.Fax |
E-mail 1 |
User.E-mail 1 |
E-mail 2 |
User.E-mail 2 |
E-mail 3 |
User.E-mail 3 |
Web site |
User.Website |
Compatibility note 1:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
Compatibility note 2:
In PlanMaker 2016 and older, there were two sets of user data: "User (home)" and "User (business)". These have been reduced to one set since PlanMaker 2018. When you open an old document that uses this function, its parameters are automatically converted accordingly.
Example:
USERFIELD("User.Website") returns www.softmaker.com