Portal table with multiple rows/columns

[leberhar]

How would one make a table using portal records that has 3 columns and multiple rows as needed? I've only succeeded in making a table 1 column and multiple rows OR multiple columns and 1 row.

[Garry Claridge]

Do you wish to use three different fields; one in each column? Or, are you using one field which is displayed three across, then row-by-row?

A couple of threads exist on this subject. One thread talks about using calculated fields and cdml to determine the change of row. The other thread talks about using Javascript to format the columns and rows.

All the best.

Garry

[leberhar]

I wanted one related record (multiple fields) per cell three across, then row-by row. I did look at both of those threads, but if cdml can't do it "out-of-the-box" ...

[Garry Claridge]

I recommend using Javascript.

Garry

[The Bridge]

Try something like this:

<table>

<tr>

[FMP-Portal:Relationship]

<td>

[FMP-Field:Relationship::FieldName]

</td>

<script>

if (([FMP-CurrentPortalRowNumber] % 3) == 0)

{ document.write("</tr><tr>") ; };

</script>

[/FMP-Portal]

</tr>

</table>

Not exactly "out of the box", but it will format related records 3 across before starting a new row.

[leberhar]

I tried that, and it didn't work (one big line again)... can I put [FMP-CurrentPortalRow] in the format file to see what portal row the record is? (...because I did, and it just displayed [FMP-CurrentPortalRow] and no number...) Is there something that needs to be in the layout with the portal?

[Garry Claridge]

Can you post your code here, so we can have a look!

All the best.

Garry

[leberhar]

I'll have to resurrect it... anything I tried this morning is in the vertical file.

[The Bridge]

Use [FMP-CurrentPortalRowNumber], not [FMP-CurrentPortalRow], which would explain why no number was generated.