ContributionsMost RecentMost LikesSolutionsRe: Can I collapse a text field on reports?Well [mention://513 @dandiebolt_QB_Pirate] you definitely got our attention! It may break with the Mercury rollout, but there are lots of unconventional solutions on the Quickbase Community that will probably stop working in Mercury as well. And who knows when that'll be............................Re: Can I collapse a text field on reports?Okay guys I fixed the line splitting issue that [mention://537 @QuickBasePros_IDS] brought up. New code is here: http://pastie.org/10963821Re: Can I collapse a text field on reports?Yeah I noticed that too. It isn't too bad, but ideally would be better if it didn't split like that. Your last point is a good idea, I may fiddle with it to see if it works out.Re: Can I collapse a text field on reports?I figured it out with a lot of googling. Copy everything below and replace [Notes] with your field name. If([Notes]="", "",//If [Notes] is blank, display nothing If(Length([Notes])>300,//If [Notes] is greater than 300 characters var Text a = "<span id="Detail"'><pre style='font-family:"Helvetica","Tahoma","Arial","sans-serif"!important;font-size:100%!important;white-space:pre-wrap!important;'>"&Left([Notes],300)&"</pre></span>"; var Text b = "<span id="Detail"'><pre style='font-family:"Helvetica","Tahoma","Arial","sans-serif"!important;font-size:100%!important;white-space:pre-wrap!important;'>"&NotLeft([Notes],300)&"</pre></span>"; //"var Text a" shows the first 300 characters from [Notes] //"var Text b" shows the remaining text //The following script is the "more/less" function $a & " <a onclick=\"$(this).hide();$(this).next().show().next().show();\">Show more</a>" & " <span style='display:none'>" & $b & "</span>" & " <a style='display:none' onclick=\"$(this).hide();$(this).prev().hide().prev().show();\">Show less</a>", "<span id="Detail"'><pre style='font-family:"Helvetica","Tahoma","Arial","sans-serif"!important;font-size:100%!important;white-space:pre-wrap!important;'>"&[Notes]&"</pre></span>"))//If [Notes] is less than 300 characters, display [Notes]Re: Can I collapse a text field on reports?Improved version: http://pastie.org/10963821Re: How to identify each week for a pay period as week 1 and week 2?Fixed. The reference date should be the starting date of the period, which would be the 28th, not the 27th. If(LastDayOfPeriod([Week Ending], Weeks(2), Date(2016,2,28)) = LastDayOfWeek([Week Ending]),2,1) Thank you!Re: How to identify each week for a pay period as week 1 and week 2?The formula returns a "1" for each weekHow to identify each week for a pay period as week 1 and week 2? I have a time sheet application that I built that collects hours on a weekly basis for each employee. Our work week starts on Sunday and ends Saturday, but the pay period is bi-weekly, so there's two weeks for each period that go into our payroll system. Everything exports out of QBase perfectly except for the [BatchID] field, which needs to identify which week it is. Our weeks are identified by a 1 or 2. What I need is a formula that will look at a date field [Week Ending] and output either a "1" or "2" based on which week of the period we're in. We just implemented this so, if it helps, I can use the date 2-27-2016 as a starting point, as there will never be a time card date prior to that. Can anyone help? Re: Embedding a child report on Exact Form, and actually formatting it without using Juiced ""Exact Form Plus"" (I'm almost there)Keith, I understand the convenience and capability of EF+, but it's just in my nature to try to accomplish things on my own, sometimes just to see how close I can get. As of today I've answered my own question. I couldn't get the syntax correct for the query on method 2, so I stepped back and thought about method 1. Using method 1 I was able to properly set up the query to filter and organize exactly what i wanted to display, (which took care of the hard part in my opinion.) Then I had to figure out how to get the formatting correct, so I spent some time reading through stackexchange and W3Schools.com, and basically created my own CSS page with styling code that overrides the CSS page that gets generated by QBase for the embedded table, and after some tinkering I've actually pulled it off! I have an embedded report on my exact form, that actually matches the formatting on the rest of my form, and I did it all myself. Oh and here's a kicker, when I started this, I knew next to nothing about CSS and how it applies to HTML aside from simple in-line stuff. Now that being said, there is a risk to all of this: if the QBase developers change the way that the CSS or HTML gets generated for these embedded tables, there is a chance that my CSS overrides will stop working. Not the end of the world, but it would take time to try and fix it. So Keith, I might be interested in the Exact Forms Basic product. I'd like to see what the capabilities and limitations are compared to EF Plus, and get some more info about it. How can I contact you? -MattRe: Is it possible to hide the first column of a QuickBase report (which can show view/edit icons)? I have no view/edit options set up and want to remove the empty column.Dan, could I implement this on an exact form that contains a report?