Skip to main content

Create related records

Create a new record in a linked database app straight from a relation field, without leaving the record you're working on.

Written by Leo

A relation field links a record to records of another database app, such as a property to its owner. When the record you need doesn't exist yet, you can create it right from the field. The new record opens on top of the current one, and it's linked as soon as you create it. This is meant to help you keep your flow while you build up connected information.

The relation picker of the Primary contact field with Search contacts…, the plus button for a new contact, and the list of contacts

Note:

  • The field must allow creating. Allow create is a setting of the relation field in the record layout. If it's off, you can only link existing records.

  • You need permission to create records in the linked database app. Without it, the button isn't offered.

  • Records stack. You can create a related record while you create another one. Closing with unsaved input asks Discard changes in all records?.

Who can create related records?

Create a related record

  1. Open a record that has a relation field.

  2. Click the field, for example Add contact. The picker lists the records of the linked database app, with a search field such as Search contacts….

  3. Click + next to the search field. If you've typed a name that doesn't exist yet, you can also select the entry below the search, for example New contact.

  4. Fill in the fields of the new record.

  5. Select the create button at the bottom, which names the record type, for example Create Contact.

If the relation field links to more than one database app, Tape first asks which app the new record belongs to.

Adding to the Primary contact field, clicking the plus button in the picker, typing a name in the New Contact window, and clicking Create Contact so the new contact appears in the Primary contact field

The new record is added to the relation field of the record you started from. Learn more about relation fields →

Cancel a related record

Select Cancel. If you've entered something, Tape asks Discard changes?. When several records are open on top of each other and you close them all, Tape asks Discard changes in all records?. Select Discard all to throw away the input of all of them.

Clicking Cancel in the New Contact window and clicking Discard in the Discard changes? dialog, so the window closes and the record shows again

Allow or stop creating from a field

If you have Full access, you can decide per layout whether a relation field allows creating:

  1. Open the layout editor: open the app menu of the database app, or ••• in a record, and select Customize record layout. Learn more about the layout editor →

  2. Click the drag handle (⋮⋮) of the relation field and select Edit field display.

  3. Select Layout.

  4. Turn Allow create on or off. It's on by default.

Clicking the drag handle of Primary contact in the layout editor, selecting Edit field display and Layout, and turning off Allow create

Allow create isn't offered when the field uses the Dropdown layout with Display as set to Select. Learn more about relation blocks →

FAQs

Can I create a related record for a single relation field that already has a value?

No. A relation with a limit of one record shows no add button once it has a value. Remove the linked record first.

Can I choose which database app the new record is created in?

Only if the relation field links to more than one database app. Then Tape asks which of these apps the new record belongs to. Otherwise, the new record is always created in the linked database app.

Why don't I see the + button in the picker?

Allow create may be turned off for that field, the field may use the Dropdown layout shown as Select, or you may not have permission to create records in the linked database app.

Do required fields apply to the new record?

Yes. Required fields of the linked database app must be filled in before you can create the record.

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

Did this answer your question?