Finding & Searching

Hi, I have encountered problem with he Start Date and End Date fields of my Events database in Find Mode. Whenever I entered a date in Find Mode, say 1/11/2011, it automatically changes it to: */01/2011 */11/2011 */*/2011 The same thing happens if I use the Drop Down Calendar to choose my date. I could not figure out what went wrong and would appreciate your help immensely, many thanks! MacGuffin

Because my search windows do not display the toolbar, users have no access to the search operators. So I have placed them in a drop down list on a text field (in the footer) with a button/script that places the displayed operator wherever the I-beam is flashing. This works fine for most operators, but whenever I choose one of < > ≤ ≥ , I get "This field contains invalid find criteria. Allow this invalid value?". Although I can click "Yes" and the transfer works, it is then not accepted by date and number fields (I get the "Modify Find" dialogue box). Can anyone explain why I am getting these error messages with these 4 operators? And why Date and Number fields …

How can I perform a find that returns only unique records? This is a simple task in MySQL but I cannot find an easy way to do this in Filemaker. For example, let say I poll 500 people and I ask them their favorite ice cream flavor. I want to perform a find in the ice cream flavor field and see a list of all of the flavors that were submitted...but I don't want to see 200 records for chocolate, 50 for vanilla, etc. I just want to see a found set that contains a single record for each flavor that was submitted. I realize that I can generate a report, or a relationship list that displays the information but I want to do this with a standard find...without having …

(I hope this is the correct forum for this question since there isn't a Sorting section.) I have three fields, each with its own sorting script: City, State and Country. Is there a standardized or "best practice" way of sorting these guys? For example, if a user selects City, should the sort order be City / State / Country? ...if State, should the sort order be State / City / Country? ...if Country, should the sort order be Country / State / City? ...or, just don't have any subordinate sorts at all? If the user selects City that's the only field that gets sorted--State and Country go unsorted? To me, it'd be beneficial to have the other t…

Databse MAIN.fp7 records (example w/ 3 records) ................................#1....................#2.............#3 End Customers: |Agil...............|Agil................|Agil Sub Customers: |Enterprise |Enterprise| |Local Circuit Number:|01-aszz-222|01-aszz-554||01-as While in MAIN.fp7, layout from MAIN databas Want to perform search that only returns unique records base on Enb Customer and Sub Customers. Desired results from search- two records: Agil, Enterprise & Agil, Local do not want to see the "other" Agil, Enterprise record. Can someone help me?

I have a database with four tables. I use this database to manage tasks in my cabinetshop. One of the tables is a master task list. This table contains all the tasks necessary to complete a particular style cabinet. The other three tables contain task lists that are germane to specific components of the cabinets. One table contains all the operations necessary to build a faceframe. One table contains operations for drawer boxes One table contains operations for end panels. Etc. Depending on the particular composition of the cabinet some or all of these processes are imported into the master task list. Is there a way to navigate from the…

If I perform find using a layoutA using file Messages and I find 5 found records, and i move through each of the 5 records maybe editing them... my problem is, I have a small trigger script, that fires in the background (MMscript) using a different layout same file Messages The trigger need to find a different record other than the first Foundset in same Message file.. then do something to a field.. How can I return back to the original 5 found record set without performing a new find? Whats happening is the Trigger script fires... finds the one record.... and changes my found set only showing 1 record verse 5 records TIA

I am working with a found set of records I arrived at using gtrr through a multi predicate relationship. I have to scroll through and check each one before moving on to the next step in the proceedure. As I check each one I mark it with a checkbox and omit. Quite often I am diverted from my task before it's complete and in the process I lose my found set. So I use the same gtrr to get back to the group i'm working with. But now I have all the checked records included. I'm embarassed that I can't get my head around this but, what is the easiest way to eliminate the marked records from the found set? Logically I would think I would just enter find mode, click omit, check th…

Ok, I'm working on the script below. I've been searching the forums and trying to figure out how I can make my second request in the find be a OMIT instead of an include find. Basically I want to find all records with an Assurance Flag = "No" and in the region the user selects from the custom dialog box and then omit any of those records that have "NONE" as their Assurance form letter number. I feel like I should know this but I can't seem to find the answer. Any help would be appreciated. Thanks. Freeze Window Enter Find Mode [ ] Go to Layout [ &#8220;Layout #18&#8221; (DA_Master_list) ] Set Field [ DA_Master_list::Assurances Flag; "No" ] Show Custom …

Hello, Im sure this has been discussed but Im not sure what it would be called, so am having no luck finding the solution. Id appreciate anyones help in directing me to a posting that covers this...(or a point in the right direction if in fact this is not a previously discussed issue) I have created a layout and a FIND script which returns the the following if the customer has a test that has not been printed: Customer Name-- Date of Test-- Printed (Y/N)-- The issue I have now is that if the customer has a test that has printed, and one which has not, the layout shows the first test date and of course indicates that it has printed. (has last years …

Hi, I have a database with a portal layout that reflects a real-time grid used at work. The portal fills with unique ID's upon a specific Group ID that is entered. One of the fields in the portal is a date field, that when clicked on autopopulates the current date and turns the cell red. One problem we are running into is when a day of data-taking is "missed" you end up with a number of records in a grid that need to be backdated one date. So you click on let's say 15 of them with a date of 10/20/11 but then you need to click on them again individually and a calendar pops up and you change the date manually, one at a time, to 10/19/11 for the ones that were…

Hi, I setup a database for patient information, and am now at the stage of learning how to generate records based upon the data that we input. I have a couple questions, and would really appreciate some help to point me toward the right direction. I have my database setup so that there is a layout called Patient List, with patient names and identification numbers, and a table called Main Table, which has a tab control on a layout for the table which has individual portals to separate tables, such as MRI data. I attached a copy of my database to show how I have set it up. One function that I would like to be able to do is to be able to generate a list of …

Hi. I have a ton of records. 250,000 in one table. More than half are records I don't need to search for this particular script. Here is what I'd like to do. Find: All records where "name" field is empty. (this shows me all the records I don't want). Show Omitted records: This inverts the find and shows me the records I want to work with. This part I'm good with. Now, I want to run multiple finds because I am using a summary field to generate totals from the records. The first time I run a find from the my found set, it is all good. But then I need to go back to that first found list to run my second find. I don't want to hav…

Have problems with script trigger. There are 2 tables: People and Account, relations between tables are by account name. In a Account table I had <SearchField> I need to find records in People table so name field had script trigger parameter on modify -------- show all records enter find mode set field (People::name; Account::SearchField) perform find Script don't work (it's change name field) if SearchField is not Global, but I need to do the each Account record must have own search fields. Please help, or tell how to make this script more better.

Hi All. This my first post in this forum. I have 3 tables. T1 and T2 has a relationship with T3. Table T1 has column Code1 and Table T2 has column Code2. When I create a new record in T3 I set the value of FKID1 and FKID2. Now I use this pop-up menu. First Pop-up menu display values from column Code1 and second pop-up from Code2. It works great. (Copy database in the attachment.) http://www.4shared.c...New_Record.html Unfortunately, I'm looking for something else. I do not want to use pop-up menu. I want to replace the pop-up menu, "a text field". I want to be able to write the value "Code" and set the relationship between T1 and T2 In the fi…

I have table_1 in FM & I need find some data in this table for criteria fieldA>fieldB I write script: I try related Table_1 for him self Table_2 from some ID field & corect script: Enter Find Mode[] Set Field[Table_1::fieldA; ">" & Table_1::fieldB] Perform Find[] In result this script work not good. They show data where fieldA>fieldB & fieldA<fieldB. Its not good Enter Find Mode[] Set Field[Table_1::fieldA; ">" & Table_2::fieldB] Perform Find[] but its dont work too. How can help me?

My goal is to have a generic script which enters find mode, goes to "x" field so I can keep my script population down. I am attempting to do this based on the script parameter for the button launching the script, but it seems that the "Specify" option only related to a repeating field. Am I on the right track or is there a smarter way? If I'm on the right track, what am I missing here?

Whats the best way to change a date in a found set(All Records) to todays date? -Jay.

Hi all! Well, here I am, at the end of my rope, again... but with the help of the experts here I'm sure I'll be shimmying back up. I have a bunch of contacts, some of whom participated in a walkathon. One of the Contact table fields ("WalkerByYear") is a checkbox set, with the last five years listed. I want a script to find all the people who walked in the previous two years; thus, they will have either 2009 or 2010, or possibly both, checked. This has turned out to be, shall we say, less simple than I expected. I've realized that checkbox sets are indeed just regular text fields that get the various options strung together with carriage returns (when you…

Hello. I'm new at Filemaker Pro. So, please forgive me if I'm asking a simplistic question. Here is what I wanted to do. I would like to enter data in a certain records's field, from "Table A". Next, I would like to have a button setup that when it is selected, a script would be activated to search for records in "Table B." This search would look for records that have a certain field that matches the data that was entered in "Table A's" field. I currently own a copy of Filemaker Pro 11. My computer is a Macbook using OS 10. This is the script that I wrote. • Set Variable [$$Enter Data: Table A::Temp Data] • Perform find [Restore…

Hi! I'd consider myself an intermediate FMP 11 user, by no means a newbie, but something simple has me stumped. Maybe it's because I've been away from FM for a while... anyway, I'm trying to find all records in a table of charitable donations within a specified month and year. Doing it manually by entering search mode and typing in "2010/8" (for example) in the Date Received field yields correct results. But scripting it, using a couple of global fields, fails - it finds all kinds of stuff beyond the intended range. Equally puzzling is the fact that when I add a Pause Script step after setting the field in question, there's nothing entered in the field. The fi…

Having a bit of an issue here... I want to act upon a search result prior to Filemaker displaying search result returned empty... So basically, if the 'found count' or search result is empty, do a different search. I do not want the end user to see the search returned empty. Since they didn't search for anything (a script did) it's confusing for them.

Hello, I have a Line Transaction table with about 113,000 records in it. When I enter Find mode, and enter 14022 (for example) in the "Contact ID" field, the results show 83 records found, 82 of which have 14022 in the Customer ID field and ONE which has 14029 in the Customer ID field. I've included the screenshot below to help explain myself... note the circled value near the bottom! Thanks for any ideas or things to look out for...... never had this happen before.

We have several off-site people that remotely log on to our customer db through the web. One of the new features of FM 11 was the 'global' search window in the upper right corner. The remote people do not have use of this feature. It is hosted on a FM 11 server. Can anyone help? We are fairly new to a hosted data base. TY

I have a question I'm afraid I already know the answer to. I walked in on someone else's database and their fields are all in ONE HUMONGOUS table rather than parsed into several smaller ones (one per layout, at least). I am trying to find a way to rearrange the existing fields to make them easier to find, but the only solution I can come up with is to create a completely new field in the target layout, then export the data from the existing field and import it into the new one. This would be fine, but I have approximately 300 fields to do this with. I'm told that according to database theory, the idea of just dragging a field from one table to another is strictly fo…

Hi All, Please can you assist a Newb, I have recently moved to Filemaker from Access and am having some troubles. I am used to building queries, hence the differences with scripts!! I have two tables with related data. The primary table (Calcs) has a field who's answer is based on a calculation, there are another 4 columns who records are based on user selections. I need these answers to look up a related record in the secondary table (Pumps). What makes it more difficult the find must take into account the calculation result from the first table is an arbitrary number ex 5.3338 the find must be based on values between 30% less and 50% more as well as the other se…

Hello, After a long time to search, I can't find the answer, so I am looking for some help here. I am doing a perform find restore which give me a restricted table. With this restricted table I am doing a loop in order to calculate something for all the rows. Inside this loop I am doing an OTHER perform find restore. The point is when I am trying to get to the next rows, he did not still have the table of my first perform find restore but the final one which I do not wan because I want to skim all the rows. How can I keep the table of my first perform find in order to use at the end of the loop. I hope I would be clear even if I don't think I…

I'm having trouble figuring out something which is probably simple. If I right click on a field and select "Find Matching Records," all matching records are found. Is there a way to script "Find Matching Records?" I see "Constrain Found Set" but not "Find Matching Records," which I would like to script so I can place a button on the layout. Thank you, Kevin

I have a table of transactions in which there are hundreds for each day that are timestamped. I want to create a "dashboard" that will show the number of transactions for the current day, previous day, current week, previous week, month etc. The only way I can think to do this is to create a separate relationship for each date period I want to show. Basically, have a Today, Yesterday, ThisWeekStart, ThisWeekEnd, LastWeekStart, LastWeekEnd, etc. fields in the dashboard layout, then build SEVERAL relationships to the transaction table where the relationship is based on the dates then have calculation fields that "count(transactions::field)." There has to be a clean…

I just joined the group here and can not figure out how to post a question. Can you give me direction? Using a 2003 or so version of Filmaker I can not figure out how to make a script to find all the Debits of say $50 in one field and all the Credits for $50 in another field across a group of records.

I have attached a simple file. If I search for A...Z in these records, it is not finding two records that I thought it should find (I have changed these two records' text to red). Can anyone explain why these two records would not be found in this script? I keep trying to pin down the theory and I just don't get it. :idunno: AlphaRange.zip

I want to locate all invoice records which contain a duplicate entry in a field "Customer Ref" and then have only ONE entry of each duplicate show up in a found set .... for subsequent processing my my own simple direct mail engine (FMpro Server v11.3) Is there a short cut to achieving this please.......? I just want to send a "special offers" letter to all the customers who have more than one invoice present on the invoice transaction file. My probelm is probably my own relatively sloppy understanding of the relational model ...... but I would greatly appreciate a wizardly point in the right direction.....

I'm a little lost as to how I would go about creating scripts in the "Find Mode" layout. For an example, I have a field called "Start Date" and another field called "End Date". Instead of typing in dates I want to be able to type "oldest date" in "Find Mode" in the fields "Start Date" and "End Date" and when I press enter it will search for the oldest date to lets say year 2005 then as I click onto the next record it will increase, like an ascending order from year 2005-2011. Where or how do I go about starting this script?

I'm trying to create a summary report by month, But I need to display the month header even though there are no records for that particular month. Here's what I have so for, but I a little stumped on how to get all months to show. Thanks in advance! Anthony Monthly Summary Report 2.fp7.zip

Sorry if this is a total noob question; my google-fu wasn't strong enough to find the answer. Using the "Perform Find [Restore]" script step, the "Specify Find Requests" window says "Find requests are executed in the order that they appear." Okay, so the list of requests must be easily re-orderable, right? How do you do that? TIA, Ian

I have had a look through the forums but I am unable to find a solution to this, I think it might be the way I am wording the query. I have a DB of 5000 odd records and i have created a search script that will find records to meet certain criteria, these records are then exported to an excel file and get marked as being exported so they will not be picked up in future searches. The export file will be used to contact our customers. I would like to be able to perform my search but tell FM I want to find the first 200 records that meet the criteria. This makes the exported file manageable chucks for the reps to get on with. Cheers,

Single Table Tree Structure Database. Every record has a unique ID and a parent ID. The Parent ID always matches some other records unique ID A Parent can have multiple Children. A child only has a single parent. The root record has a parent ID that matches it's own ID (or zero if you like) Given any ID I need to be able to search up through the tree to find the first parent record or parents parent record etc that has a character field = "Diamond". If not found I need to be able to return the root record. Given the same ID I need to be able to provide a list of all the children, childrens children etc of the given record ordered by name or ID. …

Ok, this should be easy enough. I am creating a script that include perform find. I see I can add multiple finds. The find are AND. example FirstName = Bob Then if I add another say LastName = Smith and run the script it will only find all the Bob Smith. What I want is to find All the Bob's OR All the Smith's How do I do this within the perform find when within script mode?

I have a solution that helps keep track of file deliveries. We delivery relatively large numbers of files (so far, up to about 90k per month), and some of these deliveries are of the same file to multiple destinations. I need to create a list of all new deliveries in a given month, and all previous deliveries that have been invoiced. I already have a method to get a list of unique filenames, but I now need to search the "delivery" table for all instances of each unique filename delivered in a given month. For example, the table "deliveries" contains 1,000,000 records. In August we made 25000 deliveries, of which 15,000 were unique files. I need to search all 1…

How do I do a search if I want records where the field is blank?

I'm in the process of migrating a customer from one filemaker db to a new db file and my customer would like to migrate his saved finds from the old database to the new one (without having to manually reconstruct them). Is this possible?

I hope I am posting this in the correct area. I am a novice and have just built my first application for my business. We have built an application where all our prospects, customers and Infrastructure sites are in one table. I want to have 4 buttons at the top of a screen where you can select which data you want to work with, Sales, Customers, Infrastructure or All. So, when you press the "Customers" button you only see customer records even if you add, delete or find, only when you press the ALL button will you see all records. (the table does have a record type field). Is there a simple way to do this. Everything I have tried cancels when you do a fi…

Hey Everyone, Pretty new to filemaker so this idea could be way over my head/not possible. I have a portal that displays two fields "ingredient Name" and "Qty Used". A typical portal looks something like this Ingredient #1 ----> 50 Units Ingredient #2 ----> 30 Units Ingredient #3 ----> To Wet Ingredient #4 ----> Qs to 100 Units I am looking for a way to "tag" any ingredient that has "To wet" or "Qs" in the Qty Used Field. The reason i need something like this is because I track each ingredients inventory level. As you can imagine it is pretty hard to track inventory for amounts such as "to wet", so I am looking to tag an…

Dear all, I'm using FMPro 6. I need make a search in three different files (e.g. Company, Employee, Customer), I want to make a search of telephon number in sequence; search in the first database (Company.fm) if is not found, continue the search in the second database (Emplyee.fm), if not found continue the search in the third database and so on. When the number is found, I need to start a specific script. Please, someone could help me to create a scrips (or other solution) to make a "multiple" search in more FM database Thanks a lot Walter

Hi, I'm new to FM and here is the dilema I am having: I have one portal where you enter subcontract name and attach a file - this portal has a relationsship with another portal budget - what I'm trying to do is search portal #2 with the information located in portal #1 - For example 3rd row of portal 1 name is ann and project number is 10235 - how can i set up a new layout using protal 2 and identify name is ann and project number is 10235. Any help would be appreciated. Thansk

I am not sure if anyone is going to be able to shed some light on this for me or not but I am at a loss here. The problem I am having is this. I have a report that needs to be displayed that will only show reports from the fist of the month to the 30 or 31s of the month. The reports also need to be marked "NO" as we have a radio button box that requires the user to select yes or no. Reports with yes are left out of the report we want to display in a new layout. Anyhow what is happen is we have one report that no matter what we do will not show up in a report out of 44 we would like to print and heres the thing. No matter what we enter into this box it will…

Hi All, This is a height definition consisting of two fields, one for feet and one for inches. They are currently defined as text, but I am guessing they would be better as number. Say you want to find every person between 5'11" and 6'3". My idea was to have another field which calculates the height in total inches. But I am having trouble visualizing how to do the find. This range will probably not be the only find criteria for any typical find. I cannot seem to conceptualize how to make this happen so that it is easy and transparent for the user. Any ideas much appreciated. geod

FM experts I have a partial script attached that "Enters Find Mode", selects the desire field and stops. I would like the user to be able to enter the find criteria (date in this case) and hit the return key to activitate the "Perform Find" step and not have to access the Status Area and make a selection. Any thoughts! Steve

Hi, I have 2 layouts "Leads" and "Prospects" which both have their own tables. I have made a script that imports a complete record from Leads into Prospects then deletes the record from Leads after it has been moved. This works well. The problem is after the export and deletion the Leads are reset and back to record No1 I need it to go back to where it was even if i was in a Find. Any Ideas? Ian

Hi Guys, Actually i'm collecting data from a RFID reader and data shows the time in and out of employees. Normally if an employee works on a shift system the time in will be calculated time/date=X and time out will be time/date=Y that is two different dates. for example shift workers will have time in today at 6:00pm and time out tomorrow at 2:00am. can somebody tell me the calculation to get the number of hours worked for this employee or have a better idea how to proceed. Thanks....... :D

Hi. Ive looked around and couldn't find an answer on the forum, but if there is please point me to it. Goal: In list mode I want to have 3 check buttons (in the head) that hides and shows rows based on a field. Example of field values Offer invoice order Problem: I can manage this by scripting Omit multiple values, or extend found set. The problem is that I want the user to be able to check multiple boxes and get the right results. So if I check "offer" and that preforms a (="offer") find, I want to be able to check invoice as well and get both offer and invoice but not order (="offer" & or & ="invoice"). As it is now if I check one …

Hi there, After performing a search in table A, I'd like to move the result to table B. I tried different scripts such as... New Record/Request Set Field (Table B::Global Member ID; Table A::Member ID) Set Field (Table B::Member ID; Table B::Global Member ID) with no success

I hope someone can help me preform this find. I want to find all my open jobs. This is what I am doing now is finding all jobs from a certain date to present (field name Open Date), then sorting them and omitting the completed jobs (drop down menu, field name is Job Status), but this is really a pain. 1. The original find that I wanted to do was with a radio button that has 2 buttons, open and closed. I could not get it to even search this field. 2. The second way I could search was by a drop down menu that says, In Queue, At vendor, Complete, Cancelled, On Hold and Rush. I guess I could search by closed jobs, but how do you tell FM to show the opposite of…

Hi, How can I automatically search In browse find without pressing the find button? Thanks. p.s. I have 5 field in my layout. I want them automatically go to find mode without pressing the find button.

Hi All, I want to perform a find in a table on a key field and if no records are found then create a new record but I can't find an error code to capture for "No records match this find criteria", can anyone tell me what it is please.

After someone made a boo boo on our database and managed to change 1000 phone numbers to all be the same thing I ask - is there a way to disable the "replace field contents" option for particular users/user groups? (before anyone cringes, don't worry we had it all backed up) We are using FM9 if that helps.

Hi Everyone I am trying to create a summary report based upon a number field. I want to be able to show the number of records in each range. 0 through 10 11 through 20 21 through 40 greater than 40 I hope I'm explaining it correctly. Thank You Anthony

Can someone help me with this problem? I have modified the "Show All" command so that it shows only a specific set of all records depending on the layout name. If a user has first found one particular record and, subsequently, clicks on "show all", FileMaker takes him by default to the first record in the (expanded) found set. Alternatively it can be scripted to go to the last. But I cannot find a way to take the user back to the record he had previously found - but now within the expanded found set. Thanks for any help.

I need a script to search for a text string, but I only want results returned if the string occurs within the first 50 records of the table. For practical purposes, each record consists only of a text field. I'm probably overlooking something, but I can't think of a simple way to limit the search. (BTW, I have no control over the fields defined in the table, so adding a "search me" indicator is not possible.) Thanks in advance for any help.

Hi. I have a filemaker file that I use to learn. It's where I test new ideas so I don't inadvertently kill my work FM file. I have a few questions but I will limit them to one per post so I can understand the solution before I tackle the next problem. I created this file and offer it free to Crossfitters. For those that would like to keep an electronic database of their workouts. I added a small calendar using repeating fields using fnCalendar. The calendar works fine but I would like to highlight all dates that the user has worked out. So criteria would be that the date has been entered and that something has been entered in the results (MOD) field. I …

hi guys, i'm using fm11pro and i have my inventory database, I would love to have an check mark for the sold items and dissapear from the available items. i will include a picture of my base, can somebody tell me how i have to do to make item dessapear if i mark SOLD ? thanks in advance.

Hi, I am working on a solution that searches then charts the results, how can I also include the find criteria in the chart? Hope there is a way to capture the find criteria so that it can be used in a global field or script.

Hi I need a little help as this thing is driving me crazy.... I have a part database that has a field called Part_Calc, which is a combination of different fields used to create a description of different parts that have different attributes which have been entered into different field. The end result is a text. Using a self referencing field, I copied the text to a global field and then proceeded to another layout in the same table to do a find. here is where I am having the problem. First I find all, then enter the find mode. In the find mode, I past the text so that I can look up and edit the specific variables that created this text originally. …

Hi Guys, I'm not sure if this is possible and I hope I explain this correctly, I have a database of photos, each record has a name eg. 'Riverside' and there can be hundreds of records with the same name. Within each record is a field called 'SRPath' that can contain one of three variables photo/CD/ or photo/Class/ or photo/Classic/ What I would like to do is first isolate all the records with the name 'Riverside' which is easy, but I would like to then display the total number of records within that found set that contain the three variables in the 'SRPath' field... eg. Riverside Total CD = 236 Total Class = 589 Total Classic …

Hi, I am trying to perform searches in a calculation field which uses related fields in its calculation to produce statuses (and thus not indexable). However a find in this calculation field incorrectly generates the error; "No records match this request" when there are records that match the find request. This link seems to note that this search-ability (in non-indexable) is not possible in older versions of file maker: http://help.filemaker.com/app/answers/detail/a_id/1812/kw/stored%20calculation Is this true of FM11 or is there a way around it? The coding used in the calculation field is: If ( IsEmpty(po) ; If ( Count ( rfp_link::id_rfp ) ≠…

Hi all, I am a newbie and a few years back adapted a "Filemaker Business Productivity Solution" to my needs. I successfully made many changes but could never get the "Find" to show me the last record, always defaults to the first record. Today I was trying again and realized that when I changed the name of the script from Find to anything else it would keep working, I thought it was going to complain it could not find the script. So, how does it work, is it in some code?, or is it part of the program? Can someone help me find where to make the changes? Or tell me how to work around this. I want to add: Go to Record/Request/Page [Last] (It work…

Hi, I created a login with very limited privileges, basically the following: - Records: create/edit/delete - Layouts: view only - Value list: view only - Scripts: execution only Now this user cannot use the 'find'-button on the 'status toolbar' (it's greyed out). I assume this is caused by the privileges. Does somebody know what to change to allow the 'find'? thx,

Greets, and I hope you're all still around after May 21 or I'm sunk. (This probably belongs in the Script forum but here goes...) I have a field, Table1::NameLastFirst, that contains the last and first name of people. After performing a Find in this field so I have a found set, I'd like to go to an unrelated table (Table2) and perform a Find using the names in the found set from Table1 to pull up the like-named records in Table2. How do I do that? I suppose that I could relate the two tables using NameLastFirst as a key field, but I'm still stuck with the same problem of how I can accomplish this monumental task. TIA for your help! Rich

I have a file that finds a phantom record. This partial file consists of personnel record, some of which are volunteers. If I go to the Volunteer Data (use button) and search for a volunteer ID number 8925, I get 2 records, one of which is a blank (phantom) record with question marks in most of the fields. The other record is the correct one. The total record count is 203; if I delete the phantom record, the correct record appears and the record count is still 203. This does not occur for all records, and I have only identified this one record so far. NOTE All records below 5001 are blanks. Can anyone tell me what is happening here? User Name: John Password: 123…

I will try and explain this as simply as possible I have a table with bookings for a travel agency. Each booking record contains a primary key field with unique values, an email contact address and a timestamp for when the booking was made What I am trying to do for marketing and tracking purposes is to identify repeat clients within specified time periods. Its easy enough to find bookings made within any time frame and any email addresses that occur more than once in the database. What I am actually looking for in stage one is to take any specific date range eg Jan-June 2010 and find which clients made multiple bookings within that period (eg if…

Field1(global field); // for searching LIST VIEW Script on field1 modify: show all records; perform quick find[field1] go to field1; How I can solve problem when there are no find records matching field1 criteria. How turn off the error window or do nothing when there are no matching records.

My database has a date field showing (example) "deadline" (15/8/2011) etc I would like to be able to script a find that will show all records that state todays date + the next 7 days? I have tried the following (//...7) but it shows me results from today until July (7). Can someone please advise? Many Thanks

I apologize if this is covered somewhere else, I tried a bunch of searches but couldn't find any info about this. I have field with pathnames in my database, and I'd like to find the records that the pathname field does NOT end with ".mp4" So I went to "Find" and chose to "omit", and typed *.mp4 in my "Pathname" field (text). What I got was all the records that do not end in .mp4 AND any file that had number or a symbol anywhere else in the field. This is not helpful. (I thought the * wildcard was supposed to be any character not just letters?) I just want to omit anything ending in ".mp4" any ideas?

So made a find button On entering the button, Enters Find Mode: Enter specific Find: omit records: Critera: would like to omit any records 60 days older than todays date: So omit records:// ...lost now. i know its something simple Made 2 new field Current_Date & Find_30 Script name: Customer_Report Enter Find mode[pause] perform find[] insert current date[select;job ticket::current_date] Insert calculated result[select;job ticket::Find_30;job ticket::jobdue - job ticket::current_date] Constrain Found set[restore] Find Records jobticket::Find-30[>30]

I want to find all records that a field A is > 0 or Field B is = "Yes"

I am looking for a solution to omitting records within a self join relationship. I have a table "Daily Manhours" that holds the daily hours of all employees of the company for several years. Among other fields, I have fields "date", "employee ID", and "total hours". I created two new fields named "week beginning" and "week ending" with a self join relationship to "date". By doing so I was then able to produce a report that gave me the total hours of all employees within a date range where the range would be input by the user: Daily Manhours:Week Beginning Daily Manhours:Week Ending Daily Manhours:Total Hours Summary That works good for that s…

hi all is there a way to define a filter just for a specific range of values? i have records with an ID_Number starting from 100 to 500. i want to filter out all values except 400, like all values <400 and >499 may be is just a simple question, buti can not figure it out my self, maybe somebody can help f.

Question says it.

Find button in the toolbar has an arrow to shows recent finds. Is there any way create a script to clear this finds instead of manually clearing them?

I have a database with email addresses in it and I am trying to search for specific words found within the address without success. Example: [email protected] and [email protected] I will like to find all email addresses that have "ox" in them. Seems simple enough, but no success. Tried: \.ox\. "ox" \."ox"\. \.ox ox\. .ox ".ox" \".ox" "ox.ac" ox ox.ac and several others. The only result I could get by searching "ox" was if "ox" was the first word or a part of the first word after the @ symbol. Searching "biotech.ox" works, but I am trying to find addresses with "ox" that are not restricted to "biotech". I even tried creating another f…

I have a DB with invoice file related to client file. When making monthly statements, each client will have multiple invoices per monthly statement. I want to print mailing labels from the found set of statements, but need to eliminate all but one duplicate client name & address fields (FROM EACH INVOICE). Each client has a unique client ID. WHEN WRITING A SCRIPT TO DO THIS THE Omit function in find function eliminates ALL. I need to retain one to print a mailing label.

I have a portal on a layout displaying 10 repetitions of "Keywords" that the user can enter to tag Artwork records with descriptive terms. The user can search by entering Find mode, but in Find mode there is only one repetition available, so it seems to me that it is not possible to perform a logical "AND" search -- say Find artworks tagged as "Landscape" AND "Cubist" (the way I might find "Landscape" AND "1929" where the year is held in a separate Year field. I looked in the FMP Knowledge Base to see if I was missing something, and found this: http://help.filemaker.com/app/answers/detail/a_id/3183/kw/search%20in%20portal . . . which seems to answer …

Hi, We are adding about 25 posts to our database daily. Some of the posts are the same customer. Example: I've added 10 posts today, 2 posts of these is the same customer. To find the posts added today, I'm using Table::Created [//] in the search-mode. This shows the 10 added posts today. In the same search I want to find other posts matching the same post. I want to filter by matching the Email. Example, The mail of the current post is [email protected]. I want to find all posts added today that match the mail of current post. Thanks, I hope that you understand my problem I can help me.

Hi all, Is there a way to show two separate find on a single layout. What I am trying to do is show period data from my Line_Items table and also show the same period in the prior year at the same time for comparison.

I haven't paid much attention to the Quick Find feature until now, so perhaps I am missing something: shouldn't clearing the search text box cancel the find and show all records? I thought this feature was supposed to resemble OS X Spotlight - well, that's how Spotlight works. But in Filemaker clearing the box seems to be an absolute non-event - so you cannot even use it to trigger a script.

Hello, I need some clarification on layout search option. We have a layout where the user has an option to search all fields on the layout by the click of a button except for one. All the fields have a value list behind it referencing the field itself. The user would like this option for the one field that isn't search enabled. The only difference between this field and the other ones is that it is Indexed, Unique. Is it not possible to setup a value list on this field for search purposes. I have already tried, it let me setup the value list on the field but when I go back to browser and then search its like no change was made.

In default we have quick find option in Toolbar but my objective to implement the quick find search box to the layout screen. I'm not sure how to implement it. Is anyone having the knowledge about to use the quick find options in multiple way please share your experience..

Hi everyone- I have a database where there are duplicate contacts that have been entered by different users, which means that records with identical first name and last name fields have different unique IDs. I have found scripting solutions (I'm a scripting beginner and just learning the ropes) for identifying and deleting duplicate unique IDs, but how do I script for a search that will identify records that have both identical first name and last name fields and delete the duplicate? This is for FMP11 on a mac. Thanks so much!

hi, i would like to show the total number of records present in all the other tables on my principal layout, but i can't figure out it.. very simple i think, tnx

I have a list of records and would like to have a script that would find the records where Field 1 is greater than Field 2. It should be simple but I can't figure out how to get the second field in the find after the > sign. Table::Field 1 > Field 2 When I try it I get - Table::Field 1 [> Field 2] - and it says it can't find any records that match criteria.

I'm trying to create a top two sales report by customer sorted by highest sales first. I have created a sub-summary report based on customer, but I guess I need to find my top two before I run my report not sure how to constrain the set to only the top two. A little lost :-( Running v10 Advanced Mac/Win Thank you in advance for any thoughts. Anthony Sales Report.fp7.zip

I have people (persons table). Many may live in same house but belong to different families. Some have no family (sad yes). From the person table, I need to find many people (some have families and some don’t). I find people by other information not in the sample file (age, six, birthday). I may find only one person in family#1 for example. But if there are other people in family #1 I need to increase the find to include them I am trying to use extend based on join table kf_family. But when I extend the found set, it jumps to the first record again and I lose where I was. Even sorting doesn’t stop the jump back to the beginning. I tried putting the rec…

Hi, my company currently uses FMP database for job scheduling, and employee record management. Our previous staff member that maintained and developed a lot of what the database is today is no longer with our company and now I have been left with maintaining the database which I have very little knowledge about. Very briefly we are a service company that sends multiple crews out on any given day. Within a crew there are a maximum of 8 persons. The job card that we print out and give to the team leader is a form that is printed from the FMP database. This form advises all information including, Customer, start time, finish time, additional non standard items to t…

I have a form that shows records filtered by one field. Another field on that form is one for year. I want the record to show on the screen by default is the one where the year field is the current year but I want the other years to also still remain in the found set. So for example after the find there are three record one for 2010, one for 2011 and one for 2012. I want the 2011 to be the one showing on the screen but the other two to still be available by scrolling. can anyone help many Thanks John

I created a new table where users can add records to. The records they create are displayed fine through a portal, but they do NOT show up in the table view of the table - It contains zero records. However when i perform a search in the very same table, i get results! I find the 3 records that should be there, and the search result is : 3 / 0 Found. When i do show all records, it goes back to zero. I am clueless. I must be doing, without a doubt, something very stupid! But i've been working with FMpro for many years and i have never experienced this before. Where are my records stored? See screenshots. show all records: search results f…

I’m preparing a payroll report. This file will be used year after year, but beginning a new file each year. I want buttons to find each pay period (i.e. 3/15 or 3/31). The problem is the date enters the current year automatically. so when I get to 2012 none of the find buttons will work. Is there a way to work around this?

Hi, A script I'm writing includes a perform search on email addresses. However, the @ symbol is causing problems. Is there a way to search for a full email addresses? The result returned is that there were no matches. Thanks

I am having trouble with the Specify Find Request. There are several fields that need to be examined: email DOB (Date of Birth) DOP (Date of Passing) I need to be able to find all the records where: email is not empty and DOB is not empty and DOP IS empty The problem lies in trying to specify the DOB for example. When I specify <> isempty(Members::DOB) or NOT isempty(DOB) I get an error reminding me that my date is out of range.. huh??? What am I missing Thanks

Hi guys, Currently i am trying to extract the State (always second word from the right) from an address field with only spaces in it. Eg: Allambie Heights NSW 2100 not all suburbs have 2 names Eg: Abbotsford NSW 2046. i have been able to extract the suburb using: (LeftWords ( Contact Management::Correspondence Suburb ; WordCount ( Contact Management::Correspondence Suburb ) - 2 ) ). As well at the poste code using: RightWords ( Contact Management::Correspondence Suburb ; 1 ) But am stuck on the State, some have 3 intinals and others 2. The state is always positioned as above with no commas. Help would be appreciated.

Not sure if this is a no brainer but was wondering if it was possible to find things based on their conditional formatting. Like field that has a resulting different text color or background color... Is there a search by color script step? I know that this is a funny way of going about finding something that my conditional format formula has found but being an avid excel user you get used to such tools. Tools that inexperienced user's can manage. Cheers, Jr.