I have an installation app that (among others) has tables:
installations This captures details for the installation (length/width of installation area, etc)
items This lists all item information, such as name, price weight etc
installation_items This is the table that combines the two, because there is a many to many relationship. Each record in this table contains: - a ref to an installation - a ref to an item - an amount
This all works as planned: a user can create an installation, and add certain items, to that installation, etc.
However, I would like some items to be added automatically, based on installation parameters (e.g. add [length]*[width]/10 amount of item X to the installation). This would require AppSheet to create an entry in both the installation and installation_items table. Ideally, the latter entry should then be editable, in case a customers want to add additional items to the installation.
Is this possible?