portal calculation time entry

[RT]

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

[Fitch]

Maybe this will help.

[RT]

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.

[Fitch]

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

[RT]

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