Finding & Searching

Can anyone show me the script I'd write to find records added "within the last three days"? Thank you!

How can you search for text that contains the inches symbol (") using the Perform Find script step? I have a field that stores items that are measured in inches and my users don't like the idea of having to enter "inches" instead of just the inch symbol.

All. I have a layout that is adding up revenue for various streams in one layout and then providing a result on that same layout. I have also created a layout that is pulling in the results of each record for a summary review of each transaction. Given the summary view of each individual transaction being pulled in, should I not be able to get a total on this second layout? Should I not be able to sub summary them by different types? When I go to create a part, it does not seem to allow me to do so. I am beginning to think the way the original table was done and how it is handing the revenue piece is the problem, but I am to green to know. Still thinking th…

Hi I have a problem whereby I have a table called Stock that calculates a total stock based upon records in another table - account ledger. It is slightly quirky in that the portal has a global date field that is part of the relationship so that it restricts records to all those less than the date specified as well as a stock code match. I do this so that I can run a report on the account ledger table, but want to eliminate all stock with a '0' positions. In my script I go to the stock table, then constrain the found set to omit those with a total = 0, then view all matched account ledger records across all the stock records ; except it doesn't work when it is hosted. …

Hello! Is it possible to use a find to get a record and then show that record on a new layout? I am sure this is a dumb question with a simple answer, but I can't get it!! Thanks Everyone!!

Hi everyone, I want to include a sorting function in my script, and here is some background info. I have a household table that is linked with a baby table.. For each baby record, I have fields with specifications I would like to search on, e.g. languages, age etc. And I also created a customized search function for the users - users can search households that have babies who, for example hear 100% English and are under 10 months ago... The search works perfactly, but afterwards the sorting function does not sort the baby records properly. I want to enable the sorting function implemented as part of a script to sort the babies in the found set by age, but it do…

I'm a bit perplexed (please see simple attached new test demo file) ... Searching grandchild field requires that all key fields in the parent table be indexed as well? I tested this on vs. 9, 10 and 11 and it behaves the same ... if one key field (in this case c_string_PA) in the Parent table is unstored then the search on a grandchild Name field fails - "Could not perform operation. One or more of the relationships are invalid." How could the search fail but the yellow field display the name properly? I realize it would be slower to search a grandchild table (and this is probably the first time I've ever wanted to) but my mind insists that it should …

I am working on a database with two tables SHIPMENTS and COMPANIES. They are all connected by the field Account #. In the Shipments table I created a Counter (Auto-enter serial #) field and a Check Duplicates field. In the Companies table I created a calculation field Min(Shipments::Counter). Where the value in minimum is equal to the Counter field, the Check Duplicates field returns Unique and when not Duplicate. So far so good. This works when I Omit duplicates across the whole database, however when I try to do this for a found set it omits a number of Companies (first and subsequent hits) all together. Any suggestions? Is there a way to debug a script by see…

I am trying to create a field that counts how many orders a customer has placed. As a report, it's easy: Find CustomerID and sub-summary count OrderID. But can I get a FIELD to accomplish this?

An existing value list can have hundreds of entries. It would improve utility for the user if a type ahead system filtered the value list by the characters already entered into the field. Possible?

What is the best way to remove blank spaces from a zipcode field, throughout the database? The field will sometime contain one or more spaces upon import. Either at the beginning or end and even sometimes in the middle. I'm looking for a script solution that will look at the field and remove any blank spaces, move everything to the left and not delete any characters or numbers in the record. Sounds simple but I'm driving myself crazy attempting this. Any suggestions or even a solution is greatly appreciated.

I couldn't really think of a way to search for what I am trying to accomplish, so I apologize if this has been covered. In one table I have two timestamp fields that are start time and end time. Occasionally, but not always one record is a "continuation" of a previous record. For example the end time of record 50 is the begin time of record 55 and they are basically a continuation of a single instance in separate records. There would also be a third field that will be an exact match between these two records. Obviously, I could script a series of finds to accomplish this, but the table will be very large and I believe it will seriously affect performance as t…

Hello! I am building a attendance check in and I want to have people check in to a class. I want them to use a "user name" and "password" and then have them taken to there page... Any help would be great!! Thaanks, Kris!!

In the Find mode, is there any way to search for records with two fields identical? For example, searching for records which have field A and field B with exactly the same content.. or field A and field B that do not share the same content.. Does "?" do the trick?

