Jump to content

ssidata

Registered Users - Approved
  • Posts

    3
  • Joined

Converted

  • FusionPro Products
    No

ssidata's Achievements

Newbie

Newbie (1/14)

  • First Post Rare
  • Conversation Starter Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

10

Reputation

  1. Hello all: I was wondering if you can provide me with some assistance. I have a table that contains a variable amount of rows based on the number of dependents each record contains. I have found this logic from a previous thread and it works great: var fields = [[Rule("Dep1_Rule"),Field("dep1dob"),Field("dep1rel")],[Field("dep2fname") + " " + Field("dep2lname"), Field("dep2dob"), Field("dep2rel")],[Field("dep3fname") + " " + Field("dep3lname"),Field("dep3dob"), Field("dep3rel")], [Field("dep4lfname") + " " + Field("dep4lname"),Field("dep4dob"), Field("dep4rel")],[Field("dep5fname") + " " + Field("dep5lname"),Field("dep5dob"), Field("dep5rel")],[Field("dep6fname") + " " + Field("dep6lname"),Field("dep6dob"), Field("dep6rel")]]; var myTable = new FPTable; myTable.AddColumns(14400, 6100, 8500); myTable.AddRows(6); for (var i=0; i<6; i++) { if (fields[2] != "") { myTable.Rows.Cells[0].Font="Calibri" myTable.Rows.Cells[0].PointSize = 10; myTable.Rows.Cells[0].SetBorders("Thin","Black","Top","Bottom","Right","Left"); myTable.Rows.CopyCells(0,1,2); myTable.Rows.Cells[0].HAlign = "Left"; myTable.Rows.SetContents(fields[0], fields[1], fields[2]); } } return myTable.MakeTags(); The problem I'm having is that I need to be able to add a header row (3 Columns) that contain "Name", "Birth Date", "Relationship". I've tried a couple of things but nothing seems to work. I'm pretty new to making tables so any assistance you can provide would be appreciated.
  2. Below is the code I am using to list the codes. The codes are showing in one columm. I would like them to overflow to the next column if there is more than 4 codes to list for each column. Thanks for any help. if(FusionPro.inValidation) Rule("OnJobStart"); var myTable = '<table columns=4><column width=9000><column width=9000><column width=9000><column width=9000><alignment="left"'; myTable += '<margins = "top:0;bottom:0;left:0;right:0">'; myTable += '<drawbrule = "false">' var numRecsExtDF = externalDF.recordCount; for (recordWalker=1; recordWalker <= numRecsExtDF; recordWalker++) { if (externalDF.GetFieldValue(recordWalker, 'letterid') == Field("letterid")) { myTable += '<row><cell>' + NormalizeEntities(externalDF.GetFieldValue(recordWalker, 'coid')) } } myTable += '</table>'; return myTable;
  3. Good Morning. Working on a project that requires listing a code on a letter that utilizes an external data file. While I am able to list the code on one column, I would like to be able to list the code over multiple columns. So if I have five codes to list, it will appear like so: ******X ******X ******X ******X ******X If I have 12 codes to list from the external data it will appear like so: ******X ******X ******X ******X ******X ******X ******X ******X ******X ******X ******X ******X So as you can see, I will not always have the same number of codes to list for each record and since there are paragraphs immediately after I list these codes, the amount of space I have is limited. Is there some kind of "counter", if you will, that I can use in Fusion Pro that will tell it to start a new column if it reaches a certain number? Any direction/instruction would be greatly appreciated!
×
×
  • Create New...