FormFields

Get fields of HubSpot Forms.

Table Specific Information

FormFields represent the fields contained in a form on your website.

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')


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