Finding & Searching

I must be missing something very basic and peculiar to FMP but if I write a script that sets Set Variable $Client=ClientID and then set up a Perform Find in which it says ClientID=$Client I would expect results from this. Instead, I get "No records match this set of find requests" and I can see the $Client [with the $ sign] in the ClientID field. Can filemaker not deal with $vars in a search?? That seems too absurd to be true.

I have a set of about 60 records (list derived manually) that have a blank value (at least visually) in a fee field (set as DATE/Indexed). A script is also attached to the field that calculates value in a related area. I'm attempting to search for these records by entering the = sign by itself but am not getting the expected set of 60 records. Any insights? Might the field have some non-display value like hex zeroes? or is it truly void of a value (nulls?) and so the = can't find them?

In Filemaker quick star How can i clean my recient files?

Hi, I would like to know if someone has ever developed a solution to select a set of data depending of two dates: start - end... I want to have a button, after activating I would ask for two values (start and end date) then find all records in a single table that meet the criteria, then calculate the number of records found en report this number.... Any idea?

Hi there I am looking for an elegant way to make some of my "find" scripts more refined. Particularly for those cases where the find request returns NO RESULTS. I cannot seem to find a way to avoid the standard FM pop-up window allowing you to cancel, continue or modify the request.

Ok I have a script that opens up a layout, goes into find mode and now I want to search on a field BUT I need to be able to search for a word like "Apple" with the quotes included. How do I use the Set field command to set the field to "Apple" with the quotes? I know I'm missing a special character or something here. I guess in general the question becomes how do you search for special characters like quotes, @ signs, etc. using the Set field command. Thanks.

Searching the following string "B-CMS-300...B-CMS-400" returns no results. The records are there and this used to work in Filemaker 6. This happens accessing the file directly or through Filemaker server - no difference. Does anyone know what the problem could be? A date range search works fine. Thanks.

Hi, I have a table of Client Sales, with Client ID, Product ID, Amount Paid, Sale Date ... and a summary of Amount Paid. If I do a find on Client ID = "1234" and Sale date = "2007" I can see a group of records and the summary of Amount Paid shows the year's total for that specific Client ID. So far so good. But I would like to search directly from Find mode for Sales Date = "2007" and Summary Total of Amount Paid > "500" so as to find all the clients who have paid more than 500 over all sales in 2007. Is this possible ? TIA Bobbby

I posted this in the Relationship forum a couple weeks back, but I think it may really belong here. My company organizes group tours. I have a FM 5.5 database that I set up in 2001 and it has always had some deficiencies. Now I am re-writing it in FM9. I'm doing pretty well, but one thing has me totally stumped. I have a table that lists all of our groups (Groups), then a table that lists all of the clients in each group (Clients). These tables are related by the field "Group Name." The Clients table has a field for noting each individual client's account status (Active, Canceled, or Incomplete). I have no trouble getting a count of the total number of records f…

Hello. The database I am currently working on consists of several tables, and some of them are not connected. (E.g. there is a table LOCATIONS and a table STAFF.) My aim is to have one single layout where a user can enter his search terms. (E.g. there would be a search field for location, for First Name, for Last name.) On top, there would be a search field where you can search all the desired fields at once. As long as I have tables that are related to each other I can place the according fields on the layout and everything works fine; I created fields that search in several fields at the same time and so on. But as mentioned: Here I have go…

Hi, I am new to filemaker and am using it to do pricing analysis on prototype products we make. I have two tables: one has a record for each product we are developing showing the amount of materials in each product. The other table has a record for each material giving the price and other specifics. I want a way to have the product table look up records in the materials table and return the price or other information about the material. For example, record for product A might have 5 different materials: base material, primer, paint, trim, etc. I want the record for product A to be able to access and look up the price (for example) of "paint" from the materials l…

I am working on cleaning up the mailing list for the company I work for. We produce 4 catalogs for different brands. People request the catalogs and now we have 25000 addresses, but some are the same people asking for each catalog one at a time - instead of asking for all 4 catalogs. or some ask for 3 catalogs, then come back and ask for the 4th, or 2 and 2... how can i merge the duplicate records and include all of the catalogs they are requesting into one record? example Record 1 John Doe cat2 Record 2 John Doe cat 4 record 3 John Doe cat 1 and I need record 1 John Doe cat 1 cat 2 cat 4

