Finding & Searching

This must be simple, but I just can't figure it out. All I want to do is show the last touched record (new or edited) and list all records sorted in order. Let me explain: I've added a button (save) which runs a script. In this script I want to save the current record then sort all records in the database on a date field and then display all records sorted by date with the last touched record showing. I can find the correct record using a flag [could not get status(currentrecordid) to get me to the correct record] or I can sort all records based on the date field. But I can't seem to get both at the same time. Any help would be greatly appreciated.. thanks in …

Fairly new at using filemaker, have managed quite well up to now but here's my problem. We have a database that needs to be searched to produce a particular set of customers, is there any way to copy the text typed for the find criteria into another field that will display in the header of the search results?

Is it possible to do a FIND on a container field JUST to see if there is something in it? Or maybe looping over the entire database and some type of check to see if there is anything in the container field.

Hello I am working with vin ( Vehicle Identification Numbers ) I am only interested in linking the information about a car to its model number in a related file. The VIN number is 17 digits and sometimes the model numbers are the 4,5,6,7, digits but sometimes other places. I thought I might have a solution by placing the numbers in their place in a larger number and populate the rest of the digit's placeholders with a "@" sign. Then I thought the user could type in a Whole VIN number 17 digits and reliably find it. So in the related field I would have for example @,@,@,D,G,3,5,7,@,@,@,@,@,@,@,@,@, Then in the main file through a relationship and a l…

I want to be able to do a find which will bring up either one or many records and be able to paste information into a field in the found set in one go rather than having to paste the same information into each record. Is this possible and any help would be appreciated. many thanks

Hey Anyone help me with this I want to be able to add a search that will find numbers with and without spaces for example Actual entry: 1234 2300 Search either: 1234 2300 or 12342300 so with either it will come up One way I thought was via script and to create another field (calculation) "No space telephone" but is there another way? Simon

I'm new to this, so I apologize if I'm over explaning things. I have 3 DBs that are relational Here is the pertinent info about those DBs DB A: Has a ID field (named AddressID) and and a text field (called Address). The ID is unique. DB B: Has the aforementioned ID field, another unique ID field (called PackageID), a date field and a unstored calculation of the Address field. So we have a one Address to many Packages. DB C: Has the previous ID fields (Address, Package) and another unique ID field (called ItemID) and a text field (called ItemName). Same idea as above - For each Package there are many Items. Now the problem. I do a find in DB C on the da…

A simple button with the Search & Replace command does what it should do. But when the DB is compiled to .exe, the button does not work and the S&R window does not appear. What am I missing here? John

I have a date field as ##/##/#### I want to find all records with a birth date in December. What do I enter in the date field (in Find mode) to produce this result? Thanks!

Strange FIND problem in FM 5.5: I have a script which searches based on user select of a foreign key file (they are all unique)which is the employee number. If nothing is found, it returns a custom message. If any are found, it switches layouts and shows those records. Works perfect, except when I search for one of two people. For these two people only (and I checked it with every person), if they have records to find, it hangs up. There is no loop in the script, but it acts like it. I need to abort to bring it back. It returns no records. If these two have no records, it returns the custom message. I can go to the layout it ultimately ends…

I guess I am an intermediate user. First, let me say that this Forum is absolutely indispensable to me!! I don't post often, because I usually find just the answer I needed by searching past posts. However, this one has me stumped. I am using FM 5.5. I have a db of about 100,000+ records. Important fields are: Store#, Vendor# and Date. A single record in the db equals a single store visit on behalf of a single vendor. There are only 150 different Store#'s and 90 different Vendor#'s and of course, dates going back two years. I need to run a report that shows the last time EACH store was visited on behalf of EACH vendor. Sounded simple, but …

A search and replace task on a specific field can only be performed when the current field is selected. When doing a search and replace on a radio button where I want yes replaced by no, I can't seem to select this field and a error is shown and the task stops. How can I work around this? Thanks John

Can someone tell me why the duplicate record check on the attached file does not work. I established a field (ZCONCAT) defined as: Date of Event&Event ID&Zip&Person ID I established a self relationship based on this field. Then I created a field (Dup Warning) defined as: If(Count(ZCONCAT)>1, "WARNING!!! This record may be a duplicate!!!", "") To me this looks like the same structure I have used on other files where the duplicate warnings work perfectly.

