Sebastien Bergeron

Hi, thanks for your response. That didn't work. i can see the file in the container, but it won't open it for some reason. Here the error message:

Hi, I use to go in "Button Setup" select the "Open URL" option, specify the URL using a calculation where I put a field name. In that field name there was a "file path" store. Something like this file:///Volumes/Blabla/blabla/blabla/mymovie.mov In OS X 10.4, I believe, it use to, I soon as I click on the "button" it would open the file in Quicktime right away. Wich was perfect for my needs. Now, in Snow Leopard, it doesn't do anything anymore. Unless I don't put the actual file name (mymovie.mov) in wich case it bring me right away to the right location, then I need to manually double-click on the file. If there multiple files in the folder, it's not really handy. P.S: Same thing in mail, if I send a internal link of a movie to someone at the office, if you click on the link it does nothing. If you right click and select Open Link it will bring the finder on the right file but won't open it for you. Kind of annoying . . . Anyway, if someone know a easy trick for filemaker to open the QT it would be great. I have try the Send Event option but I have fail to make it work using a calculation field to "read" the path of the file. Thx Seb

Hi, Because, I want to have a visual reference of what have been done or not. Checkbox give me that. I found a way to do it: There is an option call Set Script Triggers while using a Checkbox. It worked perfectly for me. Thanks for your idea.

Hi everyone. I have a script already written that work well that send an email to a bunch of people. Now I need that script to be trigger by a Checkbox. If they click on The X on the Checkbox the Script for emailing is being run . . . How can I do That ?

It worked like a charm ! Thanks a lot for your kind help. Now I am not sure to understand what you mean by "have the emails in a separate table if you have multiple fields for them." Each individual email address in a separate table ?

Hi, I Am trying to use the "Send email" scripting function. Now let's say I am on a record that contains multiples fields that store email addresses. I want to be able to specify more then one fields in To: mytable::staffemail1 ? How can I do that without using CC: mytable::staffemail2. You know just the way you do it when typing regular email adresses eg: joe@joe.com, bo@bo.com, luke@luke.com ect . . . . but using multiple field contain ?

