Hi everyone.

 

So  9 years ago i started using filemaker. i started by using the attached file as a base as i knew nothing. Over time i have changed it quite a bit but still have a problem i need fixing.

 

1. On the jobs layout i would like it to show how many times an employee has worked on that job (In the portal).

i have managed to sum up how may time entries (total) and how many employees (total) that worked.

 

i have tried calculations and summary but still cannot get it right.

 

thanks

 

Rob.

Job Time Tracker FM Forums.fmp12 2.zip

Maybe this will help.

Fitch thanks for the link, the solution looks simple but trying to make this work in my solution has been a no go for me i just cannot get it to work  something that looks so simple has got me feeling so frustrated.

I modified your file according to the instructions in the article. Be sure to notice the relationship setup; the TO of the fields in the portal; and the sort and filter options of the portal.

Job Time Tracker Copy.zip

Thank you so much for your time, i have updated my master file all working great  you have saved me a lot of eye ache looking through many line items to see who worked.also learnt a bit aswell