Yes you could.  But if you are going that route, I would advise to do the following, in order to simplify the code afterwards: -Instead of putting the code in each button with a slight variation, put your code inside a document-level function and call it from the button.  That way, you type it only once and in the event you need to change part of it, it becomes much easier to do so //at document-level function manProdColor(){ //put your code here } //and you call it from the action of the button manProdColor() -Since you need to output 2 values from the buttons, the manufacturer and the product selected, I suggest using export values that contain both information such as "Certain Teed.Landmark" ,  "Certain Teed.Landmark Premium" ,  etc.  By doing so, you will later be able to use the split() method of the String object to remove the "." and separate both values to export it in according fields function manProdColor(){ var myValue = event.value                 //assign the String "Certain Teed.Landmark" to myValue var aMyValue = myValue.split(".")      //Creates an array of Strings ["Certain Teed", "Landmark"] var manufacturer = aMyValue[0]        //Isolate the Strings var product = aMyValue[1]                 //Isolate the Strings this.getField("manufacturer").value = manufacturer this.getField("product").value = product } -Since you have about thirty different products with 30 different color profiles (althought some might be the same), you could use a switch to handle the setItems() method or simple if statements.  If more than one product share the same color profile, instead of using if()&&()&&()&&() which becomes rapidly unreadable, place all those product in an array and use the indexOf() method of the array object to determine if product reside in one group or another.  indexOf() returns the 0-based position of a value inside an array.  If the value is not in the array, it returns -1. function manProdColor(){ var myValue = event.value                 //assign the String "Certain Teed.Landmark" to myValue var aMyValue = myValue.split(".")      //Creates an array of Strings ["Certain Teed", "Landmark"] var manufacturer = aMyValue[0]        //Isolate the Strings var product = aMyValue[1]                 //Isolate the Strings this.getField("manufacturer").value = manufacturer this.getField("product").value = product var prodGroup1 = ["Landmark", "Landmark Premium"] var profile1 = [" ","Black","Red","Blue"] var prodGroup2 = ["Landmark PRO", "Landmark TL"] var profile2 = [" ","Yellow","Green"] if (prodGroup1.indexOf(product) != -1)  this.getField("profile color").setItems(profile1) if (prodGroup2.indexOf(product) != -1)  this.getField("profile color").setItems(profile2) } ... View more

I can help you as long as you define what those variables are.  Are they values the user enters in fields of the same name? ... View more

I understand.  But there are lots of things that are not optimised on your project which makes it hard to conceptualise.  It is understandable as you are not familiar Javascript.  I will try to optimize it with you.  You created boxes named "box1", "box2", etc and added the same mouseUp action to each of them, with only minor changes to the code.  This is not the correct way to implement such a behavior. By using checkboxes, you give the opportunity for the user to select more than one option at the same time which, in return, is in conflict with the behavior you coded.  Depending on the order the boxes are checked will have a different outcome:  only the last box checked will carry its value to page 5. Before anything else, are checkboxes the right type of field required for the task?  How about radio buttons?  Radio buttons look exactly like checkboxes but only one boxe of the same group can be checked at a time.  Also, once a choice is made, it can be changed but it cannot be completely removed leaving no choice made at all. ... View more

Not the profile field, the color_profile field.  These are two separate fields in your file. By looking at your file, it is not clear what you are trying to achieve.  Will you be placing checkboxes besides each choices for each manufacturer OR Does the checkbox accounts for the complete line across the document and the customer gets to select the manufacturer on page 5? Because this calls for a completely different behavior and I wish to provide the best one for your needs. ... View more

I looked at the file.  first, profile_color needs to be a dropdown list, not a text field.  Then, are the colors based on the choice of manufacturer or the choice of profile? I see only certain teed as a choice of manufacturer.  There is no way of selecting Owens Corning or GAF.  it will come later? ... View more

The first part of the script works fine but the second part returns an error as if it can't find the field on the spawned page ... View more

Since the value of "manufacturer" is determined but a the checkboxes, you don't need to create a dropdown for it.  As for the script, it is not in the action tab, it is in the validation tab of the "manufacturer" field, under custom validation. ... View more

not exactly.  In your example, you used the same value in the if and the esle if. if (this.getField("manufacturer").value == "CertainTeed") this.getField("Landmark").setItems([" ", "Moire Black", "Sunset Gold"]) else if (this.getField("manufacturer").value == "CertainTeed") this.getField("Landmark Premium").setItems([" ", "Walnut", "Teak"]) I thought you were looking for the kind of behavior where you have Dropdown3 to display choices based on choices of dropdown2, based on values of dropdown 1. From what I understand, this would be more appropriate: if (this.getField("manufacturer").value == "CertainTeed"){     this.getField("Landmark").setItems([" ", "Moire Black", "Sunset Gold"])     this.getField("Landmark Premium").setItems([" ", "Walnut", "Teak"]) } else if (this.getField("manufacturer").value == "some other choice"){     this.getField("Landmark").setItems([" ", "other color A", "other color B"])     this.getField("Landmark Premium").setItems([" ", "other color C", "other color D"]) } is this right? ... View more

