You are here: Data creation and management > Data type management > Configuring fields > Storage and display of fields

Storage and display of fields

The following table lists the field types and their associated property types and controls.The table also identifies the run-time appearance of each type of data.

You select a field type when you add a field to a data type. Use this table to decide which field type to add to a data type, based on what kind of information will be stored or displayed.

 

Simple types

Field type Property type Control name Run-time appearance

Text (single line)

Text

pxTextInput

Text box.

Text (paragraph)

Text

pxTextArea

Text area.

Boolean TrueFalse pxCheckBox Check box.

Currency

Decimal

pxCurrency

Text box.

Date & time

DateTime

pxDateTime

Text box.

An embedded calendar supports hours and minutes.

Date only

Date

pxDateTime

Text box.

An embedded calendar supports days, months, and years.

Decimal

Decimal

pxNumber

Text box.

Email

Text

pxEmail

Text box.

Integer

Integer

pxInteger

Text box.

Phone

Text

pxPhone

Text box.

Picklist Text pxDropdown or pxRadioButtons A drop-down list or set of radio buttons.

Time

TimeOfDay

pxDateTime

Text box.

An embedded clock supports hours and minutes.

 

Fancy types

Field type Property type Control name Run-time appearance

Attachment

Page

Not applicable.

A button and an empty text box.

The text box displays the path to the file after the attachment is uploaded.

Location

Page

Not applicable.

A map and an empty text box.

Users can enter a location in the text box or drag and drop a pin on the map.

User reference

Text

pxDropdown

A drop-down list that is populated with the list of users in your application.

 

Complex types

Field type Property type Control name Run-time appearance

Field group

Page

Not applicable.

A group of related fields.

Users interact with fields based on your selected display modes. The visual appearance of each field is determined by the field type.

Field group list

Page list

Not applicable.

A group of pages.

Users interact with field group lists based on your selected display modes. The visual appearance of each field is determined by the field type.

Data reference

Page

pxAutoComplete

An autocomplete field that prompts users to select a record of another data type.

Data reference list

Page list

Not applicable.

If the list references a single data page, this type is a read-only list of fields that refer records of another data type.

If each item in the list references a data page, this type is a list of autocomplete fields that prompt users to select records of other data types.