Insert editable table into form

Hello everyone.

My goal is to achieve the following : Having a given form for a given table A, I want this form to have a table view inside. This table view is on table B which has a reference to table A. And we can add rows to this table This action will trigger another form to fill the new row informations, and when finished, this send us back to the main form so that we can continue the input, the table is always displayed even if empty.

A similar thing was answered here : https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Insert-Table-into-a-Form-view/m-p/388827

But the solution proposed on the link above works only for display, I cannot add or delete any row in the table. And when there is no informations in the table, the table doesn’t show at all.

I have come with a close solution, it is to set the row action of the table view to ‘Add’ which add the plus signs as you can see below.

This action will send us on the form to add a row to the table but this kicks us out of the original form.

So I wanted to know if what I wanted was even possible and if so, how can I do it ?

I have finally solved the problem by using the parent child relationship.

When creating ref to tables, virtual columns named ‘Related TABLE_NAME’ are automatically created.

Inserting these rows in my form solved my problem as you can see below. Hope this help someone in the same situation.

2 Likes