Nested forms example is beyond me!

[ed_day]

Can anyone help me with the Nested forms example please? Nested forms - AppSheet

I cannot see anything that makes it tick. The only novel thing I have discovered is ‘source: nested’ but I cannot figure out how to set that (or maybe ‘nested’ is just the app’s name?).

Any pointers on where to look are much apprecited.

[Rafael_ANEIC-PY · Accepted solution]

Hello @ed_day, Nested forms are a side product of references

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

Basically, when you create a Ref type column in a table, and point it to another table, you’re creating a parent-child relationship, the child is the one that has the ref column in it, the parent table is the one to which the reference is pointed to.

To represent this relationship, AppSheet automatically creates a virtual column in your parent table called “Related (something)”

When you add a new row in your parent table, you get the option of adding new rows to your child table as well as a consequence of this relationship and the presence of the “Related (something)” virtual column that was created automagically in this process.

For example, if you had table “Fruits” and table “Basket” you would create a ref column in table “Fruits” pointed at “Basket”, so that when you create a new row in your “Basket” table, now you can add “Fruits” to it !

[ed_day]

Exactly what I needed thanks!