Creating a Multi-Table Form in AppSheet

AppSheet AppSheet Q&A
, ,
1

Hi everyone,

I’m new to AppSheet and I’m building an app to track sales and income. AppSheet automatically generates a form for creating new sales, but it only includes fields from the Sales table.

I want to enhance this form to capture additional information for related tables:

  • Payment Schedule: I need to collect details about payment installments, like due dates and amounts.
  • Sale Items: I want to record individual items, quantities, and prices for each sale.

How can I modify the form to include these fields and automatically create records in the related tables when the form is submitted?

Any tips or code examples would be greatly appreciated.

2

Consider setting the IsAPartOf option to both Payments and Items tables.

2 Likes