Can anyone advise how to find a random 10% of my database for purposes of conducting a survey? I have 9800 records, each with an individual number. I need to select 10% at random.

I created a report layout that allows someone to select dates from a drop down menus. There are 2 menus for the "From" date and 2 menus for the "To" date. The first menu (Value List)of the "From" choice allows them to select 01/01/, 02/01/, 03/01/ etc., the second (Value List) allows them to select 2003, 2004, 2005, etc. The first menu of the "To" list allows them to select 01/31/, 02/28, 03/31, etc and the second 2003, 2004, 2005. I have a set field in a script that combines the 2 drop down choices to arrive at the "From" date and combines the other 2 for the "To" date. Everything is working correctly except for the month of November. Part of the script a…

I would like to index a calcualted field to speed up sorting. However my calculation references a related record and thus can't be indexed. Any suggestions on how to work around this?

I'm just posting this because I didn't find it when I went looking, but I've figured it once since then. If you want to perform a universal Find & Replace with a carriage return (in either slot), you can't do it (any way I know) with Edit: Find/Replace. You can't, for instance, cut and paste the symbol. What you can do, however, is set up a script with the Find/Replace step, and set it to use the value from specific fields. Just create a Find field (Text, or Global) and a Replace field (same), and put in a carriage return, wacky symbol, or anything too hard for the message box.

I'm trying to create a report based on multiple finds. Some of the fields in the report layout are summary fields which I want to base the value on all of the records. When I do my find the values in the summary fields is now based on the records in the find. Is there a way to hold the value of the summary field or to make it always be based on all records so I can perform the finds I need to complete my report. AND if I need to do three finds can I hold the find value in a field so it is not changed when I do the next find for another field. Hope this makes sense. Thanks

I'm performing a find in a calculation field that combines 3 different fields. If any info is missing from any field, the field will display the word ERROR. The problem I've encountered is, when I try to find the word ERROR in the field, it will only return the records where ERROR is the last word in the field. Example: (record 1 field): 4/C-1/12-ERROR (record 2 field): 4/C-ERROR-002 will only find the record where the field contained "4/C-1/12-ERROR" and ignore the other record. I have made a new text field that uses Set Field to copy the values from the calculation field, and did the find in that field, but same results. I've tried *ERROR an…

In editing my db, I have realized I am missing an important feature. The db is for entering info. There is a name for the information, a category, page # and item # on that page. In editing, I'm finding it would be really good to have a "Go to record" type feature but that deals with the data in one of the fields, the page #. Currently, sure I can do a find for the page # but that limits me to bringing up only that page (or if more than one item on it, several records corresponding to it). The reason the above is important is that we reach a certain page # when editing. After coming back after an absence, one is further ahead so it would be nice to start aft…

I am not shaw if I am posting in the correct forum, so if not please redirect me. I have a field which is a calculation returning either 'correct' or 'incorrect' based on answers people give in other fields. What I would like is display on each record how many records are correct out of the total number of records. any help much appreciated

Ok. Please note I am very new to FM with little experience. I have created several files where the relationships work fine. Now, I'm trying to create a layout that will give someone the ability to find a record by either Last name, Id number, or phone number.(I have defined all these fields) I want to give them the choice on which search would work best. Once a record is found, or group of records, I would like the layout to switch to the "PlayerInfo" layout to either view the record(s) or be able to edit.Can anyone lead me down the path of knowledge, or at least to the front door?

Hello everyone, I'm new to this forum and new to FM. I'm wanting to isolate incomplete address records I've imported into a new database. I know about the = find command. My question is how would I use that to query only those records which do not have a company name OR do not have a address OR do not have a city etc... etc... Any assistance would be greatly appreciated :-) Thanks Ron

Does anybody know if there is way in FM to highlight the searched terms in the found records? Also, is there a way of using synonyms?

I have inherited the support of a FileMaker database. I need to move the database from a MAC to a PC. In the process of moving the database I have identified that pictures in the database are being inserted with "Store only a reference to the file" checked. Is there are way to view the actual reference to the file and can I replace the reference in a batch update to point at the new location?

hey guys. its been a while. i have a search button which takes you to the main layout so you can search by first and or last name in the records. the thing is everytime i hit search, the first name feild already has the number 1 in it. so i always have to backspace then write the name in. i already went thru the script to see if it was the culprit but its fine. any ideas?::?:?:?:?:

