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.
Solved! Go to Solution.
Hello @ed_day, Nested forms are a side product of references
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 !
Hello @ed_day, Nested forms are a side product of references
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 !
Exactly what I needed thanks!
User | Count |
---|---|
27 | |
26 | |
22 | |
22 | |
21 |