saraswati

Hi ! I need some help in writing a script which will put out the records of only students coming from MS, TN, TX, AL, AK, GA My database contains the following fields Student Name, SSN, Address, City, State, Zipcode, Phone Thanks, saraswati

the professor field format is a normal text. If a student has taken 3 courses under 3 different professors there will be 3 different records with the student data duplicated in the 3 records.

thanks for the suggestion. I will try to think more on Ugo's idea.

hi ugo ! i want to list all the professors that are in the database. One student can take classes under different professors. Does this sound clearer?

there is no professor file name of the professor is just a field in the student database

i need to write some SQL queries and take the result of the queries and run a loop and get count of a particular field based on some conditions. It is kind of a complicated mess. I am trying to figure out how to go about it in FileMaker. Has anyone been in a similar situation ?

my problem is the database file is a student database where student ID is the primary key.

i want to view as a list all the distinct names of professors.

Hi ! I need to pull out records from a database based on professor name. I have created a layout for that so when the script is executed I will get the professor names in that layout. But the problem is I dont want multiple records. The mySQL query could have been something like: SELECT DISTINCT(prof_name) FROM mytable WHERE 1 Could anyone please help me how to do this in Filemaker ?

In FileMaker is it possible to write stored procedures ?

Hi ! I have to write a script which does the following. Transfer all the records who enrolled in 2001 from Main.fp5 to Completed.fp5 I have a field called enrollment date I have to check the year and transfer all the records from the main file to completed file. Does anyone have a clue on how to transfer all records from one database to another ? Thanks Sara

Hi ! When I used the Pattern Count & Trim function and changed the Field Name to FinAidStudent by removing the period & spaces the If function worked. Thanks a lot for all the replies. I really appreciate it!

Hi ! I am a beginner in FileMaker Pro and my boss wants me to write this complicated script using FileMaker Pro. Please could anyone help me go about writing this script. The things I need to check in the script are 1. Are you a student? field (values as drop down box) says "YES" 2. Transferred field is not filled AND Withdrew field is not filled and Completed field is not filled 3. A date is entered in TO. INSTR field 4. The First Extension Expires field does not have a date in the field AND the Second Extension Expires field does not have a date in the field AND the Expiration Date field is between 2 dates (to be entered by the person carrying out search) 5. The Second Extension Expires field does not have a date in the field AND the First Extension Expires field is filled and that date is between 2 dates (to be entered by the person carrying out search) 6. The Second Extension Expires field is filled and that date is between 2 dates to be entered by the searcher 7. Email the results of the search to msdkl@yahoo.com But only include teh following fields in the e-mail First Name, Last Name, SSN, Enrollmend Date, TO.INSTR. Course, Course Name, Expiration Date, Instructor, First Extension Expires Date& Second Extension Expires Date

the word YES is actually selected from a drop down box. I have made a value list as a drop down box containing values YES & NO I cannot change the layout as it is the way my boss wants me to do. Thanks Sara

Hi ! Hey even I tried making a dummy file with just 2 text fields and with one field having a drop down box of values yes and no. & tried using the if function it works absolutely fine but in my main project file it is not working.

Please help me accomplish the following requirement in FileMaker Pro. I have 5 fields each with values YES & NO 1. UM Fee Waiver 2. FS Scholarship 3. Fin Aid Student 4. DANTES 5. VA I have another field called Enrollment Date which is a date field. I have to define a new field called FA Semester. The value of the FA Semester field is based on the following conditions. If (UM Fee Waiver = "YES" or FS Scholarship = "YES" or FinAidStudent = "YES" or DANTES = "YES" or VA = "YES" ) { if (Enrollment Date is between Sept 21 through Feb 20) FA Semester = SPRING else if (Enrollment Date is between Feb 21 through May 10) FA Semester = SUMMER else if (Enrollment Date is between May 11 through Sept 20) FA Semester = FALL }

