@Lucky1 You can create a client script as given below:
Client Script Details, you can adjust it as per your requirement for the subsequent action to be taken:
Type: onChange
Table: Change Request (change_request)
Field: Start date (start_date) or End date (end_date)
Script: The script will validate the difference between the two dates when either field is updated.
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
// Ensure the script runs only when the form is not loading
if (isLoading || newValue === '') {
return;
}
// Get the values of Start date and End date fields
var startDate = g_form.getValue('start_date');
var endDate = g_form.getValue('end_date');
// If either field is empty, exit the script
if (!startDate || !endDate) {
return;
}
// Convert the date strings to JavaScript Date objects
var startDateObj = new Date(startDate);
var endDateObj = new Date(endDate);
// Calculate the difference in milliseconds
var timeDifference = endDateObj - startDateObj;
// Convert the difference to minutes
var timeDifferenceInMinutes = timeDifference / (1000 * 60);
// Check if the difference is less than 15 minutes
if (timeDifferenceInMinutes < 15) {
// Show an error message to the user
g_form.showFieldMsg('end_date', 'The difference between Start date and End date must be at least 15 minutes.', 'error');
// Clear the End date field to force the user to correct it
g_form.setValue('end_date', '');
} else {
// Clear any existing error messages
g_form.hideFieldMsg('end_date');
}
}
If my response helped you in anyway please mark it as helpful.
Thank you,
Mahesh.
