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.
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 automationsin 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 adminof 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:
Open the database app and click the automations icon at the top right (
Create and view automations).Open an automation, or select
New automationand choose a trigger.Select
Add action→Create record. The step appears asCreate a record.Open the app dropdown after
inand select the database the record is created in.Fill in the fields. Required fields appear automatically.
Select
Add fieldfor every other field you want to fill. Tape adds the next field, for exampleDue date. Select the field name to choose a different one.Select
Create automationfor a new automation, orSave changesfor an existing one.
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 valueis used for text and number fields. Its menu containsCalculation.Set optionis used for status and single select fields. OpenSelect an optionand pick one of the options underField options. Its menu containsCalculation.Multiple select fields use
Set options,Add options, orRemove options.Set dateis used for the date of a date field. ChooseCurrent dateto use the date of the run, orCurrent date & time, then add or subtract a number ofDays,Weeks, orMonths, for exampleCurrent date+ 7Days.Set timeis used for the time of a date field. ChooseCurrent timeand add or subtractHours, or chooseExact timeand pick a time.Person fields use
Set personorSet people, and you can alsoAdd peopleorRemove people.Relation fields use
Set recordorSearch record. Relation fields with several records useSet records,Search records,Add records, orRemove records.File and image fields use
Add files.Task list fields use
Add itemorAdd items.Link, email, and phone fields use
Add valueorAdd values. Location fields useSet value. Number fields also offerLookup, which calculates a value such asSumorAveragefrom a number field of related records.Every field also offers
Calculation. Some entries, such asClear value,Remove files, andRemove items, are only offered inUpdate 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 containsDuplicateandRemove.
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:
Set the trigger to
When a record is updatedand select theStagefield.Add the filter
WhereStageHas changed to"Qualified".Select
Add action→Create record.Choose the
Tasksdatabase app.Set
TitlewithSet valueto "Call " followed by theCompanyfield of the lead.Set
StatuswithSet optionto "To do".Select
Add field, chooseDue date, and set it withSet date.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 toManual 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
Authorisn't allowed to create records in the target database app, the step fails. Choose a person with access to the database, or leaveAuthoron 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 runruns the automation once. UnderRun on, select the records, then selectSave 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?
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?
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?
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?
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
Authorisn't allowed to create records in the database.The step failed. Open the automation, select
▷next toManual run, and check theCreate a recordstep.The action is deactivated.
Can I use the new record in later actions?
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?
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?
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 →
