USERFIELD (output user info)

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