Finding & Searching

Hi, I have 2 tables. Orders table and Template table. Orders are created every issue from template table. But the customers can modify the order for that issue. Both these tables are related by issue ID. I want to create the the report to campare the total count of actual order of booklets every issue Vs the count of booklets customers are supposed to order. When I place the summary fields from both the tables in sub summary part on the report, it shows the total for just one table, the other subtotal is the total of last order. How can I get the subtotals of both the fields? Please advise. Thanks for your help.

I understand that I can put a search string inside of double quotes and it will match the phrase from (word start). Is there a way that I can search for a string such as "ing" and find all records from word end" So it would return: biking hiking running but not: ginger mingle singer

Instead of finding records within a fixed range 03/16/2011...03/30/2011 I want to find based on variable dates, so that I have a set that always shows me dates in the upcoming two weeks //... //+14 doesn't work >=// AND <= //+14 doesn't work Thanks for the help

Hi. I want to find records from my DB which fulfill certain criteria then paste the quantities (number of records I have) of different segments which I can then import into a graphing program to graph their distribution. For example: I find 1000 records. These are all one product but over the years, say 50 of them have cost $10, 70 cost $12, 90 cost $16, 120 cost $21 etc etc until we have 1,000. I want to obtain the numbers e.g. 50, 70, 90 by segment e.g. $0-10,$10-15,$15-20 etc etc. What is the best way of doing this? At the moment, I can sort of do this manually. e.g. I can find the product I'm interested in, determine the range e.g. >0<10 and I have a s…

Hi everyone, I'm not entirely a noob at FM -- in the past I've manage to build some sophisticated databases. But now I am up against a unique challenge where I don't even know where to begin. Here's the scenario. I have a master list of 200,000 people in my FM database. I have a second list of 10,000 people I have contacted that have responded to me in an excel file. I need to search each of the responders email addresses against the master list -- each contact has an email address in there. I want to look up each of the responders on the master list - find them all, and then enter a value into a specific field - i.e., the date into the D…

I have scripted a calculate a median value but looked everywhere to find interquartile calculations. Does anyone know where I would find one? Thx,

Hello guys, (FIND MODE) I have a question: if i select the year 2010 in field (1. Year) i want to show only the activities that was in 2010 in the field (1.Activiteti) How can i do this? I have attached a image. My question is based on Find Mode Regards, Serhat

Hello fellow fmforumers! I manage a database with two tables, one is the customer table, and the other is orders. They are linked together by customer name. Now, I have setup a search where I can select two dates, and list all orders placed in that date range. That however, gives me a long list of all orders, with the customers name on them. What I would like is just a list of all customers who placed an order in that time period with an order count next to it. I cannot wrap my head around how to do this, so any help would be appreciated!

I don't know if this is possible but I was wondering if anyone has been able to figure out how to do a Constrain Quick find. I have some records that are related to a group of users and the rest that are not. When I perform any kind of search script, I put a set field that adds the restrain to it. Since a standard perform search function in a script has to have all fields return records, it works fine. But I have noticed that the quick find function goes across all records in the table. I tried to perform a regular find with the set requirements for the user then the quick find but that still jumps out. I had also moved the quick find to the top of the script then perform…

