Windsor brings all your Gravity Forms data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Gravity Forms Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Ad account ID. | General |
| account_name | TEXT | Account Name | Ad account name. | General |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | General |
| day_of_month | TEXT | Day of month | Day of the month | |
| entries_created_by | TEXT | Entry Created By | Null or the ID of the logged-in user who submitted the form. | Entries |
| 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 |
| entries_date_created | DATE | Entry Date Created | The UTC date and time the entry was created. Format: YYYY-MM-DD HH:MM:SS | Entries |
| 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 |
| entries_form_id | TEXT | Entry Form ID | The ID of the form the entry was created by. | Entries |
| entries_id | TEXT | Entry ID (internal) | The unique ID assigned to the entry by the database. | Entries |
| entries_ip | TEXT | Entry Submitter IP address | The IP address of the user who submitted the form. | Entries |
| entries_is_fulfilled | BOOLEAN | Is Fulfilled | Indicates if the entry/order has been fulfilled. true when fulfilled, false when not fulfilled. | Entries |
| entries_is_read | BOOLEAN | Entry Is Read | Indicates if the entry has been viewed. true when viewed, false when not viewed. | Entries |
| 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 |
| entries_payment_amount | NUMERIC | Entry Payment Amount | Transaction amount without the currency symbol. | Entries |
| entries_payment_date | DATE | Entry Payment Date | UTC date and time the transaction was processed. Format: YYYY-MM-DD HH:MM:SS | Entries |
| 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 |
| 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 |
| 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 |
| 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 |
| entries_status | TEXT | Entry Status | The current status of the entry. Possible values: active, spam, trash | Entries |
| entries_transaction_id | TEXT | Entry Transaction ID | ID of the transaction returned by the payment gateway. | Entries |
| 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 |
| 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 |
| entries_value | TEXT | Entry Value | Entry Value | Entries |
| forms_button_imageurl | IMAGE_URL | Form Button Image URL | Contains the URL for the image button. | Forms |
| forms_button_layoutgridcolumnspan | TEXT | Form Button Layout Grid Column Span | The number of layout grid columns the button spans. | Forms |
| forms_button_location | TEXT | Form Button Location | The button location. | Forms |
| forms_button_text | TEXT | Form Button Text | Contains the button text. | Forms |
| forms_button_type | TEXT | Form Button Type | Specifies the type of button to be displayed. | Forms |
| forms_button_width | TEXT | Form Button Width | The button width. | Forms |
| 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 |
| forms_date_created | DATE | Form Date Created | The date form was created in the format YYYY-MM-DD HH:MM:SS | Forms |
| forms_description | TEXT | Form Description (Gravity Forms) | The form description. | Forms |
| forms_descriptionplacement | TEXT | Form Description Placement | The default location of the field descriptions. | Forms |
| forms_enableanimation | BOOLEAN | Form Enable Animation | Indicates conditional logic should use a slide animation when displaying and hiding fields and buttons. | Forms |
| forms_enablehoneypot | BOOLEAN | Form Enable Honeypot | Indicates if the anti-spam honeypot feature is enabled. | Forms |
| forms_fields_enableautocomplete | BOOLEAN | Form Field Enable Autocomplete | Form Field Enable Autocomplete | Form Fields |
| forms_fields_errormessage | TEXT | Form Field Error Message | Form Field Error Message | Form Fields |
| forms_fields_id | TEXT | Form Field ID | Form Field ID | Form Fields |
| forms_fields_inputs_choices | TEXT | Form Field Input Choices | Form Field Input Choices | Form Fields |
| forms_fields_inputs_id | TEXT | Form Field Input ID | Form Field Input ID | Form Fields |
| forms_fields_inputs_inputtype | TEXT | Form Field Input Input Type | Form Field Input Input Type | Form Fields |
| BOOLEAN | Form Field Input Is Hidden | Form Field Input Is Hidden | Form Fields | |
| forms_fields_inputs_label | TEXT | Form Field Input Label | Form Field Input Label | Form Fields |
| forms_fields_inputs_name | TEXT | Form Field Input Name | Form Field Input Name | Form Fields |
| forms_fields_inputs_placeholder | TEXT | Form Field Input Placeholder | Form Field Input Placeholder | Form Fields |
| forms_fields_inputtype | TEXT | Form Field Input Type | Form Field Input Type | Form Fields |
| forms_fields_isrequired | BOOLEAN | Form Field Is Required | Form Field Is Required | Form Fields |
| forms_fields_label | TEXT | Form Field Label | Form Field Label | Form Fields |
| forms_fields_maxlength | TEXT | Form Field Max Length | Form Field Max Length | Form Fields |
| forms_fields_noduplicates | BOOLEAN | Form Field No Duplicates | Form Field No Duplicates | Form Fields |
| forms_fields_type | TEXT | Form Field Type | Form Field Type | Form Fields |
| forms_fields_visibility | TEXT | Form Field Visibility | Form Field Visibility | Form Fields |
| forms_id | TEXT | Form ID (Gravity Forms) | The form ID. | Forms |
| forms_is_active | BOOLEAN | Form Is Active | The form active/inactive status. | Forms |
| forms_is_trash | BOOLEAN | Form Is Trash | Indicates if the form is in the trash. | Forms |
| forms_labelplacement | TEXT | Form Label Placement | The default location of the field labels. | Forms |
| forms_limitentries | BOOLEAN | Form Limit Entries | Indicates if there is a limit on the number of entries this form can have. | Forms |
| 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 |
| forms_limitentriesmessage | TEXT | Form Limit Entries Message | The message that will be displayed when the limit is reached. | Forms |
| 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 |
| 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 |
| forms_postcontenttemplate | TEXT | Form Post Content Template | Template to be used when creating the post content. | Forms |
| 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 |
| forms_posttitletemplate | TEXT | Form Post Title Template | Template to be used when creating the post title. | Forms |
| 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 |
| forms_requirelogin | BOOLEAN | Form Enable Login | Indicates if the user must be logged in to access the form. | Forms |
| forms_requireloginmessage | TEXT | Form Require Login Message | The message to be displayed when the user isn’t logged in. | Forms |
| forms_save_button_text | TEXT | Form Save Button Text | The button text on the form Save button. | Forms |
| forms_save_button_type | TEXT | Form Save Button Type | The 'Save' button type. | Forms |
| forms_save_enabled | BOOLEAN | Form Save Button Enabled | Indicates if the save and continue later feature is enabled for the form. | Forms |
| forms_scheduleend | TEXT | Form Schedule End | Date in the format (MM/DD/YYYY) that the form will become unavailable. | Forms |
| forms_scheduleendampm | TEXT | Form Schedule End AM PM | Indicates if the scheduleEndHour is before or after midday. | Forms |
| forms_scheduleendhour | TEXT | Form Schedule End Hour | Hour (1 to 12) that the form will become unavailable. | Forms |
| forms_scheduleendminute | TEXT | Form Schedule End Minute | Minute that the form will become unavailable. | Forms |
| forms_scheduleform | BOOLEAN | Form Schedule Form | Indicates if the form should only be available during a scheduled period of time. | Forms |
| forms_schedulemessage | TEXT | Form Schedule Message | The message to be displayed when the form is no longer available. | Forms |
| forms_schedulependingmessage | TEXT | Form Schedule Pending Message | The message to be displayed when the form is not yet available. | Forms |
| forms_schedulestart | TEXT | Form Schedule Start | Date in the format (MM/DD/YYYY) that the form will become available. | Forms |
| forms_schedulestartampm | TEXT | Form Schedule Start AM PM | Indicates if the scheduleStartHour is before or after midday. Possible values: am or pm | Forms |
| forms_schedulestarthour | TEXT | Form Schedule Start Hour | Hour (1 to 12) that the form will become available. | Forms |
| forms_schedulestartminute | TEXT | Form Schedule Start Minute | Minute that the form will become available. | Forms |
| forms_sublabelplacement | TEXT | Form Sublabel Placement | The default location of the field sub labels. | Forms |
| forms_title | TEXT | Form Title | The form title. | Forms |
| 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 |
| forms_version | TEXT | Form Version | The Gravity Forms version used to create the form. | Forms |
| month | TEXT | Month | Number of the month | |
| 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_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 |