Finding & Searching

i am creating a solution in which a material is issued to different persons. every material has different types. for every issued material there is issue date. i have generated a report in which i want the list of all the materials which is issued between certain dates.for this i have created a script and entering the dates via custom dialogue and in the calculated result i have used this calculation Issuing Tapes::g_Issue Date & "..." & Issuing Tapes::g_Issue Date both the values are global. what i want is that i also want to enter the types of material along with the issue dates . so there are three input fields in the custom dialog box first is from…

I'm trying to better understand complex searching in Filemaker 10, specifically if and how it maps to Boolean sets. Let's say I have a database with 20,000 records each with one field containing a random paragraph of text. How would you suggest I search that field using the normal search interface for arbitrary combinations of values. For instance: ("*a*" [AND] "*b*") [OR] ("*c*" [AND] "*d*") Or: ("*Super duper*" [OR] [NOT] "*b*") [OR] ! Or perhaps: ("*Young*" [AND] "*Tom*") [XOR] [NOT] "*Fred*" Producing Boolean operations is oddly wrapped up in 'New Record / Request', 'Constrain / Extend Found Set' and 'Omit' in ways that have non obvi…

I am having difficulty writing what I thought was a simple find script. I am using a single database to keep track of our widgets. We have two different types of widgets, incoming widgets and outgoing widgets and all of the widgets have a unique name. I have assigned one field (NAME) to contain the unique names of the widgets and one field (WHOM) to contain to whom the widget was sent (if it is incoming I enter "us" in that field if it is outgoing I enter "Joe" or "Acme Corp." or "The Andersons" etc). I would like to create a script that performs a find in the NAME field that first filters out all of the "us" widgets from the WHOM field. I would also like t…

Hello, I have a database with two tables, "Student" and "teacher". On the "Student" layout, one of the fields is "Teacher's Name", which is a a value list using values from the "Teacher" table. I need to add another field "Teacher's Email" that is already on the "Teacher" layout. How do I do that without re-entering the information again? I really appreciate your help. Thanks, Samuel

i am trying to make a find script that will do a find in all the fields in the way of spotlight can anybody help me?

Hi all, can you help with the following: I have a pretty basic list of contact names (experts) including an extra field listing their expertise (keywords) on a form layout. Is there a way of doing a search where the list of names resulting from that search appears in a permanently positioned portal on that same form layout? Secondly, let's say I see a list of 8 names that result from that search, I then want to peruse that list in the portal and have the ability to then click on one of the 8 names so I can see their entire record on that same form layout page. I realise I can create a script where the resulting list can be viewed as a list or table in a…

Anyone know if it is possible to perform a "Constrain Found Set" to omit a image containers that are empty? I can't seem to figure it out.. and I read that you can't do searches based on Containers... is that true?

Hi I apologise if this question has been asked before, I have looked through the forum but have found it hard to find an answer that fits my exact issue. I am trying to set up a quick search facility on the database. I have created a few fields that are only to enter search criteria and on starting the search are stored as variables and the "search" fields themselves are wiped. The first field is free text that searches all fields and the other fields are specific to certain fields eg name. At the moment the search brings up records that match any of these fields, but I would like it so it only brings up records that match all of the fields eg if the free text says b…

We have a field that has this type of data: 093_f_GermanS_#01 Now of course if we try to search with for this record the # in the field it will not return the found record. So,is there any way to search for this record with the # being part of the data? Thanks, Jim

All our new enquiries are mean't to get added to our main contact database - their name, telephone number and email address - But over time some get missed and we have to compare the list of incoming email enquiries and our database by scrolling through all our emails - a years worth - and searching for each email address individually. I have got a file with every email address that we have had an enquiry from. Is there any way of searching all the records in our database to see if any of them exist in one go? That way I can cross the ones off that exist pretty quickly and then add the rest. Hope that makes sense! Thanks

This should be simple.. I am just not finding the function for it. If I have a Field with item numbers like: q0001.... q0002.... q0003 I don't want them to be auto-serialized because there are situations where I don't want the "q" So I am trying to write a script that determines the highest value with a "q" in it and gives you the next one up. Any suggestions?

I am currently working on updating a database that has a "People" table. This contains address, numbers, some comments and of course, the persons first and last name. Simple enough; however, over the years, the folks using this database have often added family members to the first name field. For example, one record might say "Pete and Linda" on the first name..then the rest of the fields are filled in normally. The problem I am running into with this is that sometimes one of the people listed will be in a course (this is an outdoor sports school)..so now we have listed "Pete and Linda" instead of just Pete for a class coming up. My first thought was …

This is my report in 'show all' mode. Notice the last 2 records for Wellsfargo and the Expiration date range at the top. [color:red](FHUHA & FHUZZ) After the I press the "FIND" button, I get the above. Notice that the last Wellsfargo option, [color:red]FHUZZ even though it is within the date range, is NOT listed??? This is the script that drives the FIND. The above is the actual OPTIONTRANSACTIONS TABLE upon which the 'find' is performed. [color:red]The puzzling part of this situation is that the FIND gets 'some' of the records but not others?: Got any ideas?

