Finding & Searching

Hi all My company needs to track when welders weld with the welding process they are qualified in. This needs to be recorded once every six months. I have script a auto range find. This finds welder one month before thier qualifiaction are expired. The way the script works it that the range starts the day the button is push then adds 30 days. So, If the range date button is push on 7/12/2007. Then the range is 7/12/2007 to 8/12/2007. This find all the welder between those dates. Then we known who to update. The problem is if the button is push 7/12/2007 and the welder are updated and then push again on 7/20/2007. Some of the welder that were update still appears. Exam…

i'm not sure I understand this solution. Let me explain my situation: there are, say, 10 people working with this shared database. some of them are working with the same set of records during some weeks. afterwards they probably will put together another set based on different criteria to work on... during the time they work on a certain set they should be able to always get back to the set of records in question. somehow they should be able to define temprorary "work lists" and get back to them. Important would be that they could do that themselves, create such work lists, clear them again etc. thanks for any support.

I want to have a field that you type in a customer name...hit the search button and it will look at another field and search in that find to return my results. What would be the best script setup for that?

Is there an effiecient way to preserve a found set to a user table? The solution has many users using one of two machines. The login scripts return the user to the last layout they used. How can I put them back in to the record state they where in when the logged out? The final solution will have many tables.

I should know this but..... In Scripting...Preform find and the Edit Find request... I want to find all records where the field 'Packages::value' is less than the field 'Prefs::dc_value I have 'Packages::value' in the field section and '< Prefs::dc_value' in the criteria section The file has 2 tables - Packages and Prefs 'Packages::value' is unique to each record and is a number 'Prefs::dc_value' is a number also and I modify regularly Basically I want to find all items under $.99.... or maybe $.75 so this amount needs to be easily changed without going into scripting every time. I have no problem finding them if I put '< .99' in the crit…

Occasionally, we have a problem where the user will perform a daily routine find and it will return no records found in FMP 8.5 when it should return a count. Also, when I do the same find in FMP Advanced 8.5 it will return a found count. Not sure what is happening but I would like to know if anyone has any ideas.

I have in v6 in the past used the @@ to display the current find request number for the user. Version 8 seems to have a problem that v6 did not... When I add new find requests or duplicate a find request, the @@ updates correctly. However, when I delete record requests it does not update the @@... Has anyone else had this problem? Is there a way to solve it or work around it? I would use global fields, but I am trying to set information via indirection. I would prefer not having to create a conditional script with umteen steps just to account for every Layout TO I am dealing with...

I see a function called Get(RecordID). Where can the result be used ? Can the Perform Find(restore) be used with dynamic criteria (i.e. a variable) or is it only for fixed criteria ? I have tables A and B in a 1 to many relationship. After performing a find on A I FMP creates a found set of records from A. But how can I get the set of corresponding records in B? And how can I use that result later to reselect those records ? I'm hoping for a DBMS type method; I know I can always create a brute-force script.

I need to create a table of contacts which covers a) Title=Mr. or Ms., first name, last name =A, ; : Mr & Mrs., first name, last name=A (include spouses name somewhere for reference); c) Title=Mr. first name, last name=A & Mr. first name, last name=B; d)Title=Ms. first name,last name=A & Ms. first name last name=B, e) Title = Mr. first name, last name=A and Ms. first name, last name=B. Then I must be able to produce mailing labels appropriately i.e. Mr & Mrs... or Mr. A & Mr. B...Mr. A & Ms. B....at (address). I am confused. Do I have to make multiple records or can there be one record per family. Appreciate any suggestions. I am…

In a database we use to record bank deposits there is a date field for when the deposit was made. I have a report to make that just gives details about deposits over a period of time. My issue is this: The user can input a date range to generate the report. I would like to display the chosen date range in the header of the report. For example, if in the date deposited field the user were to type 07/01/2007...07/31/2007 I would want the following to display in the header of the report: 07/01/2007 - 07/31/2007 I'm sure there's an easy way to do this but I can't seem to find it. Any ideas?

Hi, I have the staus area hidden in my 8.5 solution and I need to allow users to build complex find with multiple and/or/isnot find criteria. In find mode I can use a 'new record' buton to add an 'or' criteria, and I can use an 'omit record' button to add an 'is not' criteria. But with the status area hidden, is there a way to show users whether they're looking at a find request rather than an omit request? Thanks, ft

