Average daily active employees calculation
Howdy y'all. We use Quickbase for an HRIS. Within the HRIS, there's an employees table that contains fields for the hire date, termination date, and status. An example employee could have a hire date of 08/01/2020, a termination date of 08/01/2023, and a status of 'Inactive'. I've been asked by HR to calculate turnover. The formula they provided requires me to first calculateaverage daily active employees for a given time frame. The way I see it, if I just had that one example employee, that report would look something like this: Date # of active employees 07/30/2023 1 07/31/2023 1 08/01/2023 0 08/01/2023 0 Average daily active employees report would look at each date and count the number of employees whose hire date was on or before that date, and their termination date is on or after that date or null, and their status on that date was active. In this example, the average daily active employees for the given time frame is 0.5 (2 divided by 4). I would then need to create a summary report based on that report? And the summary would divide the number of employees who left during that time frame by the average daily active employees during that time frame. That's the formula I've been given by HR. I do actually have a question...how can I create that table above? The way I'm thinking through it, I'll need a table that contains every possible date so that the user input for a start and end date can be set and used in the calculation. But to my knowledge, Quickbase doesn't have an obvious way to do this. Thoughts?Solved16Views0likes2CommentsKeep Trailing Zeros on CSV Export
When i download a report as a csv, if there is a number field it will dissappear the trailing zeros. So for example: 5000.10 downloads in the csv as 5000.1. This seems to be due to the fact that it marks the column as type 'General' in Excel. When a column is that type, it deletes trailing zeros. I have found that if I make it a currency in Quickbase, or text (include alpha), the csv will select type text or currency (currency keeps the trailing 0, but of course has the dollar sign - this may be a work around, I haven't tried). If the excel type is selected as 'number' it also keeps the trailing zero, but I cannot figure out anyway for the csv export to label numbers, as numbers (they get labeled as general). Has anyone figured out a trick to download a csv, and keep trailing zeros?3Views0likes0CommentsSpecifying the Report Used in Reminder Notification
I have a "Reminder" notification setup to trigger when a date field is after the value by a certain amount of days. Is there a way to specify the report to use when sending this email? Right now it is using the "Default Report", but I would like to change to a different report if possible. Thanks Brian56Views0likes5CommentsSort & Group separate from UI
Hi, There are a lot of instances where we need the users to be able to sort and group their reports, but we can't leave the report open for editing. I've opened a ticket to see if Quickbase can separate out the Sort & Group feature from the User Interface settings. If you're interested in this too - go "request actions" and subscribe to the ticket Sort & Group #409577 - this is a link to the feedback: Request | Feedback (quickbase.com)8Views1like0CommentsShow unique parent records for current user
Looking for a way to show a summary type list of items. In my application I have a Projects table and a Time Entries table. Projects can have many Time Entries. I also have a Team Members table. A Team Member can have multiple Time Entries. I'm trying to create a summary type report which would show the Current User a list of all Projects to which they have logged any time. I do not want to view each of the individual time entries, but just a list (non-repeating) of the project name. Example: Time Entries (table) Team Member Date Project Bob Smith 7/1/2024 Project A Bob Smith 7/2/2024 Project A Bob Smith 7/1/2024 Project B Bob Smith 7/2/2024 Project B Sally Jones 7/1/2024 Project A Report would then Display: Bob Smith Project A Project B Sally Jones Project ASolved48Views0likes8CommentsEmbedded Reports New Form
Hello, I currently use the new forms in QB, and I love the functionality to be able to easily add a record in that pop-up view when using an embedded report from another table. However, there is a limitation to this functionality of the parent record is not saved yet "adding a record". Is there a way I can let users add records to another table in an embedded report without the parent record being saved first? Or is there a way to trigger the save so that functionality can happen?25Views0likes1CommentHow to split an Export file which is too big
I need to export port a file which has over 400 fields and years of data. When I try to export I get the following error. is there a way to split the data into chunks? I still need all the data, and would like to split in yearly chunks. Is there a simple way to do this? I am a total novice at this.Solved42Views0likes1CommentMulti-level group/sort not showing subtotals
I have a report that displays time entries. The report is first grouped/sorted by Customer Name, then grouped/sorted by Project Name. After the end of each Project certain fields are totaled, however, if a Customer has multiple projects, there isn't a similar row of "totals" for the Customer. Example: Customer A Project A Entry 1 Cost $100 Entry 2 Cost $200 Tot Cost $300 Customer B Project B Entry 3 Cost $500 Entry 4 Cost $200 Tot Cost $700 Project C Entry 5 Cost $300 Entry 6 Cost $500 Tot Cost $800 Tot Cost $15,000 (this is the line that is missing) Customer C Project D Entry 7 Cost $400 Entry 8 Cost $300 Tot Cost $700 Is there a property or feature I'm missing that would not only show the "total" line after each Project but also after each Customer?24Views0likes0CommentsNew Version Form Not Showing as an Option for Data Form On Notification Setup Page
I have a notification created and below the designer area of that email there is the "Data Form" field. The dropdown displays other forms in my table, but not a New Version Form. How do I get my new version form to display?35Views0likes3CommentsQuery multiple tables
Here is a high-level overview of my tables along with the related fields: Schools (school name, etc.) Class Types (school name, class name, age range, etc.) Available Seats (school name, class name, start date, cost, etc.) Then I have: Parents (parent name, etc.) Children (parent name, child name, child age, etc.) For each parent, I would like for them to be able to select each of their children, enter some search parameters (date, time, etc.) and only see the available seats for that particular child based on those user-selected filters. Once they select one of the rendered results, I would like for them to be able to book that seat, move to the next child, and then have a total cost of all seats selected. I hope this makes sense.19Views0likes0Comments