Add to referenced table mid-form

[Cameron_Brown1]

AppSheet would be 1000x better if I were able to use the little “new” button that appears when a reference is a “part of” a table, but in the middle of a form instead of purely at the end.

If the virtual column had a property like “show below” which showed this “new” button below a particular row in a form, that would be amazing.

I would love to have a tab in my form for “product information” for example, and have the user be able to take multiple “product photos” (which are stored in another table) at an arbitrary point in the form, but it currently doesn’t seem to be possible.

[Suvrutt_Gurjar · Accepted solution]

Hi @Cameron_Brown,

Welcome to this awesome AppSheet community.

If I understand your question correctly, you would like the referenced table’s new button somewhere in the middle of the form rather than at the end.

if so, you could create a slice on the table and move the virtual column up in the order in that slice. You can then base your view on that slice.

Please refer the image below wherein the related column is moved up in the order.
You can even rename this “New” button suitably per your need , say “Upload Product Photos” by using UX -> Localize pane in the AppSheet editor.

Hope thus helps.

[Cameron_Brown1]

You have just changed my life, this is perfect!

Thanks!

[Romain]

Hi, I am interested with this topic.
I don’t exactly understand how this button appears?

In my case I have an order table and an order detail tables which are linked.
When I create an order, I would like this button appears in order to add some details pieces.
When I create an order, there is only columns from the Order tables which are appearing, nothing concerning the child records.
It is only when the order is created that I see the References details with a button New
I have tried with a slice to be sure to have the VC with referenced table.

[Suvrutt_Gurjar]

Hi @Romain,

For new child table records to be added from the parent table record when the new parent table record is being created , please ensure you have selected " is part of" to “On” for the reference column of "orders’ table that you are referencing in the child table,“Order Deails”

[Romain]

Thanks @Suvrutt_Gurjar!
It works perfectly.
I didn’t know this tricks!

Learning everyday!

[Suvrutt_Gurjar]

Hi @Romain,

Good to know it works the way you wish.

However also please be aware that this “is part of” setting tighly binds or couples the parent and (associated) children records. So if a parent order record A has associated children order details records A1, A2 and A3, when you delete Order A , the children records A1, A2 and A3 will also be deleted.

Please see the description of the setting "“is part of”