Hi everyone, I’d be grateful if someone could help me with a Boolean "OR search". I would like to offer my users a possibility to simply key in a phrase like searchtermA OR searchtermB when they search for different values in one field. Using Extend Found Set is way too complicated in my humble opinion. On top, I am very restrictive when it comes to giving access to menu options. Accessing Extend Found Set from the menu bar is not available for my users. I guess I have to write a nice script... Thank you very much for your input! Mike

I'm trying to find all the records that don't have a number in a particular field. I looked at the filemaker help guide online, and it says to put a "=" in the field that you want to find empty records for. But it just tells me that no records match my criteria? I KNOW that there are records there that don't have anything in the boxes, because if I use the opposite search "*" then it only brings up about half, so therefore the other half of records should show up with the "=" search? I'm not explaining myself very well, but hopefully someone can clue me in to what I'm doing wrong!

I'm looking at modifying my database to omit all records that do not have a valid sales quote number. Currently the correct format for Sales Quote numbers is either 4 digits or RAMXX-XX-XX where X is any number. At the moment some sales quotes are blanks, while others are just text, these are the records I want to omit. And instead of going through the records one at a time and omitting them this way I was hoping I would be able to create a script to do the work for me. And and all help would be greatly appreciated

OK a little bit of background here: I have a database that I did some time ago, where each record in one of the tables had a set of attributes, which were represented by a field displayed as checkboxes. This worked fine and well for some time, until the users decided they kept needing to add more attributes to the value list, causing problems during finds. Allow me to illustrate by example: suppose there was an attribute "Foo" which later received extensions to "Foo 2" and "Foo 3". If the user wanted to search for all records with attribute "Foo", all the records that had attributes "Foo 2" and "Foo 3" would come up as well. This particular case was solvable by …

I wish to create a repair form of inventoried items. I would like to do a search for 1) main category of the item and then 2) the item itself in a separate form. From this search use a button to go to the repair form that will display all the searched items pertinent information in the upper part for reference. To date when I do the search it changes the second field

