Template
Add Rows 1
Demo: Add any number of rows from any row within a table
This app demonstrates a way to allow adding an arbitrary number of rows to a table from any new or existing row of that same table.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
A common question in the AppSheet Creator Community is how to automatically add an arbitrary number of rows to a table. Unfortunately, there is no inherent way to do so, and I would characterize the approach I demonstrate here as advanced. I'm not aware of a simple way to accomplish this.
This demo makes use of four actions to add the rows recursively. The recursion is constrained by the recursion counter in the row that originated the adds. A form is used to set the counter of any new or existing row, and a form-saved action then adds the additional rows. The counter is decremented as each new row is added.
Every row addition produces two table updates: the new row, and the decrement of the counter in the origin row. Adding a large number of rows will quickly produce a large backlog of updates to sync. All of the work is done on the user's device--no workflow is involved--so all new rows are available on the originating app immediately.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...