My First Table - help!

[step]

Originally Posted by Kim

That HAlign centers ALL the cells. I was wondering if it's possible to just center the header and leave the actual dates and amounts under those headers flush left?

It's done the same way:

for (var i = rec; i <= data.recordCount; i++) {
  function ExField(str) { return TaggedTextFromRaw(data.GetFieldValue(i, str)); }
  if (ExField('company') && i > rec) break;

  var row = table.AddRow();
  row.Cells[0].HAlign = 'Left';
  row.CopyCells(0, 1);
  row.SetContents.apply(row, ['Date', 'Amount'].map(ExField));
}

[Kim]

Thanks for your patience with me, Ste.

It looks great!

[Dan Korn]

Here's Ste's rule adapted to use the multi-line record feature in FP 10. (It's back to a regular rule named "RUL_table", as in the original template you posted, not an OnRecordStart rule.)

var numOfCols = 3;
var data = FusionPro.GetMultiLineRecords();

var table = new FPTable();
table.AddColumns(7200, 8500);

var header = table.AddRow();
header.Type = 'Header';
var cell = header.Cells[0];
cell.SetBorders('Thin', 'Black', 'Bottom');
cell.HAlign = 'Center';
header.CopyCells(0, 1);
header.SetContents('Date', 'Amount');


for (var i = 1; i <= data.recordCount; i++) {
  function ExField(str) { return TaggedTextFromRaw(data.GetFieldValue(i, str)); }
  var row = table.AddRow();
  row.Cells[0].HAlign = 'Left';
  row.CopyCells(0, 1);
  row.SetContents.apply(row, ['Date', 'Amount'].map(ExField));
}

// Number of rows needed to evenly distribute across numOfCols.
// Minus 1 for the header row.
var rows = Math.ceil((table.Rows.length - 1) / numOfCols);

// Duplicate column 1 and 2 (and their headers) to make up numOfCols.
for (var i = 0; i < (numOfCols - 1) * 2; i++) {
  table.Columns.push(table.Columns[i % 2]);
  table.Rows[0].Cells.push(table.Rows[0].Cells[i % 2])
}

// Concatenate the rows cells in order to reduce our total rows
// and fill up the extra columns. 
var rowCounter = 1;
while ((table.Rows.length - 1) > rows) {
  var index = rowCounter % rows || rows;
  var row = table.Rows.splice(rows + 1, 1).pop();
  table.Rows[index].Cells = table.Rows[index].Cells.concat(row.Cells)
  rowCounter++
}

// Return the table tags.
return table.MakeTags();

[Dan Korn]

You could also accomplish this with a multi-column text frame, which makes the rule much simpler, since you only need a two-column table to flow into those three text frame columns. The only tricky part is the text that spans all columns after the table, but that's just a matter of using the <p paragraphplacement="straddleall"> tag. See the attached template.

[Kim]

Thanks, Dan!

A thing of beauty (as always) and great to see how to accomplish in v10.
Sorry for my slow response, been out of the office.

Happy New Year and thanks again to you both!!
Kim

[Kim]

Hi Dan and Ste,

Remember this thoroughly beautiful table you helped me work out?

I wound up using the code below for v10 and it's great and just what I asked for. But now that I've got some real data, I've got a little wrinkle. Sometimes there is only 1 entry for Date and Amount. So, I don't need 3 columns in those cases, but it still outputs the Date Amount headers for all 3 columns.

Any ideas on how to show the Date and Amount headers only if there is content to warrant them?

var numOfCols = 3;
var data = FusionPro.GetMultiLineRecords();

var table = new FPTable();
table.AddColumns(6000, 7000, 3000);

var header = table.AddRow();
header.Type = 'Header';
var cell = header.Cells[0];
cell.SetBorders('Thin', 'Black', 'Bottom');
cell.HAlign = 'Left';
header.CopyCells(0, 1);
header.SetContents('Date', 'Amount');


for (var i = 1; i <= data.recordCount; i++) {
  function ExField(str) { return TaggedTextFromRaw(data.GetFieldValue(i, str)); }
  var row = table.AddRow();
  row.Cells[0].HAlign = 'Left';
  row.CopyCells(0, 1);
  row.SetContents.apply(row, ['Date', 'Amount'].map(ExField));
}

// Number of rows needed to evenly distribute across numOfCols.
// Minus 1 for the header row.
var rows = Math.ceil((table.Rows.length - 1) / numOfCols);

// Duplicate column 1 and 2 (and their headers) to make up numOfCols.
for (var i = 0; i < (numOfCols - 1) * 3; i++) {
  table.Columns.push(table.Columns[i % 3]);
  table.Rows[0].Cells.push(table.Rows[0].Cells[i % 3])
}

// Concatenate the rows cells in order to reduce our total rows
// and fill up the extra columns. 
var rowCounter = 1;
while ((table.Rows.length - 1) > rows) {
  var index = rowCounter % rows || rows;
  var row = table.Rows.splice(rows + 1, 1).pop();
  table.Rows[index].Cells = table.Rows[index].Cells.concat(row.Cells)
  rowCounter++
}

// Return the table tags.
return table.MakeTags();

Thanks!
Kim

[step]

I haven't tested this but it seems like it would give you what you're looking for:

var numOfCols = 3;
var data = FusionPro.GetMultiLineRecords();

var table = new FPTable();
table.AddColumns(6000, 7000, 3000);

var header = table.AddRow();
header.Type = 'Header';
header.Cells[0].SetBorders('Thin', 'Black', 'Bottom');
header.CopyCells(0, 1);
header.SetContents('Date', 'Amount');


for (var i = 1; i <= data.recordCount; i++) {
  function ExField(str) { return TaggedTextFromRaw(data.GetFieldValue(i, str)); }  
  
  // Skip this record if 'Date' & 'Amount' fields are both empty.
  var contents = ['Date', 'Amount'].map(ExField);
  if (!Trim(contents.join(''))) continue;
  var row = table.AddRow();
  row.SetContents.apply(row, contents);
}

// Determine how many columns are needed based on how many rows
// were added to the table (minus 1 for the header row).
var colsNeeded = table.Rows.length - 1;

// Update the numOfCols variable if we need less than 3.
numOfCols = colsNeeded < numOfCols ? colsNeeded : numOfCols;

// Number of rows needed to evenly distribute across numOfCols.
var rows = Math.ceil(colsNeeded / numOfCols);

// Duplicate column 1 and 2 (and their headers) to make up numOfCols.
for (var i = 0; i < (numOfCols - 1) * 3; i++) {
  table.Columns.push(table.Columns[i % 3]);
  table.Rows[0].Cells.push(table.Rows[0].Cells[i % 3])
}

// Concatenate the rows cells in order to reduce our total rows
// and fill up the extra columns. 
var rowCounter = 1;
while (colsNeeded > rows) {
  var index = rowCounter % rows || rows;
  var row = table.Rows.splice(rows + 1, 1).pop();
  table.Rows[index].Cells = table.Rows[index].Cells.concat(row.Cells)
  rowCounter++
}

// Return the table tags.
return table.MakeTags();

[Kim]

Hi Ste!

Thanks for the response. This is almost perfect. I thought it was doing it exactly as needed, but have found that it behaves a little weird when there are 4 records - it makes 2 columns with 2 lines each and puts a blank 3rd column with just headers. If I have 3 records it is fine and does 3 columns across. It just seems to get confused by 4 records.

Examples of the one scenario that doesn't work attached along with examples of other record counts working as expected.

[Kim]

Have I stumped you guys?

[step]

Originally Posted by Kim

Have I stumped you guys?

No, sorry, I've just been busy. Try this:

var numOfCols = 3;
var data = FusionPro.GetMultiLineRecords();

var table = new FPTable();
table.AddColumns(6000, 7000, 3000);

var header = table.AddRow();
header.Type = 'Header';
header.Cells[0].SetBorders('Thin', 'Black', 'Bottom');
header.CopyCells(0, 1);
header.SetContents('Date', 'Amount');


for (var i = 1; i <= data.recordCount; i++) {
  function ExField(str) { return TaggedTextFromRaw(data.GetFieldValue(i, str)); }

  // Skip this record if 'Date' & 'Amount' fields are both empty.
  var contents = ['Date', 'Amount'].map(ExField);
  if (!Trim(contents.join(''))) continue;
  var row = table.AddRow();
  row.SetContents.apply(row, contents);
}

// Determine how many columns are needed based on how many rows
// were added to the table (minus 1 for the header row).
var colsNeeded = table.Rows.length - 1;

// Number of rows needed to evenly distribute across numOfCols.
var rows = Math.ceil(colsNeeded / numOfCols);

// Duplicate column 1 and 2 (and their headers) to make up numOfCols.
for (var i = 0; i < (numOfCols - 1) * 3; i++) {
  table.Columns.push(table.Columns[i % 3]);
  table.Rows[0].Cells.push(table.Rows[0].Cells[i % 3])
}

// Concatenate the rows cells in order to reduce our total rows
// and fill up the extra columns.
var rowCounter = 1;
while (colsNeeded > rows) {
  var index = rowCounter % rows || rows;
  var row = table.Rows.splice(rows + 1, 1).pop();
  table.Rows[index].Cells = table.Rows[index].Cells.concat(row.Cells)
  rowCounter++
}

// Create reference variables to the cells of the first row (header)
// and second row (the date/amount values).
var [headerCells, contentCells] = table.Rows.slice(0, 2).map(function(s) { return s.Cells });

// We only need as many header cells as there are content cells. So, if
// there are more header cells than content cells, we can begin removing
// headers until the columns are equal.
while (headerCells.length > contentCells.length)
  headerCells.pop();

// Return the table tags.
return table.MakeTags();