Hi ! I am having problem using the If function of filemaker pro. I have defined a text field called Fin.Aid Student which has value pop list YES, NO. I have defined another field called FinaidSecond which is a calculation field. The formula used is If( Fin.Aid Student = "YES", "No Second Extension Allowed", " ") I have made the calculation result option box as text. This does not work when i test it. Whether the Fin.Aid Student field selected is YES or NO it always displayes No Second Extension Allowed in the FinaidSecond field. What could be the problem with this ?

Hi ! I have 2 fields State and Zip Code. When a user enters State information for a new record I want the corresponding Zip Code to be automatically displayed in the ZipCode field. I have a drop down box for the user to choose the State. Once the user chooses the State I have to automatically put the value of that State's Zipcode in the ZipCode field. Please tell me how to go about this.

Hi ! I was wondering how to generate fields dynamically in FileMaker Pro. Based on the value of one field called no. of lessons I want to generate that many more new fields giving descriptions. For eg if the no. of lessons is 7 then there should be 7 more fields created each giving dates & details of the lessons. If the no. of lessons field value is 10 for another record then i should generate 10 more fields giving details of the 10 lessons. Could anyone help me on how to go about this requirement.

I have to create a script which accomplishes the following. There is a master file which consists of student records (student name, social security number, courses the student has enrolled, the name of the prof who course the student has enrolled in, enrollment date, no. of lessons in a particular course, mid term test grade and the final exam grade). The script should search for all the professors and display the number of lessons the each prof graded, the no. of mid term exams the prof graded and the no. of final exams a prof graded. If a professor is teaching more than one course I need the total no. of all the courses lessons, mid terms & exmas she has graded. Another thing is a student may have enrolled to take 20 lessons in a particular course but may complete only 12 lessons so in that case the prof has graded 12 lessons for that student not 20. There is a field which lists each lesson and grade the student got in that lesson. Is it possible to implement such a script in Filemaker Pro. I cant figure out how to go about this script. If anyone has a clue then plz reply to me. Thanks Sara

The problem was in the syntax. For the script to work with me I had to use Insert statement in the following manner: Insert[select, FirstExt, "="] Thanks once again for the solution

I tried the script as per the step given by you but it did not work.It comes to find mode and displays equal to sign in the field FirstExt. The scriptwhich I have written is as given below. This script works for only one particular date range. For any other date range it does not show any records inspite of the records existing in the table. Set Error Capture[ON] Go to Layout[Layout#1] Go to Field[Expiration Date] Show Message["Enter the expiration date as mm/dd/yyyy...mm/dd/yyyy"] Enter Find Mode[] Pause/Resume Script Set Field [FirstExt, ""=""] Set Field [secondExt, ""=""] Set Field [Completed, ""=""] Set Field [Withdrew, ""=""] Set Field[Transferred, ""=""] Perform Find[] Please could you tell me what could be the problem. I am using Filemaker Pro 5.5 version.

I have to find all records in the database which satisfy all of the following conditions: 1. Expiration Date is within a range AND whose 2. FirstExt Field is null or empty AND whose 3. SecondExt Field is null or empty AND whose 4. Completed Field is empty AND 5. Withdrew Field/Tranferred Field is empty Expiration Date, FirstExt, Second Ext fields are all date fields and Completed and Withdrew and transferred fields are text fields. Please could anyone help me on how to go about this script.

Im using FileMaker Pro 5.5 While writing the script to use the dot operator to get range of dates in Insert Calculated Result step under the operator listing there is no dot operator. Please could anyone help me on how to go about this.

Thanks a lot Ray ! But I still have a problem. I am using FileMaker Pro 5.5 while writing scripts in the operator listing it does not show me the dot operators. However I can use the dot operator on the layout when I am in Find Mode. The steps in the script are as given below: Go to Layout[Refresh window, "EnrollDate"] Enter Find Mode[] Go to Field ["FromDate"] Pause/Resume Script Go to Field["ToDate"] Pause/Resume Script Go to Layout[Refresh window, "MainLayout"] Insert Calculated Result["Enrollment Date", "FromDate" : what operator to put : "ToDate"] Perform Find[Restore] Could you please tell me where I could be going wrong.