Large Note Field
I have a large note field in my form. However, in the Table it takes up a ton of space. Is there a way to have a link to the note field in the table? ------------------------------ Mike McCartney ...
Forum Discussion
Thanks Mark. Works great. How about if the field is empty and I want to leave it empty?
------------------------------
Mike McCartney
------------------------------
------------------------------
Mike McCartney
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendtry this:
var text NoteLink =
Left([Notes], 100) & " " &
"<a href="&URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"&">"& "More" &"</a>";
IF(
Trim([Notes])="", "",
Length([Notes])<100, [Notes])
$NoteLink)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text NoteLink =
Left([Notes], 100) & " " &
"<a href="&URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"&">"& "More" &"</a>";
IF(
Trim([Notes])="", "",
Length([Notes])<100, [Notes])
$NoteLink)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Everything was fine until the last line. Should I rename $NoteLink) ?
------------------------------
Mike McCartney
------------------------------- From the link you posted earlier, I found this and it worked:
Left([Notes], 100) & " " &
If([Notes] != "", "<a href="&URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"&">"& "More" &"</a>")
------------------------------
Mike McCartney
------------------------------- Thanks again Mark!
------------------------------
Mike McCartney
------------------------------