How to add Single subform Row of Data based on each input of 1 field (Barcode scan)
Hello,
I can't seem to get my head wrapped around getting a subform to populate data another form properly.
I seemed to have coded something that technically populates, but it creates multiples of the same data, when I only need 1 row per entry of data in a single field, which is essentially a barcode scan field.
Form 1:
Called: Add Product
Has:
Prod Barcode
Product Name
Price
Form 2:
Called: Create Sale
Has:
Single Field called Main Barcode - this field will get the barcode scan, then be the lookup number of the product details above to populate the sub field.
Sub form called Sale Items with:
Sale Barcode
Sale Product
Sale Price
I looked at video tutorials and knowledge bases and have come up with the following workflow for user input:
prodinfo = Add_Product[prod_barcode == input.main_barcode];
prodrow = Create_Sale.sale_items();
for each prod_barcode in Add_Product
{
prodrow.sale_barcode = prodinfo.prod_barcode;
prodrow.sale_prod_name = bookinfo.prod_name;
prodrow.sale_price = prodinfo.prod_price;
prodsalecollection = Collection();
prodsalecollection.insert(prodrow);
input.sale_items.insert(prodsalecollection);
}
What happens is it actually puts an entry in, but like 15 rows of it in the sub form.
I only need to scan the product once, it populates the details in the subform and then I will have the main barcode field wipe and become the focus, ready to scan the next barcode to create the next row of data.
Anybody know what I did wrong or missed to have it create more than 1 row of the same data?
I also have a "Total" field where I coded that if the sale price sub form field is not null, to then add up each row price. the code:
var_total = 0.0;
for each sale_items in sale_items
{
if(row.sale_price != null)
{
var_total = var_total + row.sale_price;
}
}
input.main_total = var_total;
This doesnt update the total when the entries are inputted.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Chris Perkovic
Vigneshwaran K
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー