kaaltje

Hi, When I perform searches, I end up with a list with contact info of people that match my search criteria. I have created a button script, so I can e-mail them just by clicking the button next to their e-mailaddress (opening a new message to the recipient in Outlook Express). What I would very much like is to be able to mail all of the people on this list at once. I would like their addresses to be in the BCC-field, and my own e-mailaddress in the TO-field. Is this somehow possible? What kind of script should I use? Thanks! Cindy

Thanks very much, it's working now!!

It's very stupid but I cannot the "omit record/request" line. I have a Dutch version of Filemaker 4. Do you know if this version might not have the possibility?

But then it will show the records that are inactive. What I want is a selection of the records that answer to my first criteria and which are active. So I need to leave OUT the inactive ones. Because I only want to fill in something about a status when they are inactive I want to do it this way by searching for inactives and leaving them out of the search result.

I just added a new post about leaving out certain records by a script. I wanted to ask you, but I put it in a new post because this one will get so long and you might be fed up with my questions;-) Thanks again!

Is it possible to write a script to leave records out based on certain criteria? In this case, I have records of people, but some have the status INACTIVE. I already have a working script to search for certain records and have them displayed in a new layout (thanks to Quintech, Jerry) but now I want to add something to this script so that the inactive people are left out in the search results.

WOW!! It works!! Thanks, you're the best!! :-) It was just a simple simple mistake, it did it the way you described it and now it works! Thanks a lot!!!!

Ok, I'll try to make things easier by looking for something else. Let's start all over againg. I have 2 layouts: - Layout A, with contact information, e.g. NAME, ADDRESS, CITY and PHONE NUMBER - Layout B, with the same contact information fields as in Layout A, but also with other fields about certain details, e.g. HAIR COLOUR, HAIR LENGTH, WEIGHT In Layout A I fill in the records of 20 people. When I go to Layout B I see those same people (since Layout B contains the same fields). Now I want one more Layout, which will be the first layout to see when we start Filemaker. On this page I want to place buttons: - by clicking the first button, called CONTACT for instance, we go to Layout A. This works fine - by clicking the second button, called DETAILS, I want the following to happen: I want to make a script with search criteria and the results to show in Layout B. After this I can add detail information in the extra fields. Now let's forget about the FLEXPOOL-thingy from before. Let's just say I want to search for all the people that are called John. What I would to is: 1. Make the button in the first layout 2. Go to Scriptmaker and make a new script called NAMESEARCH This is what my script would look like: Go to layout ["Layout B"] Find mode [] Set Field ["NAME = John""] Perfom find[] It doesn't work; Filemaker says there are no records (but i know there are!)

The Field is called FLEXKEUZE. The value of this field is "checkbox FLEXPOOL". People have to check the box to let me know if they want to be in the Flexpool. In layout be I want just those people that have checked the box. So I think Filemaker should not search on records that have the text "FLEXPOOL" but that have the box checked. Unless filemaker only will see the text FLEXPOOL if the box actually has been checked. But this doesn't work. The problem starts when I want to specify the SetField-script part. I cannot just put the word FLEXPOOL in there and click ok. I HAVE to start with quotes, but when I click okay, filemaker itself also adds quotes, so i got": ""FLEXPOOL"". I don't think this is right.

Thanks again for your reply, but it still doesn't work. The field I'm talking about has just one checking box. The field itself is called FLEXKEUZE, and the value of the checkbox is FLEXPOOL. SO now I have: Enter Find Mode Set Field ( FLEXKEUZE ," "*FLEXPOOL*"") (maybe here's the problem. I cannot just put *FLEXPOOL* when specifying, because Filemaker tells me that it should start with ( or " , so that's why after the comma, there are two sets of ") Perform Find Go To Layout ( "Layout B" ) I really appreciate your help, I hope you can help me solve this problem!

It's not working. It goes to the right layout in the end, but it shows only one record (there are 2 people of 5 with long hair) don't I have to specify the Set field thing? (I have a Dutch version, so maybe it's a little different)

Hi Jerry, Thank you for you reply. I've tried what you suggested but I don't really know how to write te script. The long hair thing is a checkbox, so what I really need to no is how to tell Filemaker to show only those records where the checkbox for longhair has been 'checked'. Can you tell me how to do this? Thanks!!

Hi, I'm new to Filemaker, so I might not use the Filemaker-language yet;-) I have two layouts, A en B. Both layouts have some of the same fields but also some different fields. I put some records in layout A and these automatically show in layout B since it are the same fields. But in layout A, I can check a box to see if someone has long hair (for instance). Now I want to make a new layout, which will be the first layout. In this layout I want to make a few buttons, the first button is for layout A and the second button is for layout B. BUT (and here's the problem) I want the records shown in layout B to be only those records of the people that have long hair (so the box I checked in layout A). After this I want to do some other searches on the people with long hair in layout B, so therefor layout B cannot just be a result of a search in layout A. How can I make a button that if you press it, you go to layout B and only the people with long hair are shown? I would be very thankful for some help!