Datapress hyperlinks and multi-field data sorts not working

Hi Lawrence. Both of these issues are dealt with properly in the underlying exhibit framework. I’m looking into whether/how they are exposed in the datapress framework. For item (1), you can see at this example how the individual presidents’ names are clickable links. For item (2), there is some question about what it means to sort on fields with multiple values. By default, exhibit uses one of the values (chosen arbitrarily, probably the first or last listed) as the sort key. There is an option telling exhibit to put a duplicate of the item at each spot where some value of the sort key would indicate; is that what you are looking for?

OK, we’ve tracked the source of problem (1). Google spreadsheets allow you to make a column of your spreadsheet into a hyperlink using the “Hyperlink()” spreadsheet function. But then it doesn’t export the hyperlink in the spreadsheet data feed, so all datapress sees is the text, not the url.

The solution, if you want to use urls in your datapress exhibit, is to make a separate spreadsheet column containing the url. Then you can edit the lens in datapress to make use of the url column.