Collapsible Square in a Table
Hello! I'm creating a table for projects that has a Comments field that is is going to be _very_ long, and I was wondering if there was a way to make this field collapsible. Meaning, that if the co...
Forum Discussion
I use this:
If(Length([Notes])<180,[Notes],Left([Notes],180)&"...<br><a href='"&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"' title='" &
List("'",Part([Notes],1,"'"),Part([Notes],2,"'"),Part([Notes],3,"'"),Part([Notes],4,"'")) &
"'>more</a>")
I use this for building fields to use in reports. It allows the use to see a pre-fixed number of characters (you can change it from 180) with a "more" link which when you hover on it will display the entire field value. If the use clicks on the "more" link; it will open up the record.
If(Length([Notes])<180,[Notes],Left([Notes],180)&"...<br><a href='"&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"' title='" &
List("'",Part([Notes],1,"'"),Part([Notes],2,"'"),Part([Notes],3,"'"),Part([Notes],4,"'")) &
"'>more</a>")
I use this for building fields to use in reports. It allows the use to see a pre-fixed number of characters (you can change it from 180) with a "more" link which when you hover on it will display the entire field value. If the use clicks on the "more" link; it will open up the record.
