Reveal long multi-line text by clicking an ellipsis
I have multi-line text fields with unlimited length. In table reports I'd like them to function like social media comments where long strings of text are revealed by clicking the ellipsis ('...'). Wondering if this can be done in a Formula-Rich Text field.
Currently my field displays the text up to the 30th space character followed by an ellipsis; the full text displays in the hover-over bubble. This works but I'd prefer the simplicity of click-to-reveal.
My current Formula-Rich Text field is as follows:
var text TitleText = SearchAndReplace([Text Field], "\"", "'");
If(Part([Text Field], 30, " ") != "",
"<p title=\"" & $TitleText & "\">" &
Part([Text Field], 1, " ") & " " &
Part([Text Field], 2, " ") & " " &
Part([Text Field], 3, " ") & " " &
Part([Text Field], 4, " ") & " " &
Part([Text Field], 5, " ") & " " &
Part([Text Field], 6, " ") & " " &
Part([Text Field], 7, " ") & " " &
Part([Text Field], 8, " ") & " " &
Part([Text Field], 9, " ") & " " &
Part([Text Field], 10, " ") & " " &
Part([Text Field], 11, " ") & " " &
Part([Text Field], 12, " ") & " " &
Part([Text Field], 13, " ") & " " &
Part([Text Field], 14, " ") & " " &
Part([Text Field], 15, " ") & " " &
Part([Text Field], 16, " ") & " " &
Part([Text Field], 17, " ") & " " &
Part([Text Field], 18, " ") & " " &
Part([Text Field], 19, " ") & " " &
Part([Text Field], 20, " ") & " " &
Part([Text Field], 21, " ") & " " &
Part([Text Field], 22, " ") & " " &
Part([Text Field], 23, " ") & " " &
Part([Text Field], 24, " ") & " " &
Part([Text Field], 25, " ") & " " &
Part([Text Field], 26, " ") & " " &
Part([Text Field], 27, " ") & " " &
Part([Text Field], 28, " ") & " " &
Part([Text Field], 29, " ") & " " &
Part([Text Field], 30, " ") &
"...</p>",
[Text Field])