How 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.19Views0likes1CommentMulti-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?21Views0likes0CommentsNew 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?23Views0likes3CommentsQuery 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.16Views0likes0CommentsSummary Reports
Y'all have been so helpful! I'm hoping I can figure this one out! I need to create a summary report thatshows these totals in an easy report. I can't seem to figure out how to only have current MTD or YTD, just group by Month or Year, which isn't what I need. I can create a KPI widget for everything, but is there a way to show the KPI numbers in a chart that can be exported for our company analyst group? I'm hoping there's a relatively easy way to do this! Thanks!Solved54Views0likes3CommentsMissing an option in Kanban Card Groups
In my table I have three fields that are Text (Multiple Choice): Type of Leave Semester of Leave Status of Leave When I try to create a Kanban Report, I only see two of the three fields under Card Groups > Based on drop-down field as options (Type and Semester, not Status). I'm lost as to how to get Status of Leave to be an option to choose in Card Groups. FYI: The actual choices displayed in these Text-Multiple Choice fields are different, but the three fields are otherwise have duplicate settings. What am I doing wrong and how can I fix it so I can have Status be the card group??Solved47Views0likes7CommentsMonthly Budget Vs Cost Tickets
I have tickets that can cost either $2 or $68 and I currently have over 4K tickets throughout the months of Jan 2024 - April 2024. I have $368K budget spread over a 21month duration. I need to show how much over or under for each month with respect to the budget.33Views0likes2CommentsLoan database - Interest period
Hi all I am creating an interest calculator report for our finance folks. I have a duration field to count the number of days between key dates for interest calculations but am running into 2 challenges: The number of days between dates comes back as duration (# of days) and not a numeric value. I need it as a numeric value to complete interest calculations. There are hundreds of loans and we need to be able to fill in the date interest is applied for all of them at once for the calculation. Ideas or is grid edit the best option? Thanks! JesseSolved28Views0likes3CommentsCalendar Reports not Loading
Suddenly no Calendar reports will load in new forms. Anyone else seeing this? I've been dealing with this issue for most of the day today. I'm hoping it's resolved before I have to switch everything back to the old forms. They either show the spinning loading animation, or it just freezes and never loads like in the attached screenshot. They still seem to be working in the old forms though.Solved49Views0likes5Comments