I am trying to develop a script to generate a report. I need to allow the user to select a specific TERM (i.e 201110 is spring of 2011, 201120 is summer of 2011) I want this find to remain flexible so any term can be entered (this part of the script appears to be working). I then need the search the SUBJECT field, which allows for specific entries (i.e ED, EDSP, EDIM, AUT, etc. We have approximately 10 choices, which can be entered in this field. Problem: I want to allow the user to find the term and then allow the script to extract (5) of the (10) choices in the SUBJECT field. For example, I only want to report on ED, EDSP, and EDIM and not include the other it…

This is probably a very easy procedure, but I can't seem to figure it out. I have two tables: clientInfo and projects the two tables are linked via the field clientID I would to list projects between certain dates, eg, >1/1/10 and <12/31/10. I did this using search of the start and end dates of the projects to generate a subset of projects that were started and finished in 2010 How do I get this subset in another layout which lists the clientinfo? Usually, all i have to do is switch between layouts and the subset info is maintained. But then I switch from the projects layout to the clientinfo layout, the subset info is not carried along. …

Hi, I am simply trying to find the count of Salesmen that have so many sales for the month. I just want the total count of Salesman, but to ignore the sales they have made. I have 10 Salesmen ( and Women ), who have made anywhere between 2 to 10 sales per month on specific items. When I do a find, I just want the total count of Salesmen and not the 5 to 10 sales they have made. Salesmen ID= text field Items = text field Item price = number field So for the month of January my layouts look like this: Salesman 0100 Item 1 - $50 Item 2 - $30 --------------- SubTotal Sales = 2 items for $80 Salesman 0200 Item 1 - $40 …

I have two tables, one of which is ids with names, the other is a table of actions completed by said names. I currently have a relationship defined between these tables by id AND name, and in the actions table, there are a series of lookup fields depending on these relationships. However, I want to be able to enter an id _or_ a name in the actions table and have the relevant lookup fields lookup the information. If i have this relationship defined by both fields (with the AND), neither will look up, but then I can always configure the relationship to do one, but not the other. How do I get what would otherwise be OR functionality through this relationship lookup? Tha…

Hello, Can someone please please please help me. If I had hair I would be pulling it out right about now!!! I have a succesfuly written a script which constrains a set of data to one particular order type IE: Quote from four possible order types (Quote, Invoiced, Reservation and Hold). That part was easy. Now I want to further constrain that list to those orders that fall within a date range, specifically from Today's date to Today's date plus seven, basically omitting records which fall outside that date range. I need to be able to do this from within a script, with no user input, and without dialogue. Essentially what I am trying to do is prod…

Hi everyone thanks for any help in advance. I have 1 table Members which contains the usual Name, address etc I also have a DOB field and have been able to extract birthdays of Members for each month into a 'Saved Find'. How can I use the saved find results and move them to a new table called Birthdays. I have created a new table called Birthdays but can't find any way of moving the saved files I would also like to just have 1 field called name instead of the fname lname that I have in the Members table. I hope I have made sense with this post. wali60

Hello, it's been a long time since I've done anything complicated with FM and now I want to do something beyond my level. There are several possible ways to accomplish the goal (perhaps a combo of search, relational db, calculated fields) but I can't seem to even get close. That said, I have an existing database but I'm willing to start fresh and approach this in a different way to reach the goal. I have a database of students with their various information, including their top 10 preferred advisors. Example: student_name advisor1_name advisor2_name etc I would like to have a list of all the students interested in working with an advisor, but listed acco…

Hi everyone, first of all I apologize for my poor english. second is that I am new in FM. and here is my problems: I have a list layout with a global field included custom value list and shows as a drop-down list. It works perfectly in the browse mode, but doesn't work in find mode. I checked the Data Behavior in both browse mode and find mode. my other problem is that I am looking for a script which find the related records for each item in value list and save it in a excel file. Any suggestions would be appreciated.

Can someone please help me? Just started to dig my feet into filemaker and so far I'm impressed. I want a simple find query. On my main page, I have a blank layout with buttons that say FIND SH. I'd like that button to find in my "Location field" "SH". I experimented with a script using various ways on the forums... Some worked but the problem is that it never clears the old search. Example: When I click the button FIND SH, it finds SH in the fields. When I go back to the main page and click the button FIND HO, it shows HO and SH. I just want to show HO and NOT SH. Thanks again for your time!

I have two tables one called customers, one called contacts line items, related via the customer id field. The contacts lines items table records all contacts that I have with the customers, and contains the fields: customer id, contact id (serial), date. In the customers table I want to have a field called 'contacted this week', where if there is a record in the contacts line items table, that has the customer id & a contact within a specified range (within the past 7 days), it will return yes, and if there is no such record - ie, no contact has been added within the past 7 days, then it returns no. What would be the most viable way of doing this? …

I am creating a database that uploads our automated meter readings and then I want to display on a layout all of the accounts that the reading did not come through on. On my attached image, I show a field labeled KWH. This is the meter reading. I'm trying to build a script that searches for all records that are in the book BB1 and where the KWH field is blank. The KWH field is a record from a related table. Anytime I put the find in for the KWH field and run the script, I get 0 out of 101 records found. I know I'm missing something, but I'm a FileMaker newbie and I'm stuck at this point. I've tried using the = sign and even creating a match record field and finding…

I have a button linked to a script that lets me scan a barcode or type an inventory number to quickly find the specific inventory record. I would like to speed up my searching by automatically inserting my required parenthesis "()" at the beginning and end of the 4 digit number I scan into the custom dialog box I set up. How do I do this (what function(s)) should I use? My inventory numbers are all 4 digit numbers (no longer or shorter) and start and end with a parenthesis (so it's barcode scan-able when printed,) they use this format: (1234) My current script is: Enter Find Mode Show Custom Dialog (Search/Cancel Buttons + 1 Field) Perform Find PS. If …

Hello, Can anyone advise please, in Filemaker 11 is it possible to create a find script to find "similar" records in a set ? An example would be that I have 100 records and i want to find every records where 50% of the data entered is the same. Many thanks for any advise offered.

I'm trying to export stock and options symbols to excel where I can lookup current values and then update values in filemaker. I've got it working pretty well accept for the options symbols. An example options symbol is .ZUMZ\11E21\32.5 I have yet to do a successfull search for this value. I've even tried going to the record, copying the value, entering find mode, pasting the value right back in the field it just came out of, and performing the find. I always get "No records match this find criteria". I'm assuming it's the presence of the "\"'s. However I have to have them in there in order to find the current values in excel. Do I have to do some …

Hi, I have a unique problem that I hope someone could help me figure out: In our database setup, we have a containers database separate from our main database. We have successfully linked the 2 and can store records to the Containers database from the main database. Just up until a couple weeks ago, everything was working just fine. However, now when trying to pull all containers related to a certain entity, it fails to search the Container database. When I saw this, I opened the containers database and manually tried searching for data that I knew was in there, though it still says "No records found". I have indexed my primary keys and can see the data, though…

Hi all, I'm using FMP 11 and 7 I have two layouts in my database, one called Browse, one called List. Browse only has browse mode, List only has list view. List only shows a few of the fields available in Browse. For example the NOTES field is missing. When I do a find in my Browse layout using the top right search box in FMP11 then it finds every occurrence, no matter which field it is in. If I do the same in my List layout then it does not find records which have the search term in a field which is not on the List layout (like NOTES) Is there a way to make it search through the NOTES field as well? Or is find restricted to the fields …

I just came across this issue and was using FileMaker 10 and 11. I have a simple database setup to record billing information and when I went to do a billing report, a simple find, one of my records for the given criteria was not coming up in the found set. I searched for a specific date range and a record within that range did not come up. I even tried searching for just that record and that fails. I've duplicated the record and the newly duplicated record act the same way. I used the recover option and recovered the database and although it didn't come up with any errors the record now shows properly during the search. Here's what I'm using: Database hosted …

I have a table which has certain $ values for the data. The data is collected at different dates. So for example: 12/3/2007 black t-shirt $4 1/1/2008 black t-shirt (they're not all black - let's say there are 50 different products) $3.9 2/4/2008 black t-shirt 4.1 etc etc etc I want to find an average value for ea. qtr and then compare it to another qtr. So, I have written a script which creates a report for calculating values for any qtr. But I don't see how I can store this data and then use it to compare to another qtr - say, qtr 1 in 2007 to qtr 4 in 2010. The other complication is that some products may be deleted during this time, and others may come al…

Thanks!

I'm in need of a script to search for records in one database using data from a field in a second database.

hi everyone, i'm working on a search feature that would set a field with two different values (either A or , but the script didn't seem work.. Here is my script- $omitHHnoLetter is a check box field If ($omitHHnoLetter="Omit HH no letter") set field (babies::letter = "Yes") set field (babies::letter = "Letter sent") end if The script is recognizing the second criteria (the second criteria seems overriding the first one) So is there a way to combine these two criteria to make both of them valid for the same search? i really am looking for records with the "letter" field equal to Yes or Letter sent. i tried set field (babies::letter = "…

Greetings, programs. I have been using FileMaker since version 3 for all my daily database needs: contacts, invoices, mail archives etc. I always get the results I want, but I usually "stay on the surface", using basic features and simple scripts. Now I am trying to solve a problem that may be too complex either for FM or for me; but I suppose it's the latter. Maybe an experienced developer can tell me if what I have in mind here is possible. My main business is (technical) translation from English to German. Like most translators today, I'm using Computer-assisted Translation software (see http://en.wikipedia.org/wiki/Computer-assisted_translation ). A tr…

We use the database for all of our donations received. I need to do a query that shows the donors given in between a date range (example: 1/15/2010-7/15/2010). I have been able to figure out how to get the totals from each members donation but I have not been able to figure out how to filter the data down to certain dates not for their entire donation history. I am not sure if I should be doing it through a report or a script or via managing the database? We use to use Access but converting the queries over to File Maker Pro on a Mac has proven to be a challenge. Any help would be amazing. Thank you so much, Anne

I'm using a portal that shows not multiple related records, but a summary of data for those related records. There is only one row of data and that data consists of summary and average fields in the related table. What I'd like to be able to do is create a button that allows the user to drill down into those related records in a list view. I'm having trouble though finding the most optimal way. The portal is currently using two filters to thin the data further. In essence, the find would need to be for those records that match the parent record as well as the two filters. Any help? Did I explain that ok?!

It seems that this should be simple, but I'm stumped. I'd like to find a list of records, and then narrow this find down to those records that do not have a child record in a related table. Any suggestions?

My database stores all of the notes for a record in a separate table from the record. In this table, there are 2 fields that record the date the note was created: Date_Created - AutoEnter Creation Date, prohibit Modification TimeStamp_Creation - AutoEnter Creation Timestamp The TimeStamp_Creation field is displayed on the note along with a text entry box for their note. We have purposely left the TimeStamp_Creation field modifiable to see who is actually changing the dates (which we were unable to do in our last system). What i would like to do is create a report to show those notes which have been changed, but i am having issues with how to perform …

Im having a rather strange problem. Whenever i enter search mode on my layout, whether from a script or directly it works fine on all fields except one. When i press enter to execute the search nothing happens, i first have to click on the layout (which makes the search glasses in the fields disappear) and then hit enter. The fields are not global, calculated or containers. It is indexed. Field entry is enabled in both browse and find mode. Im using filemaker pro 11 advanced. Any advice will greatly appreciated!

Hi, I'm looking for a solution to find a 'pattern' in a string (not a value!), and then substitute it with another value. This substitution should be done through a script. Practically, the string looks like this: "99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999 99999" Each of the 9-s above represents a number from 0 to 9. Each group contains 5 numbers. I use this string (=field) to link this table to another one. I would now like to limit the found records in the related table, by 'voiding' those lines in the string above that contain more than 3 groups of 99999-s. The result-stri…

Hi guys, In my database of 160 contacts, I performed a search to find certain contacts and the results yielded 101 contact which is correct. However, is it possible to create a group from this found set? I'm wondering this as I don;t want to have to create a group and click on every name to add them in..? I'm a beginner so any help is appreciated, cheers. Carl

I wanted to script a Find button for a solution I am writing. I found the following in the Help section of Filemaker pro 11 Set Error Capture [ On ] Enter Find Mode [ Specified Find Requests: Find Records; Criteria: ClientDatabase::LastName: “Enter Last Name then press Enter Key” ] [ Restore; Pause ] Perform Find [ ] If [ Get ( LastError ) > 0 ] Show Custom Dialog [ Title: "No Records Found"; Message: "No records were found. Click OK to modify your request or click Cancel to return to Browse mode."; Buttons: “OK”, “Cancel” ] If [ Get ( LastMessageChoice ) = 1 ] Modify Last Find Else Enter Browse …

Hi, this is my first post, please be kind. LOL I would like to ask for help regarding Find Scripts. I need to find records for a certain value from a value list. Unfortunately, I don't know how to execute a script that asks which value from a value list, I want to have the value list "pop-up" in a window (i've seen it somewhere but i couldn't remember where). i'm really not familiar with creating find scripts, only with simply execution. Thanks in advance!

I'm just curious as to the difference between the two scripted find methods that I have found while browsing example files and demos in Filemaker Pro. The first method I was exposed is: Enter Find Mode [] Set Field "Fieldx" (Find Criteria) Perform Find [] vs. Perform Find [RESTORE] Taking in to account a fresh found set, is there any difference between the two? The second method seems cleaner to me but it seems less used than the first method.

Is their a way to put saved finds(new feature with ver 10) on a layout? I am using FM Pro 10 adv. Jay.

Hi there I am a complete novice and i am reading a teaching myself the in’s and out’s of filemaker.. I am using filemaker pro 11 and what i am trying to do is: I have designed a front page where all my icons are connected and scripted to other fields in my database.. The problem I am having is, writing a find script so, when i enter a text in a find field on the front page it performs a find and pulls up all the information from the file and shows the database information.. .. In other words, i am creating a find field which relates to another find field... I hope that makes sense!!!.... In my language!! I have a front page, and it looks nice. I have a one rec…

I need to write a FM program that will keep track of people coming in and out of our office. We have a card reader that automatically enters name, address, etc into the specified fields. That works fine. The trouble I am having is this. I have assigned every entry a status to 0 I also want to keep record of every time someone checks in and out. So if the status = 0 they are checked out, and if status = 1 they have checked in. It's kind of like a time clock that I need to build. So what I was thinking was: 1. Scan card 2. Find to see if that person has already checked in that day 3. If they have checked in, message saying you have already che…

This has probably been done over a billion times...I would ask my 9 year old but he is in school. How do I find 2 invoices lets say inv #'s 2399 & 2749 at the same time. Any suggestions would be appreciated. Jay.

I work for a small arts council and am creating a task database to manage a parade of volunteers and staff. My task records all have a due date (usually calculated). I can't believe I haven't been able to successfully write a find script that gathers tasks due in the next week, in the next month, and so on. I presume one starts with today's date and creates a range that includes today's date plus a number of days, But I've done the "// + 7" thing six ways from Tulsa and can't get it to work. Thanks in advance for stopping a relative newbie from thrashing about.

I'm returning to FMP after a couple of years and am having real trouble getting back up to speed. I have a table of DNA sequence data (just simple text strings 700+ chars long, no spaces) and another table with shorter sequences (<50 bases). I want to know the number of times the shorter sequences are present in the long ones. Patterncount works really easily most of the time but some of the search strings contain wildcards so I need to use Find but can't work out how to loop the search all the way through and sum the answer. Thanks.

Following on from this:- http://fmforums.com/forum/showtopic.php?tid/217835/ I have a table containing several thousand DNA sequences (single strings of ATCG) and I want to search for the number of times any short string of ATCG occurs in the DNA. Thats all sorted for using pattercount. Now though I want to create families of the search strings (containing maybe <50) and get the total number of pattercounts for the family. The families can be in Value lists or as separate tables for each family it doesn't matter. After some searching I tried:- PatternCount(text;List(Family1::Searchstring)) where the search strings are in a related table but this…

How do you find on a summary field? When I go to find mode, I can't enter the field. What am I missing? thanks Christopher

I've seen this done in a free training workshop at rapid speed (no longer on line, of course), but can't seem to replicate it. I'd like to use an auto-complete value list to go to the related record(s). For example: Table 1 has the field "last name." In the record Header, I'd like to have a "find field" with a value list created from "last name" set on auto-complete. Ideally, after each letter is typed into the "find field" the current layout will go to the record(s) that is related to the entry in the "find field." I'd even settle for the "Go to Related" script only operating when exiting the "find field," though that wouldn't be as slick. I've tried …

Is there a way to detect that the user has pressed the cancel button after entering Find Mode? I need this, because before entering Find Mode, I switch to a special layout, so I need to switch back to the original one. One solution could be to set Allow User Abort to Off, but I would like to give the option to go back to browse mode. So if I set this to Off, I would need an extra "Cancel Button" on the Find Layout. Is there another solution?

Hello guys, Currently I'm working on my first FM (FM9) project: updating a old FM5 solution. Right now the users are still performing some operations through the status area but I want to hide it in the version I'm working on so I need to implement a finding feature. I have already used the find steps in my project but usually with only 1 parameter (for instance to find all the document with a specific expiration date). My question is how can I implement a complete finding feature? I mean I want to have a layout with a dozen of fields and the user can input any combination of those and when he/she clicks a button I want to return him/her the list of the records t…

Thanks to help from foristas, I can now produce a found set (usually about 40 people) from a file of 2500. I now want to summarise data on some of their characteristics. When I do Count of Surname, for instance, the result is always 1. And when I do Average of Age FMPro averages all 2500 ages rather than the 40 in the found set. So: how do I find documentation on restricting summaries to a found set? It doesn't seem to be anywhere ... With your help in the past I'm getting somewhere, and enjoying the results: thanks. jd

So I have no idea how to write a script and I need to make one for my work so heres the idea maybe someone knows. We have tapes that can either be checked in or out (theres a button to click for "check in" or "check out" then the "status" would be set to either Available or Not Available. Every tape has its own barcode on it and we can scan them into the search bar to find them, but then you have to click check in for each one. When you have 10 - 20 tapes to log in it makes it a little more time consuming. I am trying to find a way so that when Im checking a bunch of tapes back in I can run a script and then scan each barcode and it will automatically be checked…

I have a database with clients and each client has a "Notes" field that contains notes from a conversation on a particular date. Those notes show-up in a portal on the individual client screen - the Notes field is contained in a related table "Client Notes". My goal is to combine all the individual notes for a particular client number into one field for export to a separate text file. I have 2 thoughts on how I can achieve this. Option A: 1. Perform Find to retrieve all records for a particular client number within the Client Notes table 2. Go to first record 3. Select and Copy contents of Notes Field 4. Go to "All Notes" Field <===created to…

I need to be able to copy an entire record from one file maker data base to another or somehow easily flag certain records without creating new data fields. Someone please help./ thanks so much

[color:red]Whoops...I figured it out. Thanks anyway. I have a field called ConferenceDate. Is there a way in "Find" to request current date and future dates only? I thought it would be simple, such as greater than or equal to current date, but I can't figure out the syntax. Thanks, Kevin

Hello - it's been a while since I used FileMaker and I've recently begun several projects in FMP11. Back in the day (somewhere around v. 5) I had some script steps that would select a form layout if a find only returned one record or a list layout if the find returned more than one. I've been through the script steps a number of times and can't remember what I used to do this. Any direction would be appreciated. All I really need to know is that the found set is > 1. Thanks! Grant

I am very new to filemaker - so please excuse the simple question. All I want to do (and I don't want to use the Find View) is to have an empty text field that a user can type in some text, and hit a search button on the page - which then searches accross my single tabled database in a field called items and goes to a list view of these items. I just can't seem to work it out. Thanks for your help. Regards, -FJ

I have a categories table that is related to multiple detail tables. Each detail table contains multiple records based on the category selected. On my layout I have a popup field where the user selects a category and then it changes to a layout that has the popup field on it along with a portal of the records from the detail table. All the portals for each of the layouts (for the detail records) are basically the same and contain only one field - a description field. I'm trying to add a Find option so they can type a word in the description field and then display only the detail records that contain that word. Is it necessary to do a portal filter i…

I need a very simple step but i just cant figure out how to do it. I have a field called NAME with the following value: johncartreehouse in a calculation field, i want the value "true" if the word car is found in NAME can somebody tell me how this can be done? i tried many things but i cant figure out how to search for a string of text. Thanks in advance!

Hi forum, I have been working on a script which performs a find, however sometimes there aren't always records to find so an error message is displayed. (the one that says "modify find or cancel") is there a way to disable this error message

I have a large DB to which another DB refers to pick up some data. THE DB is however full of dupes - e.g. shirts,blue,small shirts,white,medium shirts,grey,large, shirts,blue,small etc How would I find all the records which contain: shirts,blue,small (let's say there are 50 of them) and then keep just one of them. Also, assuming there are 2,500 different products e.g. shoes, t-shirts, ties etc - how can I do it for each product automatically without doing a separate find and delete each time? I can find the dupes (using !) the problem is it finds all of them. So, even if I omit dupes then I have none left of any one record.

Hi all, I am trying to get my list view layout, on layout enter to display the current record at the top of the list, even if records exist either side of the current record date. I am sorting the records via date ascending, but there's nothing to tell the list view layout to display the current record at the top of the list view window. Any ideas?

Ok, so admittedly I'm not sure what to even search for, but have been looking for a while at the forums without any luck (likely because I don't know the correct keywords to search for). I have a table which stores ID, last_name I have a field which I would like to display the current stored ID name. This works just fine. What I would like however, is the following added functionality: Should the user click on the box, they could start typing the last_name of the individual, and it would suggest names based on the first few letters the user is typing in based on names that already exist in the database. Is this doable in FM? If so, could someone ple…

Hi, I have a table with 2 fields (sales rep 1 and sales rep 1). Now what I want to do is when a sales rep logs in, he only sees his sales when he is listed as sales 1 OR sales 2. Now I noticed that in the script editor when you use a perform find / enter find mode and specify there that is shows Field Criteria a =d AND b =c so is there a way to work with an OR ?

I have an unusual find that i need to perform and i'm not quite sure how to perform it. a little background. We converted our old system to filemaker rouhgly 2 months ago. The old system contained one big text field for each record that contained the notes. It also contained a date field for when the record was created. When i did the export from the old software, for some reason on a few records it did not export all of the notes. So far i have only found a few records but am unsure if there are more. Since 99% of the time there was a note entered the same day the record was created, what i would like to do is: Perform a find on the text field to see …

My goal is to click in a field, and end up in find mode with the cursor in that field, type a request, and hit enter to perform the find. So far I have created this script launched by the field: Set Variable [$Fieldname; Value; (Get (ActiveFieldName))] Enter Find Mode [] Go to Field [] -"it is here I want it insert $Fieldname" What should I be doing?... Thanks in advance

Today I discovered that a find script that I've been using for years is suddenly not returning expected results. Our database tracks our company's orders, payments, etc. Occasionally I run a script that searches for invoices whose total due is greater than 0. This is result I got when running the script today. I knew it was messed up because a) the first line with a zero total was returned and : other invoices that I knew were unpaid did not appear. And when I do a manual search for either 0 or >0 or 0 and omit, in every case I don't get what I expect. Why would a search for "0" include "396" and "1971" and "2895.75" for example? The database is se…

i have a simple questions that i cannot find an answer to despite extensive searching. I need to jump to the same record in another window. Currently i do it as follows: in windows 1: Set variable [$current; Value:Get(RecordNumber)] - in windows 2: Go to Record/Request/Page [No Dialog, $current] This however does obviously not work when the sort order of window 1 is different than windows 2 the recordnumber will be different. So i was wondering can i use recordID instead of recordNumber? How can i use the Go To Record function using a RecordID? Thanks in advance for your help!

I have a large DB - >200 records. Some of the records relating to one supplier are not actually dupes but records that should be grouped as one entry or anyway identified and perhaps copied to another DB whilst deleting them from the current DB. Example for a std record: Supplier A, Sale ref, Sale date, Item ref, description, cost, colour and size. Usually these are unique records but for one supplier in particular a record might look like this: Supplier A | 0909 | 8/31/10 | 388 | T-shirt | $40 | Red | Medium Supplier A | 0909 | 8/31/10 | 388 | T-shirt | $40 | white | Medium Supplier A | 0909 | 8/31/10 | 388 | T-shirt | $40 | blue | Medium If I look for d…

Hey Guys, I'm an amateur so if my question isn't phrased properly or I don't use adequate terminology please forgive me. They want me to make a script that will check if a specific user-group (defined by an "is=1/0" field in the user records) and message those that have orders that require attention. "Orders" includes a "salesperson" field that's the same as "user_name" in "Users". I'm going a bit cross eyed just describing it so again sorry for any misunderstanding. Any help is greatly appreciated.

Hi Everyone, I've got what I hope to be a quick question with a relatively simple answer. I'm new to FMP so this may be easier than I'm making it out to be. What I want to do is set up a layout that will calculate purchase order prices based on quantity. I've got a table of part numbers with the respective "price breaks" per quantity. For example a qty of 10,000 units might cost $2 per unit, qty of 15,000 = $1.50... etc. The problem is that the price breaks are different for each item number. Where item "A" may cost $2 at 10,000 units, item "B" could be $10 at 10,000 units. I need to be able to input a quantity and have a calculated field (or script?) that will …

Hi For some reason some of my fields in my 3000 odd records have spaces at the end of the data. The text in the field may or may not have spaces in it. How do I ONLY remove the space that is at the end - some of the fields will NOT have a space at the end of course. I tried manually but it is taking ages -) Any ideas gratefully received

I have a layout that shows single record sets from a table, including the name of the record set. I need to create a drop down list on the layout with the names of the individual records so that I can select a recordby its name and get the layout to display that record. It should be simple, but I can't do it. Can anyone please help?

hi everyone, In SQL based db's, I'm able to perform a "loose" query by appending e.g. %taxi% and consiquently get an entry containing taxi in it (e.g. w10taxi or taxiAirport or parcelTaxi). How do I do this in FMP? (I've tried ~taxi but this appears not to work) thanks in advance Giles

Hi, I have a very simple calculated field which just does Sum(someOtherRelatedTable) and the field shows the correct number But I can't do a find eg: >0 on that field... it just says no records match. Any reason for this?

I have a long stream of based text that I need to parse information from. eg:- 0 This is a record 123 1 This is another record 456 . . etc.. I need to extract the data 0, 'This is a record', 123 1, 'This is another record', 456 . . etc.. My thought is to put this text in a global field and then perform a find/replace style find within the text field, searching for the tag, setting a $start variable to ActiveSelectionStart +4 (to get to the start of the text jumping over the ) Then searching for and setting $length to ActiveSelectionStart - $start. It should then just be a case of using the Middle function to get the text an…

Hi I have a inventory file... and as thing fill up.. or sold and not used... wondering if there is a way to tag & hide the record from view... or my Nav key looking through inventory.. Then later i suppose I purge hidden records to archive.. Thanks

Ok....so I'm not sure if this could be done or if so how to even begin. Basically I have a database with client info on it that I need to record a diagnosis for each client. A client CAN have up to three diagnosis'. What is the best way to enter them? Having seperate fields for each diagnosis ie. Diagnosis 1, Diagnosis2, etc? Where the complication comes in, I need to be able to search for any given combination of diagnosis' so I don't know where to begin to get it to do that as well. I'm very new to filemaker, this is the first database I have ever tried to make with it, and only my second database ever (The first wasn't too great ) Thanks in advance for any…

Another question! Sorry if it is another stupid one. I have only made one other database other than the one I am trying to create right now on filemaker. The first one I made was on Microsoft Access. On that database I was able to create reports for set queries, and some that prompted for certain information, i.e. a date range. It was very straight forward how to create and save these reports on Access, and I'm wondering if I'm just missing something in FM. Is there ways if I selected a particular report I made for it to prompt the user for information before generating the report? Or are you left to use the find/sort fields each time?

Hi I am switching from excel to fmp to carry out telephone analysis. I have two layouts, one is a call traffic layout and the other is a phone book layout. If I import a list of numbers in the the call traffic layout, i want fmp to check the phone book and assign a name on the call traffic layout to any matching number from the import list. I used a vlookup function in excel to do this. Further to that, if i import call traffic from a number of phones, i want fmp to identify the common numbers among the different lists. Is this possible using file maker. Thanks very much for your help.

Hi, I've been running around google, filemaker knowledge base, and everything else for that matter and still can't find an answer to this... or at least not as easy as I thought it would be. Scenario is; I have FM11Pro, and imported a file with 40,000 records. This is my mailing list database, and every bit of data is separated into columns. What I'm trying to accomplish is select and delete duplicates based on two columns (because a lot of the addresses are duplicated simply because there is an entry for every member of the household). It looks a little something like this; Mr. | John | Smith | 123 | Main | Street | City | State | Zip Ms. | Ana | Smith |…

I'm creating a data entry layout for a shot logger. I want to be able to have a some sort of display on the layout that will show all the scenes with a shoot day of the current day. Not sure where to start.

Hello all, I'm hoping you may be able to help. I have a simple portal setup which monitors the "Job Progress' status of my records. I want to be able to use up & down arrows within each portal row to change the sort order, so I can prioritize and move more important jobs to the top of the list. I have managed to do this in list view using the following scripts on up & down arrows to swop the numbers in a sort field with the sort order of the list set to sort by the sort no. field. But these scripts don't seem to work in a portal... any ideas!? this is the 'move up arrow' script - this is the 'move down arrow'script - Any help w…

I'm looking for a pick list. A list of all clients names. Click on one to see just that record in a new layout. Great if typing one letter anywhere would narrow the search. Ex. typing 'D' would move to the 'D''s. Thanks for you your help

This one has me stumped. I will do my best to explain. I have a simple find in a script. This find works fine Enter Find Mode [ ] Set Field [ Departments:_pk_department_id; Build_Sets::xdep ] Perform Find [ ] When I add the second criteria it pops up a find in progress dialog and never comes out of it. Enter Find Mode [ ] Set Field [ Departments::_pk_department_id; Build_Sets::xdep ] [color:blue]Set Field [ Leads::status; "=" ] Perform Find [ ] As a test I changed the first criteria. And this find works fine. (but it's not the find I want) Enter Find Mode [ ] [color:blue]Set Field [ Leads::_fk_dep_id; Build_Sets::xdep ] Set Field [ Leads…

I want to search multiple fields for a "3" character or a "3a" character but not a "3b"character and insert the found data into a new field. I have been able to use PatternCount successfully to find the 3 and 3a but can't omit the 3b.

Hi, My current database links a person to an establishment , and the establishment links to the main company information. I am however trying to make it so that in my view of a person, when I create a record, that I have a list of companies which I can select, and upon selecting one, the establishments of that company are shown so that I can select that (and thus making the link between person > establishment > company) I am however unable to get the companies to shows when I add a pop up menu or sorts with a Unrelated table, however when I click it. Filemaker gives me an error that it's not related (why give me the option of selecting an unrelated tab…

Hi all, i'm still fine-tuning my baby database. so, i wrote a script to search for babies with criteria set by the users, but it does not work properly. In a simple search like searching for babies with certain language and age criteria, the search result does not include all that meet these criteria. For example, for searching babies who hear 80% English within the range of 4 - 6 months, the search is omitting some baby records that do not follow any patterns. Please see my attached screenshot of my script. Thanks!

Im not sure if this is possible but wanted to give it a try. What i would like to do is use a dialog for a user to enter some search criteria and then have a script use the information to perform a find. It appears that FileMaker will only allow you to set a field on a dialog, not a variable. Am I correct in the assumption? If not possible, how would one go about doing something like this (letting using input criteria) without having the user go into a find mode? Thanks

Hi, I have a script screendump (attached in PDF format), that I have put together (with the help of others admittedly...), and have been trying to achieve an extra step, but to date been unsuccessful Those of you who do look at it will see that it allows me to do a realtime search across four fields. One of the fields I choose to search on (as marked with red markers in the script)appears to be completely ignored - that is, the first three fields criteria is successfully met, but not the marked one. I have tried chaging the order etc but makes no difference. It must be something I am doing wrong. Can anybody please point me in the right direction. Chee…

Hi, In my found set of records, how can I narrow the found set to display only the records I want, using a field with a value list (without having something scripted in my original script, therefore this has to be secondry). E.G. The found set in question shows records within a date range in my report, but I further need to filter these records by field "model" (this is the field with the value list). My idea is that when the generic found set is displayed in my report, I can then select from the drop down list of "model" field, any model I want, then it filters by my choice and displays the records. Your help is appreciated....

Hi All, I am trying to perform a find for a report based on a field called status. I start with a checkbox set with several available statuses. The user can select any number of statuses to base the report on. So I am trying to figure out how to script a find based on a field with return seperated values. I suspect a loop is in order but I'm not sure how to count through the values in order to go from one to the next and exit after last. Thanks in advance B)

I may be having a hard time doing something that isn't so hard, but I can't come up with an elegant way to write script that finds the position (record number) of a record in a found set sorted alphabetically by one of its fields. The records are of teams in a schedule, each with its unique id, and I sort them using a field called Listing (which gives the team members). I know the id (TeamID) of the record whose position I want to find. If I search for TeamID after sorting the found set and then perform the Show All Records step, I can get the position within the whole set of records, but I want its position in the found set (records marked as active along with a few…

I need to write a script that copies to fields from one layout (fields... User and Password) and then go to layout(student) Enter layout mode Paste two fields perform find Can some one tell me how to do this with two fields to find? Thank you!

Hi, I could do with some help/advice please. I want to create a report layout in which my users can veiw their results, after they have performed a date range find via a custom dialog box (the field to search is a date type field). My question is: how do I set this script up so that my users can enter their search criteria (date range)when promted into my custom dialog box? Hope I've made sense? Your help is appreciated. Many thanks.

I have a field with multiple values that are displayed as a checkbox set. I would like to find all records that have the checked values of Z or Z2 or Z' or Z2' I have very basic understanding of script writing only so created a button to perform a find with field "location" having criteria Z or Z2 or Z' or Z2' - this didn't work for some reason. Ideally, i'd love to be able to count the total number of checkboxed values of either Z or Z2 or Z' or Z2'

I have two fields: INDATE and OUTDATE. I would like to see all the records in my database where OUTDATE is more than 15 days after INDATE, but I have no clue how to achieve this! Can anybody help me? Thanks! Frosty

Hi All, I need to conduct a found set of records that includes only 1 or 2 values (out of 10 or more) within a given field, excluding all other records. For example, I'd ideally like a script that would transport the user to a find screen, where the user would be presented with a paused find layout that features only one field: the Salesperson field. Once the user populates the Salesperson field and presses the continue button, I'd like the database to perform an automatic find of all the records related to that salesperson, but excluding all records except those that reflect a Project Status of "In Development" or "Closed." I've gotten everything d…