Thanks Daniel, I've been rereading the documentation and think I see what I need to do.
Get the total number of rows using var totalrows = crewDataTable.getNumberOfRows(); I know there are only 5 columns in the original data, and the URL I want is in the last of those. There's only 30 of those out of 3,100 rows of data. Step through each row. Test is there's anything in last column of the current row. If there is, create the formatted URL text and add that to the first column in the current row using setCell(rowIndex, columnIndex [, value [, formattedValue [, properties]]]); where value is going to be undefined so it retains the current value Once that's done, draw the altered table using just the first 4 columns as the last one is now superfluous. I was hoping there was a nice simple way of using the formatter, but I don't see why this shouldn't work. If anyone's interested, this is what its being used for - http://hmsgambia.org/crewlist.htm Unless something goes horribly wrong, I should have this done properly in a day or two. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/096c117c-27f7-4695-9e81-03bdfb9d2719%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
