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 GrooveForms2Forms2RecordDataSet. 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."

See Also

Reference

GrooveForms2 Web Service
Forms2RecordDataSet Complex Type
System Fields in Forms2RecordDataSet
Relationship between InfoPath Tool Types and Forms2RecordDataSet Elements
Forms2RecordDataSet SOAP Message Example

Concepts

Accessing Forms Tool Records