USERFIELD (output user info)

<< 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 options_icon, 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