Newbie here, but would appreciate some guidance. There is a bus stop in front of my apartment that 26 different Vehicles stop at throughout the day. (Table:Vehicles Type: Bus or Car, VehicleID: Letter A-Z) and notes about each Vehicle. There are a total of 100 pickups at this stop (buses and cars) throughout the day. (Table: Pickups, Pickup#, Vehicle Type, VehicleID) For my purposes, the VehicleIDs of these two tables are related. I need to accomplish two things: 1. Create a list of all vehicles and the FIRST TIME each vehicle picks up at the stop. (ie, what is the Pickup# of the first time each VehicleID picks up at the stop.) 2. Create a …

Pretty simple. I want to perform a search across two date fields for for any instance where the two fields do not have the same date but I'm not sure how to do this...

I have a date field in my DB for OrderDate. I am working on a calculated search to find all records that contain an order date, no matter what the date is. I've tried searching based on: **/**/**** / / but none seem to work. How would i got about searching the field to see if a date exists? Thanks

Hi Everyone I have been stumped by what seems to be a very simple problem. I have a field called classification with the auto-enter calculation 'Left ( Self ; 1 )'. The problem is in find mode this calculation does not evaluate. Am I missing something simple or is this normal?

I have a database of accounts, and a related table listing the people that have sent me those accounts over the years. Each person listed has sent multiple accounts over many years. I am trying to figure out how to display (graphically if possible) in my main database how many of those accounts were sent in during the past twelve months, how many where closed (as a percentage), what the average cost was, and a few other things. Basically I want to create a snapshot of the effectiveness of that particular business relationship whenever I look at one of the accounts the person sent in. I have the feeling this isn't too hard, but I'm stumped. Any help would be app…

I have two databases that I have inherited and need to create a federated search. We are running FM 6 and the users access the database through the web. Is there a way to create a search across the two databases? BTW, I am relatively new to FM.

I would like to search for a set of records based on some criteria in one layout, and then omit some records in another layout (which is related to the previously) and finally display the records in the latter layout.. For example, I need to search for babies (in the baby layout) who are 100-120 days old, hear 90% of English and not premature, and then I need to exclude households (in the household layout related to the baby layout) who do not want to be contacted, and finally display those households that meet with all the above criteria.. Since the criteria based on the babies are related to info only in the baby table, I cannot perform all the searches in the hou…

Hello, I have a database with tables as follows: Customers -< Orders -< Order Line Items >- Product ...(ignore dots pls)..............v ........................................| .................................Sales Campaign Products are sold to customers based on a Sales Campaign. The Sales Campaign number is assigned to each Order. Product prices differ between Sales Campaigns. One Campaign can have many orders with the same products sold. I need to display a total of any one given part sold based on a given Campaign number and can't seem to visualize the best approach. Any help is greatly appreciated.

Not sure if this is the right part of the forum. Using FM 9. This is for the index to a book. I have a table with a unique field called "entry #", and several fields that can have the same name in them, "owner last name", "co-owner last name", "third owner", "fourth owner". All of this is in one table. I want to be able to do a find for a name over all 4 fields that have owner names in them, and get all the entry #'s associated with that last name inserted into a field called "owner entries". Any owner could have 1 to 10 entry numbers associated with it. I thought it would be easy, just use find and then have a List field, but that didn't work. I've tried about…

Hello, is it possible to modify anything on my Mac or in my 20MB Filemaker-Database to make searches via Spotlight finds entries? Any hints? Tips? Scripts? Thanks

I've found answers from this forum MANY times - thank you for all of those quick fixes! I couldn't find this one, and needed to start a thread to see if someone can help me knock this one out? No changes have been made to the database, but the "Expiration Date" field of the parent record is no longer providing results of any kind (Static or Range Search) despite there being many valid records that I have verified should show up. I've looked at the button setup and all of those options, but can't find anything that looks like it wouldn't produce results. Any suggestions on this one? Thanks so much!

I have a database that i am using for Telemarketing, however i want it to be able to bring up a menu, select the campain and then sort only the people that i havnt spoken to.. For example Launceston's Callbacks, No Answers, Answer Machines, etc. I can make it bring up the menu and select the campain. I can also make it find only the Answer machines and alike, however the problem is that i cant put two Finds back to back because the second find overrights the first one. For example Menu select campain - Launceston - CB, AM, NA for Launceston... Menu select campain - Griffith - CB, AM, NA for Griffith...

I recently got excellent advice in this Forum on how to get around the fact that Go To Related Records (GTRR) can't be used when you're trying to navigate from one layout to another but the layouts are based on calculations rather than being concrete references to something specific. (As I generalize my scripts, being able to navigate using calculations and variables becomes essential.) The solution to my problem was to rely on Find rather than on GTRR. However, I'm running into one persistent difficulty. Most of my layouts don't include a field for the serial number of the record. That is because my users shouldn't have to think in terms of serial numbers. Typi…

Hi. I am not sure if I am writing in the correct area, but I cannot seem to find this question/answer anywhere else in the forum either. I have a need to draw up a quoting system. The process will involve selecting items from a list, but there will be subcategories and I am unsure how to narrow the searches down. For example. First drop down box will list a major category e.g. "timber". From there, I want the next drop don box to only display a list related to timber - such as "pine", "oak" etc. The third drop down list to only list standard sizes of whatever is available for pine, oak etc. I am unsure how to structure the tables and/or value lists to …

I've had a request from a client to provide them with a function to find records that works in the following way (ideally): 1. The client enters a date range; that is, two dates between which records should be found. So 4/10/10 through 4/26/10 (or whatever). 2. The client then enters either a company name or a client name to find records about that company/client that were entered in the defined date range. I've been able to do each of these separately without any problem (the first using global Start Date and End Date fields). But I can't figure out how to make them work together. When I try, whichever one runs last overrides the one that runs first (so I eit…

I am thinking of using an auto-enter Text field which creates a multiline key, using the words from each of the fields in the same table and using this as a way to implement a multi-field keyword search for the table through a relationship. (Let's call this KEY) For example, in a related table I would have a KeywordSearch Global Field where I would enter a phrase and in a portal I would display records from the related table using the relationship KeywordSearch Is this a correct methodology or not?

Hi All. Wasn't sure where this one should go so sorry if this is the wrong forum. Here is my problem. I have a database with a container field for each record in a table. The field is meant to hold .jpg files for later export and so on. The images are stored within the file and not just as reference. Today I discovered that one of my users had imported a number of .wmf files in error (my bad for not scripting validation on import although that is what I will be doing while I wait for some assistance). So in order to resolve the problem I need to do a find for all the .wmf files. I have a field that uses GetAsText ( ad ) to display the file name of the image in the co…

I'm trying to script a constrain that returns the original found set in case no matches are found. With the native Filemaker search, I know clicking on "Cancel" will return you to the previously shown records. With a scripted search, however, I get taken to a screen with no records. I'm using custom dialog boxes and capturing find errors. Thanks!

I know there must be a simple answer to this: But I have been using 11 Advanced for a few months now and have never seen a "Quick Find Search Box" in the status area in any of my solutions or layouts. Yes, the layouts are Quick Find enabled and have many fields included for Quick Find. And no, I'm not a newbie: I've been using FM since its inception. And, yes, I did search to see if there were others who had asked this question. So, be kind for what must be an obvious answer, but what the heck am I missing???

I am setting up a teacher gradebook. I have a table with classes in which is linked to another table with pupil details. e.g. surname, forename, class, grade1, grade2 etc I have a table which I am using as the frontpage of the database. I want to create a dropdown menu which will be populated from the classes table and then open a new layout poulated with the pupils from that class. I am not sure where to start if someone could point me to a tutorial or similar to do this I would be very grateful Thanks

Hi guys, I have two scripts written to find records contained in a date range and display the found records in a report layout. To accomplish this, two global storage fields are used: Find_StartDate and Find_EndDate to temporarely store the start and the end dates. Another date field ClockIn_Date uses the dates stored in the global fields as a search criteria. My first script: New Window [Name:"SEARCH TIMESHEET"; Height:335; Width:367; Top:25; Left:25] Show/Hide Status Area [Hide] Go to Layout ["TIMESHEET - SEARCH" (TRANSACTIONS)] Enter Browse Mode [] My second script: If [isEmpty ( TRANSACTIONS::Find_StartDate)] Show Custom D…

how do i make script that if perform Quickfind returns 0 result, itll give error. Get(LastError) doesnt seems to work with quickfind

Im having an unusual issue with the Quick Find feature. Currently, i have quick find setup on 4 fields: Name OfficeName Phone Fax If i go to use the quick find and for example, enter the name Henry, i am presented with 13 records. As i look through these 13 records, i'm finding that 9 of the 13 records do not have Henry anywhere in the 4 fields. When performing the search do i need to add any special characters? When entering a phone number to search, the quick find works flawlessly, only appears to be an issue with searching with text as opposed to numbers Anyone else having a smiliar issue?

This may be long but want to make it clear. Database application that is designed to let the user pick a set of subjects and then is presented with questions about each subject with multiple choices on each screen. Single table with a self-join - Fields are "Subject", "Category (subsets for each Subject)" and then Question 1 through Question 5 all in the same record and presented on a single layout. The user is first presented with a "Subjects' layout - they pick pick the "Subjects" from a set of check boxes presented through a Value List. A Find is then executed through a script (does an OR search) and that produces a Found Set of records that the person then wa…

Hi everyone! I'm relatively new to FM but I hope to learn it fast with your help... I am creating a database to manage patients. Patients' contact info are in a table, and to simplify, the visits information are listed in another table, linked in a one to many way. One patient will have many visits over time, and I need to figure out a way, when entering data for a visit, to display certain information from the previous visit, and also to be able to copy/paste info from one visit to another... (I'd guess the same thinking may be already used when generating new invoices for the same customer using previous invoice info...) Any thoughts? Thanks in advance, guys! …

I am confused with a search in database, I have a indexed field with the membership status: Member and Non Member, the field is a dropdown menu when I made search usin the menu and select Members appears all records containing member and non members, if I made non members only found those correctly. There's something I can do to correct the text input in the field, to using the dropdown menu can only find the members or need to use a function or script. By the way I know if use ==members will found only this word, but I want using the dropdown menu option Thanks Karl

I haven't been able to work out the logic for the following search/find in my head, any suggestions? Here's an example of a simple table FIELD1 FIELD2 Red 2 Red 4 Green 4 Green 1 Green 5 Purple 1 Purple 4 What I want to be able to do is, find a single occurence for each value in FIELD1, but make sure that the single record found is the one with the lowest value in FIELD2. For example, from the previous table, the filter would find this subset: Red 2 Green 1 Purple 1 any ideas?

I have to change the find script in a 100 000+ record inhiretted file that performs slower and slower. I found out that the script is searching on an unstored calculated related field. What or how is the best way to speed this up? Whatis the way to make that unstored field somewhat 'stored' at the search moment? TIA

Hi I want to find how many times a word appears in long text fields. Is there a way to create a script which will also return the result to a HOWMAY number field? I think I should create values, but as I want to do a loop the values should change in each turn of the loop copying the actual value from a field. I tried but I am not really able to do so as I can't make it work Thanks a lot

Hi All, I have a database that is doing bookings, invoicing and payments for my wife's medical practice. When a booking is required to transfer to an invoice, it's "Invoice" field is marked with a "yes" via a checkbox. I then perform a find for all bookings with a "yes" that don't have an invoiceID_fk associated with it and the results are what is used for data on the invoice. This all works perfectly but it is possible to invoice two different patients on the same invoice, which is occasionally necessary but generally not, so I would like to add an If statement to the found set to check that the related records have a unique patientID, i.e. all i need t…

I would like to display the record number in a sorted found set. 'Get(recordnumber)' seems to return the record number in the unsorted found set whether or not the found set is sorted. Is there a function that returns the record number in a sorted found set?

Hi all, I would like to set up a find on a db I have where it will find records with the most recent date. I have a basic database of training history, which contains CourseID, CourseName, NameFirst, NameLast, TrgDate. I would like to be able to find for each employee the most recent record for each CourseID. This will likely end up in a future script where managers could choose to view for one person or for everyone. Thanks in advance to this wonderful community. :worship:

I have some experience with Access and SQL but I'm new to Filemaker. I have a layout which shows a list of projects. One of the fields I want it to show is "total amount of paid invoices for this project up to the end of the last financial year". The invoices are stored on another table so I will need to pick from this table all records where "project id" = "project id" (this is set up as a relationship between the tables) and also "invoice is paid" = yes AND "date invoice paid" < start of last financial year. My question is how do I go about getting and showing that data? I can get a total easily enough, it's filtering out these specific rows that I'm having…

Does anyone know a way... where one user will perform a find... resulting in a found set.... then they share or email a link that will pull that exact found set to another user? I read about the "Saved Find" Don't think that would work here, because it is intended for only that user, and some of the find criteria we use is scripted to find related records through relationships.. so it can't accurately recreate the find. Thats why I just want to deal with a found set. Any ideas?

Hello hopefully someone can help me. I am trying to script Filemaker with the following script Go to Layout [ “Holidays This Period” (approval) ] Set Error Capture [ On ] Loop Perform Find [ Specified Find Requests: Find Records; Criteria: approval::time off email sent Yes No: “=YES” ] [ Restore ] If [ Get ( LastError ) = "401" ] Replace Field Contents [ approval::time off email sent Yes No; Replace with calculation: "No" ] [ No dialog ] Go to Layout [ “booking_detail_week_1” (booking_detail_creation) ] Show All Records Exit Script [ ] Else Enter Find Mode [ ] Set Field [ booking_detail::name; "Judith Fahie" ] Set Field [ booking_detail::booking_type;…

I am attempting to do a "find" using a global field that uses a checkbox. This field has mutiple choices which I would like to then set in the find field. Is this possible?

I have been using several "finds" on a regular basis that now all of a sudden have quit working. I use to be able to enter find mode and put ">0" in a balance due field and I would find all the balances. Several other similar finds (different tables) also no longer are able to do this same type of find on a Sum field (although they all worked before). Did something change in FM? Or what could I have done that would of changed this across the database?

Hi - hope I am posting this in the right place. What is the keyboard shortcut for go to last record in found set? (FM10) thanks

Hello everyone, I have a problem I can't solve on my own. I have the following relationships - a one to many relationship between occurence "Job" and occurence "ContractType_1" ; - a one to many relationship between occurence "Job" and occurence "ContractType_2" ; I am trying to set up a layout to display all of the ContractType_1 & ContractType_2 that have not already been charged to the customer. I have already succeeded in displaying these details but I had to display them on the same row as follows : Job::ID #1 ContractType_1 ContractType_2 Job::ID #2 ContractType_1 ContractType_2 ... What I would like is to display them on one …

On one of he servers I have running FM advanced server software, from one day to the next any query of a non-indexed calc field comes up with no results whatsover. Is this a resource problem, or...? thanks for your help!

Basic question: what is a found set associated with (or, "what does a found set belong to")? A window? A layout? A portal? A script step? A table occurrence? Same question about a "current record". Thanks Chap

I am trying to set up a Find using a script. I cant' get the selected search field into the find. Some pseudo code... Set Variable [ $SearchFieldSelect , Value:"Field_Name" ] #--- Field_Name Set by Calc (not shown) Enter Find Mode[] Set Field By Name [ Get ( LayoutTableName ) & $SearchFieldSelect ] #--- This does not work New Record/Request[] #--- Other Find stuff... Perform Find[] I tried adding the colons for the Table name with: Get ( LayoutTableName ) & "::" & $SearchFieldSelect In the Set Field By Name step, but that didn't work either. What am I missing? Thanks, SC

Contact records store their phone numbers in a related Phones table. While in the Contacts table I'd like a scripted solution for reducing the current found set to just those without any records in the Phones portal. Yes, the script could loop through each record doing a test for not isvalid(Phones portal relationship), store the current Contact ID in an accumulating variable, then do a GTRR on that variable's list of Contact IDs. Is there something more efficient that does not involve looping? I suspect there must be but haven't discovered one yet. Any ideas? Much appreciated

not sure if this is the right area where to post this...? I have created a summary field which is the average of one of the fields in my DB, say a price. I can produce a report which shows the various products listing the various outputs for this field and which shows for each product the summary (eg the average of the field in question). e.g. Product A summary: av price = 30$ shop a - price = 50$ shop b - price = 40$ shop c - price = 20$ shop d - price = 10$ etc What I want to do is produce a report which sorts the products by this average price so that, say, the product with the cheapest av price is first and so forth. It seems one can't prod…

Please, I am just looking for how to make something like a Journal database where all the journal entries are stored in the same table but when a user logs in, they can only access the records that they created. Do I need to use a script for this or does record level access work for this. I understand best with an example. Something super simple would work. Simple table with the following fields: ID CreatedBy Content

Hi guys, Hopefully this hasn't been asked yet. I am constructing a research database to track patient outcomes. The focal point of the database is the operations table, where patient survey scores are entered at specific intervals. Patients fill out surveys pre and post operatively to measure general health improvements. There are also tables for diagnosis and procedures, which are linked to the operations table through a joining table. A portal for each resides in the Op table. Now for my question... Each operation can be based off of multiple diagnosis and procedures. I need a way to perform a find for operations that have specific diagnosis and procedures, while…

Hi Guys, In a little bit of a pickle here. I'm trying to convert an old legacy system into a new filemaker solution. Ive got a checkbox field called categories which contains about 15 values. Five of the values are Former Pupil, Current Pupil, Former Parent, Current Parent and Current Staff. So if my users click on the check box Current Parent in find mode and perform find, they are getting records which contain Current Staff and Former Parent as well in the field. To get around this of course you do a search "Current Parent" within quotatation marks. If I wanted to keep the values the same for my checkbox, 12 year old system with thousands of records - is ther…

I have a need to display the content of calculation fields in find mode. Any input & brainstorming much appreciated! The only idea had so far was the following work-around: Set global variables with content from calculation fields before entering find mode, then display result of variables in web viewer in place of fields. Maybe it's because I don't know HMTL, but I wasn't able to format the text in the web viewer to fit in seamlessly with the rest of my FileMaker layout. Any other ideas/experience with this? Thanks!

Hi , i'm new to this, thanks for taking your time .. what i am trying to do is i have file maker 11 trial and have a database of about 50,000 names, contact info adress and so on .. what i want to do is search through the contact names in a fast way and group them all together on one list , for example .. i would search the database for .. joe, tim, kevin, bob , ray , and have all the results on one list ... the only way i know how to do it now is through find , add then request and extend found set but it is way to time consuming , also to write a script is it possible and how would i do it.

I am trying to found out the number of times a customer has signed in the last 30 days. I have a table named “sign_in” and each customer has an ID number. Any help to point in the right direction would be appreciated.

What is the best method of duplicating a found set of records? I have a found set that I need to copy and then assign a new _fk_ value to establish a new relationship. I've used the Copy All Records/Request script step but it doesn't seem to do anything.

Quickfind is a nice addition except that it just takes you to the record(s) the Find result(s) are in, not the field(s). Ideally, it'd be great if Quickfind (or a script) could find not only the record the search criteria is in but go to the field(s) and highlight the found criteria. (It's done all the time in HTML stuff but I haven't seen it done in FMP...at least that I'm aware of. ) So my question is, is there such a plug-in or script?

Hi all, In my student database, I want to find students who have enrolled in two or more subjects. If I do a find on the subject GOVT23 and "Add new request" to also find GOVT40, I will find any students enrolled in either subject. How do I find the students enrolled in both subjects only? Cheers.

Hi, I need to script a search function. There are 3 tables: articles (12'000 records) categories --< keywords (one to many relation) Now the user could choose a category and then the script should perform a search on the articles table with the keywords from the relationship. Unfortunately I don't know how to do this thx for any ideas by ChiSao

I need to find the most recent instance of a client's order record and return only that one. Order table could have zero, one or multiple (but more than likely never more than 50) order records. For those with multiple order records, I need to return only the most recent. I can do the find based on just the client ID. That's the easy part. Based on other threads I've read, I see that the script can sort the found set. The part I'm confused about is how do I show just the first one? Thanks Christopher

Hi, I am new here, and I've poured over the forums but haven't found a solution that works for my particular database structure. I currently have a event registration database. I have two fields called Start Date and End Date. I've created a display field that strings them together (i.e. "6/28/2010-7/5/2010") using a basic calculation. Note that this field displays as text in order for this to work. I'd like the user to be able to search for all events that either occur on a given date, or occur within a date range. I've tried setting up global fields, and I've tried writing a script that allows one to search the Start Date and End Date range. What…

So basically I am trying to display like records in the portal view based off the last name field as the user is keying. For example lets say there are three records in the client information database: John Doe John Doeter John Doeteritz As the user is keying D into the last name field it shows all three but as there are more characters keyed like doet, it would eliminate the first name since it would no longer match. Below is a screen shot of my layout but I can't think how I could create a like match using a relationship with possibly a wildcard. Please let me know if you have any questions and any help is greatly appreciated.

Hi All, this is my first post. I need to perform a find which includes over 8000 data ranges. How can I do this without entering each range individually?? I have an all the data ranges in excel already. Any help would be greatly appreciated

Hi all, I believe this may be a question directly linked to the fundamental concepts regarding the relationship graph, which anyone dealing with FM should, I'm guessing, know, but as I am technically speaking a newbie I must ask. Let's say I have an appointments table, with each appointment record having a 'Contract_ID' field which is linked to a 'Contracts' table. And then I have an 'appointments data' layout which is linked to patient data, clinic data etc. This layout is used purely for the user to browse and find. Now I want to export any unexported appointments, for each contract. But I ideally don't want it to interfere with any current found sets i…

I have a user that does not want the search results to not be resorted. She uses the add/request to build a search list. Because of other lists she needs to access, she would like the searched data to remain in the order she entered it. The problem is that the search seems to automatically resort. I don't have any sort functions scripted. Is there anyway to turn this sorting off?

Is there a quick way where I could locate all instances of a field used in all calculation formulae? e.g. I currently have a field which I update manually - called manual_value. I have now worked out a way to calculate this automatically but there are lots of formulae that operate on this field. Is here an easy way to find which one they are? Thx.

HI I'm new to filemaker and have a question. I have a database, one column is email adresses. I need to perform a find consisting of many email adresses. Is there an easier way to do this than manually adding each as a new request in find mode? Fx. I have 100 mail adresses, and want to find all entries in the database with these mail adresses. Isnt there a way to find seperated data ex. [email protected], [email protected] etc. Thanks Mikkel

This is going to seem very trivial, but my users have asked for it, so here goes: I have an opening script that searches for duplicate or incomplete records. Most of the time there are no records to correct. Is there a way to suppress the "No Records Found" message, and just exit the script if there are no records to display?

Does anyone know if i can group records by areas, for example i need to find away of finding out the details of and rough distance of each record or customers in my case next nearest geographical customer within the database, it would also be great to group records by geographical areas to so different sets of records can be given to different sales teams by area. thanks in advance.. Jamesd

Hello I am using ver. 10 advance of FMP. I would like to perform a find of only 1k records of a database of over 70K. If possible, I would prefer not to hard code the number but prompt the user for a number to enter. Thanks in advance for any help.

Hi all. This question is in reguards to formatting a find and omit request. My script: Enter Find Mode [ ] Set Field [ Departments:_pk_department_id; Administration_Billing::xrepeat_dep ] Set Field [ Jobs::year; Administration_Billing::xrepeat_year - 1 ] New Record/Request Set Field [ Departments::_pk_department_id; Administration_Billing::xrepeat_dep ] Set Field [ Tickets::year; Administration_Billing::xrepeat_year ] Omit Record Perform Find [ ] Now I would like to omit a second group but I'm not sure how. Would this be correct? My script: Enter Find Mode [ ] Set Field [ Departments::_pk_department_id; Administration_Billing::xrepeat_de…

Hi! Given the alternative, which is the faster way to find records when working on a server with pretty hefty tables: a) using a global field to set up an ad-hoc relationship or a scripted search in an indexed field using a variable?

In doing an XML export of data from my FM Pro8 database I learned that my data contains an invalid hexadecimal character 0x1a. From my research so far I learned that this typically happens when cutting and pasting some data in from MS Word or Excel. Now I need to find the character(s) in my data but I don't know how to search on this. I tried typing the character (right arrow) that the hex character represents, but it shows up in the search/replace box as a square (and didn't find the character when searched). Is there a way to search on a hex character? If not, is there a way to do a search/replace calculation that will act at the hex level?

Hello, I am newbie to this forum but not to FM. I am trying to improve a database I "inherited". When I try to find based on data in an aggregate calculation field, the find is returning all records in the table. Table A - Buildings (7000 records) related to Table B - Spaces (6000 records) Table B includes a number field called Size which is the square feet of the space. When in table A, I can find by size directly in a portal to table B. But I need to find by aggregated data from Table B, specifically a Sum() calculation. When I enter valid find criteria in the aggregated field, the find returns all records in Table A. I created a new test database wi…

Hello all, Is there any way to loop find requests based on a value list? I essentially want to run a script based on multiple finds, but separately. If I have a field, FieldA where the in the values are 100, 100, 200, 200, 300, I'm looking for a way where I can loop a find request as a set variable so that the script would be like this. Set Variable[$var; Value:Table1::FieldA] Enter Find Mode Set Field [FieldA;$var] Perform Find Perform Script[script] However the "100" would loop so that then next find would search for "200" and so on. The long way would be to manually script out each value individually, but can a variable be used to loop thi…

Hello, Thanks in advance for your help. I have teacher making evaluation records for their students, they should only be making one per year per student. That's great if they do it correctly, but they are not. They have any from 1-infinity. How do I limit them one per student per year? My search is based individual school, school year and other various criterion. I have no marker to exclude these bogus records, now how to identify them as bogus records. Can this be done in FMP? Or is this an administrative problem?

On my layout I have a drop down menu that displays values from a value list. Currently I can go into find mode select a choice from the drop down, then hit the perform find button on the FM toolbar. I want to mimic this with one custom button. I would like the user to select their choice then hit the custom find button. (Status toolbar will be hidden) It seems like it would be easy but I can’t seem to get it to work. Thanks in advance

Hi, I am trying to use a check box to omit records from the found set within List View - Browse. I have the user select the search criteria from the Form View (Main Page) by clicking the "Find Button". Once the find criteria is selected, they perform the find, then click a "View Commission Report" button which takes them to a List View of the found records in Browse Mode in a new layout. A check box appears next to each occurrence of the record of the found set called "omit". The theory is that when "omit" is checked, it will remove that record from the found set, "refresh" the list and re-present the amended list on screen. This would continue until the…

My users send bulk email to clients. When they receive an undeliverable notice in reply, they enter find mode, paste the email address back in the field and return the find to find out who belongs to the email address. That follows what they have been taught about performing finds in Filemaker. Unfortunately the search always comes up empty - I think because Filemaker reads the @ as a single wildcard character. The email address is actually there and "Find matching records" works fine in the field from browse mode. It also works works if you precede with == but that then rules out part address finds. It works if you put " " around the @, and it greatly n…

I know you can do a find for a range, but is there a way to do a multiple find without duplicating the request? Lets say I want to find the job ticket records for jobs 801, 803, 811, 815, 833. Is there a way to enter as a single find request or do some other time saving method? thanks, Jim

I have a Find command with 2 set comannd looking for word 'Large' however it counting 'X-Large' Dose this have to do with the - char I have set my Find to == Then I get a 0 foundcout? Code image attached Thank

What kind of Find.. will put me at the first record of a,b,c etc? My idea, I have a 26 hot spot button... if I click on M, i go to m in the records..

Hi. I'm very new at FM and haven't touched a DB in years. I'm also pretty sure there's something wrong with the way i've set up my tables so any and all help is appreciated. First table has two fields: Date of approval (1) PK (This is a unique value) Class type (1) (This is made up of recurring values) Second table has a whole bunch of fields but the ones that are relative are: Date of approval (2) Class type (2) (Neither of these are PK) Now, ideally i would like: Class type (2) to pull all the values from Class Type (1) as a drop down; Then, once the Class Type (2) is selected: The Date of Approval (1) associated with…

We keep inventory for a bunch of different labs. Some of what they are working on needs to be hidden from the general public. I created a checkbox field named hide that I wanted to write a script so that when the generic username is signed on, will not be able to see those records that are checked yes in hide. I wrote a script that does the omit but my problem is what if they show all records or do a new find, then they will see those records again. Is there a way to hide checked records based on username only? Thanks.

I have a task list that works very well... we each create tasks for each other, when a task is done we check complete and it no longer shows on the list based on a find script. But now, I would like to add a date field, so that you can have the task not be found on the list for a time, but then be found later, for example: the task "disappears" to the user for a day, then it "shows up" on the list again the next day as a reminder to followup. But all the other tasks still need to show indefinitely until they are marked completed. What is the best way to make this happen? I am already using a refresh button to run the script, so I am assuming it would be …

I'm trying to return data for a given date range. I have the following setup gDateStart [global date field] gDateEnd [global date field] I declare a local variable called: $DateRange I set the variable as so: SetVariable [$DateRange ; gStartDate&"..."&gEndDate] I then set the field called "Date" to $daterange and preform the find, like so: Enter Find Mode [] Set Field [ Date; $DateRange ] Perform Find [] This works when I run it from my local machine - but when the client runs it in a hosted environment it doesn't seem to assign the date range to the local variable and returns all records. It is very frustrating …

I have 25 fields (text) named Material, Material 2, Material 3 etc. I also have 25 fields that are Tonnage 1, Tonnage 2 etc (number field). I need to find a way to extract specific information in a find request such as "A gravel" from an employees daily deliveries but they may have also delivered B Gravel or Stone dust as well which would be listed in the other material fields. How can I find and extract only the A gravel so I can get a monthly summary of how much A gravel they delivered. I am using FMP 7. Any help would be appreciated.

I have Customer::Agent as a text field and Job::Job Number as a number field (next serial number) These fields have worked for years. Now we began to use the Agent field. So I created a new field, CompositeJobNumber. Calcualtion: If (Customer::Agent = "AB Note" ; "AB" & Job Number ; Job Number) It will not allow me to store, so finds take 5 minutes vs seconds. I need a better result. Using FM10 with FM Server9 adv. thanks Jim

I have my master layout that shows prices. New prices are added to the pricing table and old prices are saved. I need a calculation that will fill a checkbox when a price is changed in the related table. I can get it to work in the current table, but not a related one. Any ideas?

tryng to sort a set. I haved a record lets say book title each, each title has a number of issues. I will have multiple book titles each with its own issues when i list now i get all titles and issues but want to just define my list to show only 1 title and related issues. Any ideas to get me started? Ive tried sort lists, summary fields no luck. Thanks in advance Lesjoko

I'm having a problem trying to find on names containing the Scandinavian 'ø' character. On FM6, this was treated as a match for a regular letter 'o' (i.e. a search for 'Hof' would return both 'Høffer' and 'Hoffmann' in the found set). We then upgraded to FM server 8 and client 8, and the character was treated as a distinct letter (i.e. you would have to remember to search for 'H*f' to be sure to find both names. I couldn't find a solution for this at all, and I wasn't sure whether it was occuring at the level of the field, file, application or even the OS (Windows Server 2003). The problem disappeared when we switched to filemaker server 9/Client 9 (agai…