Forms
Retrieves forms used in HubSpot for lead capture and contact data collection.
SELECT
When selecting Forms, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =.
SELECT * FROM Forms WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
INSERT
INSERT INTO Forms (Name, FormType, CreatedAt, language)
VALUES ('Test Form Name', 'hubspot', current_timestamp(), 'en')
UPDATE
UPDATE Forms SET Archivable = true, Editable = true, Cloneable = true, SubmitButtonText = 'Updated!' WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
DELETE
DELETE FROM Forms WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | String | True | True |
Unique identifier of the marketing form. | |
| Name | String | False | False |
The title of the form as it appears in HubSpot. | |
| FormType | String | False | True |
The category of the form, such as blog_comment, captured, hubspot, or flow. | |
| FieldGroups | String | False | False |
An aggregate of field groups included in the form. | |
| Language | String | False | False |
The language the form is set to use. | |
| Cloneable | Bool | False | False |
Indicates whether the form can be cloned to create a duplicate. | |
| Editable | Bool | False | False |
Specifies whether the form can be edited. | |
| Archivable | Bool | False | False |
Determines whether the form can be archived. | |
| RecaptchaEnabled | Bool | False | False |
Indicates whether reCAPTCHA is enabled for the form to prevent spam submissions. | |
| NotifyContactOwner | Bool | False | False |
If true, notifies the contact owner when the form is submitted. | |
| NewContactNewEmail | Bool | False | False |
If true, creates a new contact record for a new email address submitted via the form. | |
| PrePopulate | Bool | False | False |
Indicates whether known values should be pre-populated in the form fields. | |
| AllowLinkToReset | Bool | False | False |
Allows users to reset known field values via a link. | |
| RenderRawHtml | Bool | False | False |
If true, renders the form using raw HTML. | |
| Theme | String | False | False |
The theme applied to the form for styling. | |
| SubmitButtonText | String | False | False |
Text displayed on the form's submit button. | |
| CssClass | String | False | False |
The CSS class used for styling the form. | |
| Style | String | False | False |
The display style of the form, such as pop-up or embedded. | |
| CreatedAt | Datetime | False | False |
The timestamp when the form was created. | |
| UpdatedAt | Datetime | False | False |
The timestamp when the form was last updated. | |
| Archived | Bool | True | False |
Indicates whether the form has been archived. |