ContributionsMost RecentMost LikesSolutionsTab Behavior in Forms I have a long data entry form and switched two Sections to Tabs in the middle of the form. When the first Tab is selected, the remainder of the form below it disappears, but when I click on the second (adjacent) Tab, the remainder of the form below it reappears. Any ideas as to why it's behaving this way? I do not have to use Tabs (Sections work fine), but they help with the form optics. Thanks. ------------------------------ Keith Hendrick ------------------------------ Re: Reminder Notification for Upcoming BirthdaysThanks, Ryan. ------------------------------ Keith Hendrick ------------------------------ Re: Reminder Notification for Upcoming BirthdaysWorked perfectly. Thanks! ------------------------------ Keith Hendrick ------------------------------ Reminder Notification for Upcoming BirthdaysWe want to know when an employee's birthday is upcoming. We capture their DOB in a date field, so how do I get that month/day information in a format that I can use in a Reminder notification? ------------------------------ Keith Hendrick ------------------------------ Frameless WindowI have the following Rich Text button on a form: var text URL= "https://dredgitenvironmental.quickbase.com/db/bskxipxmt?a=q&qid=27\n\n&ifv=1"; "<a class='Vibrant Success OpenAsPopup' style='border:1px solid #000000; background-color:#000000' data-height=500 data-width=800 data-refresh=true href=\"" & $url & "\" > Select Employee </a>" It pops a window that prompts the user to enter (any portion of) an employee's name (Good Window #1). This frame/window has minimal information and is unobtrusive. Unfortunately, when a user enters text it pulls back a report (#27) that has all of the browser header information. It makes for a visual mess and is distracting (Bad Window #2). Can I strip the header information out of Bad Window #2, so it looks more like Good Window #1? If so, how? Thanks in advance. ------------------------------ Keith Hendrick ------------------------------ Automatically Calculating an End DateWe have ~80 Employees and need to keep a historical record of what jobs they have worked on. Crew assignments are made by entering a new record when an employee changes jobs so the only data entry per se is a new "Job" and new "Assignment Start Date." When a new assignment date is entered the old job assignment is complete, so I need to calculate the duration and end date (which is new assignment date, less one day) for the previous assignment record. I figured out a way to tag the most recent entry and after testing, it seems to be working as required. Now what I need to figure out is how to calculate the end date and elapsed days an employee was assigned to a particular job. ------------------------------ Keith Hendrick ------------------------------ Cumulative Expected Billings to Calculate Future Bonding Obligations When we invoice a client, it reduces our outstanding bond obligation and increases our bond availability. We project invoices for several months (by day) and always know our current outstanding bond amount. I would like a graph/chart that displays our bond obligation into the future based on our invoicing forecast, by day or week, or by date select. This would be easy to do in Excel (see attached), but ideally, I'd like to do it in QBase. Basically, it is [Bond Obligation] – (cumulative) [Expected Billings] at any given date. The problem, of course, is getting the cumulative Expected Billings "at any given date." Can anything be done in QBase? Alternately, could it be done in MS Power BI, and how difficult would it be? Thanks in advance for any feedback. ------------------------------ Keith Hendrick ------------------------------ Re: Dashboard Limitations on Cross App ReportsYes, that works. Thanks! The new Dashboards are pretty slick and we're looking forward to seeing how QB develops the technology. ------------------------------ Keith Hendrick ------------------------------ Dashboard Limitations on Cross App ReportsIs the new Dashboard currently limited to only Table Reports for cross-app inclusion? If so, any idea as to when this will be fixed so that other report types from other applications can be included? ------------------------------ Keith Hendrick ------------------------------ Re: Most Recent RecordUnfortunately, I don't have the screen real estate for a 4-tile report. I wish this new dashboard was a big longer, but I suppose that's where the tabs com in. Anyway, it's okay since this was a 'nice to have' feature anyway. The bigger issue was the auto selection of the most recent accounting date and you solved that. Thanks again. ------------------------------ Keith Hendrick ------------------------------