Save two linked tables in one form

Example: Creating an employee record and linking them to a newly created job

Use this pattern when one form needs to create a parent row and optionally create a related child row.

Build the form

  1. Add a Form block
  2. Set the table to Jobs
  3. Eject the form block
  4. Add an Options picker for choosing an existing or new employee
  5. Add conditions so the relationship field and the new employee fields only show when needed

Save the rows

  1. Save the job first
  2. Save the employee second when NEW is selected
  3. Use the saved job ID to link the employee row to the new job

Why this works

The first save creates the job row, and the second save can reference that new job ID.

App export


Did this page help you?