I'm close on this...but can't seem to get it to work exactly right. I need to script a search based on two criteria. The first is whether or not a date falls into a specific range. Once I learned about using the "Insert Calculated Result", that part was easy. The second criteria is more problematic. There is a data element that can have one of three values. I need to be able to search for any combination of the three values. I have created globals for the start and stop dates, and a yes/no global for each of the three possible values. I've been able to make this work using a calculation, but because of the size of the database (2K records and growing a…

I've hunted around, but haven't been able to find anything about this. I am trying to write a script that will find the current record, and only the current record, so that I can import a bunch of data from a file into it. I've tried several different scripts, but haven't been able to get it to work. Is this really easy? Am I being stupid? Can you suggest something?

I've got a problem. I know the answer is right here in front of me but in my sick state I can't see it. We've got a new database for manuscripts. The main database holds information about the manuscript, such as reference number and date submitted. The other database also holds a reference number (this is the relationship), as well as the author name and e-mail address. Basically what we want to do is have all the e-mail addresses for a given reference number be sent an e-mail notification. Any ideas? I know this is going to be a simple one (again) but I'm stumped. I've spent the last few hours poking through the archives on here, to no avail. Thanks much …

I'm new to this forum. I'm wrestling with an FM-search issue that I am not able to solve on my own. I have three separate databases where I have information about ports and port details. What I'm trying to do is to create an interface (an FM file) from which I can enter my queries,search the other databases and have the search results presented in one single page, possibly in one or two portals. Unfortunately, I haven't found any way to do searches from one file into another. Regular portals will present matching records from other files into a portal. But those won't do as those matches are too strict - since they're based on a strict match between matching fie…

I manufacture kitchen cabinets. Each cabinet has a series of parts. Each part requires a series of processes. I would like to be able to perform a FIND RECORD that selects records based upon more than one criteria at once. For example: All tasks that require tablesaw & glue. The drop down palette has a series of operators but does not include the operator (&). Can someone help with this? Thanks, Jarvis

I am not sure if this question belongs here, or at the scriptmaker forum. Is there a way to script a FIND so that I do not have to enter the criteria each time? Thanks, Jarvis

This is probably very basic, but please help as it's driving me mad. I have setup a database with a auot entry (creation) Date field. I have formatted the date field to day/month/year. I have also set my system (date/time) parameters (MAC OSX) to the same format. However, when I go to do a find in the Date field, I get the error message saying that I must enter the data as month/day/year. Is there any possible way to change the stored date parameters to day/month/year so that my search entry will be accepted? Thanks in advance.

Ok, heres a somewhat complicated (as far as I see it) situation I need a little help with if anyone has a few minutes. I have created an invoice database for a friend of mine that has 7 product fields on it. Basically one line across the invoice looks like this: BRAND (brand of product being sold) - QTY (quantity of product) - PRODUCT (product description) - UNIT PRICE (unit price) - TOTAL PRICE (QTY x UNIT PRICE) The problem is that basically each of those above fields I have 7 of them (So Product 1, Product 2, Product 3, etc) but now they want to be able to print a report of all "x" brand name items and their total price sold. I have no idea how to c…

Hello: I have a button that brings the user into the correct layout and enters find mode. The user then types in a date range search 1/1/03...1/23/03 and hits a button to create the report. What I need is for this date range to be copied into a field so it appears on the print layout to show this search range. I tried to use set field then perform find but that didnt do it. How can I do this? Thanks

I've been trying to find an article in the knowledge base on how to perform a find within 2 Dates that the user enters (for a report). Maybe I'm searching the wrong terms? Does anyone know of such article? Let me know if you do. Thanks!! Larry

I need a script that will automatically find all records that were created yesterday. I have a record that is creation date. I may or may not have records for today. I can't seem to find the right find request. Larry

I have a Parent db where each record can have more than one related record in my Child db. I would like to be able to find Parent records by criteria in the Child db. For example, let's say my child database has these three fields: Hair Color Eye Color Birth Month And that each record in the Parent database, may have many related records in the Child database. Sounds simple, except that I never know what the criteria will be. One minute my users may need to find the Parent db records that have related child records with: Red Hair, Blue Eyes, born in September *AND* Blonde Hair, Green Eyes, born in December -- and in the next minute they may need t…

