aapl

I need a simple script to open Mac Mail, insert an email address into the 'To:' from a field, and select an option from the stationary. This way I will be able to automate sending my custom HTML stationary. Hopefully someone can help me with this. Many thanks.

That's great, just tried this and it works perfectly. Out of interest when I have a calc to name a pdf when running a script to save as pdf I want to display the 4 week period number. I currently have (((WeekOfYearFiscal (DateField))+3) / 4) which displays 5.25 or 9.25 or 13.25 etc ...instead of the 2, 3, and 4 I am looking for. Why is this? what have I done wrong?

Could you please explain what 'not mod' and 'div' actually do here? ...and I would like it to restart each year.

I cannot get a calculation to work. I would like to run a certain report every 4 weeks. So for example if the week number of the current date is 4 or 8 or 12 etc. Needs to be ISO calc to work in the uk so 'WeekOfYearFiscal' How do I do this?

Solved this now. Thanks you your input guys, much appreciated!

I understand what you are saying about best practice with the employees names. Each employee, as does each of our clients, has a unique profile ID. I thought explaining it as 'staff' members would make it easier for people to understand what I am trying to do. Hopefully I can explain to you what I am trying to achieve. I have a 'services' table which contains all of the services our clients purchase. I have a script set up already allowing me to input 2 dates, a start date and an end date of records I want to report and a field for the employees name. At the end of each week I manually put the dates in for the week just gone, and the employees name and generate the report. I do this for every employee who worked that week. I would like this to be automated for me, I am currently able to have a found set of employees narrowed down displaying only those who worked in whichever week, but in a different table. In the 'clocked hours' table. I now just need a script which will copy and paste from that found set into the 'employee' field for me to generate a report for each employee who worked. Can this be done?

The employee names will always be unique as the database is for a hair salon, and we would never have 2 employees with the same name working at once. We would alway change someone's name. May sound odd but common practice in hairdressing. I now have a working calculation which says whether the employee worked or not during the specified week. The next one im stuck on is a script to copy a field from the first record of a found set, paste into a different layout, then go back to the set, copy the second record and paste into different layout... And know when to stop when it gets to the last record.

Ok so I have managed to fix it work work as I said above. My next question is how can I set up a script to copy and paste field values from a found set to another layout. I have my found set with 4 employees in for example. I need a script to copy the employees name, go to report layout, paste into report layout and run report. BUT then go back to the found set and do the same for the second record, then the third, and to know when to end when it gets to the last record in the found set, i.e. number four. Is there a way to loop or repeat based on the number of found records and then exit script? Has anyone got an idea of the best way of doing this? Again hopefully what I am trying to do makes sense, Many thanks.

You are right this has gotten me thinking. I have a staff profile table and a clocked hours table. The staff profile table has just one record for each employee. If I link them with a relationship saying names are equal, within a specified date and did they 'work' I could have a calculation field to tell me if they worked or not. Hopefully this will work, I will give it a try and see! Thank you for your help so far guys.

I need to use another table because the reports are generated from a service table, but I need to work out go worked from the clocked hours table.

The dates are real dates yes just gave week days as an example... Maybe I was unclear, I have two different layouts from two different tables. I need to narrow down a found set to find only one instance of each employee who worked during the week. Then from that found set copy and paste each one into the other layout to generate the report. It is the narrowing down to just one unique instance I am stuck on. I can search between a range of dates to find clocked hours for one week. i can constrain the found set to show only 'worked' records for that week. But I am left with multiple records of employees. i.e. if john works 5 days a week and sally 2 days a week I end up with 7 records. I want to be left with just 2 records, just unique employee names, no duplicates. Then I can copy and paste them into my other layout to generate the report. Hopefully this explains my problem more clearly. Many thanks.

