I am trying to add a new row to another table based on value of an existing Table.
What users of the doc must be able to do is :
Choose the Purchase Requisition (PR) that he/she wants to add the items from Catalog of Items
Users will then select the items to add into the selected Purchase Requisition from the Catalog of Items Table
a) If PR has no items added yet it will not be shown under All Purchase Request Table
b) When a user starts to increase quantity of an item it will be added to the All Purchase Request Table.
I’ve been trying to figure it out but i am still confused on how to create formulas when grouping of rows is involved.
Below is the screenshot of my doc for your reference
Thank you very much