FormFields
Get fields of HubSpot Forms.
Table Specific Information
FormFields represent the fields contained in a form on your website.
Select
When selecting form fields, they can only be filtered by FormGUID. For example:
SELECT * FROM FormFields WHERE FormGUID='123456789' SELECT * FROM FormFields WHERE FormGUID IN ('123456789', '121314515')
Columns
Name | Type | References | Description |
FormGUID | String | The unique key for the form. | |
Name | String | The name of the field. | |
DefaultValue | String | The default value of the field. | |
Required | Boolean | Boolean indicating wether the field is required in the form. | |
Enabled | Boolean | Boolean indicating wether the field is enabled. | |
IsSmartField | Boolean | Boolean indicating wether this is a smart field. | |
Label | String | Label of the field. | |
GroupName | String | Name of the group the field belongs to. | |
SelectedOptions | String | The selected options for the field. | |
FieldType | String | Type of the field. | |
Hidden | Boolean | Boolean indicating wether the field is hidden. | |
Validation | String | ||
Type | String | Value type of the field. | |
Options | String | Field options | |
DisplayOrder | Int | Display order of the field |