dynamic population of the rows via email script

tghadage124
Tera Contributor

‎10-28-2024 12:24 AM - edited ‎10-28-2024 12:25 AM

what i trying to do is add rows to the notifications based on the selected vendor_count. if two is selected then two rows will be populated with the given information. 

 

here is the script : 

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {

    // Initialize the company and requisition GlideRecords
    var company = new GlideRecord('core_company');
    company.get(current.company); // Get company record using the company's sys_id

    var requisition = new GlideRecord('x_jade_procurement_it_purchase_requisition');
    requisition.get(current.sys_id); // Get requisition record using the requisition's sys_id

    // Initialize email body variable
    var emailBody = "";

    // Add company information in table format with blue headers
    emailBody += "<h2>Company Information</h2>";
    emailBody += "<table border='1' style='width:100%; border-collapse: collapse;'>";
   
    // Add blue color to the company table headers
    emailBody += "<tr style='background-color: #007bff; color: white;'>";
    emailBody += "<th>Vendor Name</th>";
    emailBody += "<th>Quotation</th>";
    emailBody += "<th>Unit Quantity</th>";
    emailBody += "<th>Price Per Unit</th>";
    emailBody += "<th>Total</th>";
    emailBody += "</tr>";

    // Add rows for each vendor depending on vendor count
    if (requisition.vendor_count >= 1) {
        // First vendor
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.vendor_1.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.quotation_1.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.unit_quantity_1 + "</td>";
        emailBody += "<td>" + requisition.price_per_unit_1 + "</td>";
        emailBody += "<td>" + requisition.total_1 + "</td>";
        emailBody += "</tr>";
    }

    if (requisition.vendor_count >= 2) {
        // Second vendor
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.vendor_2.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.quotation_2.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.unit_quantity_2 + "</td>";
        emailBody += "<td>" + requisition.price_per_unit_2 + "</td>";
        emailBody += "<td>" + requisition.total_2 + "</td>";
        emailBody += "</tr>";
    }

    if (requisition.vendor_count >= 3) {
        // Third vendor
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.vendor_3.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.quotation_3.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.unit_quantity_3 + "</td>";
        emailBody += "<td>" + requisition.price_per_unit_3 + "</td>";
        emailBody += "<td>" + requisition.total_3 + "</td>";
        emailBody += "</tr>";
    }

    emailBody += "</table>";

    // Add requisition details with blue headers
    emailBody += "<h2>Requisition Details</h2>";
    emailBody += "<table border='1' style='width:100%; border-collapse: collapse;'>";
   
    // Add blue color to the requisition table headers
    emailBody += "<tr style='background-color: #007bff; color: white;'>";
    emailBody += "<th>Requisition Number</th>";
    emailBody += "<th>Requestor Name</th>";
    emailBody += "<th>Assigned To</th>";
    emailBody += "<th>Short Description</th>";
    emailBody += "<th>Delivery Location</th>";
    emailBody += "<th>Status</th>";
    emailBody += "<th>Description</th>";
    emailBody += "<th>Quantity</th>";
    emailBody += "<th>Department</th>";
    emailBody += "</tr>";

    // Ensure requisition record is retrieved successfully before accessing its fields
    if (requisition.isValidRecord()) {
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.requisition_no + "</td>"; // Requisition Number
        emailBody += "<td>" + requisition.requester_name.getDisplayValue() + "</td>"; // Requestor Name
        emailBody += "<td>" + requisition.assigned_to.getDisplayValue() + "</td>"; // Assigned To
        emailBody += "<td>" + requisition.short_description + "</td>"; // Short Description
        emailBody += "<td>" + requisition.delivery_location.getDisplayValue() + "</td>"; // Delivery Location
        emailBody += "<td>" + requisition.status + "</td>"; // Status
        emailBody += "<td>" + requisition.description + "</td>"; // Description
        emailBody += "<td>" + requisition.quantity + "</td>"; // Quantity
        emailBody += "<td>" + requisition.department.getDisplayValue() + "</td>"; // Department
        emailBody += "</tr>";
    } else {
        emailBody += "<tr><td colspan='9'>No requisition details available.</td></tr>";
    }

    emailBody += "</table>";

    // Print email body to template
    template.print(emailBody);

})(current, template, email, email_action, event); 
 
here is the snipate of the email notification : 
tghadage124_0-1730100547477.png

 

here in the company information there will be two rows in the company section if the vendor count is 2 .
script is not working 
 
