Newbies Jamespatricksmith Posted November 3, 2016 Newbies Share Posted November 3, 2016 Hello, Any help with this would be greatly appreciated as I am confusing myself! Basically we have a spreadsheet that keeps peoples hours on certain job numbers. I have 2 tables in filemaker one for jobs and one for hours. I want to import the hours from my spreadsheet into the hours table and have a portal on the Jobs table so that you can view who has done what hours on any particular job. I have created a relationship between job number on hours and job number on jobs. This is all working well. We update the hours on the spreadsheet weekly and when I import the records I choose "update existing records in the found set" which gives me a running total, so far so good. The issue I have is that we have a new spreadsheet for each month but jobs obviously can run over several months. So if a person has a hundred hours showing in the portal as it goes to the next month he might have five hours and when I import it then shows just the five hours. I think the best way would be to, every week that we import the records, adds them as a new line so that effectively you will have 1/10/16 John 15 hrs, 7/10/16 John 7 hrs etc. Then I would need to summarise these hours. Does anyone know of a good way to do this or even if there is a different approach? Hopefully this makes sense. Thanks James Link to comment Share on other sites More sharing options...
Newbies Jamespatricksmith Posted November 4, 2016 Author Newbies Share Posted November 4, 2016 Hello, I don't think my description of my problem was very good but I am progressing with it. I now think the simplest thing to do is import the data each week and use the add records function. This will give me a record for each person and what hours they have done on which job. I have related the hours table to the jobs table by job number and have a portal on the jobs layout to show all the hours each person has done on that job which is working. The problem I have is that it is listing the persons name multiple times in the portal. Ideally I need the persons name once and their total hours next to it. I have been playing around with sub summaries which I can get to work but not in the portal. Is this possible? Is there another approach I could try? Any help would be greatly appreciated. Thanks James Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2701 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now