HyperlinkType

Follow

Comments

22 comments

  • Avatar
    Margarita Arévalo (Edited )

    My table isn't working. Attached is an image of my table.

     

    On the second row, I type HyperlinkType(f)  and it still appears as a header on my view. On column F I have images that are supposed to be clickable and take to a link. The column with the URLs is colum F, but even when I type [link], the column isn't hidden either. The columns are not linking. Also, on the view, instead of seeing the images, I only see the URL link to the images. Keep in mind, that on the example below I typed HyperlinkType[link] only to troubleshoot seeing how syntax [link] nor {link} were working.

     

    This is how the table looks, only way to display images is with ImageType, but the images are supposed to be clickable. Typing HyperlinkType(F) - ImageType only causes the images to be displayed, and the Hyperlink appear as header, too. If I type noFilter - Hyperlinktype(F) - ImageType, I get the images to become URL, but the noFilter appears as header, the same if I type Stringfilter. 

     

    Also, I try to set as a Card View, not Table, and here the images disappear entirely. 

    0
    Comment actions Permalink
  • Avatar
    Awesome Table

    Hello Margarita Arévalo,

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "suppor@awesome-table.clom"? Just make sure you give us access to your data. 

    It would be great if you could explain in details what you want to achieve because you made comments in many articles with different requests.

    Thanks in advance.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Joseph Kyle Lons Aerotek (Edited )

    Is there a way to add multiple different hyperlinks? I have an item in A1 that needs a link and then an item in D1 that needs a different link, an item in G1 that needs another different link, an item in H1 that needs a different link and an item in I1 that needs a different link. Is this possible? 

     

    0
    Comment actions Permalink
  • Avatar
    Awesome Table

    Hello Joseph,

    You can have as many hyperlink as you desire in your view. Just make sure that you have for each element : 

    • the column with the content you want to display
    • the column with the hyperlink 
    • put "HyperlinkType(X)" in the first column (X being the hyperlink column url

    Please not that you can have several element with the same url too (a title and an image for example) just by referencing the same url column an each element.

    Nicolas

    0
    Comment actions Permalink
  • Avatar
    Eric Johnston

    I have my anchor in column A and my hyperlinks in column B. I'm trying to use hypelinkType(B) but I do not have a hyperlinklink in column B for every row in the anchor column A. 


    How can I get the table to display a hypertext for the rows that have a hyperlink in column B but just plain text when there is no hyperlink available? Currently, it is will not display a row unless it has a hyperlink in column B. 

    0
    Comment actions Permalink
  • Avatar
    Awesome Table

    Hello Eric Johnston,

    Indeed, when you use "<a href=""></a>" or our hyperlinktype keyword and some of your data have no links assigned, they won't be displayed. It is not possible to display the text when you have no link assigned.

    You can propose this possibility in our feature request platform.

    Thank you for your understanding.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Peter Brunet

    Hello,

    I am trying to setup an online Unit Planner, which links to a google doc unit planner.  The Unit Planner is created/displayed using Gantt.  Here is snapshot.  I want to add a link to a google doc when clicking Unit 4..Unit 2 and so-on.  The Hover displays information as shown below...just need a link option

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi @Peter.

    If you're asking how to put a link on the individual (Gantt) bars, this is not possible and not practical since a file will automatically open when bars are clicked.

    But if you want to put a link inside the tooltip (hover box), your desired end result is achievable by modifying the template. However, since the link will be housed inside the tooltip (hover box), no one will be able to click the link since the tooltip will disappear once the mouse steps off from the individual (Gantt) bar.

    I recommend using an advanced Gantt view with sidebar. This way, you can input the link (and other elements) statically on the side panel. Here's a live demo.

    Hope this helps.

    - Randy

     

    0
    Comment actions Permalink
  • Avatar
    Peter Brunet

    Hello Randy,

    That is exactly what I was looking for and a bit more.  I am only SLIGHTLY familiar with code/script, where can I find the code behind this feature or information how to set-up.  Also, are the 3 columns necessary in the additional Sheet:

     

    Also, maybe you can help.  I was able to set-up an UPDATE button with Awesome Table for a G-Form, and the data from this G-Form is synced with AutoCrat. Any ideas how to sync G-Form changes with G-Doc?  

     

    Thanks for your help

     

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi Peter.

    ... where can I find the code behind this feature or information how to set-up.
    - First, create a copy of the Gantt-sidebar template by clicking the USE TEMPLATE button at the top-right corner.
    > Click the datasource, and
    > Click the Template sheet
    (screencast below)

    There's a quick rundown at the end of the Gantt tutorial showing how everything was configured.

     

    ... are the 3 columns necessary in the additional Sheet:
    - Yes, they are since this is a specialized view and we need to tell that it needs to be set up like a Gantt chart with a sidebar. The CSS template <style> is used to enhance the look and feel of your view.

     

    Any ideas how to sync G-Form changes with G-Doc?
    - I only know that changes can be synced between GForms to GSheets (but not GDocs).

    As for AutoCrat (as far as I can remember), you can either rerun the add-on to sync the fields or configure it to update the GDocs output using conditional triggers. Please reach out to the AutoCrat support team for more info as I'm not well versed with this add-on.

     

    - Randy

     

    0
    Comment actions Permalink
  • Avatar
    Jeanne MARSANDE

    Hello, 

    I want to add an HyperlinkFilter on my headers, how can I do that? (like "Help" in this picture below)

    Thank you for your help!

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi @Jeanne.

    The hyperlinkType keyword won't work based on your specifications. HyperlinkType is only applicable to the data (records or rows) itself, but not the header. 

    Personally, I don't recommend this, but you can easily add an <a> href attribute to achieve your goal. Just note that this will also display on your filter, its tooltip, and the table header. 


    - Randy.

    0
    Comment actions Permalink
  • Avatar
    Nicolas Gauvin (Edited )

    Hello,

    Unfortunately, this is currently not possible with Awesome Table.

    Please feel free to suggest this idea in the Feature Request page.

    Regards

    Nicolas

    0
    Comment actions Permalink
  • Avatar
    Tim Quealy

    (Sorry if this was posted twice!)

     

    I am having trouble with the simple hyperlink feature.  I've attached screenshots of the data, and the table it creates.  The URL it points to can be seen in the bottom left, but mostly, the column says a URL (like Avalonschool.org), but then the hyperlink adds a bunch to the beginning of it (https://view-awesome-table.com/-LsIbvYj1uts3YzBJqSK/www.avalonschool.org), and that gives me a page error.  I'm sure I'm missing a very obvious step, but I can't get it to work!

     

     

     

     

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Paul Young

    I am having the same issue as Tim

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi @Tim.

    I just tried your view and the links are working fine (see screencast below).

     

    @Paul.

    Please share your:

    AwesomeTable link - Share with us your AwesomeTable & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Detailed instructions here.

    Google Sheets datasource - It's best to set the sharing settings to Anyone with the link. Click here to learn more.


    Randy

     

    0
    Comment actions Permalink
  • Avatar
    Michael Loney

    I am stuck and can't get text to hyperlink. I think I am above my head in trying to get things to work so thought I would ask and see if this is possible. 

    Here is my table: https://awesome-table.com/-LwO_ng8QoUv6q5q34rR/view

    If you hover over a card, the card flips to display additional information. My hope is that the line on the back that says "Teacher Login Help" would link to a click sheet I created to help teachers login.

    I can't seem to get HyperlinkType() to work. If I use a lowercase s in the HyperlinkType(s) then nothing happens. The card displays correctly on the awesome table but there is no hyperlink. If I use a capital S then still no hyperlink but the formatting of the cards gets crazy (see below).

     

    HyperlinkType with capital S

     

    Is it possible to hyperlink in this situation? If so, any suggestions on what I might try? 

     

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi Michael Loney.

    It's not recommended to use the HyperlinkType keyword when using an HTML <a href=""> tag in your template sheet. This will break both the internal HTML structure and layout of your view.

    Please share your Google Sheets datasource and set the sharing settings to Anyone with the link so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Click here to learn more. (we can't open your view)

    - Randy

     

    0
    Comment actions Permalink
  • Avatar
    Michael Loney (Edited )

    Thanks Randolph Abelardo,

    I changed the Google sheet setting so anyone should be able to see it now, sorry :( I tried <a href = ""> but removed that and changed to trying HyperLinkType 

    I could get the HTML command to work but it linked the entire card rather than specific words. I can't seem to get the HyperLinkType to work. I'm sure it is user error, but I can't figure out where I am going wrong.

    Thanks so much for taking a look and trying to help :)

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi Michael Loney.

    Since the template you're using behaves as links for the individual cards, we just need to reference the Link column there. As such, there's no need to indicate a Login Help link anymore for the back-card.

    You can replicate the copy I made here.

    - Randy

     

     

    0
    Comment actions Permalink
  • Avatar
    gsrathore97

    How can i hyperlink a row value?
    Or only one cell in middle of data?

    1
    Comment actions Permalink
  • Avatar
    Oleg Gulevskyy

    Hello gsrathore97,

    Same as with buttonType, keywords are applied to data in the column. Every keyword works the same.

    Please tell us more about your use case so we can figure out what could you do to achieve your goal.

    Thanks

    0
    Comment actions Permalink

Please sign in to leave a comment.