Hi, I'm not a filemaker developer so please forgive me if this is insulingly easy or stupid! I am having problems trying to run a SQL query on a large FM Pro 5.5 file (running on a Mac under OS X) from an ASP page and an ODBC driver (which I set using a System DSN on my W2K server, using the filemaker pro ODBC driver). If I query small files it is fine and comes back with results etc... albeit pretty slow. However, if I query a large file it brings FM Pro to it's knees and the application stops responding forcing a quit and restart. In fact I have just bought our production FM Pro server to it's knees by doing a simple SELECT query... not great when it's our …

I'm new to FM (and using Ver 6). I have a field called "status" and want to make a script to search for the records which contain "hold" and "testing" and "new". What is the best to go about this? Thanks

I am working with a product database where we have items that are discontinued. we need to keep them in the system for future reference, however they are in the way. I have created a field "productstatus" where the items can be marked, available, coming soon or discontinued. I would like to possibly set up a script where we find on the manufacturer of the product and the discontinued items are automatically removed from the find results. I'm not sure that this is possible. Does anyone have any suggestions?

Howdy, I can't believe there's not a way to do this, but I have been unsucessful thus far. In a script, I need to insert a pair of quotation marks around the characters I'm searching for. So, how do I get a quote to insert? I can't find a function that does it, and trying an odd-number of double-quotes gives an error. What's the secret? In my case, I need to insert this: "," as the the text I'm searching for. Thanks.

Wasn't sure where to post this, so I'm putting it here in the Searching & finding section... Aren't you lucky? ;-) I have 4 files- OrderItems, Orders, Customers, and Catalog. I need to be able to print the current order I'm working on. for example, I have order ID 12 up on my screen which consists of a portal from orderItems to Orders (I'm in Orders), with the catalog in a portal next to it. I click on the portal rows to add items to the order. now I want to hit a button to print just the order portal. I can't seem to figure that part out. any ideas? thanks! Joe

Hello, I am trying to do a simple find in Find mode but it seems to have changed greatly in version 6.0 than any other versions. I am not doing any scripting or anything complicated, just a basic find. I have a field where the records contain names similar to this "12345-P.fin". The only thing that may possibly change in certain records names' would be the character before the extension (ex. A.fin, D.fin, etc.) When I perform a find for "P" (without the quotes) it only give me files that contain a parens before the hyphen (ex. 12345(ost)-P.fin ) and none of the other "P" files. To me it seems logical that if you ask for all records that have the letter "P" …

Hi I am trying to Find records which are greater than the current Date and Time. I have 2 fields called EndDate and EndTime. I would like to know how to create a find request to return all records which are >=the current Date and time. I am really stuck on this. Any help would be greatly appreciated. I thought I had it figured out, but I was wrong.

Post deleted by dleggett

I am working with FrameMaker Solutions (from File Makers Web site's templates). I am up and running and everything is working quite good. My boss now wants some sales reports and I can't figure out how to get them. There is a "report" module but it only seems to include things like "invoice", "envelopes" etc. It seems like I should be able to print out a sales report by specifying a date range. I want to be able to see my totals for July 1 - September 13. I need to see total of sales, total of sales tax, and gross total. Can someone explain to me how I can get this information easily? I am a novice at this and am not a programmer by any stretch of the imagination.

I have a db for medical tests. It has the patient number, date of test, and results of the test. I want to get the results for a date range with a certain result for the test. Questions 1) How do I do a multi-field search? 2) Why when I enter a date range do the results fall outside that range? ie 1/1/2003...12/31/2003 I get 1999 results. I've also tried >=1/1/2003 <=12/31/2003 Just as a note, I inherited this whole mess and the original coder (wasn't a programmer that's for sure) did not put constraints on dates to ensure valid dates so I have things like 3/1/0307 and 6/5/2009 as dates in here. I am working on fixing the bad dates. A…

When I do a single-request find on two fields in a portal, the found set includes all records in the primary file for which some portal record(s) have either portal field matching its specified search value, i.e., the find seems to be doing an OR on the portal records, not an AND. Is this the way FM treats finds in portals or do I have another problem? I'm using FM 5.5. Doug

I am trying to perform a find on a field that has information from a relationship. I receive a message: No records match this request. When I am in Browse mode I can see the records and the data. When I perform the find on a field that is from the current file, it displays all the information. I need to be able to select find on any field. Can someone out there help? This tool is new to me. Thanks, Shari

