> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# form_field_value table

> Form field values saved in a searchable format

## form\_field\_value Table (538)

Form field values saved in a searchable format

## Fields

| Name                      | Description                                      | Type                                         | Nullable |
| ------------------------- | ------------------------------------------------ | -------------------------------------------- | :------: |
| form\_field\_value\_id    | Primary key                                      | PK                                           |    No    |
| form\_submission\_id      | The form submission this set of values belong to | FK [form\_submission](./form-submission.mdx) |    Yes   |
| rank                      | The rank of this form field within the form      | Int                                          |    Yes   |
| label                     | The label of this form field                     | String(4000)                                 |    Yes   |
| type                      | The type of this form field                      | String(4000)                                 |    Yes   |
| sequence                  | The sequence of this form field                  | Int                                          |    Yes   |
| string\_value             | The string value of this form field              | String(4000)                                 |    Yes   |
| int\_value                | The integer value of this form field             | Int                                          |    Yes   |
| double\_value             | The double value of this form field              | Double                                       |    Yes   |
| bool\_value               | The boolean value of this form field             | Bool                                         |    Yes   |
| datetime\_value           | The datetime value of this form field            | DateTime                                     |    Yes   |
| registered                | Registered when                                  | UtcDateTime                                  |    No    |
| registered\_associate\_id | Registered by whom                               | FK [associate](./associate.mdx)              |    No    |
| updated                   | Last updated when                                | UtcDateTime                                  |    No    |
| updated\_associate\_id    | Last updated by whom                             | FK [associate](./associate.mdx)              |    No    |
| updatedCount              | Number of updates made to this record            | UShort                                       |    No    |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/form_field_value.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=3340eadf0b5515117fb98be256e2e75f" alt="form_field_value table relationship diagram" width="763" height="59" data-path="media/loc/en/database/tables/form_field_value.png" />

## Indexes

| Fields               | Types        | Description |
| -------------------- | ------------ | ----------- |
| form\_submission\_id | FK           | Index       |
| label                | String(4000) | Index       |
| type                 | String(4000) | Index       |
| sequence             | Int          | Index       |
| string\_value        | String(4000) | Index       |
| int\_value           | Int          | Index       |
| double\_value        | Double       | Index       |
| bool\_value          | Bool         | Index       |
| datetime\_value      | DateTime     | Index       |

## Relationships

| Table                                 | Description                                                        |
| ------------------------------------- | ------------------------------------------------------------------ |
| [associate](./associate)              | Employees, resources and other users - except for External persons |
| [form\_submission](./form-submission) | A form submission                                                  |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Enum values for FormFieldRestrictionType](/en/database/tables/enums/formfieldrestrictiontype.md)
- [form_field_restriction table](/en/database/tables/form-field-restriction.md)
- [form_submission table](/en/database/tables/form-submission.md)
- [form table](/en/database/tables/form.md)
- [Forms](/en/automation/crmscript/howto/marketing/forms.md)
- [What's new in version 10.3.5.599](/release-notes/database/changes-10.3.5.md)