Hello, I am trying to make a list that shows all bills that are due. There are 2 types- quarterly and monthly. I want the monthly to always display and the user will enter what quarter/year they want. All of this has to display on 1 list My script looks like this so far Go to layout- List Billing Show all Records Enter Find Mode Show Custom Dialog ("Quarter and year" Salary_Budget::Terms; Salary_Budget::AcadYr) If (Get(LastmessageChoice=1) Constrain Found Set (Restore) Else Enter Browse Mode End if It works- except when I try to add in the Monthly ones. Any assistance would be greatly appreciated Thanks

The objective is to do a 'find' on all records with a expiration date (expDate) between two dates. By running debug I can see the cursor in my script NOT go into the designated field. If I type the code into the field I am told it is not in the correct format. What do you see is wrong? (I sure wish FM more better information on proper syntax for this) Set Field [OptionTransactions::expdate; ">=" & Global::g.LowerTransactionDate "and" & "<=" & Global::g.upperTransactionDate] (I use the 'unified symbols for less than and greater than and equal to)

I am a complete beginner. At work we have several jobs that are listed by a number. They are organized by year. 09.120 would mean job 120 in the year 2009. Sometimes we have jobs we put in bids for back in 06 but we want them to also have a new 09 number if the work was approved in 09. Therefore we give it a new number like 09.120. In Filemaker we list it in the field "JOB #" and in the field data would be 09.120 see also 06.120 The problem is when I do a search for either number it wont show up. It only shows up if I were to type in the field string exactly. I cant search for 09.120 and have it show up. I need an "any" search field. I know this is very basic …

Hi guys, I'm wondering if anyone can help me with this? I designed an invoice for my shop and I would love to have it total all of the state sales tax I took in for all of the invoices for the year and give me a running total at the bottom of the invoices as I start new ones. Maybe a total of all sales to that point too? That would be cool! That way I could see where we are in sales at any given time. Can this be done? I would obviously set it to not print also.

Wow!, I think after posting this, and rereading the script section of my book, I may have just completed my first loop without getting stuck. This is a great day, drinks are on me!!! If I wanted to set my feeding date field on 50 records would I have to do a loop of some kind? Or is there an easier way to go about it. as I have yet to complete a successful loop (I keep getting stuck and have to ctl alt del) Jim

Here is a weird anomoly: This report is sub-summarized on Company and then on OptionSymbol. It works well. At the top of the report is a global field g.LowerTransactionDate. I have a script trigger on this field that runs this script: When I enter Apr-11-2009 I don't get Expiration Dates GREATER than that date for both WellsFargo and Apple. I just get the values for Apple. What am I doing wrong?

I have report layout based on a table called TRANSACTONS I have a field Transactions::TransactionDate which holds .... yes.... transaction dates. I want to put two global fields in the header .... g.lowerdate and g.upperdate. Then I want to locate all records where the transactionDate is between g.lowerdate and g.upperdate. It seems that FM PERFORM FIND () function will not allow me to specify a criteria for a global field??? It seems like I can't specify a criteria where the transactiondate > g.lowerdate Or is there a 'trick' I am missing?

Is it possible to search a single field for "X or Y"? For example, if I want to search a field called Client and have the found set include all of the invoices for both Microsoft and Apple. Can I do this from find mode / scripting or do I have to use portals? Thanks!

hi I think this is a simple question that I should know how to do but it just eludes me each time I try it I need to generate a report which finds records where a specific field is completed within the current month I tried the following but it found hundreds of records If ${database name}:specific field name here = MonthName ( Get ( CurrentDate)) & Year ( 2009 ) grateful thanks for any hints Carol

I thought I this was going to be an easy task but nooooooooooo... How do I script a Find request where FM looks for the first character only of a company name in a text field? I want to find, say, all the companies beginning with the letter, 'C'. TIA for your help!

Is it possible to script multiple finds. When I use "Enter Find Mode[]" in my script it forgets about the previous "Enter Find Mode[]" and only runs the last request. I used variables in my script and so also use "Set Field" after each "Enter Find Mode[]" Thank you.

This is strange, because I thought I had done this before and it had worked. I have a Master Table that is related to a Historic Data Table. The Historic Data Table contains a status for the product, depending on what book they choose. So on the Master Layout, I have a drop down Global Field, where they choose the book they want to see. Once they choose this, all of the statuses populate for all of the records. That part works fine. Whats strange is, when I Right Click on one of the Statuses and click "Find Matching Records" it takes a few seconds, then even though it appears to have filtered the list a little, it still has several values listed th…

The below script will only work as expected in the debugger. The found set of 20 records has 5 unique CaseIds and the $caseList variable in the debugger gets populated with all 5. But if I run it outside the debugger then it only has 1 caseID in it. And I do make sure after each run to redo the find. So I am at a loss to why it would work differently in a debugger. I thought that one could iterate and move thru a found sets records with no issues. Go to Layout [ “MERGE_Contract” (FeesRecission) ] // Freeze Window Go to Record/Request/Page [ First ] Sort Records [ Specified Sort Order: Cases::Case_ID; ascending ] [ Restore; No dialog ] Set Variable [ $pre…

I've created a database of (among other fields) student names and classes. I have a relationship so that I can count unique instances of student names (they can be in the database more than once). I now need to be able to count the number of each class (2010, 2011, 2012, 2013) associated with the student to see how many unique students from each class was seen. I'm using: DupName=If(CounselorsStatsMatch::SerialNumber = SerialNumber;1;0) FirstValue=If(DupName = 1; student name;"") SerialNumber - auto enter QtySum = Sum(CounselorsStatsMatch::Qty) TotalUniqueStudents = Sum ( UniqueStudents ) Let me know if you need any more info. Thanks …

I have a script that worked perfectly in FM9. I set a field with a value (static HTML code) Then I go to Field (same one I just set) Then Perform Find/Replace (replacing NAME, ADDRESS, etc with values from a client order) Options are Replace All, Direction All, Current record/request and Current field. In FM10 I get an error: The Find/Replace option "Current field" requires a selected field. The process is repeated three times in three different parts of the script, on three different fields. Each time preceded by setting the field, and then going to the field. It works on the first batch of find/replaces, but not the second or third. I can't…

Hi, can we implement java script in file maker.if yes then where in file maker .

Hi,I have created a list view for my invoices (table Invoices). In the same layout, I would like to add a drop down menu with the list of my clients that would allow me to see the list of invoices for the selected client only. I struggle to create this list (cannot use the Client_Name form my Invoices table), and to perform the find. Can somebody help me with that? Thanks, S.

Hi, I’m a little new to Filemaker so I hope this is not a foolish question. I am trying to figure out how to perform extended finds covering multiple fields based on the same date range. Or more basic, I’m trying to figure out how to have the find accept its date value from a field. I’m running FM 9 Advanced. I have a client that wanted to record each date their patient came in for a visit for trials. We don’t want these overwritten, so I created fields the for 9 trial visits (Vist#1, Visit#2…) I want the user to be able to enter a beginning and end date to search for dates. For example all patient visits between 03/15/2009 and 04/18/2009 regardless if vist#1 or visit …

Hi, I'm only a year old when it comes to FileMaker, so I apologize if this is simple stuff I'm asking about. This is on FM10 used by about 10 people, hosted on Server 10. I have a set of records (they happen to be "tasks performed" and include stuff like User, Date, Task, Status, Client, etc.). I'd like to set up a solution where, either in the header or wherever is convenient, users can select options to filter results in real time. One such filter may be a drop-down menu of Users, or a couple of date fields to select a range, and the biggest one would be 15 or so checkboxes to select Clients. Our Clients list is static enough so that it's not necessa…

I have two tables, Collections and Restrictions, which are related via a unique ID string (CollectionID). For most of the records, the ID is numeric but for a few it's alpha. When viewing the Collection table, I have a script that when activated should display a dialog box showing related information from the Restrictions table. Not all collections have restrictions, so the script looks like this: [color:blue]If [Restrictions::CollectionID] Show Custom Dialog [ Title: Collection::collection_title&" -- "&Restrictions::restr_type; Message: Restrictions::restr_text; Buttons: "OK"] End If When the ID is numeric, it works great. When the ID is alp…

I hope I am posting this in the correct part of the forum. I am trying to do some resource management. I have multiple pieces of equipment which are loaned out for various periods of time. People often reserve months in advance. There may be 10 advance reservations for one particular piece of equipment, and I need to identify if a new requested period is in conflict with an existing reservation for that piece of equipment. I am not asking someone to do this for me, because if I don't do it, I won't learn it. But I would appreciate some guidance or aiming me in the right direction.

I am the newest newbie when it comes to Filemaker. We purchased Pro 8 to help us manage our client list. My first job is to compare our list of clients to the OFAC terrorist list. I have created a database listing our client's last names "client" and the terrorist last name "terrorist". I need to write a script that compares the first 4 letters of each client name to the first 4 letters of all terrorist names and output something that will show me any matches. I've been looking for a website or book that will help me understand script writing, but I'm not having much luck. I understand what I need to do, I just don't understand which functions, script steps, etc…

Hi! I've created a database to keep track of student counseling appointments. I need to be able to count how many individual students came in for appointments. Right now I'm using a field (student name) that will create it's own value list so that the names are always spelled correctly (or at least one way so that duplicates can be found). If I use omit multiples, the names that are in the database more than once don't show up at all and they need to be counted (once) when I count the number of individual students seen. Any ideas? Thanks VERY much! Corvida

I have a day camp application. In a script I go into find mode and let the user choose qualifications to find. To make it simpler, say I have one field that's the month the camper is coming. A second field is the grade they're in. For example, you click on field 1 and choose July or August. In field 2 you get to choose the grade (1, 2, 3 etc.). So if you pick July and grade 3 you'll get a report on those 3rd graders coming in July. What I need to do is allow the user to choose July as before, but multiple grades. For example all 3rd, 4th and 6th graders coming in July. I want a multiple find on one of the fields. How do I do that easily through a script?

Hello everyone I have had created a jewellery database which currently contains approx 10,000 records. I am having trouble completing a certain find, and I show an example below: Cluster rings are entered into the database in the following fashion: 7st diamond cluster 9st diamond cluster 7st sapphire and diamond cluster 13st ruby and diamond cluster etc etc If I want to just find all the diamond clusters searching for diamond cluster doesn't work as it will find the ruby and sapphire rings too. Searching on literal text "7st diamond cluster" doesn't work because it omits the 9st rings and searching for literal text "st diamond cluster" re…

I think this is a pretty basic question, but I just can't seem to figure it out. I am generating a report which has two summary fields - Addition (totaling numbers), Subtraction (totaling numbers) and a calcuation field Balance (Addition - Subtraction). I want the report to only show amounts wher Balance is greater than zero. I can't do a find on the summary field to exclude records, so how can I accomplish this. Thanks so much for your help. David

I'm creating a database for a catalog and need to use multiple page numbers for some items. If I make the page number field numeric I can't find the second or third page number, if I make the field text the pages won't sort or find properly. Example: Item ABC1234 is on pages 43 and 87 I'm up for suggestions on how to enter the numbers. Have tried 43|87 but that won't work either. 43,87 doesn't work. I can find by 43 but not 87. Please forgive if I'm not making sense!

I am a beginner to filemaker pro 10, and I am having difficulty narrowing my database by using the find function. I work at a gym and each morning we print out an active customer list who have paid up to 05/01/2009. When I used the find funtion in the "paid through" column, I searched greater than or equal to 05/01/2009. I made sure that the field type is set to "date". When I searched, only dates after 05/01/2009 appeared, however, a great deal of dates after 05/01/2009 did not appear that were left over from the clientelle list. Later I used the find function in the same column, searching with a question mark to find invalid dates, with a large amount showing up. …

I have a script that searches two fields on a table: account name and status At the start of the script I define a variable $un with the Get (Account Name) function. It then enters find mode, insert $un into the account name field, and insert "Pending" into the status field. Perform find and everything works. The problem is that when I try to extend the found set to also include the status of "Approved", I do not get the desired results. If I only add the "Approved" criteria it returns with approved records for users other than $un (it also includes $un). If I extend the found set with the criteria of status = "Approved" and account name = $un, I do n…

Hi all, I am trying to create a portal that: 1)Has a google search type - did this! 2)Has the possibility to decide where to search (for example: search for articles, search for descriptions, etc.) - getting mad to do do this... Does anyone has a solution? I solved the first point making a global field, then a calculating field related to the record I want to search. For the second point, I have been trying to use the getfield, but no results. Thanks.

I have a button that toggles between showing omitted records and the found set. I would like to have a text box show that says "SHOWING OMITTED RECORDS" or "SHOWING SELECTED RECORDS" when I toggle back and forth. I cannot find a way to do this. Any ideas?

Bit of a strange one. I run an import from an external source which gives me around 260-270 records. i am always only interested in the first 40 records. The import is scripted. Is there an easy way to add into the script a command to delete every record after the 40th record? I am not quite sure how I would go about this other than going to the 41st record, delete record, and looping. Is there a way to omit all records after 40 then show omitted, delete all ?? Thanks Ed

Hi all I have a layout with 10 fields on there. I need to run a script that notes which field in each record contains the last piece of data. So for eaxmple Record 1 has data up to field 8 Record 2 has data up to field 4 Record 3 has data up to field 6 Is there an easy way in a script to look for the last field in a layout containing data (or even the first empty field) without having to loop through each field? Many thanks

say a field can have the value "abc" (value starts with a double quote and ends with a double quote). It can also have the value abc or any other text value with "abc" a part of the string. say I want to find all occurrences with exactly the value with the double quotes ("abc"). Test values are "abc" abc "abc"xx What should the find parameter look like? I've tried =="abc" and get only abc (not the double quoted), ==""abc"" and get only abc (not the double quoted), =="""abc""" and get 'no records match criteria', "abc" and get "abc" and "abc"xx How do I find exactly the records with the field value "abc"?? TIA

I have a simple unstored calculation (number) field . Its acts as a switch and can either have 1 or 0 in it. Now when I search for all 0 it show all records. When I serach for 1 it only shows 1's. The calc is: If(j.EntryType = "AR" and j.InvoiceType = "1. Installment"; If(j.DeliveryDate>0 or FilterValues(List(SalesInv_JOB::s.InvoiceStep);"2. Installment¶Final invoice")>0 ;1;0); 1) Now the calc is doing what it should. It show up with the correct result but when searching it has this issue. Thanks in advance. Ron

Hi all. (Newbie question.) I wish to email a link to a client (by calculation) of the current record ID from FMPro app, for the client to open in IWP page. Is this possible? If so, what would the syntax be? Or, should it be a link to a find request, then the client just actions the find. BTW, the client is not required to login (Guest). Thanks in advance...

I have a list that just gained a digit. It went from K9999 to K10000. But the sort throws the K10000 to the bottom of the list, not following the K9999. Is there anyway to make this sort from 9999 to 10000, 10001, etc?

Hello, Okay, here's the scenario: You're in form view, and press a search button. A little search window pops up (a form). You type your criteria, and the search pop up window changes to show the results of your found set (a list). I have all of this working beautifully. However, the search/results window changes height according to the number of found records. To avoid a ridiculously tall window, I have a cap set to limit the window height to the desktop height [Get ( WindowDesktopHeight )]. In the event of more than 10 found records, I'd like to be able to "page" through the results (like Google results). I've thought about using [Get ( RecordNu…

Gahh ... I'm FM10 Advanced Enter find mode (CTRL+F) no scripts type data into a field hit enter - find does not execute, instead cycles through fields. No custom menus setup For the life of me I can't find where to turn this off. Have looked at preferences, file options etc. HELP!! I want it so that if you are in find mode, and you hit enter, it executes the search. At the moment the only way to execute is to have the status bar at the top of the screen and click on "perform find" Seemingly so simple yet I can't figure out where this is turned on. TIA

I have a repeating field and I need to run a search on the contents of a single repetition across several records. Example: Status[1] = 1 Means a project has been opened. Status[2] = 1 Means it's with an editor Status[3] = 1 Means it's in mockup So what I need to do is find all records where Status[3] = 1 but when you run a search on a repeating field it searches all the repetitions. I didn't realize this when I built my database and now it seems as if I may have to start over! Unless someone can help me run a find that does the job...

Hey all, I'm not sure how to OMIT a find, extend and constrain based on a variable using a script. I can include by going into find mode, setting the search field with the script variable and executing the respective script step with no static parameters, but I can't seem to figure out how to perform these three actions as OMITs. Any thoughts? Thanks for the help! Michael New York City

I have a database that I use global fields to calculate and count certain fields. When I first set it up I did not know that global fields did not filter during a find. I have a number of calculation fields I am trying to filter by salesmen (field in my DB) and date. But when i filter the criteria my calculations are off because the global fields are still calculating for all records. Is there any way to accomplish what I want with out redoing everything? Thanks, Matt ***Attached is my database Leads_V1.2_Copy042209.zip

I want to make a simple script in my Customers table that performs a find based on a radio button that is selected in the records, but I am not sure what the proper syntax would be. The 2 value options for the radio button (which is assigned to a value list called "Method") are "Deliver" and "Pick Up", and I want to have only records with a "Deliver" value in the resulting found set. What is the syntax for scripting this? I tried to find all records where Customers::Method = "Deliver", but no records were returned, where many exist. Thanks!

I want to have some way of finding any of a group of words in a field. Creating multiple finds creating Find > New Find > New Find etc is cumbersome if I make a mistake or need to update it. Ideally it would be some sort of string of words with a loop script. BTW I'm using version 7 and it doesn't seem to have setfield as a function, even though it mentions setfield in the help menu, which is confusing. I saw an example using setfield but it didn't work - just said couldn't find the table "setfield".

Hi Guys, I am playing around with the As-You-Type Search using script triggers. This is a wonderfull technique! My filemaker file is a multi-user though and since the search field needs to be global (otherwise it is not editable when there are no results). Has any of you struggled with this before and thought of a solution? Thanx! Wouter

Hey folks. Bear with me here, I'm very new to filemaker and really enjoying learning about it and experimenting. [CLIFFS NOTES at the bottom.] I work for a small entertainment company that rents a lot of DVDs and also maintains an internal DVD library for our executives to borrow from. We have a DVD Library database that lists all of the DVDs we have, and I'm now in the process of writing a database to log and track all of our rentals from outside stores (Let's call it Video Rentals database). What I'd like to do is have a way from within my new rental database to search the dvd library for similar titles. Basically, we want to make sure that people don't rent …

I'm so delighted with the simplicity of implementing a mac like find field [find_field] via the "onObjectModify" trigger which invokes a find script [peo_search] ... but when trying to do a find on a calculated field [peo_multikey] calculated as [ fname & lname & company & stnum & stname & city] the find doesn't reveal all calculated records that contain find string ? data viewer shows string exists within calculation for each record but it seems to miss some but not all? script > peo_search ; Set Error Capture [ On ] If [ (IsEmpty ( find_field)) ] Show All Records Go to Record/Request/Page [ First ] Sort Records [ Spe…

Hello all, I have a system going and I don't show the Status Bar. It is hidden and locked away so it cant cause trouble for me. I had a cool search system created that unfortunately may be to costly to system resources and needs to be redone and simplyfied. I want to show in my form the request count and the current request number as if the user were cycling through a list view. How do you show these elements in Find Mode? Please let me know if it is a lost cause so I don't waste too much time. Thanks

I trying to write a custom php web interface with my existing website so that potential customers and sign up to recieve our news letter. I have created a database with fields for email address, name, mailing address, and interests and subscriber status. customers do not have a problem coming to the website and signing up, however, I have also written an unsubscribe. where a customer may go to a different page, enter their email address, and the database scrip performs a search, finds their record based on the unique email address and automatically switches the subscriber status to "do not contact". I can not execute a search with the full email address in it, and it seem…

The current routine loops through records doing this: If [Count(Companies~Addresses.portal:_AddressesID) = 1 Addresses portal on the current Companies layout has a single record Set Field End If With many hundreds of records I'd like to speed up the routine by using the Constrain Found Set script step and then use Replace Field Contents to set the field. However I'm baffled in how to set the criteria in this situation. Suggestions? Appreciated.

I'm scripting a simple routine, constrain the found set to omit all the records in which a particular field is empty — Constrain Found Set [Restore] in which the action is "Omit Records" and the criteria is Fieldname [=]. It works. Except one of the records returned has that critical field empty. I've experimented with every variation I can think of, but the same correct set is returned, plus that particular record where that field is visually empty. Not that it probably should matter, the troublesome record is the second in the set. I suspect FMP10 is seeing some invisible character I can't see or select. Any guesses what might be going on here? Much appre…

I'm having problems with creating a script that will allow the user to check off multiple options to search the same field for. This solution must work for FMP v6, as that is what the company has installed on the end user's machines. The details are: I have a Value List(breeds) that is displayed as checkboxes (gGlobal). If these user wants to find two types of dogs, they'd click the checkboxes next to "Dalmatian" and "Poodle" and click a button that would run a script that does the following: -Enter find mode -See how many checkboxes are ticked -loop performing a search based on each box thats ticked, extending the found set. Sounds relatively easy t…

I am writing a script which examines a found set of records in one table and, based on the content of each record, creates a record in a different table. What I want to know is, if I switch from one layout to another and then switch back, does Filemaker remember which found set I'd been working on in the first layout, and the record I had selected? The pseudo-script goes something like this: Go to Layout A [Get to a found set] Go to record 1 Loop Set all fields from record 1 to variables Go to Layout B New record [Create new record based on variables set in step 4] Go to Layout A Go to next record (exit after last) End Loop It…

I am trying to do some find requests using scripts. On the first find, I would like "active=y, sex=men, inyrend=y" that works fine. In another script, I want "active=Y, sex=women, inyrend=Y", but it keeps show the results of the first find of some other find. Why cant we just save the finds? This way i could make all my find requests, then call them as I need them. Lotus approach allows that, or in Access their queries. Dave

If this is in the wrong spot I apologize and if a mod could move it I would appreciate it. Hello all, I am trying to find a way to view all the records I created in the last 48 hours/24 hours/and that day. I tried to create a report that would do it but had no luck. I am really at a lost as how to do this. Any help on this would be awesome! Thanks!

Is it possible to perform a "Find" that will search for records that are missing a charecter from a stricg? For example....I have a large email list that was given to me I am trying to clean up. If an email address does not have "@" sign it is not a valid email address. Is there a way to search the email field for any address missing the "@" sign? I am in FM 10 for this project. Thanks in advance for any help. Steve

I need help to be able to delete the first fixed number of records in a found set. For Example I have a total of 70,000 records. When I do a find on a certain field it displays a found set of 6,000 records. I need to be able to delete the first 500 records in this found set of 6,000. When I used the 'Omit Multiple' and enter 500 it omits the first 500 records of my found set but when I select to 'Show Omitted Only' it then show the 500 records I want to delete AND the other 64,000 records that I do not want to delete. Does anyone know how I can just delete the first 500 records in a found set efficiently as possible as I need to do this procedure over and over again …

I'm going to be kicking myself when I read the answer to this question but I can't for the life of me figure it out on my own. I'd like to be able to press a button in my main window to pop up a new window with a layout for data entry. In this window, I'd like to only see the one record I wanted to create the entry for. The scenario: Each patient has a number of notes associated with them. The way I've got it set up right now, is that I can flip through patient info in my "main" window. From there, there are various buttons that I'd like to trigger a script to open a new window with only the current patient as the found set. If the button triggers a script …

04-17-09 04:44 AM - Post#34172 I have been using Foxpro and other SQL based databases for years and recently changed to a MAC and it seems that Filemaker doesn't support normal database constructs or concepts like joins, or SQL language queries. I have been trialing the software for the past 3 weeks and my question is that I am trying to figure out how to take one table (lets say it has 500 records with a field called "xtype" and I have another table that has 20,000 records also with a field called "xtype". I want to do a left outer join on the common field "xtype" where "xtype" in the smaller table matches "xtype" in the larger table the results are that all re…

Good day - I am trying to clean up some data. I am working with a basic table view. I have a field for NAME, and I can easily find all records containing Mary. But some are Mary and others are mary, so I want to Find/Replace - within the NAME FIELD ONLY. Within Browse, I have selected the column for NAME. Within the Find/Replace pop-up, when I specify Search within: Current Field, I get an error that: The Find/Replace option "current field" requires a selected field. So my question is: How do I select the field more definitively, so FM will recognize which field I'm talking about?? Thank you! Marion

This is another "seems easy" question. I have a bunch of records, with a description field. I am looking to find all records who's description field STARTS with DIRECTOR. So it would find Director or Information Technology, but not Service Area Director. Ideas?

Hi, I am new to this forum and Filemaker (both are great i must say) I am making a DB for a hotel. I have 3 tables called Guests, Rooms and Bookings. They are related, as shown on the first attachment. Bookings are made on the Bookings layout with a Guest, a Room and the selections of Arrival and Departure Dates. On a new layout, I would like to show that, with dates on the top row, and rooms' number on the side column, the availability of the rooms, on a weekly basis. Just like in attachment 2 (made from Excel) My questions are: 1. Can a portal do it? Portals can only have defined columns, right? 2. If a portal can't do it, should I crea…

I'm stuck due to my inexperience in relational databases. I have a 2 layouts that display data from two related tables. Parent and Child are joined with the ParentID, and this works fine. In the first layout, the Parent fields are on the layout, and the Child records are shown in a portal. No problem. The second layout is the trouble. It is a list view that displays some Parent fields, and some Child fields. This layout is from the perspective of the Parent, and I have the relationship set up so that it displays data from newest child record. This is just what I want in this view, until I try to use the Find command. Let's say that I want to gener…

Hi, I am working on a movie and I have been asked to create a DB in FMP to track all of our digital art work. I am very new to FMP. Each Project has multiple smaller assets. For instance. We are building a lightcycle. That 'Project' is composed of smaller assets tires, handlebars, lights, etc. When the smaller assets are input into the DB, I have 3 pulldowns to assign them to a particular project. An example of the Project name is 005_Veh_Lightcycle. 005 = SerialID (range is 1 - 120) Veh = CategoryID (4 possible categories) Lightcycle = NameID (# is dependent on category) With the various combinations there are 100s of project names. …

I started this threat in a different forum but even with with all their great help I'm stuck and it seems like a fairly simple fix. I just don't know how. I have a portal field that I can dynamically filter, filter by categories and also hide records from the portal, all is working great but one thing. The current active record is automatically getting hidden after I choose a category filter. My steps are. Show all in Portal script, switch to category filter "Body Lotion", then I click on the open record (grey area outside the portal) and the green tea lotion switches automatically to hidden. You see the number change from 1 to 0 in the portal row of Green Tea…

This is a hard one, especially to explain. We have a day camp. Campers come for either the whole summer, only july, only august, the 1st 6 weeks (july and 2 weeks in august) or the 2nd 6 weeks (2nd 2 weeks in july and whole of august). I need a report where the data shown in each report is the same, so only 1 layout with variable heading will do. I need to choose which reprot I want. It can be for the 1st 2 weeks in july, the 2nd 2 weeks in july, the 1st 2 weeks in august or the 2nd 2 weeks in august. There are 3 types of reports possible for each of those - all campers in that time period, only the additions in those 2 weeks (only possible for 2nd 2 weeks in july or 1st …

I would like to find all occurrences of two words where they are within a specified number of words of each other. e.g find the word "local" that's within 3 words of "network" As an example, this will return all records where the search field contains the phrase... "local area network" "local network" "local public wireless network" but will not return records where the phrase is... "our local area has two choices of broadband network" "local people have created a self help network" I suspect this can't be done in FileMaker without allot of heavy lifting from scripts and calculations and the like, but would be pleasantly surprised to be…

Is it possible to create a simple method to the find matching records and constrain found set commands when you right click? I am designing a contacts database for two users who are not very computer literate and although the right click method is relatively straightforward, it would make my life much easier if I could put a couple of buttons on the interface to complete these tasks. The typical searches that we would need to do is: find people in the same geographical location From this group, find those with a specific qualification From this revised group, find those with a specific skill or skills Eileen

I have updated both clients and server to FMP 10 and I notice that in most databases the option to save a find is not available, its grayed out from the drop down menu. I also noticed that the databases I checked were single table databases while the databases where this was not avalable were multiple table databases. I haven't had a lot of time to look into this and was wondering is anyone has the specifics on saved finds and when its not available

I'm wondering if anyone can shed a light on something for me regarding the performance of summary fields. I'm working on a large data set, currently 1.6 million records and will ultimately balloon beyond 16 million when data for all years is added. Each year will bring on 1.4 to 1.6 million new records. If I use four summary fields to calculate the total quantity, value, tax, and cost sold on the current set of 1.6 million the first time I do this it takes about 10 minutes of which the first summary field takes the most time. Subsequent summaries take a fraction of this time even if I go back to showing all the records. If I close FM and do it again I'm back to 1…

We have a scenario where we’re doing a constrained find against an unstored calculation field that is giving unexpected results. FM9.0v3 and 10.0v1 Mac OS X 10.5.6 and WinXP Files served on FMS9.03.325 on Win2003 There is a table called “Screenings” with a self join relationship, “Screenings_Screenings|AccessionCOD”. The relationship uses two fields: - AccessionNumber = Accession Number - COD = COD There is a field named, “_cDuplicate” whose calculation reads: Count ( Screenings_Screenings|AccessionCOD::ScreeningID ) > 1 ScreeningID is the Primary Key in the table. The unstored calculation returns a 1 if true and a zero if false. If …

I have a layout that lists all the email addresses that clients in the system have and you can use find mode to further narrow things down but when it comes down to it i need a way to just select some emails using something like a checkbox. Because now you can only use finds and then a script that composes an email to the found records. but is what I'm looking for possible?

I'm trying to specify a Find Request for a Perform Find script step. The Action is Find Records and the criteria is: Charge::IndustryProduct:[==Get(ScriptParameter)] But this takes Get(ScriptParameter) literally. I also tried using a variable. How do I get this Find Request to use a ScriptParameter or variable? I also need an exact match, so I need to precede it with a ==.

Hi all, i am a complete newbie in fmp. I'm doing an internship at a company and they are using FMP 5 so as i know already it is really outdated. they asked me to edit the current forms a bit. and now i'm a bit stuck on a search filter. they want to exclude some fields from a search. they have for example 2 different contact fields and they want, if i fill in a name in the first field and leave the other field empty that it excludes the empty field from the search so that all the records that are found have the contact that is filled in but in the other contact field is nothing. and all the other fields that are not filled in should be included in th…

Is there a way to find text in a field and make it red and bold? This function is available in Excel but I don't see any options for this in the Filemaker Find/Replace dialog box.

I understand that variable can't be scripted into find requests (rather, you use "set field" while in "find mode.") However, I have a dilemma. I need to pass a variable into a scripted find request AND also include an "omit" step in the same request. I don't know of any way to use an omit step without scripting into the find request, but that can't accept the variable. Does anyone know of a trick that will accomplish this? Thanks!

My first post! I'm newish to FMP and we have 8.5Adv I have an inventory database - By nature of the business the we use a lot of the "special" characters in the descriptions for which we need to search. The boss wanted the drop down list for searching. For example when I use the drop down list and locate "Ladel #4" or 'Banner 24"'it finds it in the drop down box but will not "find it" during the search. I understand the use of special characters causes this, even though the drop down list shows the item. The boss can not simply understand why it can't find it. Go figure. I was playing with a script that was in an example DB that works with a find. Set…

Hi Guys! i would like tot prevent users from creating "newlines" in text fields. so i set the return and enter key to "jump to next object". but when i'm in find mode i would like the enter to perform the actual search. Does anyone know a workaround for this?? Thanx! Wouter

I have encountered a very strange bug and have no idea what is causing it. I just setup a distance search option for my company's candidate database. This way our recruiters can search for candidates within a certain number of miles of a zip code. To accomplish this I have one table that has all of the zip codes and their corresponding longitude and latitude for the country. In the candidates table I added a global field for the zip code being searched on. There is also a calculation field that figures out the distance between the candidate's zip and the search zip (if they have a zip code entered). The search is then done with a simple c_distance =< #miles_for _search…

Hi all, I hope that I'm in the right forum to ask this question. I am newbies in FileMaker and encounter rather annoying problem. I have 2 tables; 1 consist of employee ID & employee name and another table consist of Employee name and everything else(address, phone, etc). I want to get an employee ID from one table and put it in another table based on Employee Name. How do I do that? Thank you for your help.

Hi there, I have a few scripts in which I'd like to search for the presence of certain records in certain tables. If no records are found, I'd like one thing to happen, if records are found, I'd like something else to happen, all behind the scenes and invisible to the end user. There are a few different scenarios on our DB where this would be helpful. The issue I run into is that when no records are found, the script is stopped and a message is displayed saying no records were found that match the search criteria, with the button choices of what to do next. Is there any way to suppress this dialogue, or any other way to deal with empty search results? I've t…

I need help please.I have file maker pro 9.I am tryig to import txt files into the database and search by GMON (like employe id) or by name.But everytime i import don't match with field.Can everyone help me please.it can be php or asp script also.I just want to search stuff on txt files.I am attaching file with this post.Thank You. SAMPLE.txt

Hello everybody this is my first post and sadly is to put in evidence that i have no idea what so ever about this. One week ago i was ask by my chief to make a database for the call-center and i use file maker because it was cool and easy to use beside to the scalability and compatibility with other sistems. Now i´m stuck, my boss is asking me to enable a way to make a pick of 100 or any number of the entries of the data base to asign a caller but the best i can do is narrow a search wich gives me to many or to little info, i need to be able to make a pick of a ¨x¨ number of entries for assignament. that´s it. Any help is apreciated.

Hi- Hope I'm in the right forum. Please excuse if not. Is this possible? I have records with a job number and job date. I have clients that have multiple job numbers in those records. Can I end up with a found set of each clients latest job? In other words I need a list of the latest job of all clients Thanks for any help.

Is it possible to omit a record in a portal row? If I omit a record and I look into a portal row the record stil is displayed. Is there a way around it? Thanks T

Hi, Is there any way to do any kind of search in which one can run Find Mode through all of the fields at once (as opposed to having to search each individual field)? I’m sure this question keeps coming up, but has there been another way to integrate Spotlight or other Mac search software with FileMaker Pro? Thanks!

I need to search for an email address in my database. As you know the address needs to be enclosed in "...", like "[email protected]", for it to return any search results. I need to execute that find with the help of a variable: Enter Find Mode Set field ($EmailAddress) Perform Find How can I get the quotations to be part of the variable? Or inserted the moment the variable is used for searching?