Validation function use cases

Common use cases and code samples of validation function.

Validate if a product is eligible for delivery to a specific address

The following code sample validates whether the value in the Address__c field is included in a given array.

((default__vehicle => {
    const address = default__vehicle.Address__c;
    if(['30324','30326', '30328', '94702', '94027'].includes(address)){
        return { success: true };
    }
    return {
        success: false,
        message: "Sorry, we do not deliver to this location"
    };
})(default__vehicle);

Validate aged invoices

The following code sample validates whether the date in the Due_Date__c field is more than 90 days ahead of the current date, which indicates the invoice aging is greater than 90 days.

((invoice) => {
    const dueDate = invoice.Due_Date__c;
    const currentDate = new Date();
    const daysUntilDue = Math.floor((dueDate - currentDate) / (1000 * 60 * 60 * 24));
    if (daysUntilDue <= 90) {
        return { success: true };
    }
    return {
        success: false,
        message: "Invoice is overdue and past the 90 days threshold."
    };
})(invoice);

Validate currency format

The following code sample validates whether the value in the AcceptedCurrency__c field matches the regular expression for the USD currency format.

((account) => {
    const currency = account.AcceptedCurrency__c;
    const currencyFormatRegex = /^\$?\d{1,3}(,\d{3})*(\.\d{1,2})?$/;
    if (currencyFormatRegex.test(currency)) {
        return { success: true };
    }
    return {
        success: false,
        message: "Currency Value should be a valid USD currency format (e.g., $100,456.03)."
    };
})(account);

Validate URL protocol

The following code sample validates whether the value in the Source__c field is a valid URL.

((default__vehicle) => {
    const urlValue = default__vehicle.Source__c; 
    const url = new URL(urlValue);
    if (url.protocol === 'http:' || url.protocol === 'https:') {
        return { success: true };
    }
    return {
        success: false,
        message: "Source should have a valid URL format (e.g., http or https.)"
    };
})(default__vehicle);

Validate field entry

The following code sample validates whether the BillingState__c field is specified when the value in the Country__c field is United States.

((account) => {
    if (account.Country__c === 'United States' && !account.BillingState__c) {
        return {
            success: false,
            message: "Billing State is required for accounts in the United States."
        };
    }
    return { success: true };
})(account);

The following code sample validates whether the value in the SSN__c field is a valid social security number.

((default__Credit_Check) => {
    const ssnValue = default__Credit_Check.SSN__c;
    const ssnFormatRegex = /^(\d{3}-\d{2}-\d{4}|\d{9})$/;
    if (ssnFormatRegex.test(ssnValue)) {
        return { success: true };
    }
    return {
        success: false,
        message: "The SSN should have a valid format (###-##-####)."
    };
})(default__Credit_Check);

Validate positive values

The following code sample validates whether the value in the Credit_Limit__c field equals or is greater than 0.

((account) => {
    const creditLimit = account.Credit_Limit__c;
    if (creditLimit >= 0) {
        return { success: true };
    }
    return {
        success: false,
        message: "Credit limit cannot be negative."
    };
})(account);

Validate if a field is an email address

The following code sample validates whether the value in the Email__c field of the default__users custom object is in the format of an email address.

((default__users) => {
    const email = default__users.Email__c;
    const emailFormatRegex = /^([A-Z0-9_+-]+\.?)*[A-Z0-9_+-]@([A-Z0-9][A-Z0-9-]*\.)+[A-Z]{2,}$/i;
    if (emailFormatRegex.test(email)) {
        return { success: true };
    }
    return {
        success: false,
        message:
           "User does not have valid email format",
    };
})(default__users);

Validate field content length

The following code sample validates whether the value in the Name field of an account is equal to or less than 10 characters.

((account) => {
    const inputField = account.Name;
    if (inputField.length > 10) {
        return { success: false, message: "Account Name is too long" };
    }
    else {
        return { success: true };
    }
})(account);

Validate if a field contains special characters

The following code sample validates whether the value in the Comments field of an invoice contains any special characters.

((invoice) => {
    const comments = invoice.Comments;
    const commentFormatRegex = /^[A-Za-z0-9 ,.]+$|^$/;
    if (commentFormatRegex.test(comments)) {
        return { success: true };
    }
    return {
        success: false,
        message:
            "Invoice Comments Should Not contain special characters",
    };
})(invoice);