email link shows up regardless of if we have an email

[JosephMcArthur]

No description provided.

[char-siuu-bao]

A super quick hack around this would be to add a column that only displays "contact" text and click through link to email if they have an email address. But this adds an extra column so not as elegant

[JosephMcArthur]

We could also do something on the database end? E.g put in an email for us that they could use to ask us? I realise that comes with a stupid amount of downsides... but just playing with ideas.

On Fri, 1 Sep 2017 at 14:58 Lorraine Chuen ***@***.***> wrote: A super quick hack around this would be to add a column that only displays "contact" text and click through link to email if they have an email address. But this adds an extra column so not as elegant — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#7 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AEuWZ_hpNhKNtPEF0r_J6XCf9kPUFNPtks5seA1xgaJpZM4PIdkB> .

-- Joseph McArthur Assistant Director: Right to Research Coalition <http://righttoresearch.org/> Co-Lead/Founder: Open Access Button <http://openaccessbutton.org/> Twitter: @Mcarthur_Joe <https://twitter.com/Mcarthur_Joe> Skype: joseph_mcarthur

[char-siuu-bao]

note from Andrew from Sheetsu on how to address this: Right now by using Sheetsu Snippet there's no option for this. But...
You can use spreadsheet superpowers! I made an example for you. Here is code: https://codepen.io/anon/pen/jGmmvV and here is spreadsheet: https://docs.google.com/spreadsheets/d/1u7LPIy-lPgi6HNTk81hlLyqcQylSEw8OZ6Q5QqAXoKw/edit#gid=0

(I'll work on fixing it this week!)