Hi Everyone, I'm having a bit of trouble with the soultion I'm designing. (I'm an ex-access newbie)... I have 2 scripts that I use to find a set of records from the same table (Different types of the same record). The one script is working without any problems. However, the second script (which is an exact copy of the other with the search criteria and target layout changed) returns an error: "This operation could not be completed because the target is not part of a related table" I have error capture off to check what is going on. If I'm in Scriptmaker and execute each script, they both work as I expect. So, my questions: 1. Does filemaker reme…

I have an overview layout that will eventually show a number of portals. These will display data from different tables and have been related with an 'X' to give me all records in a certain sort order. No I need to be able to click on a field and go to the actual record. I've used to to layout and go to record with a script parameter and I can see this is passed along using the Script Debugger, the screen changes to the layout I want, but the record does not change to the one I have in the parameter. What I'm I doing wrong? Thanks

Hello, I have a student database with three layouts (fall, spring and summer). I would like to print one mailing label for each enrolled student during that year but when I make a search for "active" students in each layout, I have many duplicates because many of the students are enrolled in more than one semester. How do I get rid of these duplicates? I appreciate your help. Thanks, Samuel

So, been enjoying the "FileMaker Pro 9 Bible" and decided to implement the saving of the find requests for one of my central layouts. In the process I identified a few glitches in the basic code provided. The first issue was that if your special save--and-do-find script was triggered when no field was active, the script would loop endlessly. The second issue was that the ActiveFieldTableName was not saved this means that if you had two fields (in different TOs) on a find layout then only the first by tab order is "accessible" to the saved/played back find. A third issue was that on "failed" (no record) searches, the script simply went back to browse mo…

For the most part, my database is running well, but ocassionally I get calls from my users that they aren't seeing all of the records they are supposed to. I have found something that fixes the problem, but the fix is temporary and the problem returns the next day or a few days later. The database has a table of students and a related table of mentors. There is also a User table that contains which office each user belongs to. Each student and mentor record contains a code identifying which office they belong to. Permissions are set so that users can only view student and mentor records that belong to their office (e.g. for Student records, View permissions are s…

Each record contains 5 sample text fields (sample1, sample2, etc). In the search, I want the user to be able to just fill out one box for a sample and during the find, it would find the user request on all 5 sample fields in each record. I have tried a couple of things including setting sample2 = sample1 and then Extending Find, but nothin seems the work. Thanks for your help! This has been really bugging me

I saw it at Devcon - searching a multikey and the search result would start to display in the portal as you type. I think it had something to do with web viewer - How did they do that?

Once again, this is probably one of those things that is easy to do, but I just can't figure it out. I have two databases. One named Order and one named Bought. The order database stores records for each item being ordered, and keeps track of what order they go to by a specific ID. The Bought database keeps records of each item that has BEEN ordered and sold. Basically, an invoice is filled out with items, and as it's filled out, the items are stored on the Order Database. Once the invoice is printed, they are removed from Orders and stored on Bought. A customer may end up purchasing a particular item more than once per month (sales are broken up by month i…

Customers scan their bar code when coming into the club. The scanner records their bar code ID, also their member ID, and creates a new record that records the member ID and the current date. How do I find all of the members that attended for the week, where my weekday starts on a Monday and ends on a Saturday? 1. I need to list each member name & member ID & the date attended 2. I need to tally up the total # of members attended each day as well as for the entire week. Thanks.

Selecting a record by pk_id in a script to update record-data. What is better? Scripting a "Find" or using a "Go to Related Record". I think that a filemaker handles a "Go to Related Record" scriptstep (by using a global temp_fk_id) faster then scripting a search on the primary key.

I realize that this is a fairly basic question, and I'm one inch away from the answer. But oh that inch... So I made a database from the foundations of the FM Starter Solutions Document Library (I've tweaked it a bunch, but the structure is the same). It's a resume database, and many of the job titles have shared values in compound names (ie: "inspector" and "building inspector" and "terrain inspector") Obviously when I use the search feature and type in "inspector", wanting only the inspectors to come up, all job titles that include the work "inspector" appear in list view. Now I know that if I were to type ==inspector in the job titles field this will r…

hi all... i have a little script that imports some data in a filemaker file and then starts cleaning it. the first thing it does it looks for empty records and gets rid of those. that works fine. the second thing it does is looking for duplicates. by marking all duplicate records with 1. then when i want to do a find on all the records marked with 1 the script stops with 101 error which states: "Record is missing". awesome. which record are we talking about? i can see that there are a bunch of records marked with 1. i also put Sett Error Capture [on] in the beginning of the script but the script debugger still stops at the second Perform find with the 101 error... …

Hello everybody, I am new to Filemaker and sadly I have to use Filemaker 5 pro, which is outdated. I have a schools.fp5 database with "schoolid" as a text serial and "schoolname" as a text field. In main.fp5 I have a portal that shows all the schools from schools.fp5. Now I want to be able to sort/filter the portal results by typing into "searchfield" (text) and clicking a button which would execute the search function. I want to be able to search with incomplete school names, eg searching for "Jeff" would return "Jefferson Highschool". How do I go about doing it? Any code is appreciated. I found a somewhat similar example at http://fmpportals.blogspot.com/2007/11/examp…

It seems I'm hitting a FileMaker limitation - or not? I have a database to help artists keep track of their artwork. There's an artwork ID field, which is a text field, because every artist has his/her own way of numbering artwork. A typical ID could be JQ.78.DRW.0803.15 If I search for part of this number, it works fine for any letters (like JQ, or DRW) and it promptly finds the record. If I search for 15 though, no records are found. Is there a way to make this possible? Search for numeric values in a text field? If I search for the entire ID, it also finds the record... Thank you for any tips!

Greetings, all. I am looking for help on putting together a script that will perform a pretty straight forward task: omitting duplicate records (in saying I want to omit dupes, I specifically mean that after the script has functioned, I want just one of the records in the found set - not all). The found set would then become all records including those that had duped versions (one of instead of two). Thanks, much.

Hi is there a way, that i can get a dropdown box perform a search? Here's my problem: I have a field, where the students name is stored. Then i have a field with his grade. Now as i have more students i want to be able to select differt students via the dropdown funtions, and as i select a differt student it shows me the grades of that student. I've tried to solve this problem but at them moment i'm stuck. My solution: I don't use the FM arrow to open the dropdown but set my own and give it this script -sorry for the translation, i'm on german FM-: Enter SearchMode Select(test::name) -- lets the drop open PErformSearch This works but …

Hello! I have a scripted find with about 35 lines of finds/omits. Is there a way to add a line in the middle of all the commands without having to rewrite the whole thing? thanks! Sally L.

I am trying to implement security measures to allow users only to see certain records in a table (based on one of the table's field's values, which holds the Account Name of the person logged in). In order to do that, I created a script to take the user to the layout and automatically filter the records shown by that "Account Name" field. Then, if they want to perform a search, I created a button that runs a script to insert the user's account name into the field value before performing the search (so the user doesn't see all the records but only the ones based on that Account Name field I set up in the table). Here's the big problem: Unfortunately, the user…

