In the app that I am building I am implementing an Order Capture, so what I did I copied all tables and settings for each column on the Order Capture sample app on Appsheet. Although I have looked into almost all details it seems I am missing one which I am asking your help to understand how to accomplish.
the ADD button to insert records on the Order Details table. (see attached pic)
Inside the reference settings for the child table (the table with the reference column - aka âOrder Detailsâ) there will be a setting: Is A Part Of - turn that off and that âin-formâ way of adding records will go away.
I donât want to remove it⌠I want to recreate this action on the app that I am building which somehow I am not managing to make this button show up
I have searched for this
âInside the reference settings for the child table (the table with the reference column - aka âOrder Detailsâ) there will be a setting: Is A Part Of - turn that off and that âin-formââ
The âIs a part ofâ setting lives in the column of the child table that is referencing the parent table. In this case, the âIs a part ofâ setting lives in the âOrder Idâ column of the âOrder Detailsâ table (child) and references the âOrderâ table (parent). By toggling this on, it allows you to create new records in the child table from the form that is associated with the parent table. Just like the sample app!
I canât thank you enoughâŚ
I have 2 additional questions:
I can now see the button but the button says ânewâ, how can I change it to âaddâ
And, this button now shows at bottom of the form how can I move it in the order I desire on the âOrderâ's form?
A common way to modify the sequence of columns in a form is by using slices. The sample app is already setup with a slice. You can find it by going to Data > Slices > Open Orders. In this case, the field you are interested in is called âOrder Details.â You can drag this field up or down in the âSlice Columnsâ section. The sequence of fields in the form will match the sequence of columns in the slice.