Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About RavingLuhn

  • Rank

Profile Information

  • Location
    North Carolina

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10
  1. I have a report based on a join table. This report only contains sub-summary parts. The first summary part is grouped by 'employee name', and the second part is grouped by 'hour type'. This report displays on PC and prints just fine, but when I export the report to an Excel file it omits any subsequent appearances of the 'employee name' field. All the other fields are fine. Here's the layout view. Imp_EmpID, HourType, and s_Hours all come from the parent table. c_Name_Reversed and SubDeptartmentName come from child tables: Here's the report view from within FM (names redacted):
  2. At what point do you usually see performance degradation? I know it depends heavily on the specific design of a solution, but maybe there are some general guidelines you've observed in your experience?
  3. Is this because I intend to calculate or use summary fields on this table? For reference, we tend to average 60-70 employees a year which would result in about 25,000 records on this table for each year. I've been working on a sample file as a test and it seems to be pretty responsive.
  4. That probably wouldn't work, as I have layouts in this solution that require calculating daily discrepancies for all employees within a 14-day period. The basic layout is that a user clicks on an employee name in a portal from the employee table. This triggers a filter in a portal that displays records from the join table. The values shown here are the sum of hours from the time clock table as well as a sum of hours from the jobs table. A date is selected on this join portal to filter the jobs portal for that specific day. The user enters jobs and hours for that day until the discrepancy
  5. The shortest answer I can give is: it's quite complicated. This join table exists to merge data between: A table with worked hours; this table is populated from an import and updated at least once daily A table with manually entered job (or assignment) hours. I need the join table to more easily calculate discrepancies for a given date and employee between the two tables. There are other fields on this table that aren't relevant to the script. These are primarily summary fields used for calculations and reporting. Given some other limitations, it's probably the simples
  6. In my database I've got a table that functions as a join table. Due to the nature of the data, I've got to create the records here manually - or at least with a script. There needs to be a set of records for each employee that contains their ID number and all possible dates of a given year. The workflow happens like this: An administrator navigates to the layout They enter an employee id number and the desired year into respective global fields: GLOBAL_AddYear and GLOBAL_AddEmployee A button is pressed and then the script runs to create a year's worth of records for the sel
  7. Point taken on the minimal complete example. I'll reference that for future instances. I think this is where the biggest gap in communication is coming from: What I'm trying to display is the cumulative total up to the current week of that year. Here is the pertinent data from my parent table: 'PlantCount' is the weekly output. I have a summary field in this table to calculate the annual cumulative output each week. So week 2 is the sum of weeks 1 + 2. Week three is the sum of weeks 1 through 3, etc. My child table has detail records for hours per day: I
  8. Sorry. My experience in asking help from a community gravitates between two extremes. People either want all the details or none of them; trying to work on communicating more clearly. Trying again: How do I compare cumulative output from one table to cumulative output in a different table? The background: I have a database to track employee time spent on tasks per department, as well as metrics for different departments. This data resides in two different tables. My goal is to create a report that shows a weekly summary of total hours per department, whilst comparing those hours to the re
  9. To help illustrate what I'm trying to do, I've uploaded a demo file: https://drive.google.com/open?id=1-knf0y7rMgBFI8loBAX0RQW1EGvJ9TpM My report layout has no body parts, so that might be what makes this more difficult to accomplish. Here's a view of the layout: And here's what the report itself looks like: The field labeled 'c_Cumulative Plants from Trackingdata' is a calculation field that's pulling a value from a summary field in a related table. Placed on this layout, the calculation field only shows the weekly total instead of the running cumulative total. My a
  10. It's me again. This time my question is centered around how to reference a summary value from table A in a calculation in table B. The end goal is to calculate a running average of seconds per plant in the 'TrackingData' table by dividing time in seconds 's_Cumultaive Seconds' by 's_Cumulative PlantCount' from the 'Shipping Volume' table. After doing a bit of research I know that it's not possible to use the values of a summary field from table A in table B. So I made a field in 'TrackingData' to try and pull over the values from the 'Shipping Volume' table. That field do
  11. Wow, that's incredible! Thanks for sharing! I appreciate your willingness to help people learn. 🙂
  12. Either way, I still need to have two fields? One for the month number and one for the text value?
  13. Wait a minute; I misspoke. Originally I had a calculation field with the function 'MonthName' set to generate a numerical result. The report didn't function that way. Changing the calculation result to text solved the issue. Do you recommend I make another calculated field to return the first day of the month?
  14. It had been set as text, since the field returns the month name. However, changing it to a number makes the report sort by month; albeit in alphabetical order. Do you recommend I make another calculated field to return the first day of the month? I just thought it was odd that there was an option; I hadn't noticed the capability to sort by fields on a layout before.
  15. I've got another question about subsummary parts and how to ensure that they present data for reports as expected. My layout is based on the most atomic table for the data to be displayed, but I'm having some trouble getting sub-summaries to be grouped by month. What I expect to see is this: Year January Department List - numerical data February Department List - numerical data ..etc. for each month of the year What ends up happening is that my data is grouped by each year, then one
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.