Hello I start to use Fm pro 9 advance recently and I´m finding a first found set and found 20 records and soon after I try to apply another find over the 20 records and filemaker makes the find over all the whole data base, how can I make the second find over the 20 records only??? help please!

Hi there I have a layout into which users can enter UK postal codes. I wish to check this postal code against a list of codes that are within the London Congeston Charging zone. In the script I assign the postal code field to a variable and then attempt to 'Perform Find' on this variable. the script is taking the variable ($cc) as literal text. What am I doing wrong? Cheers

Hi all, This is my first post so please be kind! I am writing an order management system at the moment. The problem I am having is trying to locate which orders are ready to be sent. Each master order contains one or more line items. I can find whether a line item is ready to be sent (in stock) but want to ship an order only when all items are ready. The search I need therefore is for each order, to check whether all items are ready. I suspect that this will be some form of loop script but can't get my head around it. Has anyone done anything similar or can offer advice? Many thanks - this is a great forum! Matt

So, my invoice database is set up so that every invoice has exactly one type. The possible types include Credit, Paid, Charge on Account, etc. Initially, I had it set up so that for searching, the types were listed in a dropdown menu, and that worked great. But looking at it now, the user may want to look at several types at once, so I've changed the dropdown menu into a checkbox set. My problem now is how to search. I know that when multiple values are selected, Filemaker separates each value with a carriage return, but I'm not sure how to do the search with this information. The search should be something like "type1 OR type3 OR type7". Any help would be apprecia…

In FileMaker 9, I have a new problem I've never encountered before... I have a field whose contents have values like: 1 1A 1B 1 - Small In previous FileMaker versions finding those fields with "1" was quite easy. However, I cannot figure it out in 9... Here are some examples of my Find requests: 1 "1" =1 ="1" =="1" ==1 All of these requests find ALL of the above values. I just want those with a "1" and nothing else. What am I doing wrong? Thanks!

Hi, I have a basic find script that has the basic responses if no data was entered, or 1 record was found = go to form layout, or > 1 record was found = go to list layout. I was wondering if it was possible to have the button when clicked for a second time during the find script adds a new request. It seems simple but I can't get it to work. It just resets the find script when I push on the button again.

Hello, How to omit records using script which does not match particular sub string? For example if I have strings "JUMPER WIRE,0.6Dx12.5MM" , "JUMPER WIRE,1.8DX33MM,ADD TUBE" ,"JUMPER WIRE,D2.0,COPPER_02,BALM" I want to Omit records which does not match "JUMPER WIRE" and "1.8D" Thanks in advance

Disclaimer: I came from a Microsoft Access background and was quite proficient with it. Now I'm in a Filemaker world and am still trying to figure out how to do some coding techniques that I used to be able to do in my sleep! Here is today's problem. I want to open up a layout and only display the records that don't have data entered in one particular field. It is a list of residents who are due to be retested. If they are no longer eligible for testing, then I fill in a "date testing terminated". So I want all of the records that don't have this date filled in to appear. Thank you in advance!

I am attempting to reproduce the perform find script found in FileMaker Help that will capture errors and display a custom dialogue (see attached). Can anyone tell me how to insert [Restore] after the Perform Find step? Thanks.

Just today I ran into a problem searching a date field. In a invoice portal, that links records from an external filemaker table by account ID, I used to be able to search in that portal for a date range. In other words, I could search for all invoices older than 60 days by just entering a date range. Recently, I cannot find invoices older than a month. I can search and pull up invoices within 2 weeks, but any date greater than that , it returns no records. I even manually looked for a record that had related records with a specific date from 60 days ago, it's listed in the portal, and when I searched for that specific date, it came back with no found records. …

Hello, this may seem odd but I have a inventory table and an inventorySOLD table. We enter stuff that comes in into the inventory table and the stuff we sell on the inventorySOLD table. They are pretty much Identical tables, so I want to create a custom find that will find all records in the inventory table that are not the same as the records in the inventorySOLD table. So it would look something like this Click a button Perform a script Script would find anything not equal in the Inventory::Serial Number and InventorySOLD::Serial Number Seems confusing, but it would allow us to see what we have in stock, because anything not equal would still be …

Hi, I have 3 tables: one with data for a student's University applications (UCAS). one with university offers (key is the student name) each student has 5 offers, one of which is "Firm" and another "Insurance",hence one of the field in OFFERS is an indicator with a value of "F", "I", or space to point to these offers. one table with University Addresses (ADDRESS). This table is linked to OFFERS, key is the university name. Now, I need to print letters to accept the "Firm" or "Insurance" offers, so I have a layout with the student data and portal which displayes the 5 offers. From there you can go onto the layout for the letter (layout based on UCAS) which al…

