FormFields

Returns details about form fields within HubSpot forms, supporting form customization and data collection.

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		Unique identifier key assigned to the form.
Name	String		Internal name of the form field.
DefaultValue	String		Default value assigned to the field, if any.
Required	Boolean		Boolean flag indicating whether the field is required for form submission.
Enabled	Boolean		Boolean flag indicating whether the field is currently enabled in the form.
IsSmartField	Boolean		Boolean flag indicating whether the field is a smart field, which adapts based on prior contact interactions.
Label	String		Label displayed on the form for this field.
GroupName	String		Name of the group or section to which the field belongs within the form.
SelectedOptions	String		Comma-separated list of selected options for fields like dropdowns or checkboxes.
FieldType	String		Type of the form field, such as text, dropdown, or checkbox.
Hidden	Boolean		Boolean flag indicating whether the field is hidden from view.
Validation	String		Validation rules or requirements applied to the field, if any.
Type	String		Data type of the value stored in the field.
Options	String		Available selectable options for the field, if applicable.
DisplayOrder	Int		Numeric value determining the display order of the field on the form.