Go Back   MarcomCentral (PTI) and FusionPro User Communities > Software-Related Talk > The JavaScript Library > Tables & Charts

Notices

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 15th, 2011, 08:56 AM
dbentley dbentley is offline
Junior Community Member
 
Join Date: May 2011
Posts: 15
Default Using shading on variable table rows

Hi All.

I'll start off by saying that I am completely new to the Table functions within Fusion Pro.

With that being said... I'm trying to create a Table that includes new Rows if certain fields are populated within a record. I have been successful, I think, in having the content flow as needed, but the shading and borders continue to remain static. I only want to have the shaded/white rows and borders to appear if there is content available within those specified fields. I have tried many, many ways to fit the shading and borders into the rule, and really have come to the conclusion that I need help.

Also, I would welcome any ideas on how to clean this rule up.

I have attached the working test template as well as the test data file. Thanks so much in advance.
Attached Files
File Type: pdf Table_Test.pdf (468.2 KB, 27 views)
File Type: txt TableTest.txt (5.0 KB, 17 views)
Reply With Quote
  #2  
Old June 15th, 2011, 09:39 AM
dbentley dbentley is offline
Junior Community Member
 
Join Date: May 2011
Posts: 15
Default Re: Using shading on variable table rows

I figured I could post the rule I have created as well in case it isn't necessary to go into the template for explanation. See below...


FPTable.prototype.NewRow = function()
{
myTable.AddRows(1);
return myTable.Rows[myTable.Rows.length-1];
}

//DomainTable
var myTable = new FPTable;
myTable.AddColumns(14000, 9000, 9000, 9000, 9000, 9000, 9000);

// Add rows as we go...
var row = null; // FPTableRow

// Domain rows; some are optional.
for (var DomainNum = 1; DomainNum <= 8; DomainNum++)
{
var FieldValDom1 = "";
try { FieldValDom1 = Field("Domain1"); } catch (e) {}
if (FieldValDom1)
{
row = myTable.NewRow();
row.Cells[0].Content = FieldValDom1;
row.Cells[1].Content = Field("Expires1");
row.Cells[2].Content = Field("Privacy1");
row.Cells[3].Content = Field("Auto-Renew1");
row.Cells[4].Content = Field("Free Easy Email1");
row.Cells[5].Content = Field("Free InstantPage1");
row.Cells[6].Content = Field("Free InstantPage1");
for (var c = 1; c <= 5; c++)
row.Cells[c+1].Content = FieldValDom1;
}
}

myTable.Rows[0].Cells[0].ShadeColor="Green";
myTable.Rows[0].Cells[0].ShadePct=30;
myTable.Rows[0].CopyCells(0, 1,2,3,4,5,6);

myTable.Rows[0].Cells[0].Font="Times New Roman";
myTable.Rows[0].Cells[0].TextColor="Black";
myTable.Rows[0].Cells[0].PointSize=8;
myTable.Rows[0].Cells[0].SetBorders ("Thin", "Black", "Top", "Bottom", "Right");
myTable.Rows[0].Cells[0].VAlign = "middle";
myTable.Rows[0].Cells[0].HAlign = "Center";
myTable.Rows[0].CopyCells(0, 1,2,3,4,5,6);

myTable.Rows[0].Cells[0].Content="Domain";
myTable.Rows[0].Cells[1].Content="Expires";
myTable.Rows[0].Cells[2].Content="Privacy";
myTable.Rows[0].Cells[3].Content="Auto-Renew";
myTable.Rows[0].Cells[4].Content="FREE Easy Email";
myTable.Rows[0].Cells[5].Content="FREE InstantPage";
myTable.Rows[0].Cells[6].Content="Action Required";

myTable.Rows[1].Cells[0].SetContents=Field("NewDomainNames1");
myTable.Rows[1].Cells[1].SetContents=Field("Expires1");
myTable.Rows[1].Cells[2].SetContents=Field("Privacy1");
myTable.Rows[1].Cells[3].SetContents=Field("Auto-Renew1");
myTable.Rows[1].Cells[4].SetContents=Field("Free Easy Email1");
myTable.Rows[1].Cells[5].SetContents=Field("Free InstantPage1");
myTable.Rows[1].Cells[6].SetContents=Field("Action Required1");

