<< Click to Display Table of Contents >> USERFIELD (output user info) |
Syntax:
USERFIELD(FieldName)
Description:
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 the User info button.
FieldName is the name of the field to be returned (see table below).
Uppercase and lowercase letters can be mixed. But please note that, if entered directly, FieldName has to be surrounded by 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 is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last 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)". This was 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