MatthewMatthew1
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: 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............................0Views0likes0CommentsRe: 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]0Views0likes0CommentsRe: 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!0Views0likes0CommentsHow 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? -Matt0Views0likes2Comments