you need to use the setItems() method.  It will set the items of your dropdown lists based on the value choosen in another dropdown list. Supposed you have manufacturer A and B, product 1 and 2 for the first and 3 and 4 for the second if (this.getField("manufacturer").value == "A") this.getField("product").setItems([" ", "1", "2"]) else if (this.getField("manufacturer").value == "B") this.getField("product").setItems([" ", "3", "4"]) repeat the same process for colors, according to product and be sure to put such a script as a custom validate script, not calculate or it will constantly change the values of your fields ... View more

Got excatly the time sheets at work. I named my fields that way ->  ADM034.TABLE.number.number numbers are replaced by the y/x position of the cell as if it was a table in excel.  The first number being the row (y) and the last number being the column (x).  Numbers are 0-based. ADM034.TABLE.0.0     ADM034.TABLE.0.1     ADM034.TABLE.0.2 ADM034.TABLE.1.0     ADM034.TABLE.1.1     ADM034.TABLE.1.2 ADM034.TABLE.2.0     ADM034.TABLE.2.1     ADM034.TABLE.2.2 etc Then put the same script in the calculate event of the total field.  (You should pass it as a doc level function but you don't have to) var myName = event.target.name var aName = myName.split(".") var myLine = Number(aName[2]) var myColumn = Number(aName[3]) //gather the values var SstartValue = this.getField("ADM034.TABLE."+myLine+"."+(myColumn-2)).valueAsString var SstartTime = SstartValue.substr(0, 2)+":"+SstartValue.substr(2) var SendValue = this.getField("ADM034.TABLE."+myLine+"."+(myColumn-1)).valueAsString var SendTime = SendValue.substr(0, 2)+":"+SendValue.substr(2) if ((SstartValue != "")&&(SendValue != "")){ //convert to date object var OstartTime = util.scand("yyyy-mm-dd HH:mm", "2018-01-01 "+SstartTime) var OendTime = util.scand("yyyy-mm-dd HH:mm", "2018-01-01 "+SendTime) //convert to milliseconds var milStart = OstartTime.valueOf() var milEnd = OendTime.valueOf() //End time update if (milStart > milEnd) milEnd += 1000*60*60*24 event.value = (milEnd-milStart)/(1000*60*60) } else event.value = "" ... View more

Put the following script in the custom calculate tab of the text field.  Make sure to replace what is in BOLD if (this.getField("Name of the checkbox").value == "Checkbox export value") event.value = "Autofill sentence" ... View more

We build our regular expression by putting the things we want between those ->  /  / it will be: /^$| |\d/i; ^$ means it will accept an empty sting a.k.a erase means it will accept an upperCase X \d means it will accept any digits you separate each part by this -> |     (equivalent of a boolean OR) the i flag at the end means it is case-insensitive      (it will accept also the lowerCase x) We switch the value back to UpperCase at the end Custom keystroke in the format tab: var re = /^$| |\d/i; if (!event.willCommit){ if(re.test(event.change) == false){ event.rc = false; } else{ event.change = event.change.toUpperCase(); } } You can find lots of tool and examples for regular expressions on the web.  Once you get used to RE, you feel like you want to validate everything. ... View more

I use this custom validation script if (event.value && !eMailValidate(event.value)) {         app.alert("Wrong email entered",0,0,"Error");         event.rc = false; } ... View more

This seems ok altought it is a bit long. You could really shorten it by assigning a 0 value from the sart to all three variables and increment it to 1 only if needed like so: var v1 = 0 var v2 = 0 var v3 = 0 if (this.getField("Rating 1.1").value =="Meeting") v1++ if (this.getField("Rating 1.2").value =="Meeting") v2++ if (this.getField("Rating 1.3").value =="Meeting") v3++ var sum = v1 + v2 + v3 event.value = sum The middle block looks repetitive, don't it? How about using a loop and an array instead: var aValues = [0,0,0] for (var i in aValues){     if (this.getField("Rating 1."+(Number(i)+1)).value =="Meeting") aValues++ } var sum = 0 for (i in aValues) sum += aValues event.value = sum Well, look at that, we iterated twice in the same array.  Why not do both operations in one loop? var aValues = [0,0,0] var sum = 0 for (var i in aValues){     if (this.getField("Rating 1."+(Number(i)+1)).value =="Meeting") aValues++     sum += aValues } event.value = sum We can even get rid of sum and operate directly with on the field value var aValues = [0,0,0] event.value = 0 for (var i in aValues){     if (this.getField("Rating 1."+(Number(i)+1)).value =="Meeting") aValues++     event.value += aValues } Do we need an array at all?  Definitly not. Lets iterate 3 times instead event.value = 0 for (var i=1;i<=3;i++){ if (this.getField("Rating 1."+i).value =="Meeting") event.value++ } Do we even need brackets? nope event.value = 0 for (var i=1;i<=3;i++) if (this.getField("Rating 1."+i).value =="Meeting") event.value++ So that 17 lines code you wrote can be achieved as a 2 lines code.  Whenever you feel something is repetitive and long, it's because you are doing it wrong.  It takes experience but it will come. ... View more

I tested it myself.  There is a problem with it so try this instead: //Counts how many Un-checked boxes there are var isOff = 0 for (var x=1;x<=3;x++){    var f = this.getField("1.1."+x)    if (f.value == "Off") isOff++ } //If all three are un-checked, shows blank if (isOff == 3) event.value = "" //If at least one is checked, sum only those that have a value of 1 else{     var sum = 0     for (var x=1;x<=3;x++){        var f = this.getField("1.1."+x)        if (f.value == 1)  sum++     }    //and display the sum    event.value = sum } For some reason, isBoxChecked(0) only returned true when the first check box was checked, not the second one.......So I tested its value instead.  For the sum part, I tested if the value is equal to 1 (because it is the only case where the value will be incremented) and just used the increment operator "++" ... View more

this is why this part: //If at least one is checked, sum only those that are checked else{     var sum = 0     for (var x=1;x<=3;x++){        var f = this.getField("1.1."+x)        if (f.isBoxChecked(0) == true){              sum += f.value        }     } is important.  It will sum up only boxes that are checked (that return a number) and will skip the ones returning a string ("Off") ... View more

Of course you are.  In JS, like in every language, data has a type.  It can be a number, a string, an array, a boolean, etc.  JS is a dynamic language, as opposed to a static language.  In a static language, like JAVA for instance, you need to declare variables, but you also need to declare the type or it will not work.  JS, being dynamic, will "presume" the type, and will also dynamicaly change type when needed, without the need for the coder to do it specifically.  This speeds up the coding process but will sometimes induces errors when the coder is not aware of what is happenig.  You can return the type of the data with the typeof command like so: var myData = 9 app.alert(typeof myData) //will output "number" as an alert var myData = [] app.alert(typeof myData) //will output "array" as an alert In JS, the "+" operator is an addition operator when working with numbers, but it becomes a concatenation operator when working with strings (meaning it will append strings one after the other).  But what happens when you try add a number (0) to a string ("Off")?  As soon as it its a string, it converts any number it encountered to a string and concatenate it. ... View more

I know, but look at the outcomes describred earlier [  ]   [  ]   [  ]   sum = 3 [  ]      [  ]    [  ] sum = 1 But what about:    [  ] [  ]   [  ] [  ]   sum = "0Off1"  ??? Unless radios are required fields, that poses a problem with your solution ... View more

Try the solution posted by JR_Boulay.  But for that to work, the field of your main page must be different from the on in your templates.  Whenever I change the script in "Text27", it changes acoordingly in P1.TRI.Text27.      Since both scripts are slightly different, you need to independant fields. ... View more

What happens if at least one line is empty?  Won't it concatenate an "Off" string? ... View more

you paste this in the custom calculate tab of the field where you want the total to show.  As Bernd said, you need to adjust the name of your radio field in the script, or change the name of your field to what I wrote in the script.  It doesn't matter what name you use, juste make sure you use the same (it is case sensitive) and the important part is that it ends with numbers 1 to 3 so you can loop throught them. ... View more

in that case: //Counts how many Un-checked boxes there are var isOff = 0 for (var x=1;x<=3;x++){    var f = this.getField("radio"+x)    if (f.isBoxChecked(0) == false) isOff++ } //If all three are un-checked, shows blank if (isOff == 3) event.value = "" //If at least one is checked, sum only those that are checked else{     var sum = 0     for (var x=1;x<=3;x++){        var f = this.getField("radio"+x)        if (f.isBoxChecked(0) == true){              sum += f.value        }     }    //and display the sum    event.value = sum } you will also need to update your other script to take the blank value into consideration. ... View more

The script I wrote, And the link provided by @JR_Boulay , they do just that. My script: this.pageNum() method returns the position of the page in the document as a 0-Based index.  Therefore, this.pageNum()+1 is the number of the page. @JR_Boulay's script: the "page" property of the field object (event.target.page) as described in the post returnes the same thing but will return an array of integer if there is more than one occurence of the same field, based on the order they were created. I tested my script in your document.  It works fine except for some reason, the calculateNow() method doesn't trigger fast enough for the fields to update.  It updates as soon as a value is commited anywhere in the document (because it is a calulate script) ... View more

Can you share the file via a google drive link? If it shows the correct value when all three are ticked, but shows 0 otherwise, my guess is that at least one of you radio has an incorrect export value associated to the "working towards". Also, take into consideration that if non of the two choices is made, the radio returns "Off" which cause an error in your calculation. You might want to create a custom calculation indeed ... View more

What calculate script did you use to sum checkboxes?  Since you say it always shows 0 no matter what is checked, you need to work that issue first. If the return value of the checkboxes is not 1, that could be your problem. ... View more

What do you mean by "take into consideration whatever order the pages will be spawed"?  Doesn't spawned pages append to the end of the document?  Therefore, their order in the document is the same as the order they were spawned? ... View more

You mean you want the file name to update in regards to the value of certain fields? You sort of wish to code a SaveAs function ? ... View more