HyperlinkType

Follow

Comments

16 comments

  • Avatar
    Ravi Vekaria

    Hi,

    Using the HyperlinkType function, my links appear dead, going to this page

    https://view-awesome-table.com/-KtNABg-OaRcODaNrVUE

    Whenever I Look at the table as a view,

    The links are fine when clicking the link in Google Sheets ...What is going on?

  • Avatar
    Awesome Table

    Hello Ravi,

    Could you please send me a copy of your spreadsheet at support@awesome-table.com (if your data is sensitive please make a copy with fake data) so I can try to find the source of your issue.

    Thank you,

    Nicolas

  • Avatar
    jérémy texier

    Hello,

     

    We don't have acces to your page.

    Have you check the range of data source in configuration ?

  • Avatar
    Ravi Vekaria

    Hi,

    Its to do with the CSS/HTML Template for the column that is supposed to show hyperlinks within the tiptable..

    In this case I would like the data in that column to create a hyperlink, but I want the actual text displayed to be different.

    Cheers

  • Avatar
    Ariel (Edited )

    I was having this problem too. Maybe it is case sensitive with "HyperlinkType(yourLinkColumnIndex)" working and "hyperlinkType(yourLinkColumnIndex)" not working. But I'm not sure because switching to the second seems to work for me now too.

  • Avatar
    Awesome Table (Edited )

    Hello Ariel,

    Actually if you use "HyperlinkType(yourLinkColumnIndex)" or "hyperlinkType(yourLinkColumnIndex)" will not change the validity of the link. In both cases, it will work.

    If you still experience this issue, please send us your Awesome Table view and your spreadsheet at "support@awesome-table.com". If you have sensitive data, make a copy with similar data.

    Thanks.

    Thomas

  • Avatar
    Mahernioio

    Hi, I'm having a problem using multiple hyperlinks:

    I have a field in a table that includes multiple hyperlinks, separated by comma.
    Problem is, I need to have multiple Links generated to access the hyperlinks separately.

    Any idea how this could be achieved?

  • Avatar
    Awesome Table

    Hi Mahernioio,

    A field in a table can contain only one hyperlink. It is not possible yet to have multiple hyperlinks in the same field. 

    Regards,

    Thomas

  • Avatar
    José Matías del Pino (Edited )

    Hi, I have a list where only some rows have a link. Let's say Column A has the Names, and Column B has the Links. When I use HyperlinkType(B) on column A and there's no link on B2, the Text on A2 is not shown. Is there a workaround for that?

  • Avatar
    Awesome Table

    Hi José Matias del Pino,

    Unfortunately it is not possible yet to have only text if you use the keyword "Hyperlink". I suggest you to create another column to display when some of your texts have no link.

    Thank you.

    Thomas

  • Avatar
    Andrew Sheridan

    Hello - is it possible to have the hyperlink open in the same tab instead of opening in a new tab every time?

  • Avatar
    Awesome Table

    Hello Andrew Sheridan,

    Unfortunately, it is not yet possible to open your hyperlink in the same tab. Opening in a new tab is automatically set up with "hyperlinkType".

    Kind regards,
    Thomas

  • Avatar
    Corey Diamant

    Hi,

    I'm having the same issue that Ravi and Ariel had about the hyperlink not working. The hyperlinks sometimes work and sometimes do not. This has happened on Chrome, Explorer, Safari, Windows, OS, iOS. The broken links take you to this page: https://view-awesome-table.com/-L9HGOQDjmKf0CxnQcZI/Loading...

    I haven't found any patterns and it seems to be random times that the hyperlinks work or do not work. It is odd that sometimes it is broken and sometimes not.

    Have you seen this problem and do you know of a possible fix?

    Thanks,
    Corey.

  • Avatar
    Awesome Table (Edited )

    Hi Corey Diamant,

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "support@awesome-table.com"? If you have sensitive data, you can make a copy with similar data. Just make sure you give us access to your data.

    Thanks in advance.

    Thomas

  • Avatar
    Corey Diamant

    Thanks Thomas,

    I believe I have found the source of the issue. Or at least the issue has not persisted since I made the change. I originally used a script to extract URLs from hyperlinks I had created, then referenced those cell on another sheet (which were the cells used for the hyperlinkType).

    The two issues that arose were the link I showed above and occasionally the Awesome-Table website opening in a new tab with my Table/Map full view (on which the hyperlinks actually worked). It seems as though maybe there was a processing time to run the reference+script that did not allow the hyperlinks to open correctly. I simply copy+paste values all of the cells and it has run fine since.

    Does this sound reasonable? If the problem comes back I'll post again, but hopefully it is fixed.

    Best,
    Corey

  • Avatar
    Awesome Table

    Hi Corey Diamant,

    Thank you for keeping us informed!
    Indeed, of you use a script, it could be the cause of this problem.

    Please, do not hesitate to warn us if you meet this problem again.

    Kind regards,
    Thomas