Setting the header/label for an HTML block field.

[perchance]

I have a tabular result set that I'd like format the alignment for. Using advice here on the forums, I've substituted

[@field:NumericField]%

For the generic field.

That works great for the right align, but then I lose the \"label\" that sets the column's header row. Is there any way to keep that in AND adjustment the alignment?

[bahar_vm]

If you display the field from an HTML block, you will lose the header label. Why don't you just leave them as regular fields and not in HTML blocks and just align the data within Styles? However that one will align all the columns and you can not set a specific column alignment.

[ycollier]

I agree, it would be very useful to be able to define the header of a html block.

To control the alignment of each column, you can use script like:

var stl='none';

var tbl = document.getElementsByTagName('table')[5]; // 5 for the number of tables before you datapage

var rows = tbl.getElementsByTagName('tr');

for (var row=1; row

var cels = rows[row].getElementsByTagName('td');

cels[0].style.textAlign='left';

cels[2].style.textAlign='center';

cels[4].style.textAlign='right';

cels[6].style.display=stl; // if you want to hide the data of a column

}

I have a tabular result set that I'd like format the alignment for. Using advice here on the forums, I've substituted

[@field:NumericField]%

For the generic field.

That works great for the right align, but then I lose the "label" that sets the column's header row. Is there any way to keep that in AND adjustment the alignment?

[bahar_vm]

If you were able to customize the results table with Java Script, why don't you simply add a header label to that spedific column within the JS? You could simply add the following to the already existing code:

var colheader = rows[0].getElementsByTagName(\"td\");

colheader[10].innerHTML=\"HEADER\";

Note: It should be outside of the \"for\" loop.

[ycollier]

Very good idea and simple to put in place.

Thanks

If you were able to customize the results table with Java Script, why don't you simply add a header label to that spedific column within the JS? You could simply add the following to the already existing code:

var colheader = rows[0].getElementsByTagName("td");

colheader[10].innerHTML="HEADER";

Note: It should be outside of the "for" loop.

[Gwen]

Can someone please help! I've tried using the suggestions listed here but they aren't working. I must need to change something but don't have any idea what to change. To set a label in the header I tried both options offered, both left the label field blank.

I tried

var colheader = rows[0].getElementsByTagName(\"td\");

colheader[10].innerHTML=\"HEADER\";

What do I change the <\td\> to so it will work? This code is in a HTML Block so there isn't a caspio fieldname associated with it.

To hide a column I tried the following - I set the table number to both 0 and 1 neither worked(It's the only table deployed on the page. Do I need to replace 'tr' with something? (I have this in the header block)

var stl='none';

var tbl = document.getElementsByTagName('table')[5]; // 5 for the number of tables before you datapage

var rows = tbl.getElementsByTagName('tr');

for (var row=1; row

var cels = rows[row].getElementsByTagName('td');

cels[9].style.display=stl; // if you want to hide the data of a column

}

thanks for any help!!!

[bahar_vm]

To assign a label to a column, make sure the code is as below:

<script>
var colheader = rows[0].getElementsByTagName("td");
colheader[10].innerHTML="<font size=1><b>HEADER<b></font>";
</script>

You need to replace number 10 with the corresponding column number.

To hide a column in results page put that code inside the footer.

Best,

Bahar M.

[Gwen]

Thanks however this is the same code suggested above that isn't working. I put it after the and nothing happened. I put it before the

.getElementsByTagName("td"); colheader[8].innerHTML="WEBSITE"; Website

I changed

[Gwen]

I moved the code to hide the column to the footer. I set the table to [0] since it's the first and only table on the page. The column still displays.