I have a timesheet that shows a summary for the total time spent on each job using the Related Records function. A job might have 50 time entries and the time for each is working nicely plus a summary field of total time for each job is working fine.

All times for all jobs are in a single table. A summary field shows the total for all times spent for all jobs. Just as it should.

The times come in 3 types currently designated by a letter in a text field. In case it matters the designations encode Quoted, Unquoted and Non-Chargeable times.

How can I show the total time filtered for each of the 3 types for each Related Record?

I've been hacking at this for a week and don't know the approach and don't know where to look it up. It seems so simple, yet...

I also have employees which I haven't attempted to filter yet.

I would appreciate some guidance on learning how to create my own solution.

Edited October 22, 200817 yr by Guest

It's a matter of the stacking in the sort order def... take a look at the stacking I use "make summary script" in the attached template...

who

theMonth

theType

The summary layout straight from the wizzard have then been deprived the bodypart...

--sd

Worksheet.zip

I've been trying to accomplish something similar. What I'm actually trying to accomplish is to show the 3 time_type summaries in a portal. One portal is related by Job, another portal is related by Employee.

Your solution was locked so I couldn't see the script or the database. I don't know how to do the "stack order" for multi-criteria results. A search for "stack order" only talks about layering fields on top of each other in a layout. So I'm still clueless!

I have Osborne's training series and this isn't covered. I've been unable to locate it in the FMP docs. I probably don't know what to look for.

So, I can filter for all Related Records or I can filter for all Time_Types but I have been unable to filter for both at the same time.

If you wouldn't mind expounding a bit on "stack order" maybe I could figure the rest of it on my own.

Edited October 22, 200817 yr by Guest

What I'm actually trying to accomplish is to show the 3 time_type summaries in a portal.

Well thats not Summaries in the strictest sense, but instead a pretty rendering heavy exercise....

Take a look at this template:

http://fmforums.com/forum/showpost.php?post/266487/

Your solution was locked so I couldn't see the script or the database.

No, it should be open I've just checked it! It must be something to do with the media you download the solution to, or a hiccup in the unzipping causing this?

The scripting could studied in the image above look where it says "Specified Sort Order"

--sd

That's quite helpful. Thanks!

Maybe my viewing problem was I have FMP 8 Advanced, huh?

I'm little confused here, only conditional formatting would be a fm9'ish feature - is it really enough to lock up the access to the file??

But to be on the safe side have made a new version, with oldfashion conditional formatting using merge fields underneath to give the change of color to indicate the weekends and which person we choose to enter data for.

--sd

Worksheet8.zip

Since you're leaning up against a spreadsheet metaphor instead of a database ditto, could inspiration be found in this thread:

http://www.fmforums.com/forum/showtopic.php?tid/198882/post/306822/fromactivity/posts/#306822

...although it requires you get an "Advanced" version of filemaker to make custom functions.

--sd

Thank you very much!

I have 8 Advanced.

I am learning and am about halfway through Osborne's series. I had to stop and am spending a lot of time on what he calls "join tables" and "filtered portals". He shows how to build one but doesn't explain what he's doing. No matter, I'm using trial and error with some extra reading to get a handle on them. They look like a critical element in what I need to do.

I haven't gotten to the advanced scripting lessons yet so I'm still primitive in this area.