Solved: Order Capture Order Details

Luis_Gomes_Mac1 · 04-09-2020 08:26 AM

Hi Guys!

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)

Can someone please point me in the right direction

Derek3

Hi Luis,

Glad that helped!

You can change the label for the “New” button by going to UX > Localize.

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.

View solution in original post

MultiTech

Do you want to remove it?

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.

Luis_Gomes_Mac1

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””

and can’t find it… please help

Luis_Gomes_Mac1

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

Derek3

Hi Luis,

You can find this setting by going to Data > Columns > Order Details > Order Id.

Click the edit icon next to the Order Id column to open the settings for the Order Id column. This is where you’ll find the setting Matt refered to.

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!

Luis_Gomes_Mac1

Hi Derek,

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?

thank again

Derek3

Hi Luis,

Glad that helped!

You can change the label for the “New” button by going to UX > Localize.

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.