hello.. i hope someone has heard of this phenomenon. When I first open db and do first find in a name field in contact db, it takes like 10 seconds for the auto enter feature to kick in and you start seeing field names. After that first find. it's very quick and smooth.If I reopen file, it works perfect if there hasn't been a restart. The database has around 7000 contacts. I have turned off the indexing on many of the other fields, and that didn't seem to make a difference. help..........

Would it be better to use a normal FM search or is it better to have a dialog box search? Which way of searching usually do regular people prefer, people that have no knowledge of FM and for them it is just another program that they have to use at work? Also is it difficult to make the dialog box preform a search on all fields in a layout - not just one?

Hi Everyone, I apologize if something like this has been asked, I just couldn't find it anywhere. Anyways I have an invoice table and I have a report designed. Now what I want to do is create a script that will ask the user what month & year they want to generate a report for, go to the report and find the records with these credentials. For some reason I can't get it to only select a certain month for a certain year. It works without the year. Any help is greatly appreciated. I am just confused! Thanks Roger

FM 8.5. I used the Set Variable script step to set a $$ variable. Can I change the value of $$ within the same script with Set Variable? I want to change it so I can use it in an If statement to perform different kinds of finds.

FM 8.5 When I use a global field as the criteria in the Find Script Step, the find does not succeed. However, if I use the steps Enter Find Mode, Set field , Perform Find, it works. In the Set field step I enter the global global field. Why is this?

Does anyone have an elegant way of navigating to recently accessed records (say the last 10). I've tried storing the details in a separate table looping back after 10, but that seemed problematic. I've wondered about drop down or pop up menus (eg in MS Word). Any help much appreciated Many thanks :P

Hello I have just published a db on the web and all is nearly well. My problem is that when I try to conduct a search exclusively across a collection of checkboxes (of which I have about 20 catergories each with about 7 checkboxes), I get this reply from firefox: The page at http://192.168.3.100 says: There are no valid criteria in the request. Type a valid request before clicking Perform Find. I hope that this is not true as my entire db is based on searching via checkboxes. Does any one know how I can turn them into valid search criteria. Many thanks.

I have a database that I set up (naively) flat. Each record represents a quarterly report from an HIV clinic in Africa. There is an id field for each record, so you can find all the reports for each clinic. Each report is numbered in another field. I need to compare the results from one quarter to another, finding any that have been operating for more than 1 year that have had a decrease in a field that tracks the percentage of women getting treated. I think I need some kind of script loop, and I started by self joining the id field so records for the same clinic are linked, but after that I'm not sure where to go. An If calc probably, but I'm ignorant about how the…

I'm trying to create a find where for when either of 2 fields equals a certain value. In Specify Find Requests, i hit "New..." On the left-hand selection I pick my table value, and in the right set my criteria and hit "Add". Then I make another one and add it below. Here's the problem: It says "AND" between the two criteria, and I want it to say "OR", but there's no obvious way to do it. There is also no obvious way to just type out the logic in one line. How do I make an OR in a find?

Hello, Does anyone know of any error codes associated with the Find Next command trying to "Find Next" and not having anything else to find? Thank you!

Hi, I am having trouble conducting a search in multiple tables. Not sure if the tables should be relational or if I should use a script. Pretty much, I am trying to have the user enter in three fields to find a certain investor(first name, last name, partner name) and FM will scan through all of the tables of the different groups and will show which groups in which the investor is a member. There are going to be several dozen tables of investor groups. I tried making the tables relational, but I would only get the one result within the Current table. What I tried to do next was build a script using Show Custom Dialog and an If statement, but I'm not strong enoug…

Hi I don't know if this is the correct manner in which to accomplish this task so any suggestion is welcomed. We have a [color:red]Repetition Field in which we've listed various accommodations that need to be met for disability students. Each accommodation is sorted by Test, Test/Class, Class, or Campus. I've executed a FIND and have been able to select accommodations that must be met for TEST or TEST/CLASS, but in the print out all accommodations for that student is listed including Class or Campus if these are as well listed in the [color:red]Repetition Field. Is there a way to separate out the TEST and/or TEST/CLASS info so that only those two c…