Okay, here's one for you wizards: We have a time-register database that are used by 15 or so people. In one record, they choose their name and type in how many hours they've worked on a project/customer. What I want is statistics for how many hours, how much money all these employees have earned. I'm thinking something like this: Do a find on person Joe Blow to list all the money only this person has generated. Copy summary-field to other field for storage. Repeat for all employees. How can I do this without having to do 15 Set Field ["Employee", "Joe Blow"] ? Do I use a repeating field for storing the individual totals? Use loop and lookup the e…

My program allows users to record a client's visit dates; each visit is recorded with a new record. Each record contains visitor's name, visitor's ID number, reason for visit and the user's name. I would like to be able to pull up a list of visitors by the user name without every visit being displayed. Thus generating a single client list. I have solved this problem by using a "first visit" field and placing a "yes" in that field for the first visit only. I can then do a find on the user name and "yes." This works. But there has to be a better way. For example, is there a way to do a find on all visits by user name, and then add a script that will eliminate duplicate I…

I have probably a very easy question... I have a field for all my students that contains their birthdates. What I want to do is perform a find, lets say if I wanted to see all the students who have birthdays in August. I went into find and that field I typed 08, August, ect... but nothing. the field is set a a Date field. could it be because of that?

Hi, I've got a database of salesmen with fields headed Name, Target and Sales. I'd like to find all records where Target is greater than Sales. I can't seem to find an easy way to enter this into the Find screen; the only way round so far has been to create a calculated field with the formula if(Target>Sales,1,0) and then Find on 1 in that field. I'm new to FMP (version 6) and would appreciate any help on this. Thanks in anticipation. Dave

This should be and probably is a no-brainer, but when I want to find fields that have nothing in them, or find ones that don't have nothing in them, what do I type in? I've tried <>"" <>'' "" AND "" I can't find how FileMaker handles NULL

Im trying to create a script that will search for a specific date range (example: 4-1-03...5-1-03) in two different date fields. I've set up a script that does this in a step one step two process, but I would like to have the user input the date/date range only once. The results would be stored in global fields. here is what I am using now... Enter Find Mode [ Pause ] Perform Find [ Replace Found Set ] Insert Calculated Result [ SFC_Global_1, Status Found Count ] Enter Find Mode [ Pause ] Perform Find [ Replace Found Set ] Insert Calculated Result [ SFC_Global_2, Status Found Count ] I tried using a combined Calc field, as stated elsewhere in the foru…

Okay, if you haven't been following some of my other questions, a brief overview. I have a FM3.0 application that deals with patients at a huge hospital. It is very poorly designed and implemented. I have to pick up the pieces and am NOT a FM guru (yet ) Here is my next question. I have an outside system that handles appointment scheduling. When a patient is scheduled or admitted to the hospital the scheduler FTPs their SSN to a folder on my FM server as a text file. A small FM app checks this folder every 5 seconds. When a text file is found, it imports it, reads the SSN, deletes the text file, uses the SSN to do a search of the main FM app for that pati…

I am building a solution that has 4 databases. The names of the files are Invoicing, Products, customers, and line Item. I have relationship between them. For example I have a relationship from invoicing to customers that supplies all the information about the user before creating an invoice. In the invoice database I have 5 fields that the user can use to search for a particular invoice. Three of those fields come from the customer

Hi, I have two databases, one which shows an individual's cancer record and another related databases which contains a list of all cancer types. The user can lookup which type of cancer someone has had via conditional value lists related to fields in the second database. There are three types of information in the cancer type database, the main group of cancer type, a more detailed sub group and their own unique disease code. Many users on my system will not know what main group of cancer to look in to display the sub-group's value list. I want the user to be able to enter basic a basic search string in the individual cancer record and have this searched…

I have a DB with fields SN (auto entered), NameSN (used to relate to a Names DB), Year and additional fields. An extract might look like this: SN NameSN Year 7 11 2002 8 14 2002 9 14 2003 10 21 2003 I need a find request that will return only records like SN7. Obviously, Find 2002 will return both records like SN7 and SN8. Thanks for any help.

Hi All, How can i find company names that range between letters a & k ? I tried a*...k* but it does not work what am i donig wrong? I can see all of my records, yet if i use a* only the ones starting with letter "a" are displayed (which is great). I gues i need to combine a* with a range? thanks --Dan

