I am creating an App with nested forms. Is there a way to format what columns can be viewed in the form that is nested? Also, is there a way to SUM all the values of a particular column in all the nested transactions?
Example: In the below Picture, the nested form is called “Carrier”. The columns that are visible are ‘Carrier’ & ‘Truck Rego’. Is there a way to choose other columns can be viewed there? May be ‘Date’ column instead of ‘Truck Rego’?
Also, if there are 100 stock items on the “Ash hill Transport” transaction, and 150 stock items on the “Hale River Transport” transaction; Is there a way to SUM the total stock items on both transport being 250 and view the SUM at the bottom of the nested form some how?