First post/question here.... I have a situation where I add items to a transaction record. These items are displayed in a portal on the transaction record page. Upon saving or committing the record, I need a specific field of the records displayed in the portal to change. Reflecting a change in status of the item associated with the record. I have created a script that is triggered by a "Save/Commit" button to try to accomplish this task. Commit Records/Request[] Loop Go to Portal Row [select; Next; Exit after last] Go to Related Record[From Table: "TransactionDB"; Using Layout: "TransactionDB" (TransactionDB)] Replace Field Contents [No dial…

I have a multi-relationship set up between two tables. The last piece of this relationship is to allow the user to type in "keywords" into a global field that is related to a text field in the other table. Of course setting the relationship to "=" results in no match. I guess what I am looking for would be equivalent to a "contains" sort of relationship. Any assistance would be greatly appreciated.

I am new user of FMP and struggling with some of the 'basic' programming actions. I have extensive experience with ACCESS. My problem, I have 3 related tables each containing an account number which is obtained from a value list. I want to summarize results for each account in a single line item report and show a date sorted sub-total by each line item. For example, if I have debit, payment and credit tables and want to keep these tables separate but still summarize the results, how do I perform that find? Account X Date Tranasaction Amount Balance dd-mm Debit 1.00 -1.00 dd-mm Credit 0.50 -0.50 dd-mm Payment …

Hi, In 3 related TOs I have the option to: 1.- Just copy the foreign keys to the parent tables, then search in whatever fields and related TOs the relationship allows 2.- Copy the foreign keys and copy the field contents. Then search in the source TO fields, not in the related TO fields. Is there any difference in search speed? Is this standard practice? (it did not used to be so prior to version 7) Assuming it is OK. Would reporting speed also not be affected by not having the data in the source TO? Thank you

I would like to find all the records that have missing details, but are in multiple events. So something like this: ( I apoligize for my pseudo code i'm just trying to figure out scripting.) FIND MODE Field Title (search for =) all empty fields Field Copy (search for =) all empty fields Field Copy2 (search for =) all empty fields enter events (555555,666666,777777) or instead of comma is it AND PERFORM FIND So this would give me all items within these 3 events that have no title, copy or copy 2. Ideally I would like the option to manually select the fields to be searched (There's 21 or so.) The Sorting of the file shouldn't be an issu…

I have a situation where I import transactions from our customers, and then I use that data to track the customers and send them emails. However, many of the customers have multiple transactions and their names show up several times. So them when the email goes out, it is sent several times. What is the best way to set this up to find the unique values. Thank you!

Hi, I need a script to find a category of equipment available during a date range. So I need to find the category then omit those category items with schedules that fall within the specified date range. The category and date range will change every time the script is used. One way to do it would be to use the "Perform Find" script step but it doesn't seem to allow for variable find criteria (is that right or am I missing something?). Another approach would be to use "Enter Find Mode" and use "Set Field" to enter the search criteria with multiple "Requests" but with that method there's no way to set a "Request" to Omit (again, am I right about that or is …

hi all, i was wondering if there was a way to write a script to display the least sold products in my database. i have a field which calculates how many times each product has been sold, and currently i am doing a find to display products sold < 10 times. I know this is not a very good way of doing it because it doesn't show the 5 least sold, just ones sold under 10 times. I hope there is a script which will allow me to achieve this. thanks in advance, Lucas

Hi everyone, I'm going to use the word "contacts" to mean occasions on which we have interacted with a student... I've got a database with that tracks student contacts. The database has two tables: one with student info (name, phone, etc.) and one with the contact info (reason for contact/ date of contact, etc.). I need to generate a report of all of the students that have fewer than 4 contacts. Contacts are created by adding a record to the contacts form. In that form, the "Name" field is a drop-down fed by a value list being created by the "Name" field in the students table. I did this because we need the auto-complete, if that makes sense. So …

Hi I am using the Expense Report template to create reports. I am trying to create a layout which has the follwoing: 1.Two pop-up menus to choose employee name 1 and employee name 2. 2. Two calendars to select From date and To date. 3. Search button When the user clicks on search button, I want to find all records using the employee ids of the selected employee names and within the date range. I have written a find script for searching by the employeeids and date range. Please see the attached file for more information. What I am unable to do is, get the employee ids corresponding to the names from the layout. Please tell me if what I am trying to do…

Hallo, Here is the case. From the point of view of one field in my database most of the records are duplicates. They are grouped in sets of records with the same value in this field. I need to filter the records and display only one record (regardless which) having this value, but not to delete the rest. A script is to be used to automate the task. Would you help me with this?

I do have a script which should perform a search. I used the command 'Constrain Found Set [Restore]' the criteria is 'Field_1="Hello"' Cool this works , every record which value in Field_1 is Hello is shown. Now I thought to put the searchvalue "Hello" into a global field in another Table which is referenced to my searchtable. Then I used again the command "Constrain Found Set [Restore]" the criteria this time is 'Field_1=Table_reference::Field_search_value' . But this time the script, or better the search, stopped and told me that the value 'Field_search_value' couldn't be found. OK - ounds logical. What do I have to write that the criteria takes…

Greetings! I've been put to task and I can't figure out how to do this... I have a list of parts sold, with part number field and date sold. Now I've been told I need to produce a report showing the last date that each item was sold. I can certainly sort by part number and then date, but how do I isolate just the last date for the report? Any ideas?

Currently all of our items have codes such as: MO-011 MO-300 IP-005 IP-255 TR-856 and so on. While making the data base I have noticed that when in find mode and when searching with certain criteria such as range and find MO-011 > I get strange or no results. It makes me thing that it happens due to - being used in item number. What are the potential drawbacks and or future problems, if any, using - in item codes. What is recommended - use the codes plainly as MO011 or is there a particular way that it should be done. The field is also set not to allow duplicate values.

Is there a way to sort by a 'less than' or 'greater than'? I'd like to be able to search for items in a particular week, or certain set of numbers. I'm on FileMaker 6. TIA!

Hello: I was wondering how others deal with handling finds and layouts. I have a script where I do finds on 5 different tables and for each set of records I find I create recs in a Temp table. I was wondering how others handle the layouts for finds. Do you minimize them or hide them. I think hiding them would be best so the user doesnt see these layouts popping up but I just wanted to know what others do in these cases or any black box script for window handling of find layouts. Dom

hi guys, i was wondering if anyone could help me. on my database i am trying to set up system so i can print an invoice for a sale made previously. The reason for this is if a sale is made and i don't print an invoice then, later on i can print it (each sale has a unique sale number). I would like to have it set up so that from one value list you select the client, then from another list (perhaps on another layout) you select the sale relating to that client. At the moment all the sales come up for any client so it is impossible to find the correct one. I'm hoping there is a way to do this so it will show only the sale numbers relating to that client. Tha…

I have a simple database with products and clients There are then transaction records created when a client buys a product. I have the option to choose installation as yes or no. At the moment i have a find which gets all the transactions where installation = yes and sorts them according to the transaction month. my script then goes on to a second find which has a drop down box of transaction month coming from the transaction table which they then select and results for that individual month come up rather then all of them. At the moment it shows all the months from transactions in the second find from the pop-up list, even those where there is no installation for t…

Greetings! Beginner data entry executive assistant here. I have no problem finding all records that have e-mail (in the e-mail field i type ">0"). However, I want to find records that only have e-mail; that is, they have e-mail but not phone numbers. I have no idea how to do this. Any help would be much appreciated. Thanks. -Audra

When there is not an exact match for a find, is it possible to do a 'fuzzy' search, say something like a Levenshtein edit distance threshold on alphanumeric strings? I have an application/need, a 'cross-ref' list which has connector industry part #'s that are cross-ref to our products. Often a call/request will not have an exact match for the part number, e.g., M39029-13 and the correct part number is M39029/13 (its not just misplaced '/', '-', '', etc, but also situations like, MS24256A requested, but actual is MS24256B. These examples had the differences tacked onto the end, but it could be the prefix as well, customer gives 240-4578B, and the correct is 24-4578…

In my database there are 3 options that can be ticked contained in one field - school1 school2 and school3. One, two or three options could be ticked. How can I make a search so that on the find page, if 'school1' is ticked, results contain those with just school1 selected, school1 AND school2 (or 3) selected or all three? At the moment a search like this only yields results that match the query eg just school1 ticked. Is this possible with all 3 options in the same field of should i make 3 fields - one for each school?

I'm trying to make some queries (I think they're called requests) so that when I push a button on my front page layout, it will show all records on my input form layout that have a certain value in my Task Group field. I think the way to start this is create a script to do a find for each possible value, go into browse mode and set the layout to the input form, and then call it with the button. I create requests, and fill in the desired value to query in the task group field on the input form, but when i go into another mode and back to find/request, my requests are deleted. What's going on? Also

This should be simple. I'm trying to do an OR search by adding new requests, which would allow me to search multiple states. Unfortunately, I'm not able to actually select "Add New Request" as it is greyed out and unclickable. I simply want to be able to search for results from multiple business address states and do not understand why I can't add a request. I am in find mode. Thanks, Evan

Hello: I have a layout with 2 global fields on it. The globals are called g_BeginDate and g_EndDate. I use these two globals for a date range of records to find. I have a find button that passes the dates from these 2 globals to local variables. I then compute the find using the local variables. I would just like to know if this is a valid may to do something like this? I guess my dilema comes from the scope of globals. In a multi-user database -- if a person changes either of those two globals does it really matter since I'm only using them as temporary holders? Dom

hi.. i'm new here.. i would like to search the field with a list of numbers.. how can i do this with out using "new request." i would search 5133 then 39020, then 200303, 20202...is there a way i can do this all at once? like and "and" sign. thank you!

I imported some addresses. But in some records the fields are blank and they are easy to delete but how does on find a space character that is all by itself in the first part of the field with nothing after it. If I put the cursor in the field I get the blinking insertion point after one space. I need to automate how to find this. I tried IsEmpty function and that doesn't work Thanks

I am trying to allow the user to enter a unique record ID, have FileMaker Pro find that record then find all the records that have values matching some of the fields of that record. How could I accomplish this?

Hi, I am making a database for my Fathers business, he does MOT testing(a test all cars have to go through once a year in the UK). I would like to create some kind of find that would show us the customers which has a MOTs that is a month or less away from expiring. But I'm not sure how to go about it and have spent many hours trying unsuccessfully. Could any one enlighten me as to how to do it. I am using filemaker pro 8.5. Thanks in advance for you help

I'm making a database for school. Its a car mod shop and i have a button to search for all transactions by clients who chose installation as yes. (This is an added fee) At the moment it shows all installations but i want to do a find for only the ones in the last week. I found a similar topic but it didnt help.

Hello all This is my first post i'm very new to FileMaker started this week! I learnt a lot from a book. However, i'm now stuck!!! I require a statement for invoices showing how many per month with totals. I'm sure this can be done but how? Look forward to any replies and thanks in advance for any help. BFGK

I want to replace " , " with a line feed (or carriage return, or new paragraph, or whatever you want to call it). According to the Help file, you simply copy the invisible character from the text somewhere and paste it into the Find/Replace window. That's not working for me. How do I do this?

Hi, I have an order entry system that I need help with. One of our layouts is associated to an FM table named "Order Items". There is no script or query used in the current functionality. When the user goes to the screen where they enter items for an order, all they need to do is type in the Product ID # then the name, price, etc are automatically filled in based on the relationship between the "Order Items" and the master "Products" tables by the Product ID #. What's occuring is that some of our Product ID #'s are being reused after a product is retired and now there's a problem. Here is my quandry… For example: Product A with Prod ID #123 is …

Good Morning, I have a report that consists of only summary fields. The final and most important field is a Balance Due field which is a summary total of all registrants in a particular program. I'd like the report to only display those Balance's Due that are greater than zero. Unfortunately, FM won't let me constrain the report based on a summary field. Any ideas? SummaryBalanceDue > 0 Thanks for any help!!

Is there a way to avoid using the [Enter] key after entering data in Find in more than one field? e.g. using a button that will play a script which will emulate the [Return] and switch to another Layout. If yes how do you do it. Thanks S.A. Moor

I need to search for a set records between month names. i.e I wish to find records from January 2007 to March 2007. Any ideas how I can do this?

If we have the following in our DB: 603-900055-201 and I do a Find for 603900055201 it does not find the part. Is there a way I can make that work because it's kind of a pain..?? I can't seem to find any wildecards that will make it work. Any info would be great. thanks!

I have a script that searches for records. If it finds none based on the criteria, it creates a new one. The hickup is that I want it to be seemless. Right now, when no records are found, I get the "No records found" message and am presented with the option to Modify, Continue or cancel. I always want to Continue. Is there a way to tell FM to do that?

Hello all: I have a table A which has a many to one relation to Table B. I've done a find on Table A and came up with 2 records. I then used the GTRR command to get ALL the child records from Table B. Question: I would now like to loop thru the found set of Table B child recs and create new records in a Table C. I keep losing my found record set as I'm looping thru because I have go to layout command for Table C before my New Record request. How do I create those new records without losing my found set of Table B recs? Dom

Hello: I'm looking for the best way to get a set of records. I have a table A with a many to one relationship to table B. After I search on Table A I have 2 records. I want to loop thru the Table A records and get all the related records from Table B so I can process them. What would be the best way to do this? I'm thinking I will need to use a "find extend"? I'm just confused as to the usual standard type commands to make this work?

ok... I need a way to search my entire database for keywords and have a report printed out of what records contain these keywords. Every field in every file needs to be searched for these keywords. I am running Filemaker 6 on my client machines with Filemaker Server 5.5, the database i need to search is about 30 files and at least one of the files has well over 100 fields that will need to be search in 400,000 records. Is there any plugin that will do this or is this something that I will have to script, because it sounds like a really complicated thing to script.

I have simple database for school which has products and clients and then transactions. I'm trying to perform a search by month and year. I have the year working fine but i want the pop-up menu for month to come up as the actual month names but then perform the find according to the corresponding month number (e.g. January will search for 1) Is there a way to have a custom value list which comes up with one thing but searches for another or will i have to make a new bunch of fields in the transaction table?

Hello everyone! Here goes my first post: I've been banging my head a lot with a I've read a bunch of post here at fmforums.com but I still can't get it right! I have two fields, "date1" and "date2" (very original) in the "Search" layout, and what I want to do is find all the records between the two dates in those fields and show them on the "Results" layout. I've tried making a find request script but with I enter something like ">date1 I'd be very apreciated for some help in the matter! Thank you in advance.

Assumption: Data with valid dates from 1890 through today in mm/dd/yyyy enforced format. Search example: I would like to find all items that fall between October 1 and November 30 for each year from 1956 to 1974. Stated another way for clarification: find all items from 10/01/1956 thru 11/30/1956, find all items from 10/01/1957 thru 11/30/1957 and so on through 1974. I've tried all I know and have not been able to devise such a search. Thank you in advance for any help. Dave

Hello: I have a main Table A with 2 one to many tables B and C. I want to create a report with base information from Table A and the child records from both Table B and Table C. What would be the best approach to accomplish this? I know I'll need 2 finds - one for each of child tables B and C. Can I assume that after performing these 2 separate finds that I will have 2 selections in memory? So if I put a 2 portals on the report layout -- one for Table B and one for Table C -- I think I can accomplish what I want. Does this sound like the right path? Dom

How can I Find records that have a blank in the Committee Action field? The only values for the field are either Admitted or Rejected. Records for which no action has yet been taken are blank. I've tried =" ", ="", = . I wasn't able to do it on a layout either. For another report I want to list applications received since the last review date, which the user would input when running the script. The script I've written runs correctly, but I want to limit it to those with a File Started Date greater than a date from the user. Thanks bunches!!!

I'm trying to track my company promotions, but I'd like the option to view promotions in a calendar and have it be visible that so and so is running a promotion from the 15th to the 20th. Additionally I really want to be able to use the search mode in the calendar so that I can just view the month of May if need be and also see what the total being spent on promotions in a month is. Can anyone help?

I have a database containing several fields, which I will use Account, Symbol, NEt Quantity and date. I set up a new table just to get the result I need, which is the SUM of net quantity for the specific acc and symbol I choose within a date range. This new table contains the fields acc , symbol, date in , date end, net quant sum. Acc is the account field from my main table that I choose from a drop down. Symbol is the same as above. date in is the date i need to start the query, initial point of the date range. date end is the end of the date range point. I need that the net quant sum come out with the sum described above.(SUM of net quantity for the spec…

Hi, everybody, One very basic question,I'm afraid a very stupid one too, but... How can I define a date range search in the Specify Find Request window using a script. Range symbol - that's fine. First and last dates of the interval are in two fields. The thing is I can not link them to work together and perform the find depending on the fields contents. It's a part of a larger script, so using Perform Find script step is desirable. Thanks and wish you all a nice day.

for those who read my previous topic "issue with script that has multiple finds", ignore all of that. i have boiled the problem down to one simple question... here's my script: Go to Layout ["Artist"] Enter Find Mode [Pause] Perform Find [Replace Found Set] Go to Layout ["Artist Report"] Sort [Restore, No Dialogue] The Artist layout is a simple screen that says "Enter an Artist" and only shows the Artist field. After you enter the artist you want to search for, it performs the Find and displays the results using the Artist Report layout, which includes the YEAR, TITLE and FORMAT fields. For example, if you were to type in Eric Clapton, you would …

Here is my situation. In my database, each record has more than one field that could contain a date. I would like to pull up any record in which in any date field meets the criteria (i.e. >03/31/07) How is this possible? When I enter, for example, >03/31/07 in more that one field, then only the records that meet the criteria in every field are displayed. Basically, I am getting 0 records. Am I going to have to do multiple finds for each field and then add up the results? I tried to type OR in the date fields and FM wasn't having that. Help

Hi, I'm experiencing a rather weird behavior which I can't explain so far, hopefully sombedy out there can help. I have a text field containing "month periods", with the content formatted as YY_MM, like: 07_01 for January 2007 07_02 for February 2007 etc I'm trying a very simple "Find" on that field with something like: ">07_05" to give me all periods after May 2007. This returns 07_08, 07_09, 07_10 etc but NOT 07_06 or 07_07. I've tried to: - find with the condition >"07_05" (with quotes) - recover the file - optimise and compress the file Nothing makes a difference. Obviously, if I add a calculated field in that …

Using FM8.0 I created a runtime solution and, when I try to send an email message to a found set a message comes up for each record asking if I want to send a message. How can I send the same email message to a group of found records without having to ok each one?

i have a music database. each record is an album by an artist. (there are several other fields that are irrelevant here.) most records (albums) are owned, in which case OWN = "T" and WISH LIST = "F". some records are on the wish list, in which case OWN = "F" and WISH LIST = "T". i have an Artist Search script where you first go to a layout that lets you enter the artist. then, the script proceeds with another Find where I get to limit the results to weed out records where WISH LIST = "T" because I do not want my Artist Search to show records I don't own. i only have to do the second find once, as i can go back into the script and turn the pause off and remember the …

i'm hoping there is already a way to do this. so far i know that i can type "//" to indicate the current date. what i'm trying to do is indicate a range in find mode that would return records entered from 30 days ago through the current date without having to type in any actual dates. right now i'm having to settle for using, for example, "4/22/2007...//" to indicate the range from 30 days ago through today. tomorrow, the range will only update on one end. the 4/22 won't update to 4/23. that's why i wanted to use "//-30" for that end of the range. can anyone tell me if there's a way to do this? i'm using FileMaker Pro 6. thanks!

I want to be able to hide the scripts from the menu. Is there a way to do this? I am running FM7. Thanks Rick DeCollo

I have contrained a set using the start date / end date but now to need to refine to select only those that have a certain text in a field. ANy help would be greatly appreciated.

I created a script that would take the ID for a student, copy it, enter into Find Mode, adds an asterisk into another field and executes the find. The script, after performing the find, would then send the user to a related layout and provide the found records in list view. Now, this worked fine for weeks. Then, all of a sudden, it stopped working. Nothing changed. I'm the only one who can modify scripts and that didn't happen. Nowadays, the script puts you in Find Mode no problem but tells the user no records could be found. If I just climb in and run the same Find manually it finds all the records with no problem, but this defeats the purpose of efficienc…

In the case of: set error capture on Enter Find Mode set field x,y Perform Find Enter Find Mode Set field a,b Constrain Found Set What is the proper behavior if the first Find results in zero records? Shouldn't the Constrain then also find zero records, since logically anything constraining zero is zero? I'm finding a case where it does not work this way. Instead the second constrain is finding records as if it were starting from All records. Bug or feature? Did this change in FM 7 or 8 or did I just never encounter this particular data pattern before?

If I change the "today" field created by filemaker to be either an unstored calc field or a global field could this screw up calcs in scripts and other calc fields? I want to remove the "update today field" script as I have a comment file with 200,000+ records in it and it takes way too long to update each morning. Thank you in advance.

Hi I want to find record occurances of (instances) of a particular criteria e.g... I have 500 contacts and want to find instances that include bob in the name field. But this is what I want to do... Search for Bob goto 1st instance but also be able to browse the previous or next records surrounding this instance that don't necessarily have bob in them but then I want to click to the next or previous instance of bob and again browse the surrounding records. Any ideas?

Apologies if this has been answered elsewhere - or if the answer is obvious and I'm being stupid: In FM 6 and earlier, if go-to-related-record found no matches, the Found Count would be zero. That seems no longer to be the case. I haven't discovered any Get formula that will allow me to display a message when there are no related records. Where have they hidden it?

I'm looking for a way to preform a sort in multiple fields within a single record.

Hi. I have a text field that has lots of spaces. I want to find the spaces but when I use find " " or ==" " it doesn't find anything. I tried different text with spaces, etc. No luck. Any suggestions? Im' using FM Pro Advanced 8.0. Thanks.

Hopefully this is the right place to ask this, provided I can articulate it... I have a rather complicated calculation field ("Project Category," shown below) that results in one of four text results. In the layout, the Project Category field format is a pop-up list that uses a value list compiled with the four possible text results from the calculation. Everything worked fine in 5 & 6 and worked fine in 8, after conversion; however, when accessed by staff using 7, the find will not work in that if you enter find mode, type or select the text value and hit enter, it returns records that don't match the search. I fear this may be a bit much for folk…

I have a script used to find certain jobs in our system. I am trying to get a count of those jobs that meet certain criteria. I am almost done but need help omitting some of the records found. Each job gets a job number (5 digits). Some jobs however get a second number assigned to them, the same number ending with an A. For example: 12345 & 12345A. I want to omit those records ending in A. Any ideas?

Does anybody have a solution for a find script to allow finding the record one before the last find???

Hi, We recently migrated from FM 5.5 to 8.5. In one of our databases that contains ~42,000 records, doing a find for field content match (e.g. =="Text") has become ridiculously slow compared to the old version. This field is a normal, basic text field. It's even indexed. Why would a find that used to be instantaneous in FM 5.5 (with the same number of records) now take 20 seconds? Is it possible that the indexing has become corrupt? Is something else at work? Will unindexing and reindexing this field rebuild the index? Thanks for your help!

Hello all-- I have a text field doing double duty as a button. Click or option-click the field (button) and a script executes. However, when in FIND mode, I would like the user to be able to click in the field, type some text, and perform a find--without the button interfering (and without seeing the 'hand cursor' which appears whenever a button is moused over). So my question is, is it possible to somehow disable or bypass a button's functionality when in Find mode? Many thanks--

After several hours of reading the posts I have successfully placed a portal on my layout . (Please hold your applause until a later date Now I have a new question for the group. After entering data into my portals I then want to search for something on one of the portal rows. I enter find mode and enter my search data in the portal and execute my search. The search brings up the correct record but it does not go to the portal row with the data I was searching for. I have to scroll down sometimes 8 or more rows to get to the row with the data. Is there a way to go to the portal row with the data I was searching for? Also, the book they gave us here …

I have a job management system and for each project file we create there are additional job records which are created as the work on the project progresses. When it comes to invoicing not all of the additional jobs are to be included on the the invoice. We have a field which has a 'yes' or 'no' value on the additional job records which is selected by the user. I have created a portal in the invoice layout which shows all the additional jobs but I only want to show the records with a 'Yes' value - is this possible? The invoice layout also has other portals for other types of work which does not need to be filtered if this helps? Can anyone help with suggesting a …

Hallo, I have a simple database which consists of two objects: “schools” and “teachers”. The schools (master file) are related to teachers (related file) through a 1-to-many relationship with the school name as match file. So there are many teachers in one school. No I wanted to perform the following searches: I wanted FM to display all teachers with the attribute “female” who work in schools with the attribute “southern region”. On the other hand I wanted to see all schools with the attribute “sport facilities in the school yard” that have teachers with the attribute “part time employees”. I thought that I was enough to put the teachers f…

smiley-wink Hallo, I have one file "schools" and one file "teachers". As there are many teachers in one school, the school file is connected to the teachers file by the matching field "school name" and the teachers file is being displayed in the school file through a portal. My question: I tried now in the school file the search for all "female" teachers. Therefore I typed the attribute "female" in the field in the teacher portal, but the search did not work. FM showed me all the teacher and even only for one school So I tried the same search in the orginal teachers file (so not in the Portal in school file) and it worked. So, isnt it possible…

Hi, I’m a newbie and I work with FM8.5. But i have a probleem: I would like to see the amount of documents per folder,ordner and map all the time At the moment this can only be done via the button, which is a search When the given quantity is 25 the next record , 26, should be red and a message “new Folder Please” should appear. The same for ordner and map (it only works with Folder). Who can help Thanks alain Ordener_2007.zip

Someone earlier on this board kindly helped me with a script to find the current month. http://www.fmforums.com/forum/showtopic.php?tid/186398/ Now, I would also like to make a script to find both the current month and next month and display the results together. I assume that it can be accomplished by modifying the previous script, but I'm such a rank beginner that I'm not sure what changes to make. Thanks for the help in advance.

I have a report setup whereby the user enters in a date range and clicks Submit for it to generate. On the report itself I would like to display the year in which the date range was in. For example if the user enters in 1/1/2006...12/31/2006 I want the report to display '2006' in a designated area in the header. I've tried formatting the field to display only the year and it does that but doesn't pick up the correct year for example. In the above example the report incorrectly displayed '2004' instead of '2006'. Any thoughts?

I have a contact table and a conference table. Both have serial # IDs attached to their records. I am trying to make a portal on the Contact layout to allow me to make a list of the conferences that a specific contact has attended. In my portal table I have a drop down list that lists all of the conferences. Once a user selects a conference from the list, I want the start date and end date to be included automatically into the table (the dates can be found in the conference table). How do I do this?

Hi, I'm having a big problem... I transfered records from a corrupted DB on a clone, but all the indexes in the new db don't seem to work. When I'm doing a search on the primary key, it never finds the record. I tried with an existing record... Does anyone had this problem before?