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
- Add a Form block
- Set the table to
Jobs - Eject the form block
- Add an Options picker for choosing an existing or new employee
- Add conditions so the relationship field and the new employee fields only show when needed
Save the rows
- Save the job first
- Save the employee second when
NEWis selected - 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
Updated 4 months ago
Did this page help you?