Author: Jency Nidhin

Show a pop-up window for the user to enter the text message

When the user needs to type any test messages in a pop-up window, use the below-added code section. let popUpWindow = ”; while (!popUpWindow) { popUpWindow = prompt(“Write the message to display in the pop-up window”); }; let changingReason = popUpWindow; Here the message entered by the user will be displayed in the ‘changingReason’ variable.

Proposal For Cautionary Pop-up on Re-printing the Picking Ticket

This proposal covers the process of displaying a cautionary pop-up when re-printing the picking ticket. Proposal summary The proposal covers the new customization in the sales order record which is to show a cautionary pop-up message when re-printing the picking ticket more than once. Requirement Show a cautionary pop-up alert message when trying to print… Continue reading Proposal For Cautionary Pop-up on Re-printing the Picking Ticket

Schedule a workflow to change the status of a particular record

If a user need to change the status in a particular record, then you can choose the scheduled workflow. This workflow will trigger at the scheduled time. To configure the scheduled workflow, first, we need to create a saved search for that particular record. Scheduled workflows always run on all of the records in the… Continue reading Schedule a workflow to change the status of a particular record

Search formula to find the latest date among the three dates

Scenario: If we need to find the latest date/the recent date among the three dates in a saved search, use the following formula in the search criteria. Formula(Date): CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_second_expiry_date},{custrecord_project_first_expiry_date})) THEN (CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_third_expiry_date},{custrecord_project_first_expiry_date})) THEN {custrecord_project_first_expiry_date} ELSE {custrecord_project_third_expiry_date} END) ELSE (CASE WHEN ({custrecord_project_second_expiry_date}>= NVL({custrecord_project_third_expiry_date},{custrecord_project_second_expiry_date})) THEN {custrecord_project_second_expiry_date} ELSE {custrecord_project_third_expiry_date}END )END

An error occurred during custom object validation

The given image shows that when we are ‘Add Dependency References to Manifest’, while we are trying to deploy objects to a new account, there may cause an error like ‘The object reference [scripid=scriptid] is missing in the project and also not included in the dependencies list’. This is because the ‘scriptid’ used in the… Continue reading An error occurred during custom object validation

To get the link of a particular record using the script

If we need to set the record id instead of setting it by hard coding, add the following code, For Eg, we need the link to a particular sales order ‘123’ var salesOrderURL = url.resolveRecord({ recordType: record.Type.SALES_ORDER, recordId: salesOrderId, isEditMode: false }); // to get the link of the sales order var companyInfo = config.load({… Continue reading To get the link of a particular record using the script

Function to fetch the Start time and End time for saved search based on the availability of the processor.

Case: When we schedule a script to run every 6 hours, then it will run at 12 am, 6 am, 12 pm, and 6 pm. when the script runs at 6 am, then we need the data from the time 12 am up to 5.59 am. But in case of priority, the scheduler runs at… Continue reading Function to fetch the Start time and End time for saved search based on the availability of the processor.

To check whether the Date created date and Line system note date is the same or not

If you want to check whether the sales order’s date created and the line system notes date are the same or not, we need to create a formula text field in the saved search. formulatext: CASE WHEN (TO_CHAR({datecreated}, ‘DD/MM/YYYY HH24:MI’)=TO_CHAR({linesystemnotes.date}, ‘DD/MM/YYYY HH24:MI’)) THEN ‘Yes’ ELSE ‘No’ END When we use this formula in the saved… Continue reading To check whether the Date created date and Line system note date is the same or not