Avatar

Correct answer by
Level 10

The attached produces...

Untitled.png

where Ref is calculated as follows...

// form1.page.header.Ref::calculate - (JavaScript, client)


if (form1.page.header.Date.isNull || form1.page.ContactSF.Contact.isNull) {

  this.rawValue = null;

}

else {

  if (!(form1.page.header.Date.isNull && form1.page.ContactSF.Contact.isNull)) {

    var dateStr = form1.page.header.Date.rawValue;

    this.rawValue = form1.page.ContactSF.Contact.rawValue + dateStr.substr(8,2) + dateStr.substr(5,2) + dateStr.substr(2,2);

  }

}

Steve

View solution in original post