Forum Discussion

JaimeStrawderma's avatar
JaimeStrawderma
Qrew Cadet
6 years ago

Hover Over Text Field

I have text fields with unlimited character length. Due to my layout the fields are only a certain width. Is there a way to create a hover over option to reveal the full amount of text in the field? T...
Formulas and functions
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
6 years ago
I use this.

If(Length([Notes])<180,[Notes],Left([Notes],180)&"<br><a href='"&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"&dfid=10' title='" &
List(" ",Part([Notes],1,"'"),Part([Notes],2,"'"),Part([Notes],3,"'"),Part([Notes],4,"'")) &
"'>more</a>")​
You can change the 180 to any value.

This formula will show the # of characters you specify unless there are less characters than the number you specify, in which case it shows all.  The more option shows up and display in a hover-m​​odal .

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
EricFixler1's avatar
EricFixler1
Qrew Trainee
6 years ago
Laura - this works great.  One limitation I have found is that if the notes field is long it cuts off the text in the hover field. 

How do I extend that hover box to include more characters?

I have tried to add ,Part([Notes],5,"'" , but that doesn't seem to do the trick.

Thanks.
Eric

------------------------------
Eric Fixler
------------------------------
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    I think this is the limitation of the title attribute. It is used to show additional information about a link so that the user can learn more before clicking on the link. There may be a work around, but I am not aware of one yet.

    ------------------------------
    Adam Keever
    ------------------------------
    • EricFixler1's avatar
      EricFixler1
      Qrew Trainee
      6 years ago
      Thanks,

      So what is the purpose of this syntax? It seems like you don't need the additional Part statement and it still works. 
      Part([Notes],2,"'"),Part([Notes],3,"'"),Part([Notes],4,"'")


      ------------------------------
      Eric Fixler
      ------------------------------
      • AdamKeever1's avatar
        AdamKeever1
        Qrew Commander
        6 years ago
        I agree. I removed the List function including the Part functions and got the same result as with them included.

        ------------------------------
        Adam Keever
        ------------------------------