how can I search on a date range? Like from 5-1-08 to 6-1-08 Thanks

Hi! Is there anyway to exclude parameters in a search. Lets say I want to extract all records in a database that are "members" of a boatclub, but in that search I want to exclude all members that have already payed there membersfee? In this sence I would be left with all who need a reminder to pay their fees! regards nils

Hey there, I wonder if there is a way to make a Search Layout a little easier for my users. In my database you can search for different newspapers. Each newspaper record has a start year. When in Find Mode, there is the start_year field, and the user can key in let’s say <=1990 to find all the records that started before or in 1990. Well, every now and then it happens that the users mix up the < and > signs. So, I’d like to offer them a field where they simply enter four digits for the year and the explanation text next to it says something like „Searches for all publications that start with the entered year or earlier.“ Your help is highly ap…

Hi All, Any ideas how you would create a Find script that will find all Records with a Due Date for the current work week? Thanks, dmg

I'm a beginner, and have looked through the forum for this answer without success. I would like to know what the best practice is for creating a keyword search over multiple fields. The method I have seen is to create a calculation field which concatenates data from multiple fields, and then perform a search on that field. Is this the best way to achieve my goal? Thanks.

Hi all. Thanks for any help that you have to offer... I have an inventory database with about 4500 records. Each record is one piece of hardware -- desktop, laptop, monitor, etc. What I want to do is first search the database to show all current Dell laptops that are currently in use. This is easy enough and gives me about 80 records as a result. But what I want to do next is have the database show me what monitors are in use with those ~80 laptops which would give me a total of ~160 records. I have no idea how to do this. Basically I need a way to tell FileMaker "show me all of the monitors in use by these 80 laptops" without actually entering 80 separate …

Greetings, I have a flat file mailing list with about 2000 names and 400 unique zip codes. I created a separate table for the zip codes (thanks fmforum). Now what I want to do is select a subset from the zip code table and print out all the addresses for that subset. What I can do is create a find for the zip codes in my zip code table and then do multiple finds in the mail address table. I'm doing this using the loop and next record script steps. But it seems there should be a better way. It seems like it should be a join table but there is only the 1 key, that is, zip code. Any recommendations will be much appreciated. Cheers, MJ

Here's what I'm trying to do: I need a unique list of zip codes from a mailing list. That is, I need 1 record for each unique zip code as opposed to multiple records per zip. I have a mailing list with a mess o' records. I can sort them, no problem. I can create a layout that counts the number of times a unique zip code appears and display that in Preview mode no problem. What I need to do is somehow get those unique zip codes in a table so I can do something like select them individually and the do some relationship stuff to it. How can I accomplish this? Thanks for any input. MJ

Hello, I am overlooking something very obvious here. Any help would be much appreciated. I have 3 tables: Teachers->Students->Classes I have a list view layout based on the Teachers table. I have fields from all 3 tables in the list view. In the Classes table there are 2 fields: Subject and Description. I have 1 teacher record related to one student record related to 2 class records. - The 1st class record - Subject field contents: "Science" Description field contacts: "Hard Class" - The 2nd class record - Subject field contents: "Math" Description field contacts: "Easy Class" PROBLEM: When I am on the …

I have created a Time Tracking DB for our Graphic Design firm. Basically it contains a Start and Stop time for each job. Each designer logs in, starts and stops the job and it's logged through a global time field. I then have a separate layout displaying all the time records on a portal from that designer (which lists every job done). I now want to create a report where I enter the FROM & TO dates and the designers name so I can see and print all the records from that designer between those dates. I am quite new to filemaker and my scripting knowledge is quite basic. Any help to this problem would be much appreciated. Thanks in advance. Fabian

Hello again, FM wizards and wise guys. Whenever I accomplish something there's something else waiting in the bushes behind it, ya know? Why is that? Anyway. . . Now that I've started to get the idea of using globals to perform scripted finds . . . I need to come up with a way of saving a record of the filter criteria so that if the found records are printed or otherwise referenced/used, the criteria won't be lost and forgotten. Please offer me all of your suggestions. Thank you.

How do I check for duplicates? I want to prevent a user from entering a duplicate report for the same department..... Is there a script I can run before they get to add a new record? Thanks in advance

I am trying to produce a series of layouts that will show in each a range of names. For instance I would a layout with all the names range withe first letter between A...M. I feel the answer is simple but I cannot get anything to work. Using A...M as the range returns all the names that have an occurrence of A or M anywhere. Thanks Mitch