The field Option1 or Option2 would be to define if the employee gets 10 days per year of vacation or 15 days from day one of their start date . In some cases, some senior employee come in with their accumulated benefit from other job ! :(

The formula seem to work great ! Thanks a lot again for your kind help. In my original one I was counting the months separately, but I don't think it make much difference . . . I don't get your observation about the idea that employee that start working in February accumulate their vacation earlier than in January. Are you saying that because it's now Month based instead of yearly based ? Also I would like to add a field that trigger the calculation to be done at 10 days for the first 4 years like in your formula (that would be the (option 1) or straight at 15 days per year (option 2) What do you recommend ?

Thanks a lot ! It does look like it's working great for years, I need to add the month calculation after. Which is the same rule but applied to months while taking in consideration the amount of years. So (10/12) for each month or (15/12) for each month after 4 years.

Here you go I have a calculation that give me the "Period of employment" of each staff member using the current date and their respective start date. The result is displayed like this : 1 Year , 3 Months , 10 Days. Now, I want to calculate their " Accumulated Vacation during their POE". The thing is . . . for the first 4 years, they get 10 Vacation days per year. After 5 years they get 15 days of vacation per year. What do I have to add so my formula calculate the first 4 years @ 10 days per years and then 15 days per year for the subsequent ? Also, I want my formula to add the Vacation days every months. . . Here what I got so far: GetAsNumber(Year(Current_Date) - Year(Start_Date) - Case(Current_Date < Date(Month(Start_Date); Day(Start_Date); Year(Current_Date)); 1; 0))*10 + GetAsNumber(Mod(Month(Current_Date) - Month(Start_Date) + 12 - Case(Day(Current_Date) < Day(Start_Date); 1; 0); 12))* (10/12)

Let's clarify. I left some info out in my original question. The field that use a pop-up menu that display my "value list" is named Worker1 and this is part of a table call "Work_order". The "value list" made of FullName & Email is from another table call "staff". So the field Worker1 is use in a Layout inside "work_order" that display the values from the table "staff". This is all from the same database file. So My relationship should be from where to what ?

I have relationship.

Thanks Daniele, It does sounds like great idea ! To solve your problem there are many ways, the simplest is to place in that layout the full name field. How would I do that without having to manually enter each time the name of the person associate with their email ?

Hi, I have created a "Values list" that display values from 2 fields. first field : Email second field: Full Name Then selected "Show values only from second field". Now, I have created a field that used a Pop-up Menu to display that "Values list". It work great, it list the Full Name but still seem to store the email address of that person. That way when I press my email button it use the email address of that person . This is what I want. My only problem and it's a very inconvenient one, I can't search that field using the full name as criteria. Even thought the pop-up menu only display the full name. What can I do ?

Hi Everyone, I have a DB with 2 Tables. One is the staff list. Each record his a person with contact information fields: Name, email , phone etc . . . The other one is base on (Job) that we are working on. Each record is a job. The fields are mostly to describe the job ; duration, location, description, status, etc. Also I have few fields about who are assigned to work on it and what task they have to do. These fields are "Drop-Down List" that uses the values of the other database ( the staff one).So a list of all the people appear to chose from so i can i assign them to the job. Here the question: I want to add a "button" that would lunch a script that would send an email to all the people that have been assigned to work on that job. So basically the script would get the name of each field that have a name on it and would "retrieve" their email using the email field for the same record from the "staff" DB. Can someone help me ?

I want to be able to make a search on a bunch of records and then see automatically the number of record at the buttom. That it's Easy. I got it working. Now, on those records, I have a "Status" field which contain a value list: Done, Final, Temp. I want to be able to have an automatic count of each "Status value" in my footer , So I would see after each searh this: Total of record 25. Total of "Done" 10. Total of "Final" 10. Total of "Temp" 5. How can I do That ?

Hi, I want to get a portal within a portal. I have 3 Tables: Hardware , Software, Upgrade_Software. In the Software Layout there is a portal where all the Upgrade_Software appear for a specific (assigned) Software. Now, all the softwares are being assigned to a specific Hardware. Again in the Hardware Layout , I have a portal that show All the softwares being install on a specific Hardware. So Now, I am putting a portal of the Upgrade_Software within the software portal. At the beginning it seems to be working ! You could see the rows for each software. And the Upgrades for the first software. But what happen is that you see every software in the portal, but all the Upgrade_Software go straight into the first software(row) of the Upgrade_Software portal. So, The Upgrade_Software portal is linking correctly in the Software Layout, but not anymore in the Software portal under the hardware Layout. How can I fix this ? thx

Thanks Fenton, it is working great now !!

no idea Fenton ?

Hi Fenton, There is something that I'm obviously not getting. So I am sending you back your file with my modifications. Let me know what you think. thx seb modifs.zip

Hi Fenton, Thanks for your answer. No, I was thinking of exporting records. (each one of them individually ) as .PDF, in a defined location (like your desktop) each .pdf would be named after a field of the record they came from.

Thanks guys they are all good solution. I think option 2 will be the best for me. Is it possible to get the script to name the .pdf the same as one of my field ? thx seb

Hi All, Here the situation: I have a Layout "pretty graphic" with real world mesurement (pixel - 1920 X 1080) that I would like to export as an image to load up in another application. So, each record, under this layout, would become an image. It need to be in a format like TGA or TIFF or PSD or PNG etc . . . Please tell me it's possible . . . . thx Sebastien

it's working, How come ? Should I always make modifications to a file locally ? And them put it back on the server? P.S = Are you really 17 ? Not that it is my bussiness, I'm just impress.

Hi, I need to change the color of a field (City) base on another field (Country) that contain a value list. EX: My value list is different country; USA , Canada, UK , France , etc. This Way, if I set the country field to USA the city field become Blue. or is I set it to France the city field would become green. Not the text, the actual color of the field . Right now, I am using multiple container field with global storage to get color from a picture wich is a solid color. Then in a calculation field (color_city) resulting in a container, I determine wich color will be use. It work pretty good, except that every time I open the file I need to restore the global field that contain the color. Is their a better way to do this ? or is their a way to make the global field permanent storage ?