I'm trying to develop a script that finds specific records by date and then constrains the find to those where "Send eMail" field has been checked. I can find the dates thanks to Fenton and LaRetta, but now what seems to be a simple extension (or constrain) just won't work. I have tried setting the field to both Text and Numeric and it will not find the records. Please help.

I've uploaded the text of the scripts in question.

Thanks.

Script_Name_FollowUp3___followup4.txt

You should only need one script here. Simply click the Specify button for your Perform Find step and specify the criteria to be hard-coded for your Send eMail field. You could alternately specify it using Set Field [send eMail; "someValue"] and not specifying the Perform Find criteria.

Then add your Sort Records step, specify the order, and select the No dialog option.

I would also add Allow User Abort [Off] and Set Error Capture [On] to the beginning of your script and test If [Get(FoundCount)] after the Perform Find step, followed by the Sort Records step.

Dear Anomality:

I tried your suggestion, and every variation of it, and still get no results, although, if I do a simple find from "Find Mode" there are 2 records that are marked "Send eMail." For the life of me I can not figure out what is wrong.

The send email field is set up as a number field. It is formatted "Boolean" and it is set to accept "Yes" and "No" in place of 1 and 0. The field set up is check box. I've had it radio button as well as drop down list. Defined value is set to Yes/No and custom values are set to only Yes/No. Each on a separate line of course, no spaces preceding or trailing.

Help!! Please.

I think You don't "insert" any thing in Your find request, so You do not find any thing. than You do not "constrain" Your found records and there is nothing to sort.

pls incude sample file with your script !

than I can fix it

I've uploaded a copy of the file with a few records and the scripts relating to sending email and finding follow ups. Any help you can give will be greatly appreciated. Thank you.

Al

Contact_Names2.zip

enclosed is Your File with an improved script and an example of using related records.

hope it helps!

Thanks very much. As a new user I have a lot to learn and your suggestions are invaluable. I appreciate the helping hand. I'll put all your suggestions and scripts into action. Thanks again.

Al