Finding & Searching

Thanks for reading my dilemma! Im trying to make a list of clients who visited my office this last year. I have a log of test done for my clients, but some clients might come in 5 to 10 times in a week. So I want to find all clients that I've tested but only have one occurrence not duplicates, if I omit duplicates this takes out every occurrence. I hope this make's some scent's, any post would be most helpful. Thanks for your help!!!

I have layout which contains a listview of names I put some buttons at the top like a phone book and added a find [A] for the A button, find for B button and so on. I noticed that when I click the 'A' button, it finds not only names that begin with A, but names that have an A anywhere in the field. I really want to only find the names that Begin with A. in Perl it's ^A I looked through the online help of filemaker, but did not see any mention of how to specify 'begins' with A Regarding the approach above, is there an easier way to do this button / phone book lookup letter approach? For example, could I somehow get the text of the button, then pass tha…

i know this is probably a silly question, but I don't know the answer I have a script to search in a table that works when i type in the text to find, but I want to use the value in a specific global field to search. how do i specify that I want the value in the field and not the name of the field. thanks

How can I perform a *text* find with a script?? I knwo i can enter the find mode and put the (*) to search a word wherever it is, but how can i do this with a script?? I cant go into find mode cause its a field where you have to write and press enter to perform the find.

I have Created 2 Tables Master and Detail, in master table i have created "Total Quantity" a calculation field - sum(detail::qty) - for calculate total quantity in the detail table, if i enter find mode in the master layout and than finding by "Total Quantity" field whit >0, the massage "No record Match" is appear, so why ?

I am building a small database that tracks tools that require calibration. I made a field called "Calibration Due" that contains a manually entered date when the calibration expires. I want to generate a report (at the click of a button, script) that will give me a list of tools that will expire in the next 30 days. I can't figure out how to do the "find" and save it as a script. Any thoughts? Thanks Dave

hello world, i'm using the built in script "Perform Find[]" to find matching records. When No records are found, it pops-up a window have 3 buttons: Cancel, continue, and modify find. IF I click on modify find button in the pop-up window, AND click on some other buttons, it doesn't let me do, because the "Perform Find[]" scipt hasn't finish excecuting yet. Is there a way to go around it? Thanks

