Field Validation examples

FieldTwo checks if it is equal to FieldOne, if not: show error

1. FieldOne: no validation

2. FieldTwo:

   1. Set validation error via: Javascript

   2. Validation Error:

      1. if (#REPLACE-PARTVALUE-FieldOne||# !== #REPLACE-PARTVALUE-FieldTwo||#) return 'Field one must be equal to field two';

   3. Screenshot

Compare dates

1. Field ‘DateToCompareTo’ contains the date to compare the other field ‘DateAfterDateToCompareWith. ‘DateToCompareTo’ can be filled form the workflow and set as read-only.

   1. This is the default value to set on ‘today’:

      1. Default value type: NCALC

      2. Default value: FORMAT('{0:yyyyMMdd}', NOW())

2. DateAfterDateToCompareWith

   1. Set validation error via: Javascript

   2. Validation error:

      1. if (#REPLACE-PARTVALUE-DateAfterDateToCompareWith||# < #REPLACE-PARTVALUE-DateToCompareTo||#) return 'Date must be after date to compare with';

      2. Screenshot:

3. DateAfterToday checks if the filled in date is in the future.

   1. Set validation error via: NCALC

   2. Validation error;

      1. IIF('#REPLACE-PARTVALUE-DateAfterToday||#' < FORMAT('{0:yyyyMMdd}', NOW()), 'Date must be after today', '')

Field cannot contain negative values (-)

1. var thenumber = Number(#REPLACE-PARTVALUE-nummer||#);

2. if (thenumber && thenumber < 0) return "Only positive numbers allowed";

Make a field required (example is for Document template part)

In the example below, 2 fields are required:

var toreturn = { success: true };

var parts = JSON.parse(g_data_string).parts; var category = parts.filter(function (p) { return p.internalname === "Doc_Category"; }).map(function (p) { return p.value; }).join(""); var version = parts.filter(function (p) { return p.internalname === "Doc_Versie"; }).map(function (p) { return p.value; }).join(""); if (!category || !version) { toreturn.success = false; toreturn.errormessages = {};

if (!category && !version) {
    toreturn.errormessage = "'Category' and 'Version' are required";    
} else {
    if (!category) {
        toreturn.errormessage = "'Category' is required";
    } else if (!version) {
        toreturn.errormessage = "'Version' is required";
    }
}
if (!category) {
    toreturn.errormessages.Doc_Category = "A value is required";
}
if (!version) {
    toreturn.errormessages.Doc_Versie = "A value is required";
}

} return toreturn;

Make 3 fields required (example is for Document template part)

var toreturn = { success: true };

var parts = JSON.parse(g_data_string).parts;

var category = parts.filter(function (p) { return p.internalname === "Doc_Category"; }).map(function (p) { return p.value; }).join("");

var version = parts.filter(function (p) { return p.internalname === "Doc_Version"; }).map(function (p) { return p.value; }).join("");

var versiondate = parts.filter(function (p) { return p.internalname === "Doc_Version_date"; }).map(function (p) { return p.value; }).join("");

if (!category || !version || !versiondate) {

toreturn.success = false;

toreturn.errormessages = {};

var missingfields = [];

if (!category) {

missingfields.push("Category");

toreturn.errormessages.Doc_Category = "A value is required";

}

if (!version) {

missingfields.push("Version number");

toreturn.errormessages.Doc_Version = "A value is required";

}

if (!versiondate) {

missingfields.push("Version date");

toreturn.errormessages.Doc_Version_date = "A value is required";

}

toreturn.errormessage = "One or more fields are required: " + missingfields.map(function (fld) { return "'" + fld + "'"; }).join(", ");

}

return toreturn;