DanMarks Posted October 30, 2011 Posted October 30, 2011 Hey Guys, I think i know the answer to this already, but if it is no, just wondered if you had any alternatives. Basically my clients want to convert the excel sheet they have into a layout on filemaker, or an export to excel. It is an availability sheet for staff. So there is a table called availability, which has a row per date per member of staff. The staff is referenced by another table via an id. Each date has three shifts the staff can select as available and not available. The report the client wants produced, is to have staff names down the sides (row per staff) and have the next 7 days across the top broken down into the three shifts. So top would read Mon Shift 1, Mon Shift 2, Mon Shift 3 etc. They need to have it across like this so they can see if someone is available to do a week shift for example. I cannot seem to find away in manipulating the data for it to appear in this way. Wondered if any of you guys could help? Thanks in advance! Cheers, Dan
comment Posted October 30, 2011 Posted October 30, 2011 I cannot seem to find away in manipulating the data for it to appear in this way. You could use 7 one-row portals to the Availability table, placed on a list layout of Staff. Filter each portal to show only records from the corresponding date.
DanMarks Posted October 30, 2011 Author Posted October 30, 2011 Thanks, works a treat! It's always something so simple!
Recommended Posts
This topic is 4790 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