Unlike the example template, add form does not display the option to add underlying entries for REF_ROWS

[dntrplytch]

Issue: Add form (to add a new record) does not display the option to add underlying entries for REF_ROWS .

Reference: A template application that does work:

This is from the application - Order Capture How-to (which I copied locally - but you can also “Look Under the Hood”)

However, when I try to mimic the same behavior, I do not see the equivalent OrderDetailsIdx with the Add button

Note: The Detail view does let you enter the OrderDetails; but I would like to mimic the behavior where it allow you to add the Order Details as/when the order is created.

I will share screenshots for the various definitions:

The Order Form (system generated) is displayed in the images above.

In trying to troubleshoot, I’ve tried to mirror not only table / view settings - but also global settings (such as Settings –> Legacy –> Blank value comparison mode) from the working “Order Capture How-to” template.

Note: The suggested resolution in Order Capture - ‘Add button’ does not work (as also reported by a user towards the end of that thread)

Note 2: I do not use slices in my data - the template example does - not sure if that matters

Regards.

[Denzil_Snyman]

@dntrplytch You should enable “Is Part Of” on Orderidx column of the child table.

Note that they will be deleted from the child table when the parent is deleted as they are considered part of that parent record.

[dntrplytch]

Thank you @Denzil_Snyman

Upon having reviewed numerous posts on this very issue, one of the responses indicated that the “out of the box” REF_ROWS that is generated will work if “Is Part Of” is enables. That is indeed the case. I had unnecessarily replicated the REF_ROWS column by manually creating it. From all estimates, there did not seem a difference between what I had created and the entry auto generated by AppSheet.

In my case, the solution was to delete the virtual column introduced by me and instead use the virtual column generated by AppSheet (Related Order Details) above.

The final solution looks like: