How to add new row immediately below the current row and not in the last.
My current script is adding new row at the end of the subform but I want to add row next to or just below the current row. Can anyone help?
Current Script:
Writer
Get Started. Write Away!
Current Script:
// Extract the numeric quantity from the 'Quantity added' string
addedQtyText = row.Quantity_Added.toString();
addedQtyNum = addedQtyText.replaceAll("[^0-9.]","");
// Remove all non-numeric characters, assuming a period for decimals
// Convert to number, with error handling for empty or invalid input
try
{
addedQty = addedQtyNum.toDecimal();
}
catch (e)
{
addedQty = 0;
// Set a default or handle the error as appropriate
}
// Extract the numeric quantity from the 'Quantity to add' string
//toAddQtyText = input.Ingredients.Quantity_to_add.toString();
toAddQtyText = row.Quantity_to_add.toString();
toAddQtyNum = toAddQtyText.replaceAll("[^0-9.]","");
// Convert to number, with error handling
try
{
toAddQty = toAddQtyNum.toDecimal();
}
catch (e)
{
toAddQty = 0;
// Set a default or handle the error as appropriate
}
// Validation for excess quantity
if(addedQty > toAddQty)
{
alert "Please check the quantity added, as it is more than required. कृपया जोड़ी गई मात्रा की जांच करें, क्योंकि यह आवश्यकता से अधिक है।";
return;
// Stop execution if the added quantity is too much
}
// Calculate the difference percentage
difference = toAddQty - addedQty;
percentageDiff = difference / toAddQty * 100;
// Check if the difference is greater than 0.5%
if(percentageDiff > 0.5)
{
// Add a new row with the same ingredient name and the difference as 'Quantity to add'
newSubformRow = Production_Batch.Ingredients();
newSubformRow.Ingredients=row.Ingredients;
newSubformRow.Quantity_to_add=difference.toString();
// Create a collection to hold the new row
rowsCollection = Collection();
rowsCollection.insert(newSubformRow);
// Use 'insert' to add the collection to the subform
input.Ingredients.insert(rowsCollection);
// Prompt for the remaining quantity
alert "Enter the remaining quantity in the next field and scan the new batch. अगले फील्ड में शेष मात्रा दर्ज करें और नए बैच को स्कैन करें।";
}
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
Akul
Damien Cregan
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セミナー