please help!!
0 Helpfuls
  • 694 Views
5 REPLIES 5

Ramesh Poola
Tera Guru

‎10-28-2024 12:37 AM

Hi @tghadage124 ,

Did you tried by putting some logs there, to understand its entering the second if condition "  if (requisition.vendor_count >= 2)" or not.



0 Helpfuls

tghadage124
Tera Contributor
In response to Ramesh Poola

‎10-28-2024 03:43 AM

yes I did its not getting in the loop

0 Helpfuls

Ramesh Poola
Tera Guru
In response to tghadage124

‎10-28-2024 03:54 AM

Then put some more logs and see what is the values you are getting for the all variables you have.

 

And also try to build your if conditions like below and see once

 

If 1st condition {

   If 2nd condition {

        If 3rd condition {

        }

   }

}

 

Please check and let me know 

0 Helpfuls

tghadage124
Tera Contributor
In response to Ramesh Poola

‎10-28-2024 07:55 AM

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {

    var company = new GlideRecord('core_company');
    company.get(current.company);

    var requisition = new GlideRecord('x_jade_procurement_it_purchase_requisition');
    requisition.get(current.sys_id);

    var emailBody = "";

    emailBody += "<h2>Company Information</h2>";
    emailBody += "<table border='1' style='width:100%; border-collapse: collapse;'>";
    emailBody += "<tr style='background-color: #007bff; color: white;'>";
    emailBody += "<th>Vendor Name</th>";
    emailBody += "<th>Quotation</th>";
    emailBody += "<th>Unit Quantity</th>";
    emailBody += "<th>Price Per Unit</th>";
    emailBody += "<th>Total</th>";
    emailBody += "</tr>";

   gs.info('check if its getting inside ');
    if (requisition.vendor_count >= 1) {
       
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.quatation.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.unit_quantity.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.price_per_unit + "</td>";
        emailBody += "<td>" + requisition.total + "</td>";
        emailBody += "</tr>";

    } else if (requisition.vendor_count >= 2) {
       
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.quatation.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.unit_quantity.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.price_per_unit + "</td>";
        emailBody += "<td>" + requisition.vender_2.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.qunatity2.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.price_per_unite2 + "</td>";
        emailBody += "<td>" + requisition.total + "</td>";
        emailBody += "</tr>";

    } else if (requisition.vendor_count >= 3) {
       
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.quatation.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.unit_quantity.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.price_per_unit + "</td>";
        emailBody += "<td>" + requisition.vender_2.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.qunatity2.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.price_per_unite2 + "</td>";
        emailBody += "<td>" + requisition.vender3.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.quantity3.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.price_per_unite3 + "</td>";
        emailBody += "<td>" + requisition.total + "</td>";
        emailBody += "</tr>";
    }

    emailBody += "</table>";

   
    emailBody += "<h2>Requisition Details</h2>";
    emailBody += "<table border='1' style='width:100%; border-collapse: collapse;'>";
   
    emailBody += "<tr style='background-color: #007bff; color: white;'>";
    emailBody += "<th>Requisition Number</th>";
    emailBody += "<th>Requestor Name</th>";
    emailBody += "<th>Assigned To</th>";
    emailBody += "<th>Short Description</th>";
    emailBody += "<th>Delivery Location</th>";
    emailBody += "<th>Status</th>";
    emailBody += "<th>Description</th>";
    emailBody += "<th>Quantity</th>";
    emailBody += "<th>Department</th>";
    emailBody += "</tr>";

    if (requisition.isValidRecord()) {
       
        emailBody += "<tr>";
        emailBody += "<td>" + requisition.requisition_no + "</td>";
        emailBody += "<td>" + requisition.requester_name.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.assigned_to.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.short_description + "</td>";
        emailBody += "<td>" + requisition.delivery_location.getDisplayValue() + "</td>";
        emailBody += "<td>" + requisition.status + "</td>";
        emailBody += "<td>" + requisition.description + "</td>";
        emailBody += "<td>" + requisition.quantity + "</td>";
        emailBody += "<td>" + requisition.department.getDisplayValue() + "</td>";
        emailBody += "</tr>";

    } else {
       
        emailBody += "<tr><td colspan='9'>No requisition details available.</td></tr>";
    }

    emailBody += "</table>";

   
    template.print(emailBody);

})(current, template, email, email_action, event); 
 
here what changes what i made , making it condition if else. 
 
 Screenshot (419).png 
still its the company data is not getting populated 
0 Helpfuls