Skip to main content

Create record action

Create a record in any database app when an automation runs. Fill fields with fixed values, record values, or a calculation, and choose who it's attributed to.

Written by Leo

Create record is an action that adds a new record to a database app when your automation runs (the trigger decides when it runs, and the action decides what happens). It's meant to help you hand work from one database to another without copying data by hand.

You can use this action for many things, including:

  • Creating a follow-up task when a lead moves to the "Qualified" stage.

  • Copying a finished project into an archive database.

The Create a record action creating a task in the Tasks database with Title, Status, Due date, and Priority

Note:

  • A manual run creates real records. Test with a database app you can clean up afterward.

  • A new record can start other automations. This only happens if you turn on Trigger automations in the action menu. It's off by default. If you turn it on and the new record belongs to the database that started the automation, it can start the same automation again.

Who can use the Create record action?

  • Automations are available on all plans: Free, Plus, and Premium. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.

  • To add or change this action, you need to be a Workspace admin of the workspace the database app is in. App permissions alone aren't enough.

Add the Create record action

To create a record from an automation:

  1. Open the database app and click the automations icon at the top right (Create and view automations).

  2. Open an automation, or select New automation and choose a trigger.

  3. Select Add action → Create record. The step appears as Create a record.

  4. Open the app dropdown after in and select the database the record is created in.

  5. Fill in the fields. Required fields appear automatically.

  6. Select Add field for every other field you want to fill. Tape adds the next field, for example Due date. Select the field name to choose a different one.

  7. Select Create automation for a new automation, or Save changes for an existing one.

Adding Create record in an Expenses automation: Add action, selecting Create record, changing the database after in from Expenses to Tasks so the required fields Title and Status appear, and selecting Add field, which adds Due date
Choosing the status option of the new task from the field options

Create record settings

The action shows one row per field. Each row has three parts, from left to right: the field, how its value is set, and the value itself.

  • Target app: the database app that receives the new record. The dropdown shows the database apps of every workspace where you're a workspace admin, as long as you have full access to the database.

  • Field: open the field dropdown to choose any field of the target database. Fields the database requires are marked with a red asterisk and are added for you.

  • How the value is set: depends on the type of field.

  • Set value is used for text and number fields. Its menu contains Calculation.

  • Set option is used for status and single select fields. Open Select an option and pick one of the options under Field options. Its menu contains Calculation.

  • Multiple select fields use Set options, Add options, or Remove options.

  • Set date is used for the date of a date field. Choose Current date to use the date of the run, or Current date & time, then add or subtract a number of Days, Weeks, or Months, for example Current date + 7 Days.

  • Set time is used for the time of a date field. Choose Current time and add or subtract Hours, or choose Exact time and pick a time.

  • Person fields use Set person or Set people, and you can also Add people or Remove people.

  • Relation fields use Set record or Search record. Relation fields with several records use Set records, Search records, Add records, or Remove records.

  • File and image fields use Add files.

  • Task list fields use Add item or Add items.

  • Link, email, and phone fields use Add value or Add values. Location fields use Set value. Number fields also offer Lookup, which calculates a value such as Sum or Average from a number field of related records.

  • Every field also offers Calculation. Some entries, such as Clear value, Remove files, and Remove items, are only offered in Update record.

  • Value: type a fixed value, or insert fields of the record that started the automation. In the editor, they appear as tags like @Expense / Amount. When the automation runs, Tape replaces each tag with the value from that record.

  • Add field: adds another row.

  • The ••• menu of a row contains Duplicate and Remove.

Fields you don't add stay empty. Default values of the database's fields only apply when someone creates a record in Tape, not when an automation creates one. Set every field you need in the action, including required fields like Status.

Action menu

Open the ••• menu next to the action to find Settings, Author, Silent, Trigger automations, Trigger webhooks, Continue on error, Deactivate, Turn into, Duplicate, and Remove. For Create record, these matter most:

  • Author: the person the new record is attributed to. Without a choice, it's attributed to the automation itself. If you choose a person, Tape checks that this person is allowed to create records in the target database when the action runs.

  • Silent: creates the record without notifications.

  • Trigger automations: decides whether the new record can start other automations.

  • Trigger webhooks: decides whether the new record sends webhooks.

  • Continue on error: keeps the run going if this action fails.

Silent, Trigger automations, and Trigger webhooks are off when you add the action.

Let's look at an example

Let's say your sales team wants a task for every lead that is qualified. Here's how:

  1. Set the trigger to When a record is updated and select the Stage field.

  2. Add the filter Where Stage Has changed to "Qualified".

  3. Select Add action → Create record.

  4. Choose the Tasks database app.

  5. Set Title with Set value to "Call " followed by the Company field of the lead.

  6. Set Status with Set option to "To do".

  7. Select Add field, choose Due date, and set it with Set date.

  8. Select Create automation.

The next time a lead moves to "Qualified", a task like "Call Acme Solar" appears in Tasks.

Create record errors

  • If a required field has no value, the step fails. The run shows the step and its message, which names the missing field, for example Missing values for required fields: Status. Open the automation and select ▷ next to Manual run (View all runs, cmd/ctrl + 1). Add the field to the action, or make sure the value you insert isn't empty.

  • If the person under Author isn't allowed to create records in the target database app, the step fails. Choose a person with access to the database, or leave Author on the automation.

  • If the new record starts the same automation over and over, turn off Trigger automations. Learn more about runs that loop →

Test, pause, or edit the Create record action

  • Manual run runs the automation once. Under Run on, select the records, then select Save and start run. New records are created for real.

  • To stop only this action, select ••• → Deactivate.

  • To change the action, open the automation, select the step, make your changes, then select Save changes.

Learn more

FAQs

Can I create a record in a different database app than the trigger's?

Yes! Open the app dropdown after in and select the database. The dropdown shows the database apps of every workspace where you're a workspace admin, as long as you have full access to the database.

Can I create several records at once?

Each Create record action creates one record. To create several, add the action more than once, or put it in Loop actions. Learn more about creating records from a number →

Can I copy files from another record into the new one?

Yes. Add the file field, choose Add files, and select a file field of the current record. Choose All to copy every file, or Filtered to copy only matching files.

Why wasn't my record created?

If the record wasn't created, it could be because:

  • A required field had no value. Default values of the database app don't fill it in.

  • The person under Author isn't allowed to create records in the database.

  • The step failed. Open the automation, select ▷ next to Manual run, and check the Create a record step.

  • The action is deactivated.

Can I use the new record in later actions?

Yes. Later actions can use the new record's values. Type @ in a later action and select them from the created record.

Are there other actions I can use?

Yes! Actions can create and update records, add comments, send emails, create PDFs, call other services, and more. See every action in Automation actions →

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: record_create in the developer docs →

Still have questions? Find answers and get help from community experts in the Tape community →

Did this answer your question?