This is a bit tricky and I almost have it but think some help would speed things up a bit, p-l-e-e-z-e... Situation: Using a language file to provide field labels in different languages depending on user choice. They display fine in browse mode. Problem: When I try to do a find then ALL the field labels disappear so know one knows what they are! Script Sample: (not 100% English FMP terminology since I am using the Japanese version and am translating roughly into what the FMP script maker commands are.) # Clear Temp fields (global text) 1) Set field: TempName_gt, " " 2) Set field: TempCompany_gt, " " # Go to Find Layout and enter the field f…

Greeting! I am a beginner in developing FileMake Pro Database. This is my first database and I get stuck when I try to implement the search function. 1. There's a field called "Salary". I would like to let the user to type in the minimum and maximum salary and return the related records in the result page by pressing a button. What should I include in the scipt? 2. In the same layout, I would like to include other fields for search as well, e.g. Name Language Position But I would like to make the search "Name" OR " Language" OR "Position", How can I do it? Thanks in advance.

Greeting! I'm setting up a searching script to allow user searching in a date range. I use two global date fields to hold the beginning date and the finishing date. The problem is: I cannot enter anything in these two fields in find mode.

I am an access user and I need to make my access database work on the Mac. I am working with Filmaker 6 Pro trial version in order to see if this package will work for my needs. I am having quite a bit of trouble with more complicated queries (that were relatively easier to design in access) and I was wondering I what I am trying to do is even possible in Filemaker. Again, I'm not looking for the details how to do these things (actually, I am) but for THIS question all I really want to know is if these things are possible. Once I know that it's possible, then I spend some time figuring it out. I don't want to waste anyone's time explaining something again that's…

We use our database to input and print workorders and invoices. Each record has a name, address, city with zip, & phone# fields. I want to keep a running total of invoice totals by city, but several cities have multiple zips. How do I sort, find and display data?

I am trying to create a report listing the activtiy on an account limited to a field on a separate database. I have a database that lists all the accounts and information on the accounts. Some are Intercounty. I have a transactions database listing the activities. The databases are linked through account name. I'm trying to get only the accounts that are intercounty. I tried to add a global field to the transactions and a script telling it that if intercounty in the list database is true to mark true to the field in the transactions database. the script does not work. Any suggesstions? Cin

Hullo, I am trying to build a filemaker database for a rental company in Sydney - Australia. LaRetta pointed me to a great file by cobaltsky in another part of this forum for tips with searching a range of dates- he had a great setup for a hotel reservation program. I found this a fantastic help with my main problem, at the time, which was attempting to reserve my items for future dates, by searching for a range of dates on which other orders existed. However before I proceed any further I'd appreciate some feedback as to whether I am attempting to reinvent the wheel. As I have come from a background working with video rental databases I thought the main diffe…

I would like to create a report that would produce a list of training someone has taken. I have create a value list with check boxes for all employees and a value list in a drop down menu (listed numerically)of all the courses an employee could take. I would like to see all courses someone has taken, now he is the kicker, that would produce a list showing in numeric order (from the drop down list) what each has. Possible?

I have an inventory solution in which I would like to perform a conditional find script based on whatever the info is in the text field <product_id>-in that given record. For Example: In record 3, the value in <product_id>=rsrchlcp. Based on that particular value, I want to find all records based on that criteria alone. OR in record 4, <product_id>=lhexec, I would want to find all records based on that specific criteria. I'm stumped on this one. Can I do this with one script-if so..how? Any suggestions would be greatly appreciated!

Hi, I need help!! I am trying to come up with a way to perform a find which will possibly include more than one value in one field. Specifically, I have a field, "school". This field is based on a value list of 14 unique values. I would like my users to be able to select more than one school value, as well as any other criteria I have on my search page, and return those records which match all the other criteria selected AND any of the school values selected. For example - if someone is looking for a software title (which is one field in my db), a version #of that software (another field in my db), and then selects 2 or 3 schools specifically to search…

Hi everybody ! Is there any possibilities to perform a find using AND-operand inside one field ? I mean... If I have records with a field "Story_text" Record1: "A cat climbed to a tree" Record2: " A cat jumped over the moon" Record3: "A horse run away" Record4: " A cat fell from a tree" Now I need to perform a search which would return Records 1 and 4 which both include words "cat" and "tree": Find: "cat" AND "tree" Is it possible at all ? Cheers Arttu