I am aware of the "one fact, one field" rule in FMP and I'm trying to find out how to a very involved search. I have a table of 26.5 K records of census-reported occupations from Here. . (It was pared down from 30K records) As you can see there are a lot of duplicate occupation titles, BUT they have different SOC codes. I imported only the title list because I only need the titles of the jobs when they are being entered (and my data entry people have NO way of knowing what the SOC code an occupation might be. e.g. If someone is an "A Operator" that's all that I can get and expect my co-workers to know.) Here comes the rub: When we do year-end reporting, I w…

I have a company list - when I search for "Test Company #4" it will not find it, even though the value list created from the company list includes it, AND it is visible from the list view. However, if I change the company name to "Test Company Four" and search for it, it finds it. What am I missing here??

hello... i want to sort the found-record-set based on 3 fields. how can i accomplish this? i know how to sort with one field. but i want to use 3 fields and that too in a script. thanx in advance. :)

hello... me again... : ... i have a script which finds all the non-blank records and show them on a layout [listview]. records are about patients and their appointments [1 patient can have multiple appointments] and each appointment is assigned a status [urgent booking required, to be booked, book appointment, booked]. for now the find-script shows the records as required. but i want to further narrow it down to a single appointment-record / patient. my issue is that i want to show only the highest priority appointment for each patient [urgent booking with highest priority, booked with the least]. so if a patient has 2 urgent appointments and 3 to-be-booked appointme…

hello... i want to break-down master found record set into sub-sets based on common ID. lets say if master-found-record-set returns 12 records where first 4 records have ID[1], 5-9 have Id[2] and 10-12 have ID[3] then i want to break down the found-record-set into 3 subsets each containing corresponding records. also how can i retain the master-found-record-set so that after i'm done working with first sub-set, i can move to second ID and then loop through its records and so on. thanx in advance.

hello... how can i show unique records only in a search/find? lets say my search/find returns 7 records, 4 with ID A and 3 with ID B. so instead of showing all 7, i only want to show 1 of ID A and 1 of ID B. like this ID [A] Value [Val1] ID Value [Valb] and so on. thanx in advance. :)

I have a project tracking table with a "PO #" field (text, indexed). When I try to perform a find using part of a PO#, I get a "no matching records" error message, even when I know that is false. For example: Let's say I have three records with the following PO #'s: 03829-3918MID 57265-4815MID 68137-5843MID If I perform a Find and type MID into the PO # field, I get the "no matching records" error message. Why does that happen? It doesn't seem like that should be an issue.

Is This Possible ? Filtering Lookup Fields I made my first FileMaker database which is conversion of one of our old databases. It is a relational 2 table database. My key field is ProjectNumber for the two tables, Each project has 2 Project Numbers one for contract work and another for extra billable work and a status field with shows that the project is open or closed. I have ProjectNumber set as a lookup in the other table. I need to filter out all the Extra Work Numbers and the Closed Projects out of the ProjectNumber Lookup so it shows only the Open Contract Numbers to avoid duplication of project names. How can I do this? …

I have a text field called subject that I want to use the contents of this field to perform a find. Right now I do it this find and delete manually but I need to have it scripted. Here is the manual process: Go to record request 1st Copy contents of field subject Perform find in field subject paste the contents into the Criteria section and hit enter Delete retuned records Show all records Go to record request 1st I need for this above manual operation to be scripted but since you cannot paste into a criteria field for a find the script will not work. Has anyone ran into this before or has any ideas on how to work around this problem. Than…

Hi All: I have a database where I would like field B to extract the first 10 characters from the field A. I would like field C extract characters from 11 to 20 from field A. I would like field D extract characters 21 to 30 from Field A and so on. I have been using the Middle ( A;1;10) calculation then Middle ( A;11;20) then Middle ( A;21;30) but is has not worked precise. Depending on how the data is in the fields it is copying some of the same data in field c as field. Any ideas? Thanks a bunch.. Gary

I would like to know if is possible to make a search upon records that have repetition fields and isolate these values upon the found set in the list mode. I dont want to all of the repetition fields apear, only the found ones, since each one has a individual value.

Is there a way to Perform Find upon drop-down menu selection? If that doesn't make sense, here's a scenario: Three States to find by: Illinois Michigan Colorado Upon choosing "Michigan," I would like to perform the find without requiring any further actions (e.g., Hitting the Return key, or clicking on another button) Any ideas?

