Add One Record to 2 Tables

AppSheet AppSheet Q&A
1

We have 2 Tables - Orders and Design. I want to create a Checkbox field in the Form , So when adding a New Order, If the Design Field is checked (True). This New Order should get created in both the Orders and Design Field. Like adding a new record to two tables simultaneously. Is that possible ?

If not, Is there a way to add the field values from this record in the orders table to the design table using an action button from the order list or detail view ?

2

It sounds that you are trying to use related table structure where the order itself is a parent record and design is a child record. Is my assumption correct?

3

Yes Design is a child with additional fields.

4

If you have the option “Is a part of” set as ON, you are able to fill the Child record at the same time when Parent record is filled.

2 Likes
5

Thanks Aleksi . Let me try that.