I am looking at creating a yearly report that could tell me what training and individual has completed for the entire year. I am using a value list with check boxes. When I currently search for (1) persons name, I get that name but all the other names as well. Also that persons name might not be the first one listed, it appears that it brings back the group of names whom have attended which included the one I am looking for. I would like to have just that persons name appear.

i was wondering if i can do a find based on the content of another (global) field. the point is that i need a script that can perform different finds every time. so i was thinking to make the find look in a global field which value will be set in the beginning of the script based on the value i'd like to search on.....

I have a generic report that can be printed for each found set. However I would like to display the criteria used for the find on the report. I know Filemaker stores this info because if you create a script with a Preform Find step, then print the script. The printout will display the find criteria. Does anyone know how to put this info into a global field? Sort of like Status (CurrentFindCriteria).

From a report script I get the dialog "No records match this request.", with Modify Find, Continue and Cancel message choice, when it is so. But I wonder if there is a way to reject/bypass this dialog so it exit the script instead? I want to use a plugin that gives custom menu items and hidden locked status area. I don't know how this will work if the user choose "Modify Find" message choice.

Ok, I have a set of fields, labeled "field 1" through "field 10" for example. The values contained in these fields are from a defined set of possible values, or the fields are empty. No two fields in a record will have the same info though.. For example, let's say that the possible values for these fields are: a b c d e f g h i For the first record, field 1 = a field 2 = b field 3 = h field 4 = c and the rest are blank second record: field 1 = b field 2 = f field 3 = e field 4 = h field 5 = i and the rest are blank What I want to do is enter a value, click a "search" button or something, and have it list all the rec…

Hello, Sorry for the long setup, but here goes: I have a file called "Info" that has two layouts. One is called "General Info" and the other is called "Restricted Info". Users switch between the layouts by clicking buttons. When the user opens the Info file they have to log in using a custom log-in system that I've come up with. They enter a user name and password. The user name is stored as a global field, gUserName. gUserName then forms a relationship with a file called "Users." The Users file has a record for each system user. The Users file has a field that indicates if the user in question is allowed to access the Info file at all, and another t…

Hey: Ok, here's the setup: 2 files - Agents and Clients, related. An agent can have many clients assigned to him. I needed a report that shows a count of how many client records an agent has created. I also needed these stats for the week and month. So I set up some calc fields that return 1 or 0 if the rec was created in the last week and month. Then I find records for each agent and set fields in the agent file with the total numbers. In order to hit all the agents, I have to loop through all the agents with this process. It works, but the whole process seems more difficult than it should be. Does anybody have a better (maybe conventional) way of doing …

I am trying to do finds where field1 contains "x" and field2 does not contain the value "y" but I can't figure out how to make it work on FM5.5, Mac OS X. I can't use the omit function because I am doing multiple find requests and for other requests, it is okay if field 2 contains "y". Is it possible to do this in filemaker??

I am trying to clean up a file in which certain fields contain an ampersand (&). These records need to be split into two different records. A simple find on a special character does not work. Can anyone tell me how to do this? TIA

I've created a script that will put a user in find mode in a find layout. However if a user hits the cancel button in the middle of the find it leaves them in that find layout. What would be the best way to have the user return to the original layout if they hit the cancel button during the find? Thanks, Alain

I'm trying to write a script that will find all records in my database which are more than 12 months old. Not necessarily just this year -1, but more like today - 365. My date fields exist as mm/dd/yyyy (all in one field). What's the best way to go about this? Thanks.

Hi, I have a page where users enter search criteria as global fields. When they execute the search I'm using a script to enter the Find mode, and then using the SetField script step to set the values of the fields to the values they entered in the global fields. This works fine except for date fields. I want the user to be able to set the field as a single date or as a date range, such as 1/1/1970 ... 1/1/1980. If I set the global as a date field, it won't let me enter date ranges. If I set it as a text field I can, but then it doesn't find the date properly. I'm using the TextToDate function with the SetField step. Any thoughts? Thanks, Dan

Goodday all. This is my first post to this forum, but it's helped me through some problems I've had developing in Filemaker for quite some time now, so let me start of by thanking you all for your contributions that have made live easier on me so far. Now however, I have come across a situation I haven't found described in this forum anywhere, and I am at a bit of a loss. The situation is as follows: I am creating a contact database, my goal is to categorise contacts into various dynamic categories. This would mean, as one contact can have many categories ( ) and one category obviously has many contacts and the categories also need to be editabl…