I have a layout displaying a list of orders. I used to have a "go" button next to each record so the user could view the details of each order. The user has told me they want to be able to click anywhere on the record/row and be taken to the details, rather than clicking a "go" button. When I selected every field in the row and made it a button to display the order details, I ran into problems with the Find Mode. The button takes precedence over the ability to type in the fields to perform a search. Is there a way to disable the button so the user can type into the fields, or a way to make a transparent button and "send to back" when in find mode, or a way to sele…

I'm switching from a access 97 database to a filemaker 9 database and I know in Microsoft Access you can create queries, which are fairly common in the access world, but I do not know/see how to create a query in Filemaker Pro 9. Can anyone tell me how queries, like in MS access, can be created in filemaker? Thank you

Hi all I have a runtime on our network at work that we use to track our material test reports. We do a google like search to find a material test reports . The problem is that the search works like it should on some computers and does not work properly on other computers. The search when not working porperly will not find all the records or will not find any records. The record are in the system because if we go to another computer, we can find all the records. Any ideas why this happens. Thanks in advance Lionel

Hi everyone... I'm pretty sure it's a silly question, but I can't realize what to do! Is there any way to do a search and delete the found set? I mean, into a script. I want to script a search (records with one field empty) and then delete the records it had found. Well, thanks for everything guys (and girls, obviusly : ) See you.

hello got another issue that needs to be solved. i have a script that does a find n perform find routine and returns a number of records based on a set criteria. i know i can use get(foundcount) function to get a number of all records in the found set. but how can i break down that foundset even further and count how many records have one specific value. lets say my search returns 5 records. two have "1" as value, 2 have "2" as value and 1 has "5" as value. this is the count i want. Total records found : 5 FURTHER BREAKDOWN ==================== 2 records with value "1" found 2 records with value "2" found 1 record(s) with value "5" found. ======…

I am new to filemaker pro but I have an IT support background. I want to view all the records for a month by a user logged into Filemaker. Under the sort option you only have the choice of "fields" to sort by, there is no option to sort records by a particular user. Any help would be greatly appreciated. I am new to this forum

hello once again i need your expert help to sort out this issue. i have a table which store appointments for patients. a patient can have more than 1 appointments. so my problem is that i want to find and display only those records where appointments are within a range of 7 days [7 days from today] so that the person who logs into the system can view the list and then call the patients to remind them about their upcoming appointments in the next 7 days. this range will never exceed 7 days and will always be 7 days from today. so all i want is to filter out and show [omit all others] a list of records that have appointments coming up in the next 7 days only. so h…