I did something I've always done: Create a new field, specify as a Radial button (Yes/No), add it to a layout that is Viewed as a List. I want to run a Find routine (show me all those entires marked "Yes"). I've done this numerous times. For some reason, tonight, FMpro7 simply doesn't want to find it. It just says "No matters" found. First that came up in Script, so I went to the Find manually. I see the row in Find mode. I click the "Yes" radial button option. I execute the find. Nothing. Then I convert the Radial button to a regular Edit field. I show the list again. I see the same records now all have "Yes" written in them. I try and do a Find by t…

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d, or e put text/.gif/.jpeg/value in space 1,2,3,4 etc on form/page 1, 2, 3, or 4.... any help would be great tyvm` [color:"green"] Silose

This might be a REAL newbie question (being a newbie) but is there a way to do a simple find across multiple files? Suppose I have several clone database files and I want to create a master file that would search all of the others for similar info. Thanks in advance for any help.

I am a long time Filemaker user, but I only recently started using it for my business. I am using a mailing list which has a field that contains a date in the form of 08272005, 10152005 etc. Even though I have defined the field containing this information a a date field, I cannot sort or search that field. If I try to search for all the 2005 dates in that field I get a message saying "the value of the field must be a valid date in the range of years 1 to 4000 and should look like "12/25/2003". Is there a way to convert from the format I have without slashes to that? Or make FM understand the format I have?

Ok - I give up. How do you do a find a range in a timestamp field? I want to find all records in a table that have been created today. So I switch to Find mode and enter a range in the CreateTimeStamp field. Voila - nothing. I've typed in every combination of things that seem to work in other fields but I either get nothing or a bunch of records that were created anytime from today to months ago (not all records mind you, just some).

I am fairly new to FM7 and have inherited a database with about 2000 clients in in. There are 6 tables with varoius info on each of the clients. On the last table of ID numbers there are about 500 duplicate records - somehow?! How do I delete these records without deleting the original clients too? Please can you explain very simply.

Hi again, I have a solution that I would like to hide the status area from my users to minimize any problems that may occur. My problem is that I would like them to be able to perform a find using the omit button. Is there some other place to do this. i have a find script but how do I place the option of omitting in it? or is there a keyboard stroke or is it anywhere else but in the status area? Thanks in advance.

How can I search/find something within 3 different fields and show all of the results in another field. Its hard to explain so heres an example: Field 1 Field 2 Field 3 Field 4 A x z t B z y j C s t u D u z p (Imagine its a table w/ 4 colums and 4 rows) :S If I were to search for z it needs to display A,B,Dbecause they all contain a z. Does it need to be a script? Hope someone can make sense of this :S Any help would be appreciated, thanks

Hi all I need to create a mailshot to all my customers who have had an estimate in a specific time period. When I execute the find it shows that some of these customers have had more than one estimate during this time. In this case I need to show the last estimate for the customer. Anyone have any ideas how I can do this? 2 files: customer and estimate. Many thanks in advance for your help eSBee

Say I have a field called NAME in a table. The names are BOB BOB-A JOE JOE-A BILL BILL-A How would I write a script to search for and display only the names that DIDN'T have an "A" at the end?? Help is much appreciated. Thanks!

OK, so I am probably making this harder than it should be, but here is the scenario. I have a button called, "affiliate": when you click this button it is supposed to search all the records within the table for all exact matches of the affiliate under the "affialates" field. For example, I am on record #33526 and the affiliates field is eg. "Pizza Hut" (The one in your hometown for an address). When I click the affiliate button, i want to do a find for all the "Pizza Huts" in my database and return them in a table view? How do i do this? I am using a script "perform find" but my criteria is wrong? Please help Thanks

Hello, is there any way to remove quotation marks from the text inside a field? I've tried the substitute command but it sees the quotes as part of the formula. thanks....

How does one determine the number of unique values in a field in a found set? That's the question! I found a recipe in FM Help for finding duplicate values via a self-join, which might be extendible to solve this, but I wondered if there was a simple, direct solution. Odd that I can't find this question in the archives. Gratefully, Chap

I have a problem with searches I am running with a script The database is one for airline contracts and the airfares within them...... certain data at contract level is manually entered but the basic fare data (departure, destination, class, price season etc) is allowed to be imported from spreadsheet. I import it into a table where it is validated before being transferred to the main database. During the import from spreadsheet various criteria are checked by calculation and the value auto-entered in a set of marker fields (1 if ok, 0 if the data is invalid) I then perform a number of search requests on the calculated marker fields, first to find any inva…

Hello all I have a customer file and an estimate file. I want to write a script to find the last estimate for a customer based on a value within a value list. This is my first time writing a script and I can't see how to set the value for a value list field. The relationship is 1:m in that a customer can have a number of estimates. I'm using FMP v7.3 Many thanks in advance for any help you can give. eSBee

Hi, I'm trying to script a search for dates that fall within a certain range in a schedule. For the start date I use >= start date in the date field in find mode, but I can't seem to do anything like: >= startdate and <= enddate in the field. Here's what I have for a script so far: Show Custom Dialog Box ["Search Criteria"; "Please enter a start and end date"; UI_Schedule::Global_SearchStartDate; UI_Schedule::Global_SearchEndDate) Go To Database ["Database - Schedule_DailyEntries"(Schedule_DailyEntries)"] Show All Records Enter Find Mode {} Set Field [schedule_DailyEntries::Schedule_DailyEntries_Date;">= " & Global_SearchStartDate] Per…

I know this should be a simple one but my brain has frozen! I am trying to script a find to find records in a table where the field data is in multiples of 3 letters (not counting spaces)... so AAA BBB CCC or AAABBBCCC would be fine. But AA BBBCCC would not be returned. I could do it with @@@ @@@@@@ but i know ther must be a way to check number of letters and see if it is a multiple of 3... can anyone tell me what I am missing here?

Hello Together, I didn't really know where to post this so I guessed Finding&Searching comes closest. Here's the deal: I have two related databases, one called TOURS contains all my customer records, the other one called HOTELS contains 15 different hotels that I use on a trip. Now I perform a search for participants on a certain trip. Everything works fine and the found records from TOURS show up in the file HOTELS. But how do I manage to create records in HOTLES for my 15 different hotels? I already have the set of found customer records, different layouts each named after the individual hotel name doesn't work, placing the hotel names in the header does…

I am having trouble when performing finds in our email field. What is happeing is that I usually have an email in lowercase to search with and some of the data has uppercase. This makes it hard to search since email address is the one field I always use to perform a search. Is there any way to make it find both cases with one search? tia Joshua P.s. Filemaker is retarded when it comes to email, they have the @ symbol as a reserved character!?!

Is there a way to a) display how many Find Requests a user has entered, if the Status Area is hidden display which Find Request the user is currently 'in', if the Status Area is hidden? Thanks in advance,

All, I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift. I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call. Any ideas? Jim

does fm 7 have a tool to write/execute queries against fm 7 databases? something like m$ query analyzer for sql server*? thanks

I have a layout with a parent file (Customer with ID#) and a child (customer staff) file in a portal (related by Customer ID#). I want to be able to click on button and open a new layout with a different child (actions) file (#2, related by Customer ID#) and create a new child record in child file #2. Situation: Customer file. Customer Staff is the child file #1, and actions for Customer (child file #2) using information from the customer staff file (child file#1) also. When I go to my new layout, and select new record, all three files are cleared and I cannot create a new action record since the customer file and the staff file are not displayed. When the acti…

I have a DB that adds start time and end time.The result is elapsed time for a bike race. There are 8 races in the series thus the fields repeat 8 times. I get my results by showing the info on a layout that finds the catagory, class, and sorts descending. If I wanted this script to only show the result of a certian race in the series how could I only get the result from a certain race in the series?

I have a calc time field repeating that I would like to omit in a find script. How would I omit all empty time results from say repeating 1?

I am trying to write a script that will find records based on a field. Right now I have a loop setup that checks each record and omits or passes it. Can't this be done by putting a "find" in the script? I just want to say find records where Field x = Field y but when I go to script the find, it looks like I can only make it find where Field x = something I manually type in. Is there a way to do this?

Dear All, I have searched for this in the Forum and have also found some solutions but it was for fmp7 and I guess I can't use the same syntax for my script in fmp5. Here's what I'd like to do: at opening of the databse I want to assign a script (at edit/prefs/document...) that runs and finds the birthday of somebody - but one day before his actual birthday, so I can send him a card or email etc. I have tried to calculate my field DOB in the script, set field to ... etc etc but haven't gotten to the proper syntax - I give up! Thanks for your help... Andy

Simple question - but I can't find the answer anywhere. The error function for a record not found is 401. But if no entry is made in any fields in a search, 401 doesn't pick it up. What's the error for this situation? thanks in advance

Can anyone suggest a way for the user to specify that a given Find variable is to be handled as an OMIT condition, when the Status Area is hidden? I can't think of a way for the user to : a) specify that a given find request be treated as an OMIT : have some kind of on-screen reminder that a given find request is flagged as an OMIT Thanks in advance, Andy

This should be simple and maybe is... I'd like to be able to go directly to any record without flipping, scrolling etc. - i.e., go to record 66553. How?

Is there a way to disable Enter Key? If my users hit the Enter Key rather than the "Perform Find" button, undesired results follow: rather than switch Layouts, they stay in the "Find" Layout in the Browse mode where they are able to modify data.

One table has all my clients and the another table has all the calls I have made. I would like to preform a find that would show me all the clients that I have not called yet.

Hello Together, say I want to search for a Last Name in my database, so far no problem using the find layout. But now I want to do the same thing, only that I enter the name I want to find in a separate field XY which is on a different layout called SEARCH. The entire thing looks like: Enter name you are looking for into field XY >> then click button FIND. After the name is entered into the field I want to push the FIND button that has the find script assigned to it. How would my script have to look like? So far I have the following: Enter Browse Mode Go to Layout ["Data"] (this is the layout all names are on) Show All Records Enter Find Mode …

I am creating a Trouble Report/Log database for a Computer Operations Center so they can track issues and their resolution. The dbase has a number of reports that will allow the users to enter a start date and time and an end date and time. It then finds all records during that time frame. Here are the scripts I came up with: Script One Setup for Search- When they push the Report button in the header Go to Layout [ Choose Reprt ] Insert Calculated Result [ Start_date_search, "" ] [ Select entire contents ] Insert Calculated Result [ Start_time_search, "" ] [ Select entire contents ] Insert Calculated Result [ End_date_search, "" ] [ Selec…

Apologies if this has been covered many places elsewhere -- I did search around and couldn't quite find anything that answered my question. I am using FMP 6 with a hosted solution (FMP 5.5 Server running on an eMac 1 GHz). I know that you're not supposed to find through relationships when using hosted solutions, because it takes a long time. Well, that's the problem I've got, but I just can't seem to figure out what to do differently. I've got a CONTACTS table, an ARTISTS table, and a TRACKING table which joins the two. When a contact is associated with an artist, a single record is created in TRACKING with an ID which is a concatenation of the numeric ID's from…

Hi. I've a question regarding doing a search on a GetSummary calculation field. I have fields as follows... EmpId(Number) Status(Text) Date(Date) Count Of Student ID(Summary) No.Occurrences(Calculation = GetSummary(Count Of Student ID, Student ID) I need to be able to do a search for eg. Status = "Present" in Date Range 1/1/2004...31/12/2004 with no. occurrences per employee = 4 I'm having major difficulty doing the find for the no.employees. Is it possible to do this using a calculation field which uses getSummary? If I do the search first of all for the required Status and Date and then subsequently I sort by Student ID, then the No. …

I am trying to perform a find from one table to another related table. For example: I want to go from one table to another by pushing a button. I want to find the same record that I am in currently, matched with the same record in the second table. How can I accomplish this. I tried a script like this: enter find mode set field(main:ordernum;auth:ordernum) peform find But this script tells me no records found, modify or cancel find. Let me know what I'm doing wrong, or if there is a totally different way of handling this. Thanks!

We are having issues with a few of our databases. We have a "Date Paid" field that is manually entered. The field is formatted as a date field, indexed, and must have a 4-digit year. Certain dates will not be sorted correctly or found. Example: a record contains a 'date paid' field as 11/22/2004 - it is not found when doing a find and when sorted it ends up towards the end of the sort when there are dates that are chronologically after it. The dates are entered correctly. Please help!

Hi, I've a layout in which a pop-up menu resides, displaying field values taken from table A. When one chooses an item in the menu, one has to click on a "Search" button to display a new layout in which records of table A a displayed, based on the value selected in the menu. The script launched when one clicks the button is: Perform Find[] Goto Layout["abc" (prout)] It works correctly for the vast majority of the records, but when one selects, say, the value "x z" in the menu, clicking "search" displays not only "x z", but also "xy z", "xyy z", etc. This is not my goal, I'd like that only "x z" be displayed. Has anyone an idea on how to do it? I'm a …

I have a database listing contents of various magazines and books. Each entry is listed in a repeating field with 200 repetitions (probably not the best way to have set this up). When doing a find, the records come back but the search test is not hilighted, forcing me to read every entry. A major PITA. There must be a better way. It occured to me that some kind of a lookup via relationships would be the way to go, but I need some advice as to how to get started. The manual isn't much help on this subject. Any advice would be appreciated.

Hi, I'm quite sure this has probably been asked before, but I cant find it by searching, so I'll ask anyway. I just need to know if there is a script step that will allow me to put a couple of buttons on a layout which will perform the function of the book on the toolbar. I plan to hide that in my final solution. There is only one place where I want users to be able to flip through search results.

Hey, I made an invoice/timebilling thing in FMP. I'd like to have quarter subtotals. How do i do that? Thanks

I want to use a pop up window to enter into find mode and then perform a find but view it in the original window. Is this possible. Thanks Craig

I have a database which has some VERY basic accounting calculations, as follows: Quantity * Unit Price = Cost Sum(Cost) = Total Cost Total Cost + Tax = Grand Total Here

I am trying to set up a portal filter where the user can select a particular value out of a drop-down list or choose "All". If they choose "All" I want the filter to return the related records for every value in the drop down. For example - Drop-Down List values - 107, 108, 109, 110, 111, 112, All I might choose 107 in which case it would return only those records with 107. I might choose All in which case it would return those records with 107, 108, 109, 110, 111 and 112. Thanks in advance for the help on this.

Hello, I have searched for an answer to my problem in the archives, but haven't quite found a solution, or else I just can't see it. I need to find the most recent contact date for a given Client and generate a warning if they haven't been contacted in more than 30 days. For example, ClientA was contacted 9/1/2004, 10/1/2004, and 11/1/2004, but not since. I need to grab the 11/1/2004 to use for the warning calculation and have a "Client hasn't been contacted in 30 or more days" warning show up on the client's record. Each contact is a separate record and I need to do this across all of the clients. Am I posting in the wrong place and this is really a sc…

Okay, so here

Hi guys, I have a a few small niggly problems that i cant seem to tap on the head. If someone could give me any direction or info on how to overcome it that would be great. 1. how do i turn off return all records(applescript maybe or is there a handy script step) 2. when people search for firstname for example i want to make sure that the gender male is only returned do i use contrain ?? what are the steps about getting this working. has anyone any good examples of a who is logged layout or url to a tutorial i would be very much in your debt. Thanks D

I have a field "VIN" that contains "*&*" and "*" types of data. say if I do a search for "1GC&G39R" it will show up...great but if I do a search for "1GC5G39R" it will not find anything. How can I tell the database to look for both types and just display the relevant variables i.e "1GC&G39R" and not all those records which have an "&" in them. without reinputting the data myself thanks

I am using the example in the filemaker book about using XML script parameters with the custom function GetParamXML to retrieve them. I am currently trying to make a button that will add a record to a join table, and I want to check to see if the record already exists in the table before I add it. The way I am currently trying to do it, I am doing a perform find where the id of the record matches the parameter passed to the script. The only problem is, I don't think that "Perform Find" allows calculations in the criteria field. So I guess my question is, how the heck do I do a simple search with data passed from a script parameter?

Is there a way to find all totals using a value list? I have a value list in my invoice layout that has several values in it ( salt,plow,walks and so on) I want to be able to find a total $ amount spent on salt for example. I know I can do a find & find all invoices with salt item on them. but how do I find a grand-total for ALL invoices with salt on them & have it total the amount of $ spent on salt. Can this be done? I'm stuck...

I am trying to write a script that will find records when looking in a date field (formatted as date) that is today minus 3 years (to the exact date). I have to run this every month. Help is appreciated!

I have 5 fields: group (number), record_number(calc, Get(recordnumber), record_number_max (summary, max of record_number) rec_num_getsummary (calc, getsummary(record_number_max; group) highest_record_number_flag (calc as text, if(rec_num_getsummary = record_number; "X", "") I want to get an x in highest_record_number_flag when I have the maximum record number in each group. This works fine. However, when I try to find only these record, by placing a search on X in the highest_record_number_flag, or searching on non-blank with * in this field, I get the message "No records match this set of find requests." Do I have another misunderstanding? …

I'm running a script that compares the "looking for" data (a teacher's name) to 10 different fields in a record, and, via a loop, across all the records. When the appropriate records are found, it displays some related data for the found teacher. Until recently I believe it has been working correctly. Lately, however, it's been naughty! :-) The script itself runs without error, but when it displays the data, it sometimes shows the wrong info. A little more background...Each record is a student in Special Ed. Each student can have up to 10 different teachers working with him/her. For each teacher, we list the amount of Direct Time and Indirect Time spent with the…

I'm fairly new at file maker and I'm sure this isn't a difficult task but here goes. I want to be able to do a find (for example a certain client or company) the find will be in list view (to see all of the find results). What I want to have happen is when preforming this find the hours are added together and displayed in another field to bill that client(total hours for 1 client). If anyone can help me with this script it would be greatly appreciated. Thanks for your time guys.

I have a check box field with ten boxes from a value list. Is there a way to write a script to enable user to do "AND" and "OR" search by simply selecting the check boxes?

Hi I keep encountering a serach error the first time I try to search in a calculated field. The field is a calculation - Writer 1 Name & " " & Writer 2 Name & " " & Writer 3 Name & " " & Writer 4 Name & " " & Writer 5 Name & " " & Writer 6 Name & " " & Chair Name I want to be able to search on any of the writer's names but the fist time I try the search I always get a message saying that there is no valid criteria in the request - when I modify the find by typing in the exact same thing the results come up perfectly. Any suggestions? R

I have a script that does the following: - show all records - sort by date (so most current date is last) - go to last record and date field Now, based on the contents of that date field, I want to do a second FIND to return all records with that date. (The reason... sometimes we do our billing and need to unmark the most current billing print date for various reasons. I would be adding the script to a button so anyone can do it without having to call me).

Is any-one able to help me i am currently making a database for a restraunt and I am trying to get a price to display when I select a type of drink followed by a size both these values should correspond to give the price any help on this matter would be greatly appreciated

Ok, so I thought I knew searching well enough. Say I go into find mode on a layout. I want to find all records that are under the age of 18 that also have information (non-blank value) in another field. I type in (field names in parenthesis): (File Number) = (Age): >17 Click -> Omit Record Click -> Find ------------------------------ I get 2745 records with that search. When I search for JUST file numbers that aren't blank, I only get around 1000. Therefore I must be getting the blank file numbers plus EVERYONE who is >17 years. I had always assumed that if you enter in multiple fields on the same request it acts like an 'AND'…

Hi every-one just a quick question I am creating a restraunt db and I am trying to lookup a price based on a selection of a type of drink and then it's size to specify the cost. Any help would be greatly appreciated!

I'm trying to put a button on a find layout. What I'd like to do ideally is attach a script which will detect what mode the user is in. If they are in browse mode, I want it to switch to find mode. If they are in find mode, I want it to do a perform find. Is this possible, or do I have to settle for 2 buttons?

Using fm7 dev on OSX and Win XP. Has anyone been unable to find a record by searching by it's primary key but able to find the record when doing a find all? I have atleast one record doing this to me, I can find others, but atleast one will not show up for me at all. This is being used in a invoice with line items situation, when i go into the line items file, I can't find the line item records by useing the invoice id either. My find scripts are simply to jump to a different layout where the fields have a yellow background, and a button that runs perform find is all. Can't think that anything goofy is going on. Any info, is appreciated!

Hi fellas, I have a database of food items. I randomly select items from the database and then present sets to different restaurants. Is there a way to save these randomly selected sets of records with names (Like "McDonalds" set, "Burger King" set, etc.) so I can quickly recall them? Thanks! Andrew

I'm very new at developing in FileMaker Pro 7.0V3, XP Pro SR-2. I need to develop a database application with Transaction number - auto serial # field Transaction date - date field Account # - number field Amount - number field. I need to enter the transactions and then provide a report with date period by fiscal quarter and totaled by account# and amount. I setup the transactions with no problem. I have used the date calculations found in the -Queue-#141044 records calc and they work great. Thank's so much -Queue- but I don't know how to do the totals by account# and date all on the same layout. Thanks for any help I can get. Bob...

Here is my problem. I am creating a system of accounting statments. From each statement a specific amount is held back for 1 year and then liquidated. I am trying to figure out a way to look up the old statements and fill in the liquidation amount 1 year later. For example: Statement 1 - Date 1/1/2003 - $100 held for liquidation Statement 2 - Date 1/1/2004 - Need to have automatic lookup to 1 year previous and plug in $100 Any suggestions? I would like this to be either automatic, or trigger a script to lookup the value from the previous statement and insert it into the new statement.

I provide the user a small pop up window where the seach criteria are entered. The field is a global and the seach results are then displayed into a full screen list layout. The user can be in any of several files and request a search for the data in another file or the user can be in the file containing the data to be searched. The script to request a search displays a small pop up window where the seach criteria are entered. The 'Execute search" script will look at the previous layout to determin if the user was inside the file previously or not. If the user was inside the file in question and viewing the list layout, the small search window is closed, the …

Hi all, I want to find/keep only one record of recurring duplicates-please see attatched. In column RF node, the first 3 records are all the same-I want to get to a point where I only keep the first one of the 3.The next 3 again are all the same-I only want to keep one.The next 8 are the same-I only want to keep one-and so on. Could somebody advise me on the best way to do this-the aim is to have an exportable summary file that contains only one record of each, rather than multiples. Thanks Sandy testfile.zip

I need to set up a Find scipt for Instant Web Publishing as I want to hide the Status Area on the web page. However, I can't find a way to Resume the script after the 'Enter Find Mode (Pause) step which allows the user to enter their Find requests. On the web, the Enter and Return keys simply add a carriage return after the entered text, and since the Status Area is hidden, there is no access to the 'Continue' or 'Submit' buttons. Using 'Pause/Resume Script', either later in the same script or called through another script doesn't work. It just seems to add an additional pause. Ideally, I'd like to use the same 'Find' button, and therefore the same script for both e…

I have a problem where when I search using a date I get a "no records match this set of find requests" error. I am searching an invoice date field that is populated on creation and is indexed. In browse mode the date looks like 1/13/2005 and if I search in that exact same format it works fine. But if I type in 01/15/2005 it doesn't find the record. What is weird is I have another database that this works fine in. What am I missing? Thanks, Chris

Hi. I would like to have a Find button on my solution that will prefrom a find, that will NOT look at the previous found set. For example the first time a ran a find on all new records I typed in "first name" in that field & it found that record, however the next time I did a find it didnt give me an option to type in a frist name, it just fount the record from the 1ast time I used find. How can I make the find button clear all previous finds, then ask me "what to find"? (using that 1 button) What I really need is to add the Continue Button (Continue (a button created by FileMaker Pro in the status area) to my Find Button. But I don't know how. Thanks again. …

Ray Novitske called my attention to this odd search result. In FileMaker Pro 7, finding items in a field holding 2 words beginning with the same letter yields unusual results. Consider a concantenated field (Firstname & " " & Lastname). A search for "Dan D", yields "Daniel Davis" and "Daniel Steen". Search for "D Davis", yields "Daniel Davis" and "Rusty Davis". N script will call for deleting a record after such a vague, short-cut find. However, if you are making up nonsense words for some elaborate navigation scheme, the rule should be AVOID ANY WORDS USING THE SAME FIRST LETTER. Where 2 words starting with the same letter, or hyphenation as in "c…

Hi, If you sort a field by say 'ascending' in a table and you allow the user to toggle ascending or descending by pressing a button or two. in a multi-user environment each user gets their own sorted table view correct? so if user 1 sorts by ascending; then the next user , user 2, will be able to sort by descending without effecting the other users sort right? thanks, Sincerely, J__

Would someone be able to post a calc for finding last month's records and all records for the current month? Thank you so much!!

I am hoping this is not true... I have a Table 'Projects' and a table 'Invoices'. They are related by project numbers. I have a field in 'Invoices' called 'Invoice Amount' for the $ of each invoice and one called 'Sum of Invoice Amounts' which is a simple total summary of the invoice $. In 'Projects', there is a portal to 'Invoices' which works fine and shows all of the invoices for the project. I also have the related field 'Sum of Invoice Amounts' on the layout. This displays the correct total. When I go to find mode, the 'Sum of Invoice Amounts' is not accessible. I checked field behavior and it is set to allow entry in find mode. What gives? This is …

Hello all, I have created a search page in my database with the necessary fields for the user to search. One of the fields on the page requires the ability to exclude any files that have matching criteria. All the other fields need to look for exact matches. The exclusion field is a checkbox set, i want to program this so that if any of the checkboxes are selected, any files with matching ones will be excluded in the find results. This needs to be automated for the user so they dont have to click or push any specific buttons. Hope this makes sense Nicholas

Hi there, I am very very new to FMP7 (about 2 days) so this is going to seem like a silly question but please help me. I am trying to create a database for a casting agency, and part of the actors profile is to input an age range that they can play (ie 20-30). So there is a minimum and a maximum. How do i create a find command that will look for people say 'suitable to play a 25 year old'? And also (prepare for the really stupid question), how would I make a search command that will find people who are higher or lover than a standard (ie search for people who are over 30 years of age) If anyone can help me it would be much appreciated as i am rea…

I hav a field that is a bunch of checkboxes from a value list. I want to write a script to run a find with one or more of the check boxes selected. Is there a script step I could use to do that? Any ideas?

Can't seem to find the right function for this: I need to find within a text field if the word "electronic" exisits. The field may hold up to 100 words and characters. The Extact function does not seem to work on this. Any Ideas? Thanks

I am a school teacher who has been developing a database for use by staff to record things about students e.g. infringements, merits, etc. In very early versions of this database (called MASTER), I was able to do the following searches: 1. Find a specific student (e.g. Alexandra Wood) 2. Find a specific student on a specified date (e.g. Graham Bell -10/01/05) 3. Find student entries entered today (using //) 4. Find student entries entered today for a specific year group (7-12) 5. Find student entries after a certain date 6. Find student entries after a certain date for a specific year group 7. Find student entries between 2 specified dates …

Hi all, I'm very new to this so please bear with me... I am trying to create a datbase for a casting agency, and I've been trying to crash learn my way through FMP7 for the last three days or so, and whilst I am going fine, I have one major question Can anyone tell me (and I'm sure this should be an easy one), how can you create a searchable field that searches across many different fields that carry the same value. Part of the database includes the clients skill (Musical Instruments) for example. There is a pop-up menu which has a list of instuments on it (piano, guitar, flute etc etc). Then i have another field under that with the same pop up menu, and th…

I have little problem when specifiying find requests to omit records on a found set. In the Specified Find Requests dialog box, I can easily input the field to match a specific number, literal text and all that jazz. What I need to do is have the cirteria be field data from a global field (that changes now and then). Ive tried every combination I can think of and it doesnt work. I can set the criteria to be the actual variable in the global field but I cant get FIlemaker to actually look at the field contents. The online help is pants (no surprises there) and ive only ever seen examples where criteria has been a specific number or text. Can a Specified Find Requ…

I'm trying to develop a filemaker game based on Black Jack. The solution has a table and records for decks. Does anyone know how I can sort these records "randomly" as in a real game of black jack?

I want to have the user enter search criteria through custom input fields for searches. To do a range search I ask for Date start and date end. How do I get this data into the date search field to find the correct range. Al attempts end with "O" The date field on the layout is actually a date field

Hi! I have a layout displaying records from one table, one at a time. I would like to add two buttons in the header, so the user could move to the previous record or to the next by clicking these buttons. I know there is the Go To Portal Row, but this needs records from two or more related table, I only have one table. Thank you

One of the best things about Google search-results is that they often provide excerpts from the pages that match your search, so you can see the context in which your search term occurs. My database of journal entries and reports (I work as a writer) has hundreds of records. Currently, if I perform a search of this database, the results of the find are presented in a list arranged by record title in alphabetical order. Unfortunately, the context in which those matches occur is not provided. Can a FileMaker database be programed to provide 'find' results similar to the Google-style results described above? If yes, where do I start? Thanks in advance, …

My movie database has a number of fields including "actors" and "directors". Currently, if I move into "FIND" mode, I am able to enter a search term in the "actors" field or the "directors" field for the directors. Is there a way for me to include in my database a box that allows me to search all fields simultaneously? EXAMPLE: in this "SEARCH ALL FIELDS" box, a single search for 'Mel Gibson' would show films where Gibson was either an actor, a director, or both. Thanks in advance, Sydneytim

Hi all, happy new year and thanks in advance for helping with my noob question. I have a simple income invoice that tracks checks received. How can I get a script to search for and display all records from the current calendar week (Monday-Sunday) and last calendar week? I know I can simply search with a date range like 01.03.2005...01.09.2005, but that requires inputing the specific dates for each calendar week. How do I get to automatically search for this week and last week with out requiring the user to type in the actual dates in question? I need it to automatically roll over every week without the user having to input any actual dates. I also need a curre…

Please bear with me. I have only had filemaker for 9 days and have no prior database/programming experience. I am creating a database for my synagogue to use to deal with member and non-member data. There are two major tables - families and individuals. The individuals are related to each family by Iid and Fid. However, the data in the families table includes members, non members, prospective members, previous members and businesses (basically everything with an address.) That field is designated "Type of Entry" I have two layouts for each major designation/Entry Type (members, non member -- this includes nonmembers, prospective members and previous members…

Have popup with value list based on the name field, many names. Can I hit a name and find it - either click or click-click? What's the script? thank you, Dwins

hello all, I've created a form and when I click the button it goes to the find interface. The user enters the info and then hits the return/enter key on the keyboard. I would like to add a GUI with a button that does the same thing. So the user would click a submit button that would the search. any help would be appreciated.

Hi, For the most part when I do a search/find, I use the find button which blanks out all the fields, then the user can enter any data they want. It works well, but I wanted to make it look more professional. What I wanted to do is when a person wants to do a search they would press a button which opens a window, then the fields would be blank, (possibly arragned in a more compact fashion). once they have entered their search terms, it would search, if results are found it would transfer that found record into the intial form they were searching for.) The other questions is how do you perform a wildcard search without the end user mannually entering a wildc…

I have two files: Households and Individuals. Each house has multiple individuals assigned. I am trying to find houses that have children in them. Any ideas on how to go about this?