Override Values in Calculating Field

 +++EDITED REPLY, did some corrections in the custom format script

Well, I've tried everything I could think of with my current level of JavaScript scripting.

I don't think that you're using the changeEx method appropriately. 

If I use the following :

• Declare the global variable in a function using a literal Array method instead of "new Array(), "new Array", "Array" methods:

function testTable() {

gTable =   [

[" ", "-- -- --"],

["Item 1", "1H--25--3"],

["Item 2", "2H--17--4"],

["Item 3", "3--1H--9--7"]

] 


}

• And then add a Custom Format script to the combobox to call that function:

testTable();

var f = this.getField("select.01");

f.setAction("MouseUp", "f.setItems(gTable);");

•  And a custom Keystroke script in the same combobox:

if (event.willCommit) {

this.getField("field.01").value = event.value;

} else {

this.getField("field.02").value = event.changeEx.split("--")[0];
this.getField("field.03").value = event.changeEx.split("--")[1];
this.getField("field.04").value = event.changeEx.split("--")[2];

} 

It leads back to the same problem that you mentioned. You will get errors and undefined values wehn the commited and not commited values are processed., Also, it won't let you revert to the prior value when it is deleted in any of the text fields.

To work around this you may have to use the Adobe Acrobat API Reference which explain in full detail the differences of event.value, event.change, and event.changeEx when they're used in custom keystroes and  text boxes.

If you noticed in my script above there is no need to split the value that you want in field 1. This line alone does it:

this.getField("field.01").value = event.value;

That said, if you still prefer to use the code that I posted in my prior reply,  all you need to do is add this line

this.getField("field.01").value = gTable[b].split("--")[0];

into this script:

var f = this.getField("select.01");
var a = f.currentValueIndices;
var b =  f.getItemAt(a, false);
var c =  event.target.value;

if(event.source&&event.source.name=="select.01") {

if ( (c =="Item 1") || (c == "Item 2") || (c == "Item 3") ) {

this.getField("field.01").value = gTable[b].split("--")[0];
this.getField("field.02").value = gTable[b].split("--")[1];
this.getField("field.03").value = gTable[b].split("--")[2];
this.getField("field.04").value = gTable[b].split("--")[3];

} else {

if ( (c !=="Item 1") || (c !== "Item 2") || (c !== "Item 3") || (c =="") ) {

this.getField("field.01").value = this.getField("field.01").target.value;
this.getField("field.02").value = this.getField("field.02").target.value;
this.getField("field.03").value = this.getField("field.03").target.value;
this.getField("field.04").value = this.getField("field.04").target.value;

    }
  }
}
 

That works, if the combobox entry is overridden, but I need to be able to override the value in a field that gets calculated based on the selection in that combobox. So, I guess, the combobox is irrelevant to the issue...

Essentially I need:

if (fieldA == manual entry) {

     event.value = manual entry;

}

else { event.value = calculated entry; }