fourdeuces67
-
Posts
5 -
Joined
Posts posted by fourdeuces67
-
-
This worked for me. Replacing the necessary fields and sentences you plan to use.
Code:
//if A is blank and B is not, use sentence 1
//if B is blank and A is not, use sentence 2
//if A and B both contain data, return sentence 3
if (Field("A") == "" && Field("B") != "")
return "sentence 1"
else if (Field("B") =="" && Field("A") !="")
return "sentence 2"
else if (Field("B") !="" && Field("A") !="")
return "sentence 3"
else
return ""
Another way to skin a cat I guess...
-
You can't specify an exact height, as the row automatically expands down to accommodate the text of all the cells in it. However, in FusionPro 8.1 and later, you can specify a minimum height, either with the "minheight" attribute on the <row> tag, or using the table API, with the "minHeight" property of the FPTableRow object.
I'm trying to set a minheight attribute within a table but I'm uncertain where to put FPTableRow minHeight.
Any help would be appreciated.
Thanks
}
/*=============================================================================
|| Create the table
||=============================================================================*/
new FPTable;
var myTable = new FPTable;
myTable.AddColumns(7000, 14000, 14000, 14000); // 1 inch = 7200 pts
myTable.AddRows(clientMatch.length+2);
// HEADER ROW FORMATTING
myTable.Rows[0].Type = "Header";
myTable.Rows[0].Cells[0].Font = "Helvetica";
myTable.Rows[0].Cells[0].PointSize = "10";
myTable.Rows[0].Cells[0].Font = "HelveticaNeue LT 75 Bold";
myTable.Rows[0].Cells[0].TextColor = "Black";
myTable.Rows[0].Cells[0].ShadeColor = "Lt. Blue";
myTable.Rows[0].Cells[0].ShadePct = 100;
myTable.Rows[0].Cells[0].Margins = new FPTableMargins;
myTable.Rows[0].Cells[0].Margins.Top = 50;
myTable.Rows[0].Cells[0].Margins.Right = 500;
myTable.Rows[0].Cells[0].HAlign = "Center";
myTable.Rows[0].CopyCells(0, 1, 2, 3); // Apply the same formating to each cell in this row
// HEADER ROW CONTENT
myTable.Rows[0].SetContents("Date", "Check/Confirmation Number", "Fund Name", "Total Amount");
// interate through the length of the arrays (data matches from external data file) and create rows
for (var i=1; i<=clientMatch.length; i++)
{
// TABLE CONTENT FORMATTING
myTable.Rows.Cells[0].Font = "Helvetica";
myTable.Rows.Cells[0].PointSize = "10";
myTable.Rows.Cells[0].Margins = new FPTableMargins;
myTable.Rows.Cells[0].Margins.Top = 50;
myTable.Rows.Cells[0].Margins.Bottom = 50;
myTable.Rows.Cells[0].Margins.Right = 500;
myTable.Rows.Cells[0].SetBorders("Thin", "Lt. Blue", "Bottom");
myTable.Rows.Cells[0].HAlign = "Center";
myTable.Rows.CopyCells(0,1,2,3); // Apply the same formating to each cell in this row
// CREATE CONTENT FOR EXTERNAL DATA FILE RECORDS
myTable.Rows.SetContents(invoiceMatch[i-1], dateMatch[i-1], jobMatch[i-1], amtMatch[i-1]);
}
// FOOTER ROW FORMATTING
myTable.Rows[clientMatch.length+1].Cells[0].Font = "Helvetica";
myTable.Rows[clientMatch.length+1].Cells[0].PointSize = "10";
myTable.Rows[clientMatch.length+1].Cells[0].Font = "HelveticaNeue LT 75 Bold";
myTable.Rows[clientMatch.length+1].Cells[0].TextColor = "Black";
myTable.Rows[clientMatch.length+1].Cells[0].ShadeColor = "White";
myTable.Rows[clientMatch.length+1].Cells[0].ShadePct = 100;
myTable.Rows[clientMatch.length+1].Cells[0].Margins = new FPTableMargins;
myTable.Rows[clientMatch.length+1].Cells[0].Margins.Top = 50;
myTable.Rows[clientMatch.length+1].Cells[0].Margins.Right = 500;
myTable.Rows[clientMatch.length+1].Cells[0].SetBorders("Thin", "Lt.Blue", "Top");
myTable.Rows[clientMatch.length+1].Cells[0].HAlign = "Center";
myTable.Rows[clientMatch.length+1].CopyCells(0, 1, 2, 3); // Apply the same formating to each cell in this row
// CREATE FOOTER CONTENT
myTable.Rows[clientMatch.length+1].SetContents("2014 TOTAL","","", Field("total"));
return myTable.MakeTags();
}
-
This has been answered in other places on the forum. The code I use looks like this:
if (FieldChanged("Field")) FusionPro.Composition.OpenNewOutputFile(Field("Field") + "." + FusionPro.Composition.outputFormatExtension);
Just place this in the OnRecordStart Rule when creating a new rule. However, this only works on FusionPro 9. To my knowledge, older versions cannot create arbitrary chunks. What version are you using?
-
Any ideas on how it fix this annoying message while saving?
Thanks
http://baysideprinting.com/error/Screen%20Shot%202014-07-02%20at%209.52.46%20AM.png
isSpot issues
in FusionPro® VDP Creator
Posted