Relationship between Groove Forms Tool Types and Forms2RecordDataSet Elements

The Forms tool designer creates a new field and specifies the field type. The field type determines how the field is displayed on the form, the data type of the field in the underlying record, and the type used in the GrooveForms2 Forms2RecordDataSet. The following table describes these types.

Designer type Type returned by ReadFormFields operation Schema data type Description

Text

String

xs:string

Value is a string

Multi-line Text

String

xs:string

Value is a multi-line string

Options Button

String

xs:string

Value is the stored string specified by the forms designer, not the display value.

Check Box

String

xs:string

Value is the stored string specified by the forms designer.

Drop-down List

String

xs:string

Value is the string associated with the drop-down list element selected.

List Box

String

xs:string

If a List Box has multiple values, the values are separated by newline characters in the corresponding field of the record.

Password

String

xs:string

Treated as a text field.

Date

Date

xs:dateTime

Date values are treated as Date-Time values of 12 noon local time on the specified day. Consequently, a Date value will be specified as the Coordinated Universal Time (UTC) equivalent of 12 noon local time on the specified day.

DateTime

Date

xs:dateTime

Date-Time values are converted from local time to UTC time.

Number

Number

xs:double

Value is a formatted number.

Unformatted Number

Number

xs:double

Value is an unformatted number.

Currency

Number

xs:double

Value is a number formatted as currency.

Rich Text

RichText

xs:string

Microsoft Rich Text format (RTF). When you read a record and the RTF field in the record contains one or more embedded objects, such as images, the embedded objects are removed from the value before it is returned in the Forms2RecordDataSet value. When you are creating or updating a record, you can specify the string either in RTF or plain text.

Attachments

FileAttachment

Array of FileAttachment

Fields with this type can have multiple values. Each attachment has its metadata, such as full name and size, and its contents. When querying or reading records, the contents are omitted if the IncludeFileAttachmentContent parameter has a false value.

Contact

VCard

xs:string

Contact types are represented by a serialized VCard, which is defined by the Network Working Group RFC 2426 September 1998, ”vCard MIME Directory Profile."

Community Additions

ADD
Show: