Avatar

Level 2

Hi,

I would insist that you change your order date field from "Date" to somethingelse like "OrderDate" since Date is predifined as object in javascript.

pretend you changed to "OrderDate", try following code in "calculate" event of the Ref field.

if ((ContactSF.Contact.rawValue != null) && (OrderDate.rawValue != null)){
this.rawValue = ContactSF.Contact.rawValue + util.printd("ddmmyy", util.scand("yyyy-mm-dd", OrderDate.rawValue));
}

This will make your Ref field with your desired value only in case both contact and order date fields are filled in.