Skip to main content
Question

Hover over a graphic in a column to briefly display a comment in hidden column.

  • March 22, 2017
  • 0 replies
  • 72 views
Our comments column contains tons of data that I want to hide on the home page to make things look better.  We will be able to view the comments by opening each individual record, but I would like to make a column, with a notepad graphic in it, that when hovered over or pressed, will briefly display the comment.  Is this possible?
    This topic has been closed for replies.

    • ChrisChris
    • Quickbase Alumni
    • March 22, 2017

    The html enabled formula text field would be coded like::


    "<img src='link to image source' alt=" &[comments field]& " title="&[comments field]&" />"


    the alt and title attributes would display the content of the comments field upon hover.

    • EricJHansen
    • Quickbase Alumni
    • March 22, 2017
    Hi Neil,

    Yes, this is possible! We've done it before (see attached) and there are probably more ways to do it than one however, I can't think of a way to do it natively. 

    We do it with a code page that is called with the IOL technique that Dan Diebolt has discussed in this community many times. That allows us to show pretty much anything we want in a mouse over of each row. In the attached example, we are showing the most recent activity information from a child table, but it could be used for the notes instead. 

    If you need assistance, please feel free to reach out to me via my contact info in my profile.

    https://getsatisfaction.com/people/cirrusops


    Good luck!
    • EricJHansen
    • Quickbase Alumni
    • March 22, 2017
    The method Chris presents would be a great example of a native way to solve for it. Thanks Chris! =]
    • EricJHansen
    • Quickbase Alumni
    • March 22, 2017
    Actually, after testing it, it cuts off at the first space between words. Chris, do you have a way to fix that? I've never used this method before.
    • anomDiebolt
    • Quickbase Alumni
    • March 22, 2017
    > ... it cuts off at the first space ...

    Surround the attributes with single quotes:

    "<img src='link to image source' alt='" & [comments field] & "' title='" & [comments field] & "' />"

    One limitations is that your fields cannot have single quotes within them.
    • EricJHansen
    • Quickbase Alumni
    • March 22, 2017
    That worked. Thanks Dan!
    • ArchiveUser
    • Author
    • Quickbase Alumni
    • March 23, 2017
    Thanks!!!!!!!!!  We had to do the single quote then double quote to make it work and it's great.  I think this will become our replacement program for SharePoint for the company.
    Terms & ConditionsAccessibility statement