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
MarkShnier__You
Qrew Legend
Qrew LegendHere is an app with a bunch of Tips which was presented at EMPOWER, and I have a link here to the tip you can use
https://team.quickbase.com/db/bpj7nsk6n?a=dr&r=br&rl=kfn
Let's assume the text field is called "Notes". Create a formula rich text field with the following formula:
Left([Notes], 100) & " " &
"<a href="&URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"&">"& "More" &"</a>"
where the number eleven above is the identifier of the custom form that displays only the field "Notes". To determine the dfid of your custom form you would want to open up the settings for that table, open up the forms section and you will see the form id of each form listed in that report. The above formula displays the first 100 characters of the "Notes" field. To display more or less characters change the number one hundred above. To change the display text for the link you would edit the part "More" to display the text you would like.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
https://team.quickbase.com/db/bpj7nsk6n?a=dr&r=br&rl=kfn
Let's assume the text field is called "Notes". Create a formula rich text field with the following formula:
Left([Notes], 100) & " " &
"<a href="&URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&dfid=11"&">"& "More" &"</a>"
where the number eleven above is the identifier of the custom form that displays only the field "Notes". To determine the dfid of your custom form you would want to open up the settings for that table, open up the forms section and you will see the form id of each form listed in that report. The above formula displays the first 100 characters of the "Notes" field. To display more or less characters change the number one hundred above. To change the display text for the link you would edit the part "More" to display the text you would like.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thanks Mark. Works great. How about if the field is empty and I want to leave it empty?
------------------------------
Mike McCartney
------------------------------
------------------------------
Mike McCartney
------------------------------
- MarkShnier__Youtry 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
------------------------------- 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
------------------------------