Gravity Forms Connector Reference

1 metrics103 dimensions

Fields

The Gravity Forms connector exposes 104 fields (1 metrics, 103 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Gravity Forms Fields

Gravity Forms Entries fields

The Entries report of the Gravity Forms connector includes 21 fields.

ID	Type	Name	Description
entries_created_by	TEXT	Entry Created By	Null or the ID of the logged-in user who submitted the form.
entries_currency	TEXT	Entry Currency	The three character ISO 4217 currency code used by the submission for any pricing fields and payment add-ons.
entries_date_created	DATE	Entry Date Created	The UTC date and time the entry was created. Format: YYYY-MM-DD HH:MM:SS
entries_date_updated	TIMESTAMP	Entry Date Updated	The UTC date and time the entry was most recently updated.Format: YYYY-MM-DD HH:MM:SS
entries_form_id	TEXT	Entry Form ID	The ID of the form the entry was created by.
entries_id	TEXT	Entry ID (internal)	The unique ID assigned to the entry by the database.
entries_ip	TEXT	Entry Submitter IP address	The IP address of the user who submitted the form.
entries_is_fulfilled	BOOLEAN	Is Fulfilled	Indicates if the entry/order has been fulfilled. true when fulfilled, false when not fulfilled.
entries_is_read	BOOLEAN	Entry Is Read	Indicates if the entry has been viewed. true when viewed, false when not viewed.
entries_is_starred	BOOLEAN	Entry Is Starred	Indicates if the entry has been starred (i.e., marked with a star). true when starred, false when not starred.
entries_payment_amount	NUMERIC	Entry Payment Amount	Transaction amount without the currency symbol.
entries_payment_date	DATE	Entry Payment Date	UTC date and time the transaction was processed. Format: YYYY-MM-DD HH:MM:SS
entries_payment_status	TEXT	Entry Payment Status	Status (limited to 15 characters) of the transaction processed by a payment add-on. Possible values: Authorized, Paid, Processing, Pending, Active, Expired, Failed, Cancelled, Approved, Reversed, Refunded, Voided, or a custom value set by a third-party add-on.
entries_post_id	TEXT	Entry Post ID	Null or the ID of the post created by legacy post fields. This is not used by the Advanced Post Creation add-on.
entries_source_id	TEXT	Entry Source ID	ID of the post or page where the form was embedded at the time the entry was saved. Since Gravity Forms 2.9.
entries_source_url	TEXT	Entry Source Url	The URL of the request that saved the entry, limited to 200 characters. Usually, the URL of the page where the form is embedded. It can also contain the Admin Ajax or REST endpoint URL if the entry was created by an Ajax or REST API request.
entries_status	TEXT	Entry Status	The current status of the entry. Possible values: active, spam, trash
entries_transaction_id	TEXT	Entry Transaction ID	ID of the transaction returned by the payment gateway.
entries_transaction_type	TEXT	Entry Transaction Type	Indicates the transaction type of the entry/order. 1 for a one-time payment (product/service type feed), 2 for a subscription.
entries_user_agent	TEXT	Entry Submitter User Agent	The user agent string (limited to 250 characters) from the browser the user used to submit the form. Helps identify the browser, operating system, and device used to submit the form, but it can be unreliable.
entries_value	TEXT	Entry Value	Entry Value

Gravity Forms Form Fields fields

The Form Fields report of the Gravity Forms connector includes 17 fields.

ID	Type	Name	Description
forms_fields_enableautocomplete	BOOLEAN	Form Field Enable Autocomplete	Form Field Enable Autocomplete
forms_fields_errormessage	TEXT	Form Field Error Message	Form Field Error Message
forms_fields_id	TEXT	Form Field ID	Form Field ID
forms_fields_inputs_choices	TEXT	Form Field Input Choices	Form Field Input Choices
forms_fields_inputs_id	TEXT	Form Field Input ID	Form Field Input ID
forms_fields_inputs_inputtype	TEXT	Form Field Input Input Type	Form Field Input Input Type
forms_fields_inputs_ishidden	BOOLEAN	Form Field Input Is Hidden	Form Field Input Is Hidden
forms_fields_inputs_label	TEXT	Form Field Input Label	Form Field Input Label
forms_fields_inputs_name	TEXT	Form Field Input Name	Form Field Input Name
forms_fields_inputs_placeholder	TEXT	Form Field Input Placeholder	Form Field Input Placeholder
forms_fields_inputtype	TEXT	Form Field Input Type	Form Field Input Type
forms_fields_isrequired	BOOLEAN	Form Field Is Required	Form Field Is Required
forms_fields_label	TEXT	Form Field Label	Form Field Label
forms_fields_maxlength	TEXT	Form Field Max Length	Form Field Max Length
forms_fields_noduplicates	BOOLEAN	Form Field No Duplicates	Form Field No Duplicates
forms_fields_type	TEXT	Form Field Type	Form Field Type
forms_fields_visibility	TEXT	Form Field Visibility	Form Field Visibility

Gravity Forms Forms fields

The Forms report of the Gravity Forms connector includes 45 fields.

Gravity Forms Forms fields (forms_button_imageurl to forms_schedulestarthour)

ID	Type	Name	Description
forms_button_imageurl	IMAGE_URL	Form Button Image URL	Contains the URL for the image button.
forms_button_layoutgridcolumnspan	TEXT	Form Button Layout Grid Column Span	The number of layout grid columns the button spans.
forms_button_location	TEXT	Form Button Location	The button location.
forms_button_text	TEXT	Form Button Text	Contains the button text.
forms_button_type	TEXT	Form Button Type	Specifies the type of button to be displayed.
forms_button_width	TEXT	Form Button Width	The button width.
forms_cssclass	TEXT	Form CSS Class	One or more space separated custom class names that will be added to the class attribute on the <form> tag.
forms_date_created	DATE	Form Date Created	The date form was created in the format YYYY-MM-DD HH:MM:SS
forms_description	TEXT	Form Description (Gravity Forms)	The form description.
forms_descriptionplacement	TEXT	Form Description Placement	The default location of the field descriptions.
forms_enableanimation	BOOLEAN	Form Enable Animation	Indicates conditional logic should use a slide animation when displaying and hiding fields and buttons.
forms_enablehoneypot	BOOLEAN	Form Enable Honeypot	Indicates if the anti-spam honeypot feature is enabled.
forms_id	TEXT	Form ID (Gravity Forms)	The form ID.
forms_is_active	BOOLEAN	Form Is Active	The form active/inactive status.
forms_is_trash	BOOLEAN	Form Is Trash	Indicates if the form is in the trash.
forms_labelplacement	TEXT	Form Label Placement	The default location of the field labels.
forms_limitentries	BOOLEAN	Form Limit Entries	Indicates if there is a limit on the number of entries this form can have.
forms_limitentriescount	TEXT	Form Limit Entries Count	The total number of entries that can be created for this form during the period defined for forms_limitentriesperiod.
forms_limitentriesmessage	TEXT	Form Limit Entries Message	The message that will be displayed when the limit is reached.
forms_limitentriesperiod	TEXT	Form Limit Entries Period	The period the limit is based on. Possible values: An empty string to indicate the limit is based on the total number of entries that exist for the form regardless of when they were submitted. day: the limit resets daily.week: the limit resets weekly.month: the limit resets monthly.year: the limit resets yearly.
forms_markupversion	TEXT	Form Markup Version	Indicates which version of the form markup should be used. Possible values: 1: Indicates legacy markup (pre-2.5) is enabled.2: Indicates the accessible markup introduced in v2.5 should be used.
forms_postcontenttemplate	TEXT	Form Post Content Template	Template to be used when creating the post content.
forms_postcontenttemplateenabled	BOOLEAN	Form Post Content Template Enabled	Determines if the post template functionality is enabled. When enabled, the post content will be created based on the template specified by forms_postcontenttemplate.
forms_posttitletemplate	TEXT	Form Post Title Template	Template to be used when creating the post title.
forms_posttitletemplateenabled	BOOLEAN	Form Post Title Template Enabled	Determines if the post title template functionality is enabled. When enabled, the post title will be created based on the template specified by forms_posttitletemplate.
forms_requirelogin	BOOLEAN	Form Enable Login	Indicates if the user must be logged in to access the form.
forms_requireloginmessage	TEXT	Form Require Login Message	The message to be displayed when the user isn’t logged in.
forms_save_button_text	TEXT	Form Save Button Text	The button text on the form Save button.
forms_save_button_type	TEXT	Form Save Button Type	The 'Save' button type.
forms_save_enabled	BOOLEAN	Form Save Button Enabled	Indicates if the save and continue later feature is enabled for the form.
forms_scheduleend	TEXT	Form Schedule End	Date in the format (MM/DD/YYYY) that the form will become unavailable.
forms_scheduleendampm	TEXT	Form Schedule End AM PM	Indicates if the scheduleEndHour is before or after midday.
forms_scheduleendhour	TEXT	Form Schedule End Hour	Hour (1 to 12) that the form will become unavailable.
forms_scheduleendminute	TEXT	Form Schedule End Minute	Minute that the form will become unavailable.
forms_scheduleform	BOOLEAN	Form Schedule Form	Indicates if the form should only be available during a scheduled period of time.
forms_schedulemessage	TEXT	Form Schedule Message	The message to be displayed when the form is no longer available.
forms_schedulependingmessage	TEXT	Form Schedule Pending Message	The message to be displayed when the form is not yet available.
forms_schedulestart	TEXT	Form Schedule Start	Date in the format (MM/DD/YYYY) that the form will become available.
forms_schedulestartampm	TEXT	Form Schedule Start AM PM	Indicates if the scheduleStartHour is before or after midday. Possible values: am or pm
forms_schedulestarthour	TEXT	Form Schedule Start Hour	Hour (1 to 12) that the form will become available.

Gravity Forms Forms fields (forms_schedulestartminute to forms_version)

ID	Type	Name	Description
forms_schedulestartminute	TEXT	Form Schedule Start Minute	Minute that the form will become available.
forms_sublabelplacement	TEXT	Form Sublabel Placement	The default location of the field sub labels.
forms_title	TEXT	Form Title	The form title.
forms_usecurrentuserasauthor	BOOLEAN	Form Use Current User As Author	Indicates if the user logged in at the time the form is submitted should be the author.
forms_version	TEXT	Form Version	The Gravity Forms version used to create the form.

Gravity Forms General fields

The General report of the Gravity Forms connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Ad account ID.
account_name	TEXT	Account Name	Ad account name.
date	DATE	Date	Date.

Gravity Forms other fields

The Gravity Forms connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors