Search the Community
Showing results for tags 'for loop'.
-
Hi, I am trying to get the loop below to run through the record count and execute different results based on the quantity. The rule below never gets past the first if statement. Not sure what I am doing wrong. Any help would be appreciated. var nameFieldName = "first"; var data = new ExternalDataFileEx(PrimaryInputFile()); var totalRecs = data.recordCount; for (i = 0; i < totalRecs; i++) { if (totalRecs = 5000) { var recordsPerBox = (2500); } else if ((totalRecs > 2500) && (totalRecs < 5000)) { var recordsPerBox = Math.ceil(totalRecs / 2); } else (totalRecs < 2500) { var recordsPerBox = (totalRecs); } } var numBoxes = Math.ceil(totalRecs / recordsPerBox); FusionPro.Composition.repeatRecordCount = numBoxes; var boxNum = FusionPro.Composition.repeatRecordNumber; var boxStartRec = (boxNum - 1) * recordsPerBox + 1; var boxEndRec = Math.min(boxNum * recordsPerBox, totalRecs); FusionPro.Composition.AddVariable("totalRecs", totalRecs); FusionPro.Composition.AddVariable("boxNum", boxNum); FusionPro.Composition.AddVariable("numBoxes", numBoxes); FusionPro.Composition.AddVariable("boxStartRec", boxStartRec); FusionPro.Composition.AddVariable("boxEndRec", boxEndRec); FusionPro.Composition.AddVariable("boxStartName", data.GetFieldValue(boxStartRec, nameFieldName)); FusionPro.Composition.AddVariable("boxEndName", data.GetFieldValue(boxEndRec, nameFieldName));
-
Bellow is a rule I pieced together from some other post. It worked for what I needed but I would like to learn how to clean something like this up and make it more efficient. So if you are bored and good at coding some help would be greatly appreciated. Thank you, var StrLine1 = (!Field("series_1")) ?" ": Trim(Field("series_1") + "<br>"); var StrLine2 = (!Field("series_2")) ?" ": Trim(Field("series_2") + "<br>"); var StrLine3 = (!Field("series_3")) ?" ": Trim(Field("series_3") + "<br>"); var StrLine4 = (!Field("series_4")) ?" ": Trim(Field("series_4") + "<br>"); var StrLine5 = (!Field("series_5")) ?" ": Trim(Field("series_5") + "<br>"); var StrLine6 = (!Field("series_6")) ?" ": Trim(Field("series_6") + "<br>"); var StrLine7 = (!Field("series_7")) ?" ": Trim(Field("series_7") + "<br>"); var StrLine8 = (!Field("series_8")) ?" ": Trim(Field("series_8") + "<br>"); var StrLine9 = (!Field("series_9")) ?" ": Trim(Field("series_9") + "<br>"); var StrLine10 = (!Field("series_10")) ?" ": Trim(Field("series_10") + "<br>"); var StrLine11 = (!Field("series_11")) ?" ": Trim(Field("series_11") + "<br>"); var StrLine12 = (!Field("series_12")) ?" ": Trim(Field("series_12") + "<br>"); var StrLine13 = (!Field("series_13")) ?" ": Trim(Field("series_13") + "<br>"); var StrLine14 = (!Field("series_14")) ?" ": Trim(Field("series_14") + "<br>"); var StrLine15 = (!Field("series_15")) ?" ": Trim(Field("series_15") + "<br>"); var StrLine16 = (!Field("series_16")) ?" ": Trim(Field("series_16") + "<br>"); return StrLine1 + StrLine2 + StrLine3 + StrLine4 + StrLine5 + StrLine6 + StrLine7 + StrLine8 + StrLine9 + StrLine10 + StrLine11 + StrLine12 + StrLine13 + StrLine14 + StrLine15 + StrLine16;
- 2 replies
-
- clean up code
- for loop
-
(and 1 more)
Tagged with: