Has anybody an idea how to change the parameters correctly? ... View more

I would be greatful for any recommendations. ... View more

Hello Gkaiseril, Thanks for your reply. How to change the paramters of the funtion based on a concrete example? For each row i have 4 different prices. BR ... View more

Hello ZoPaars, Merry Christmas ...now its working perfectly for one row. Many thanks for your support. In case of validating values for other rows, how to change to funtion? I tried to set one more calculation script and changed the filed names, but not working. Or maybe it is done in one calculation script, like this? Not working... ... View more

If there are several rows of prices, which need to be validated seperately, accordingly how to adapt the script? ... View more

Now I got it  "var valArray" has been changed. Thats`s why it has not been working. As the fields values of "PreisA11", "PreisB11", "PreisC11", "PreisD11" are not values which are directly entered, but are the result of a calculation (from source fileds) and only readable, the OnBlur is not working. Is there any posiblility to place it into the source text field? ... View more

Hello ZoPaars, the valida-tion is working, however not working for comparison of ZERO numbers for example: 0,1; 0,3; 0,45, 0,6; In this the ithe MIN value is shown in the right way (in green color), however the MAX value is not shown in red color and also in the field "MAX1" only value=1. I would be grateful for any idea or comments on problem solution. BR Florian ... View more

"Format" tab set to Numbers with 2 decimals with currency symbol ... View more

ZoPaars, good morning. Thanks for your reply. Maybe there is still a mistake from my side. For all 4 price fields I set calculation script as follows: var PreisA1 = this.getField("PreisA1").value; var temp = this.getField("temp").value; event.value = PreisA1/temp; if (temp==0) event.value = "0"; var NamesArr = ["PreisA11", "PreisB11", "PreisC11", "PreisD11"];  for (var i = 0; i < NamesArr.length; i++) this.getField(NamesArr).setAction("OnBlur", "calcFields();"); For document javascript I set following script: function calcFields() {      //make an array of the numbers and the field names that correspond with them      var valArray = [[1],[2],[3],[4]];      var total = 0;      var NamesArr = ["PreisA11","PreisB11","PreisC11","PreisD11"];      for (var i = 0; i < NamesArr.length; i++) {          var Nm = NamesArr, fld = this.getField(Nm);          fld.textColor = color.black; //reset all the field colours          if (fld.value && !isNaN(fld.value)) {              valArray[0].push(fld.value);              total += fld.value;              valArray[1].push(Nm);          }      }      //get the max value and make it red      var maxVal = Math.max.apply(null, valArray[0]);      var maxIndex = valArray[0].indexOf(maxVal);      var maxFld = this.getField(valArray[1][maxIndex]);      if (maxFld) maxFld.textColor = color.red;      this.getField("MAX1").value = maxVal;        //get the min value and make it green      var minVal = Math.min.apply(null, valArray[0]);      var minIndex = valArray[0].indexOf(minVal);      var minFld = this.getField(valArray[1][minIndex]);      if (minFld) minFld.textColor = color.green;      this.getField("MIN1").value = minVal;        //get the average value      var avgVal = total / valArray[0].length;      this.getField("AV1").value = avgVal;  };  ... View more

Validation doesnt work with 0,...  zero decimal places ... View more

Comparison doesn`t work if values are all below 0,... ... View more

Interesting that, if the difference of price value is rising the evaluation works. ... View more

The minimum value evaluation is not working for me only maximum. Any idea, whats the reason for the problem. Thanks in advance! ... View more