can someone please tell me how to constrain or extend a found set using 5.5. i know these functions are in 6 but we are unable to upgrade yet thanks in advance

i was wondering if a seach can be done by the date of modification? sorry if this sounds stupid, but newbie as of today. i got a steep learning curve (veritical) to tackle, but need solution for project.

How can I make only selected itens with radio buttons copy to a report?

I have a button on my layout to "find record". All it does is go to a different layout, and enter find mode. I have a 'find' button on that layout that runs a script that takes the user to another layout, which lists the found set. The users here are really big on pressing enter, and not clicking a button. When they press enter, it performs the find in the current layout, instead of running the script that takes it to the list layout. I know it's because the focus of the enter key is on the "find" button on the status area to the left, and I don't know how to make it... NOT do that... Is there any way I can make is so that the "enter" button will run th…

I have a MAIN SCREEN layout that contains all the usual contact information for a customer. I produced a second layout which is a columnar style layout. In this layout I include only the field "CUSTOMER NAME". I have layed a transparent button over the top of the name field. When you go to the columnar list layout you click on a name and the transparent button activates the script GO TO MAIN SCREEN LAYOUT. This works great. It allows me to see a list of customers, click on their name and go to additional information about this customer. I would like to be able to alphabetize this columnar layout. Can anybody tell me how to do this? Than…

I have imported records into a database, and the "Phone" field is set to "Numeric, Indexed". The data imports in this format: (xxx) xxx-xxxx When I try to search for (as an example) all phone numbers in the 404 area code, I get an error message or no records found. I can't even find a valid phone number. What am I doing wrong or how do I stucture the FIND command? Thanx Bob

Hi there, i have post a question related to the title before but nobody reply, so now just want to ask again. I had post a samply file which can perform find and show the result in a portal. But the sample is using button to perform find action. Can any one teach me how to perform type-ahead find? Regards Henry Find.zip

I want to find all records with a date field empty using script. Here is the script: go to layout[layout having date filed] enter find mode[] setfield["date field", ""=""] perform find[] enter browse mode[] I got "No record match this request". and I found, in find mode, a question mark (?) is set in the date field instead of an equal sign (=). Thanks in advance!

I am using FM 6.0 to sort research data. The data involves what strategies various students have used for different questions. Each student as a unique student code. IT is also a multi-user file. What I'd like to do is to pull up students who have used the same strategy on different questions. For example, I only want students who have used strategy A on Questions 1 and 2. When I do a Find, I get students who used strategy A on question 1 or question 2. I only want the students who used it on both. I think what I want to do is to find the duplicate student codes for the found set mentioned above, but I am not sure how to do it. Any help would be greatly appreciat…

Hi all Is there a way of suppressing the find dialog box when no records have been founded. I am searching three db for welders qualification who have left the company. I enter the welder id in one db and use the set field option to install the id in the three db and run three external scripts sreaching for his qualification. If no record exist in a db, i would like to just exit the db and continue to the next script without having to press the cancel button. It is not possible to make one db as the forms are different. Can this be done Thanks Lionel

Hi all trying to script a find using the star (*) symbol. My company use this to denote a inactive welder. We currently do the find manually. The script reads like this: Enter Find mode Insert calculated result[select,"inactive" ,""*""] preform find This insert the star (*) symbol into the inactive field but does not insert the quotation marks that is need for FM to recognize the star (*) symbol and the message "No records are found" appears. When the find is done manually, the symbol button is push and the literal text symbol is chosen and this inserts the quotation into the inactive field and the star (*) symbol is added. This works perfectly. How do you g…

I'm performing a search using '!' in Filemaker on last names, and I'm coming up with some duplicates and some that are not. Is that a bug? I'm using FM v5.03

in our project, we need first find the entries in the database during one period based on date. then we need to get the count based on another specific field in the finding result. is there any better way to do that. thanks a lot and sorry for this silly questions.

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.

Hi there, i have attatch a file which consist of 2 database, related.fp5(id, name, foreignkey and 3 global field) and find.fp5(id, find_status, find_text). Find.fp5 is a search system which can search the data on related.fp5 by id or name. And the result will show on a portal with a relationship. It is done by you select the find status(value list:i, name) and type the key word in ind_text, then click a find button to perform find. Now my question is how to make the search system automate without click the find button, just like after user select the find status and type some key word in find_text, then the system will automatic display the result on the portal list witho…