I wish that there were a spreadsheet-like function like Lookup ( =lookup(data-range,search-criteria,result-range ) I'm finding that the lookup function and lookup action in text and number fields is a lot more complicated. Can anyone direct a novice to some basic information on how to do a lookup as prescribed above?

Hi, I have a problem accessing the previous record on a found set that I need to evaluate. For an inventory that I'm developing, I need to know the value of, say the field QtyIn recorded on the last transaction. Please see the image below: http://www.designink.info/test/Case1.jpg I tried using the function GetNthRecord ( QtyIn;Get ( RecordNumber ) - 1) to get the QtyIn and passed it on the QtyInPrevious field just to have a reference to see if it's doing what it's supposed to do. You will also notice that on the left pane, the records are Unsorted and is displaying ALL the records created in the table. The problem becomes evident when I tried narrowing…

I have a text field that is indexed and is a lookup. When trying to search this field majority of the time it does not work. The only time I've got it to work is when I've typed 1 or 10. For other tables and files I have no problem search this type of field. The one thing that is different is that I'm only viewing active records. If they are marked inactive I search for them in the opening script and omit them from the viewed list. This occurs both with my script and when I use the filemaker search. Any input would be greatly appreciated.

I want to count the number of unique values for a field across all records. for example, if a field contains A,A,B,C,C,C,D,D,D,D (in a database of 10 records) then the desired result is 4. I would like the count for all records, even if viewing only a subset of records. Is there a simple way to accomplish this? Thanks much.

Hi: I have a file maker database with duplicate records. I am trying to find out how to write a script that will search duplicates based on field A and insert the number of duplicates there are in the field B. Any help is appreciated. Thanks Gary

hello... just wanted to know how to get the count of # of records found by a search/find through script. thanx in advance.

hello to all i have a layout with over 40 fields. i want to set up a script where user can perform a search either by a single field or multiple fields. search selection [single field / multiple] completely depends on the user. how can i work around this so that my script builds a query/search-string based on filled-fields and then perform the search n return the matching records. for eg: field 1: id field 2: fname field 3: lname field 4: address field 5: gender . . . field n: comments i want to write a script that will let user run a search/find based on a single/multiple fields input. thanx in advance for your help and input.

Hi Folks, I have a large relational database that is three databases all tied to the contact ID. When i go to make a new record in one of the relational bases, it doesn't see the contact ID. Any thoughts? A professional set this up for me and now even he is stumped. Here's the scenerio: There's a main contact database. It is tied to a donation database and to a talent database, all are connected by contact ID. The professional formulated a script so that i can add a new record from the contact view for the donation database. The first "New" record is added just fine. When I want to add a second new record (to the same contact id) it doesn't see the co…

I can't figure out how to search for empty fields when a) the field is a drop down list of 10 values and : when the field is a checkbox set of 12 values. Any suggestions/insights? Thanks!

I am wondering if there is a script or calculation that I can setup to find all records in my database for a particular month and year. Several date fields are completed in this database as its main function is to keep dates of each job that comes through our department. The first date entered is an automatically generated field once a new record is created named "Received". The next two date fields are entered by the user which are "Artwork" and "Proof Out", these can sometimes be several days later than the "Received" date and thus require their own field. Lastly, there are two date fields for each time the job returns from the client with correction…

hello ... i want to know if i can do the follow in a filemaker report. 1: this is how my portal looks portal 2:this is how my report looks report now if you see in the report ... 2 customers order ref 1010 so the report shows me 2 lines ... if 10 customer order ref 1010 it will shows me 10 lines with that ref ... what i want is a report that shows all the references using one line per reference making totals.... thanks for your help Mauricio Monsalve

hi ...im trying to make an order reception app ... but im having problems with reports ... my question is .. if i have a table with a "reference" column wich i select all the reference my client order .. how i find and especific reference from all the orders and how many quantities from that reference ... example .. Ref: 2020 you sell 500 units i hope somebody can help me with that... thank you in advance

Hi I was thinking of a keyword search feature in one of my projects. I have Essential Oils that I want to keyword in a "Keyword Text Field" for example. Wood, Sweet, Fruit, Strong Aroma..... What would be the best search function for a feature like this? Would it be Possible to enter multiple features in one search field and it lists all compatible Essential Oils. How could that be done? Thanks, as always!

Hi, I tried doing a search for this without luck, but am I delusional (quite likely!), or is there a bug with global? Essentially my system is a checkin/out system of assets. A user will have their main processing window and will search and be presented with a list of possible matches that they can then click on to add to their checkout list. So, the user types in their search term into the global, clicks on search. It opens a new window (same layout obviously) and the global disappears??? I have a work around to do the search in the same window then goes back to the original layout and presents the findings in a separate window, but would like to k…

Has anyone run into an issue where a Find for a text range is not working? I have a table with a ShortCode field of 2 to 5 digits, in text. When I try to search for a range ("KE...HRYD") I'm getting 0 records, when it should be returning around 100+ records. Any ideas?

I've posted this under Finding, but maybe it belongs under Custom Functions. I'm looking for a function that would "Get LastRequestValues" so that I could create dynamic reports with the Find Criteria Listed in the header of the report. Is anyone aware of such a function or technique. It would have to identify the fields and values selected by the user. I looked at seeing if there was a way to save the Last request when you goto Modify Last Find, but couldn't see a way of extracting that information into a variable. It seems like a useful function for creating catalogs, etc.

Hi, I'm an italian developer. I try to explain my problem. I've a table with a GLOBAL STORAGE field (type date) named "Dataini" and another normal field (type date) named "Var". I want to find all the records in this table where Var = Dataini. I try to use the script function "Perform Find" but when I select the field "Dataini" I can add as criteria only a date (ex. 10/12/2008) and not the global field "Var". How can I solve it? Thanks

Is there a way to do an "==" exact find that is case sensitive? Thanks!

: Hi folks.... can you help me...how do I perform a NOT query using FileMaker Pro? Would really appreciate some help with this one......

Hi, I have a database running on a server in filemaker 8.5 and have the following problem. There are many users of the database and a small set of priviledge sets among them. I have set scripts up so that when a user tries to access a layout they don't have access to, it takes them there, they do see the "no access" gray screen in the back, but are immediately shown a dialogue box which tells them they have no access to that page and sends them back to the main page of the database. However,when I go in (as the full access user)and I enter find mode and try and go to another layout, i can see the other layout in the background, but i get that same error message…

Hi all, Can I preform a find request where the criteria is another field. The example I'm trying to run is: I have a date field and two global dates fields. I want to run a script to only find the records were the date field is in the range of the to global fields. Thanks, Ziv