Add rows to subform (Form B) with dynamic data comming from another form (Form A)
Form A is a Requisition form where People select products to get Quotes from suppliers. Subform in Form A looks like below-Form B is a Quotation form where vendor submits quotes for products
Above data in subform A needs to be displayed in subform B(this is Vendor screen) like below
Vendor A should see like
Product Quantity Price
Product 1 10 [Vendor will enter]
Vendor B should see like
Product Quantity Price
Product 1 15 [Vendor will enter]
Product 2 15 [Vendor will enter]
Vendor just need to enter the price for product given to him only, as shown in 1st screenshot (Form A subform), product and quantity needs to be populated for vendor subform automatically via deluge when Form A is submitted successfully, example screen of vendor is below
I want below script to segregate the subform A data and dynamically create row1, row2, row3 -
- row1 = Add_Quotation.Products();
- row1.Product="P1";
- row1.Quantity="1";
- row2 = Add_Quotation.Products();
- row2.Product="P2";
- row2.Quantity="2";
- rows = Collection();
- rows.insert(row1,row2);
- obj = insert into Add_Quotation
- [
- Products=rows
- Request_ID=input.Request_ID
- Added_User=zoho.loginuser
- ];