//Row1 formatting
myTable.Rows[1].Cells[0].Font="Arial";
myTable.Rows[1].Cells[0].TextColor="Green";
myTable.Rows[1].Cells[0].PointSize=6;
myTable.Rows[1].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[1].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[1].SetContents (Field("Domain1"), Field("Expires1"), Field("Privacy1"), Field("Auto-Renew1"), Field("Free Easy Email1"), Field("Free InstantPage1"), Field("Action Required1"));

//Row2 formatting
myTable.Rows[2].Cells[0].Font="Arial";
myTable.Rows[2].Cells[0].TextColor="Green";
myTable.Rows[2].Cells[0].PointSize=6;
myTable.Rows[2].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[2].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[2].SetContents (Field("Domain2"), Field("Expires2"), Field("Privacy2"), Field("Auto-Renew2"), Field("Free Easy Email2"), Field("Free InstantPage2"), Field("Action Required2"));

//Row3 formatting
myTable.Rows[3].Cells[0].Font="Arial";
myTable.Rows[3].Cells[0].TextColor="Green";
myTable.Rows[3].Cells[0].PointSize=6;
myTable.Rows[3].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[3].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[3].SetContents (Field("Domain3"), Field("Expires3"), Field("Privacy3"), Field("Auto-Renew3"), Field("Free Easy Email3"), Field("Free InstantPage3"), Field("Action Required3"));

//Row4 formatting
myTable.Rows[4].Cells[0].Font="Arial";
myTable.Rows[4].Cells[0].TextColor="Green";
myTable.Rows[4].Cells[0].PointSize=6;
myTable.Rows[4].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[4].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[4].SetContents (Field("Domain4"), Field("Expires4"), Field("Privacy4"), Field("Auto-Renew4"), Field("Free Easy Email4"), Field("Free InstantPage4"), Field("Action Required4"));

//Row5 formatting
myTable.Rows[5].Cells[0].Font="Arial";
myTable.Rows[5].Cells[0].TextColor="Green";
myTable.Rows[5].Cells[0].PointSize=6;
myTable.Rows[5].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[5].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[5].SetContents (Field("Domain5"), Field("Expires5"), Field("Privacy5"), Field("Auto-Renew5"), Field("Free Easy Email5"), Field("Free InstantPage5"), Field("Action Required5"));

//Row6 formatting
myTable.Rows[6].Cells[0].Font="Arial";
myTable.Rows[6].Cells[0].TextColor="Green";
myTable.Rows[6].Cells[0].PointSize=6;
myTable.Rows[6].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[6].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[6].SetContents (Field("Domain6"), Field("Expires6"), Field("Privacy6"), Field("Auto-Renew6"), Field("Free Easy Email6"), Field("Free InstantPage6"), Field("Action Required6"));

//Row7 formatting
myTable.Rows[7].Cells[0].Font="Arial";
myTable.Rows[7].Cells[0].TextColor="Green";
myTable.Rows[7].Cells[0].PointSize=6;
myTable.Rows[7].Cells[0].SetBorders ("Thin", "Black", "Top", "Right");
myTable.Rows[7].CopyCells(0, 1,2,3,4,5,6);
myTable.Rows[7].SetContents (Field("Domain7"), Field("Expires7"), Field("Privacy7"), Field("Auto-Renew7"), Field("Free Easy Email7"), Field("Free InstantPage7"), Field("Action Required7"));

// Apply formatting to all the rows.
for (var a = 0; a < myTable.Rows.length; a++)
{
myTable.Rows[a].Cells[0].Bold = "On";

for (var b = 0; b < myTable.Columns.length; b++)
{
myTable.Rows[a].Cells[b].SetBorders("Thin", "Black", "Top", "Bottom");
myTable.Rows[a].Cells[b].VAlign = "middle";
myTable.Rows[a].Cells[b].Margins = new FPTableMargins;
myTable.Rows[a].Cells[b].Margins.Top = 60;
myTable.Rows[a].Cells[b].Margins.Bottom = 40;
myTable.Rows[a].Cells[b].Margins.Left = 600;
myTable.Rows[a].Cells[b].Margins.Right = 600;
myTable.ShadingColor1 = "Black";
myTable.ShadingPct1 = 1;
myTable.ShadingRepeat1 = 1;
myTable.ShadingColor2 = "Black";
myTable.ShadingPct2 = 20;
myTable.ShadingRepeat2 = 1;
myTable.ShadingType = "ByRow"
}
}

return myTable.MakeTags();

Last edited by dbentley; June 15th, 2011 at 09:41 AM.. Reason: deleted unnecessary returns (too long)
Reply With Quote
Reply

Tags
rows, table

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 02:17 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.