Relationship between InfoPath Tool Types and Forms2RecordDataSet Elements

Article
10/16/2013

The InfoPath form designer selects the field data type for each field in the form. The field data type determines how the field is displayed on the form and how the promoted field is treated by the InfoPath Forms tool and by GrooveForms2 service in the Forms2RecordDataSet complex type. The following table describes the relationship between the InfoPath types and the types of the corresponding elements in the Forms2RecordDataSet complex type. Promoted InfoPath fields with any data type not listed in the table will be ignored by the InfoPath Forms tool and treated as if it had not been promoted.

InfoPath data type	Type returned by ReadFormFields Operation	Schema data type	Description
`Byte`	`Number`	`xs:double`	Groove stores the value as a double in the record, but InfoPath converts it to an integer before displaying the value or storing it in the X-document.
`Date`	`Date`	`xs:dateTime`	Value is a date.
`Date and Time`	`Date`	`xs:dateTime`	Value is a date-time.
`Double`	`Number`	`xs:double`	Value is a double.
`Entity`	`String`	`xs:string`	Value is a text string.
`Entities`	`String`	`xs:string`	Value is a text string.
`Float`	`Number`	`xs:double`	Value is a double.
`Hyperlink`	`String`	`xs:string`	Value is a hyperlink, but is treated as a string.
`ID`	`String`	`xs:string`	Value is a text string.
`IDREF`	`String`	`xs:string`	Value is a text string.
`IDREFS`	`String`	`xs:string`	Value is a text string.
`Int`	`Number`	`xs:double`	Groove stores the value as a double in the record, but InfoPath converts it to an integer.
`Language`	`String`	`xs:string`	Value is a text string.
`Name`	`String`	`xs:string`	Value is a text string.
`NCNAME`	`String`	`xs:string`	Value is a text string.
`NMTOKENS`	`String`	`xs:string`	Value is a text string.
`NormalizedString`	`String`	`xs:string`	Value is a text string.
`Rich Text`	`String`	`xs:string`	Value is a text string. All rich text formatting is removed when the value is converted from an InfoPath form to a record. Rich text fields are ignored if you specify them in an UpdateRecords operation.
`Short`	`Number`	`xs:double`	Groove stores the value as a double in the record, but InfoPath converts it to an integer.
`Text`	`String`	`xs:string`	Value is a text string.
`Token`	`String`	`xs:string`	Value is a text string.
`True/False`	`String`	`xs:string`	Treated as a checkbox in the InfoPath Forms tool designer and in Views. Value is a Boolean, but is converted to a string. By default, Boolean InfoPath Fields have a value of "true" or "false" in the record.
`UnsignedByte`	`Number`	`xs:double`	Groove stores the value as a double in the record, but InfoPath converts it to an integer.
`UnsignedInt`	`Number`	`xs:double`	Groove stores the value as a double in the record, but InfoPath converts it to an integer.
`UnsignedShort`	`Number`	`xs:double`	Groove stores the value as a double in the record, but InfoPath converts it to an integer.

Relationship between InfoPath Tool Types and Forms2RecordDataSet Elements

See Also

Reference

Concepts

Additional resources