Copying Hyperlink into Coda

[Hannah_Krumholz]

Hi everyone! This is a small thing, but curious if anyone has found a fix.

When I try to copy and paste hyperlinks from google sheets to Coda tables they don’t copy as links and I have to manually update every single one.

Has anyone figured out how to fix this?

Thanks!

[Pch]

Hi @Hannah_Krumholz !

Someone ran into a similar issue some time ago and if I do remember correctly this happens because in GSheets hyperlinks are created with a “cell formula” (and Coda doesn’t support “cell formulas”, so the hyperlinks are not interpreted as hyperlinks but as text) .

What you could do is instead of copying/pasting the hyperlink from GSheets would be to copy and paste in your table the display text of your GSheets hyperlink and the url… then in another column, recreate the hyperlink (with Hyperlink()) .

In my sample, the Hyperlink() formula is :

Hyperlink(thisRow.[Copied URL],thisRow.[Copied Name])

It’s been a while since I’ve used GSheets so I might be wrong here .

[Ed_Liveikis]

Not sure if this is similar, but I have the same issue with emails and urls that get pasted into text fields. Sometimes coda makes them a link, other times not:

Text column entry won't convert email to a hyperlink if focus is lost

Hello, Reproduction steps: Select a text field for entry, make sure cursor is blinking if selecting on table view. If selecting in a detail view, then it will always enter text edit mode (cursor blinking). Paste or type the email. Click away from the field to make it lose focus. Observe that the email is not converted to a hyperlink. Expected results: the email should be converted to a hyperlink. This seems to happen very often with various users of the app, and it is easy to miss. To corre…

[Hannah_Krumholz]

Thanks for the reply! The issue is that I’m trying to copy over 100s of hyperlinks, so I am trying to not have to copy and paste each link individually.

I’ll try to expose the links directly in Gsheets and then do this.