Hello ZoPaars, I got it. However the calculation is not working after changing values of fields  "PreisA11", "PreisB11", "PreisС11", "PreisD11". Do you have any idea? var NamesArr = ["PreisA11", "PreisB11", "PreisC11", "PreisD11"];  for (var i = 0; i < NamesArr.length; i++) this.getField(NamesArr).setAction("OnBlur", "calcFields();"); this.calculateNow()   Didn`t help. ... View more

Hello ZoPaars, many thanks for your quick reply. Still facing with pproblems. In my opinion the root problem is, that I dont know how to work with Arrays.... valArray = [[], []];  Do I need to ofill in the fildnames, where user puts in variable prices? Following way correct? var valArray = [["PreisA11"], ["PreisB11"], ["PreisС11"], ["PreisD11"]];     Do do I need var NamesArr = ["PreisA11", "PreisB11", "PreisС11", "PreisD11"];  Correct? ... View more

I tried this...But for sure there is a mistake... //make an array of date values  var valArray = [[], []];  var total = 0;  for (var i = 1; i < 6; i++) {      var Nm = ("PreisA11,PreisB11","PreisC11","PreisD11")+ i, fld = this.getField(Nm);      fld.textColor = color.black; //reset all the field colours      if (fld.value && !isNaN(fld.value)) {          valArray[0].push(fld.value);          total += fld.value;          valArray[1].push(Nm);      }  }    //get the max value  var maxVal = Math.max.apply(null, valArray[0]);  var maxIndex = valArray[0].indexOf(maxVal);  var maxFld = this.getField(valArray[1][maxIndex]);  if (maxFld) maxFld.textColor = color.green;  this.getField("MAX1").value = maxVal;    //get the min value  var minVal = Math.min.apply(null, valArray[0]);  var minIndex = valArray[0].indexOf(minVal);  var minFld = this.getField(valArray[1][minIndex]);  if (minFld) minFld.textColor = color.red;  this.getField("MIN1").value = minVal;    //get the average value  var avgVal = total / valArray[0].length;  this.getField("AV1").value = avgVal;  ... View more

Hello ZoPaars, firstly many thanks for your support. Unfortunately not working correctly. As I understod I need to make an Custom calculation script of following: //make an array of date values  var valArray = [[], []];  var total = 0;  for (var i = 1; i < 6; i++) {      var Nm = "field #" + i, fld = this.getField(Nm);      //Here I need to put the filed names, which need to be cpalculated? I tried "PreisA11", "PreisB11", etc.     fld.textColor = color.black; //reset all the field colours      if (fld.value && !isNaN(fld.value)) {          valArray[0].push(fld.value);          total += fld.value;          valArray[1].push(Nm);      }  }  Do I need to put this in textfields calcualtion? //get the max value  var maxVal = Math.max.apply(null, valArray[0]);  var maxIndex = valArray[0].indexOf(maxVal);  var maxFld = this.getField(valArray[1][maxIndex]);  if (maxFld) maxFld.textColor = color.green;  this.getField("field #8").value = maxVal;    //get the min value  var minVal = Math.min.apply(null, valArray[0]);  var minIndex = valArray[0].indexOf(minVal);  var minFld = this.getField(valArray[1][minIndex]);  if (minFld) minFld.textColor = color.red;  this.getField("field #7").value = minVal;    //get the average value  var avgVal = total / valArray[0].length;  this.getField("field #6").value = avgVal;  ... View more

As there will be many different attached reference files and the main PDF will get quite heavy, is there also an option to work with download links from server? That means, that through the popup menu files could be downloaded from the server? ... View more

try67, it works! Many thanks! ... View more

I have tried this.openDataObject(cRtn + ".pdf");  ...unfortunately not working. Actually trying following script: var cRtn = app.popUpMenu("Option1","Option2","Option3","Option4"); if (cRtn != "Option1"){   this.exportDataObject({ cName: "1.pdf", nLaunch: 2 }); } else if (cRtn != "Option2"){   this.exportDataObject({ cName: "2.pdf", nLaunch: 2 }); } else if (cRtn != "Option3"){   this.exportDataObject({ cName: "3.pdf", nLaunch: 2 }); } It is opening attachment in new window, however mixing the attachments. Anz idea, where the bug is? ... View more

The main PDF form has 4 attached files, which are opened in a seperate window, depending on users choice. Is something like this possible to handle by java script app.popUPMenu ? ... View more

Hello try67, many thanks for your prompt reply. In accordance to user`s choice different PDF attachements should be opened in a new window. For this reason in my opinion an "if" command is necessary. Furthermore how I could make sure that the attached PDF will be opened in a new window? As I am pnot professional java script programmist, I would be very grateful, if you could help me with the java scriting. Best regards Florian ... View more

I understood that during the spawning perocess field names are changed. But i still dont understand how to change the validation script in the dropbox. As I dont know how many time the form will be spawned, Is there any variable, wchich condiders the name changing of fields? if (event.value == "0") { this.getField("00").display = display.visible; this.getField("11").display = display.hidden; this.getField("22").display = display.hidden; this.getField("33").display = display.hidden; this.getField("44").display = display.hidden; this.getField("55").display = display.hidden; this.getField("66").display = display.hidden; this.getField("77").display = display.hidden; this.getField("88").display = display.hidden; } else if (event.value == "1") { this.getField("11").display = display.visible; this.getField("00").display = display.hidden; this.getField("22").display = display.hidden; this.getField("33").display = display.hidden; this.getField("44").display = display.hidden; this.getField("55").display = display.hidden; this.getField("66").display = display.hidden; this.getField("77").display = display.hidden; this.getField("88").display = display.hidden; } else if (event.value == "2") { ....etc. ... View more

I have 1 PDF page whi is the template. It has one dropdown box, where in accordance to the dropdown box value is shown a picture. After spawning this template page, names of picture filds are changed and the dropbox is not working anymore. gkaiseril, mentioned that there is one waz to solve this problem:  event.target.name. This will give one the name of the field that currently has the focus or is being accessed. From this one should be able to get the "P#" and the template name values which have been affixed to each renamed field. Is there anybody out here, who could explain me who to change the scripting? if (event.value == "0") { this.getField("00").display = display.visible; this.getField("11").display = display.hidden; this.getField("22").display = display.hidden; this.getField("33").display = display.hidden; this.getField("44").display = display.hidden; this.getField("55").display = display.hidden; this.getField("66").display = display.hidden; this.getField("77").display = display.hidden; this.getField("88").display = display.hidden; } else if (event.value == "1") { this.getField("11").display = display.visible; this.getField("00").display = display.hidden; this.getField("22").display = display.hidden; this.getField("33").display = display.hidden; this.getField("44").display = display.hidden; this.getField("55").display = display.hidden; this.getField("66").display = display.hidden; this.getField("77").display = display.hidden; this.getField("88").display = display.hidden; } else if (event.value == "2") { ....etc. ... View more

..Explain how tom work with the funtion "event.target.name."? ... View more