Jump to content

fourdeuces67

Registered Users - Approved
  • Posts

    5
  • Joined

Posts posted by fourdeuces67

  1. Not sure what you are intending to make a spot color but to add a spot color to use in Fusionpro is to click Fusionpro>Advanced>Colors... in the top menu and click New in the Colors dialog box. Then in the New Color dialog box check the spot color checkbox, type out the name of the spot color you want to use EXACTLY and type in it's CMYK values. When you compose a job with this color the Output should use the spot color not as a CMYK blend.
  2. 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...

  3. 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();

    }

  4. 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?

×
×
  • Create New...