Do you know how to make the icon a mouse hover over to display a field from the related table.

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have a button displayed as a email icon that creates a new record in the related table, and I need the ability to hover over the field and display the notes from the record in the related table.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
"<a href='link' alt = ' " &[field to display on hover] & " '  title = ' " &[field to display on hover] & " ' ><img src='image source'></a>"
(Edited)
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
How do I add it to my current formula

var text URL =URLRoot() & "db/" & [_DBID_NOTIFICATIONS] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Project ID#])& "&z=" & Rurl();
var text Image = "<img src=https://images.quickbase.com/si/32/018-email_unread.png>";

If([Project ID#] > 0,"<a href=" & $URL & ">" & $Image & "</a>" )
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
If([Project ID#] > 0,"<a href=" & $URL & " alt=' " & [field value to display] &  " ' title=' " & [field value to display] & " '>" & $Image & "</a>" )



Mind the single and double quotes
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
The field is located in the related table will this work?
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
If related 'parent' table, bring in the lookup field name.