I have a timesheet in an external table that is accessed in a portal in a jobs table. The times come in 3 flavors.

I need a script that will show a total for each flavor for each job. It needs to appear in the jobs portal as well as in another spot on the jobs layout.

Please contact me if interested.

Thanks

[email protected]

Sounds more like a calculation need, rather than a script solution.

Given a field in your Timesheets (Expenses?) table for type (flavor), just create a filtered relationship from Job to Timesheet for each of the types. Then, a calc that sums the expense for each type, using the appropriate filtered relationship from Job to TS.

Or, create a sub-summary report based on Timesheets, by Job, by type.

I'm pretty sure I'm not trained enough to do it. I've tried filtered portals, calculations, scripts, custom functions, bought a $300 training series, have posted for help on the forums...

and I haven't gotten close.

You want the job? I'll pay.

Or, create 3 calculated fields in your timesheet, one for each flavor, e.g.:

Case( flavor = "vanilla" ; time )

Then in the jobs table make your total calcs based on these fields, e.g.:

Sum( related::vanillaTime )

That'll be $1000 please. B)

Whoowee!

I knew it had to be something simple. I was hunting for an elephant and found a flea. I had tried using case but just didn't have the related part right.

Thank You!

Do you accept gold?