# Creating Dynamic Data
Creating Dynamic Data can be achieved in several ways, one of which is by using a form. In this example, we will demonstrate how to create a new employee form that will create the employee table, columns, and data record in the Dynamic Data database when the form is submitted.
## Data provider, jig, component & action
1. **default.jigx** is the database where the Dynamic Data table is defined.
2. [jig.default](/examples/readme/jig-types/jig_default.md) is the type of jig we will use to contain the form.
3. [form](/examples/readme/components/form.md) is the component used with text and date fields.
4. [submit-form](/examples/readme/actions/submit-form.md) is the action that executes the create method of the Dynamic Dataprovider
## Examples and code snippets
Form creating Dynamic Data
Dynamic data database
## Create the Dynamic Data table
{% columns %}
{% column %}
In Jigx Builder under the databases folder in the **default.jigx** file the employee table is added. This will create the table in Dynamic Data.
{% endcolumn %}
{% column %}
{% code title="default.jigx" %}
```yaml
tables:
employee: null
```
{% endcode %}
{% endcolumn %}
{% endcolumns %}
## Create the jig, form and action
The code example below is for the `jig.default` with the `component.form` that uses `componet.text` and `component.date-picker` to create the fields on the form. The `action.submit-form` executes the `DATA_PROVIDER_DYNAMIC` that uses the `save/create` method to create columns and data records.
{% tabs %}
{% tab title="new-employee-form.jigx" %}
{% code fullWidth="true" %}
```yaml
title: New Employee
description: Employee form
# use the default jig as the container for the form
type: jig.default
icon: person-task-2
header:
type: component.jig-header
options:
height: medium
children:
type: component.image
options:
source:
uri: https://images.unsplash.com/photo-1522202176988-66273c2fd55f?q=80&w=1471&auto=format&fit=crop&ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D
children:
- type: component.section
options:
title: Personal Information
children:
# add the form component with fields to capture the dynamic data record
- type: component.form
# The id is used in the action for context to the fields which crete the columns and data
instanceId: form-employee
options:
children:
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: first_name
options:
label: First Name
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: last_name
options:
label: Last Name
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: address
options:
label: Address
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: contact
options:
label: Contact Information
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: email
options:
label: Email
- type: component.section
options:
title: Employment Information
children:
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: job_title
options:
label: Job Title
- type: component.text-field
# The name in the instanceId becomes the column name and the value entered in the field becomes the column data value
instanceId: department
options:
label: Department
- type: component.date-picker
# The name in the instanceId becomes the column name and the value entered
# in the field becomes the column data value.
instanceId: start_date
options:
label: Start Date
actions:
- children:
# use the submit form action to execute the create/save method of the Dynamic Data provider.
- type: action.submit-form
options:
# The formId is used to get the context to the fields and values that specify the columns
# and data.
formId: form-employee
# specify the Dynamic Data provider to store the employees data record.
provider: DATA_PROVIDER_DYNAMIC
title: Create Record
entity: default/employee
# use the create or save method, the first exection will create columns and records,
# the second will create data records as the columns already exist.
method: save
# Cater for offline data handling to add the save command to the queue.
# Once the device is back online the queue is cleared and the save command executes.
# By default the command is added to the queue if queueOperations is ommitted.
queueOperation: add
onSuccess:
type: action.go-back
```
{% endcode %}
{% endtab %}
{% tab title="index.jigx" %}
```yaml
name: employees
title: Employees
category: business
tabs:
home:
jigId: new-employee-form
icon: home-apps-logo
```
{% endtab %}
{% endtabs %}
## View the Dynamic Data in Jigx Management
1. Open [Management](https://docs.jigx.com/administration/management-overview), navigate to your solution (employees).
2. Navigate to **Data** option
3. Click on the **employee table** and view the **data record** you just created.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.jigx.com/examples/readme/data-providers/dynamic-data/creating-dynamic-data.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.