# FormSubmissions ## Documentation What visitors submitted through the forms of the sites. Holds personal data. A delete removes the submission. - Catalog: `Webflow` - Schema: `Forms` - Primary Keys: `id` - Retrieve: True - Insert: False - Update: False - Delete: True ## Table Columns The columns of the table `FormSubmissions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `date_submitted` | `datetime` | | ☐ | When it was submitted, UTC. | | `display_name` | `varchar2` | | ☐ | The name of the form submitted. | | `form_response_json` | `varchar2` | | ☐ | Every value submitted as JSON, keyed on the name of the field. | | `id` | `varchar2` | | ☑ | The id of the submission. | | `locale_id` | `varchar2` | | ☐ | The locale it was submitted from; null for the primary. | | `site_id` | `varchar2` | | ☑ | The site. | | `workspace_id` | `varchar2` | | ☐ | The workspace of the site. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `site_id` | [[Sites-Sites\|Sites.Sites]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Forms-FormSubmissionValues\|Forms.FormSubmissionValues]] | `form_submission_id` | Declared by the connector, not enforced by the platform |