WordPress.org

Datapress hyperlinks and multi-field data sorts not working

• lawevan

  @lawevan

  5 years, 9 months ago

  This plugin has great potential, but I have run into a problem or two.

  1. Hyperlinks (using the Google-specified convention of “=hyperlink(“[URL]“;[link text or label]” work fine in the native Google spreadsheet but are not preserved in the wordpress datapress page display.

  2. Fields with multiple values (semi-colon delimited, but displayed via DataPress with friendly “and” connectors) do not interactively sort properly, even though single-value fields work just fine.

  Anybody know any solutions to these issues?

• David Karger

  @karger

  5 years, 9 months ago

  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?

  lawevan

  @lawevan

  5 years, 9 months ago

  Thanks for looking into this. I can see how nicely things work in your example for issue (1). As for issue (2), I wondered how the key would be selected, but I assumed that it would probably be the first value. As I look more closely at this thing, I am seeing that I may have some sort of caching issue, as edits to my Google spreadsheet do not seem to be consistently coming through. I will investigate that further in the meantime.

  David Karger

  @karger

  5 years, 9 months ago

  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.