Create Database Record

	Component	Type	Description
	Create Database Record	🔀 action	Create a new database record

The Create Database Record component allows you to create records inside of an existing database at any point in a workflow.

You can have multiple Create Record components in your workflow, allowing you to create records in multiple databases from a single workflow session.

Configuring the record to be created

To set up the Create Database Record component, select a database from the dropdown menu:

Then click Get Data to retrieve and display the columns of that database:

You can now configure the values you want for the record. You directly type in a value, use placeholders to dynamically set the value when the workflow session runs, or mix placeholders and something typed together:

Once set up, this component will create a record with those values inside of the selected database.

Output from the create record component

The placeholder outputted from the Create record component is the record/row ID for the record/row it creates. This can then be passed to other components for additional operations e.g. Update Database Record component.

What happens if there is an error when creating a record?

When creating a record, an error may occur if the input data type does not match the column data type. For example, creating a record where there is a datetime column, but the input value is not a valid datetime. In this scenario, this column will be skipped and the create record will continue.