Best way to summarize tasks in a portal
So I have a plethora of tables that I need to placed into a PDF. This PDF will be pulling fields from various table but I'm looking for a way to dynamically show tasks. For example, in one of my table I have the following:
__kpTaskID _kf_EmployeeID Task
1 1 Cook
2 1 Paint
3 3 Clean
4 3 Play COD
5 3 Debug FM
For the output, I'd want all the tasks for Employee 1 to take up only 2 lines where Employee 3 would take up 3. Is there a way to do this within a calculation field?
Your example shows what you request. It has 5 lines, 2 for Employee #1 and 3 for Employee #2. I think you need to provid more detail.
And the best solution will depend on the database version. A filtered portal requires a Filemaker 11 or newer. ExecuteSQL requires Filemaer 12.