I am using FM Pro 11. I currently have a layout where I can manually put in a "start date" and an "end date", the team members "name", and press 'run report' - the report then pops up. I am trying to put together a script to automate this process further so it will automatically run reports at the end of each working week for each team member who worked at some point during that week. I have a table containing records with staff clocked hours. Records have staff fields "name", "date", and a field saying what they did that day, either 'worked', 'sick', 'holiday' etc. If I search for one week of records I would get something like the following: 'Monday' 'Luke' 'Worked' 'Monday' 'John' 'Worked' 'Tuesday' 'Luke' 'Worked' 'Tuesday' 'John' 'Worked' 'Tuesday' 'Sally' 'Worked' 'Wednesday' 'Luke' 'Worked' 'Wednesday' 'John' 'Sick' 'Friday' 'Luke' 'Worked' 'Friday' 'Sally' 'Worked' So basically I need my script to search for a set of 'one weeks worth' of staff clocked hours, narrow that by only records for people who 'worked', and then narrow to show only unique staff. That way I am hoping i will be able to have another script copy and paste each unique name to my original layout and run reports. Based on the above example my found set would have been whittled down to display just 3 records, 'Luke, 'John' and 'Sally' because in a nut shell that is who 'worked' at some point during that week. Hopefully what I am trying to achieve has made sense to you, and hopefully someone can help me out here. Many thanks.

Many thanks, This works perfectly!

The problem is I am looking to find a range of dates. When I search for: >=01/01/2011 <=16/01/2011 I get a range of dates. When I search for >=01/01/* <=16/01/* I get an invalid message. Is there a work around here? Many thanks

My intention is to be able to search for peoples birthdays between two sets of dates. For example between the dates "Greater than 01/01/NA" to "less than 15/01/NA". How can I search through dates for the day and month, It doesn't matter what the year is. I am looking for a way to have a script which performs a find in the BirthDate field to find the results. Hopefully someone can help me here. Many thanks.

Thank you! This works perfectly. If you have time would you mind explaining to me what it actually means in non calculation terms? Many thanks.

Hi guys I have a problem which I am sure is easy to solve when you know how! I have three Date Fields named: LastAppointment, RebookedSince, and Cancelled My calculation field needs to display the name of the field with the greatest date in. So for example if (dates displayed DD/MM/YYYY): LastAppointment = 01/01/2011 RebookedSince = 02/01/2011 Cancelled = 03/01/2010 My calculation field would need to display "Cancelled" as that is the field with the greatest date. It also needs to ignore any empty fields Hopefully someone can head me in the right direction here, Many thanks!

Hey guys. Hopefully someone can help me out here... I am looking for a way to have my records sorted by default. I can press the sort button but when I go to a different layout and go back again they go back to the way they were before. How do I get my records to stay sorted by default automatically. Many thanks!

I have currently worked it to have a script go to the first portal row, and copy and paste it into a separate text field. I would prefer though to have a calculation to do this automatically. As for if there is a tie I had not considered this. For the purpose of what I am using it for I am only wanting a good idea of how many active clients each staff member is servicing so I am not too worried.

Yes thats right, so I can easily search for Luke, Ben & Johns clients.

I have done this and it works perfectly. Thank you! The only thing is I need a way to search just the first row of the portal. What is the best way to do this? Can I set it for only the first field in the portal to be searchable? Or is there a way for a normal field to get the contents of the first record in the portal?

I'm still a little confused. Just to check is this the best way to find this. For example say I have 1 Client in my table and have 5 related service records - MembersOfStaff being "Luke" x 3, "John" x 1 and "Ben" x 1 on these service records. I need the field for MemberOfStaff in my Client table to say "Luke"

Hi Guys, Hopefully someone can help me out here. I am looking for a way to get a field to display the most frequent value of a field in another table which is related to it. I have a Client table which contains ClientName, ClientID, and MemberOfStaff fields. A Service Table which contains ServiceName, ClientID, and MemberOfStaff. Looking for a way for a field MemberOfStaff in the Client table to display the most frequent value in the MemberOfStaff field in the Service table when records are related by equal ClientID's. Can't figure out how to do this, hopefully someone can help!

I am looking for a way to schedule appointments and view them graphically, for example something like this: How is something like this set up? Are these grids Portals? Any feedback or suggestions would be great, thank you.

I did think of creating as many records as slots so i could use a portal to display empty and schedualed records but then im faced with the problem of sometimes having 2 records for one time slot because i don't want to have to search for the created record to edit it i just want to create a new one. Also the records for appointments wont just have one time, they'll have a start and an end which complicates things further, at the moment i think i'll just have to use method 2 - create a relationship for each time slot. Has anybody got more info on how I'd do this? thanks