Finding & Searching

I have a db of pictures and I have designed a check box value list that lists themes (portrait, landscape etc) so I can search styles. When I do a find, I use the find & click on the boxes. The result very strange as I get all sorts of files coming some of which are right and others that are not. What is wierd is it that even if unclick & reclick the pertinent checkboxes & save the new configuration, it continues to show up the wrong files. I have also noticed that FM7 checkbox searches get even more confused when I add or reduce the value list. Is this all very normal?

Can I have arguments in a Finder script function? This script doers what I need done but I have to define the $trip and $pref manually. It would be really nice Finder would use that arguments. If I specify the arguments in Finder they show as text. Show All Records Set Variable [ $trip; Value:1 ] Loop Set Variable [ $pref; Value:1 ] Loop Enter Find Mode [ ] [ Pause ] #How can I make $pref and $trip be arguments to the Find? Perform Find [ ] Enter Browse Mode Pause/Resume Script [ Indefinitely ] Set Variable [ $pref; Value:$pref + 1 ] Exit Loop If [ $pref ≥ 7 ] End Loop Set Variable [ $trip; Value:$trip + 1 ] Exit Loop If …

Hello. I made a layout listing all records from a table. It has a calculated field which collects the record date from the history table. I need to open a new window from the dashboard I made with this layout. I know how that can be done. I have two fields in the temp table (don't know if thats correct) which isn't linked. The fields are global date named start_dt and end_dt. With the script to open the report you can enter the two dates (may change but the flow remains the same). The result must only be the records where the date is between start and end. I can't get this done. Any ideas how to solve it? So the script must collect the start and end in put …

Hi Folks, I'm trying to find what I *think* should be a simple solution to a feature I want to implement. : : I have a database that contains tables such as "Projects" and "Contacts." Projects and Contacts are related. I've recently set up some new users, who have access to create and modify records. These records contain existing information that I don't want to be accidentally overridden. Also, I'd like to monitor that the users are inputing info and changing info. as they should. To monitor activity, it would be great if I could capture changes to fields within these two layouts. (The layouts correspond to the fields in the tables.) If I can ca…

Hey all, i've done up this script which allows me to do spotlight searches on my database, however, the spotlight search only allows me to use a single keyword as the search criteria. in any case, will anyone be possible to show me whether if it is possible to make a spotlight search where multiple keywords can be used? my idea of the search is like this enter into field - (blah blah)--> key words are seperated by spaces also, i'd like to ask if it is possible to extract data from a certain record to conduct a search? i'm thinking of making a database which can cross refer to the different tables which is bounded by the same keyword results comes o…

Hi, I have 5 fields which contain color names. All 5 fields can have the same color or different colors. I often need to find one particula color in any of the 5 fields. So in find mode I enter a color name in field 1, and enter the same color name in the second field....then the 5th field. That's a very tedious job. If I needed to add other search components, it is not easy. I tried a calculation filed to combine all 5 fields. But when I do find from the calculation field, it finds nothing. Here is my syntax. Hope someone could tell me what' wrong with it. SearchColor = c1 & " " & c2 & " " & c3 & " " & c4 & " " & c5 Appr…

I have a DupCalc key 'CompanyName&LastName&FirstName'. When I enter a'!' in the DupCalc field and get e.g. '200' records. Are they all the dups or are they the original and the dup? The reason I ask is sometimes there is only one record rather than 2 or 3. Should I be deleting the whole found set or every other record? Thanks

Hi people... how do you do? I have a situation here and I can't realize how to solve it. May you help me please. The thing is: I have a customer table where I write down the date when I give my customers "warnings". I give them the first warning if they forget calling me... if they don't call me during the next 7 days, I give them the second warning; if they don't call me during the next 7 days, I banned them from my list. In the table I attached here, I have 4 fields: the customer ID, the "1st warning" date field, the "2do warning" date field and the "banned" date field. I want to write 2 different scripts to find: 1)which customers haven't called me during the …

Hello. I've just started out trying FileMaker and the only database experiences I have from before all use SQL. Now I'm trying to create a little video rental system using FileMaker. I have a table called Customers with all the information about each customer (including a unique ID number). I also have a table called Movies with all the information about each movie, including an ID number. To connect these two I have a table called Rentals, which uses the ID from Customers and the ID from Movies to make up what I like to think of as the keys for the table. So if a movie has been rented by someone, that someone's ID is in Rentals together with the movie ID. So th…

I have a table which containes fields such as partnumber, supplier, price etc. There can be same partnumber with different supplier and different price. How can i fetch records of those parts with minimum price? I have included a summary fieled 1 which is minimum(cost) and another calculated filed 2 GetSummary(1;PartNumber) I get all records with field 2 i get the currect minimum cost per part number. But how to omit other records? My script steps are Go To Layout Enter Find Mode[] --I have few conditions here Perform Find[] Sort Records based on part number

Hi, this is my first post here. 'Complete newb. I'm learning as I go on a project here at my workplace. It's fun but I do get stuck sometimes. 'Trying to figure out how to compare the list of identifiers provided as a field in every record of one table to the same ID field in a related table; i.e., I'd like to get found sets that could be represented by a Venn diagram. . . common, list A exclusive, list B (from separate related table) exclusive. Please give me any guidance you can. Thanks.

I am new to this forum and need assistance with a query/search/find in a database – this is a bird banding project. I have recently decided to switch from an old db program called Paradox to File Maker Pro. I was able to export the db from Paradox to an excel file and then import to File Maker Pro. FYI, I currently have over 6,500 records each with 45 fields. The problem I currently have is being able to search the File Maker Pro db as I had previously done with Paradox. The only way I know to pose the question on this forum is to note what info the needed query contained in the old Paradox db. So here is the example… Band #....................Date Join 1.…

Hi all, I have the following question: I have a table called "Archive", which stores different items, like "Clippings", "Publications" etc. Since those categories require a different set of fields each, I've placed several tabs in form view; each containing the specific fields for the category the record belongs to. Some of the fields exist on more than one tab. For example "Author" exists for "Clippings" AND "Publications". It is also overlaid by a transparent button, so that some users can't change it. Now here comes the question... I need access to that field in FileMaker native Find Mode. I've tried the "GoToField" script step, but since the field …

How do I set up a script that will allow me to search for two different data values in one field? For example, I have a 'Building' field that contains building names. I want to run a script that displays a report on two, and only two, of those buildings but I can't figure out how to search the same field twice. Thoughts? Thanks!

I thought I knew how this worked! I have a relationship between two tables that is based on a compound join involving two fields. Like this... table a::g_date = table b::date table a::id = table b::id The date field in table a is a global field. I also have a field in table a that sums related records in table b. Like this... table a::net = sum ( table b::net ) If I ask it to find records in table a where table a::net is null (=) it works just fine. If I then perform the same find but this time check the omit box it returns records where table a::net are both null or have values. I would haved expected only non null values or where t…

Sadly I've pretty much solved my problem minus my final step. Within my quote table I have two fields... one being "Search_Day_Start" and "Search_Day_End". Those are both used within a layout I have designed to have different variables you can modify and then clicking on a specific button to generate a report for it. A simple report that would be generated would taking the two dates selected by the user and then displaying all quotes generated within that time period. Within that script I broke the dates down into a text format and then used a few other various things to extract the day/month/year. I would then generate a line of text based upon what …

Hello, I've been a FM7 user for 4 years now, and I do consider myself to be pretty well aware of what can be done and what can't. However this request threw me for a loop this morning. Our accountant asked for a report of all orders that shipped out of state in 2007. In my mind, I'm thinking that means I need to find a ship date of 1/1/07...12/31/07 AND the state does NOT equal MN. I am aware of the 'omit' flag for finds, but have never really needed to use it. I'm not sure how that would help me in this situation since I also need to limit the year to '07. I'm stumped. I ended up just making a copy of the file and butchering the copy to get what I needed …

I was wondering if you could give me a hint on the following. I'm trying to write a small script that takes a value stored in a global in one file (ie. current invoice number) and then enters Find mode and sets the InvoiceNum field to that global. Then the script would Perform the find to find records matching that invoice number. I do it in Filemaker 5 just fine. I enter find mode, set the invNum field to the global and then execute the 'Perform Find' with no dialog.It returns matching records. But in FileMaker 8, when I Enter Find mode by a script, it just puts the database into Find mode, executes the subsequent steps and waits in Find mode. It never …

Help! I have a large database which is primarily contact information. What i need to do is gather information for each contact that is "a year" and the amount of $ given for that year. Currently i have a pulled-down menu that displays "2007." I also have a separate field where the # amount given that year is displayed. I need to make the year field a pulled down menu that displays several years. BUT, when i search the dollar amount for 2007 it is not be tagged with the specific year correctly. Can some one please tell me how I should set up this relationship? Ultimately i need to have several years that each correspond with a different $ value. Thank you!…

I think I asked this before but am not sure. In a file let's say with about 2500 records and about 30 fields on a layout what is the advantage (if any) or disadvantage of creating a global calculation field that will hold the data of all fields thus allowing a single search via custom dialog box which will search all records? Something like find / replace from the edit menu only without the replace ability. Any serious impact on speed of searches, file performance in general and such?

It's me again. Easy one this time. Need to find all records with a due date more than 90 days before Todays date. Tried to due set field DueDate < Get(CurrentDate)-90 Doesn't work of course. I hate date finds. Don't understand them (except the easy ones.) Thanks

Disclaimer: I am a Filemaker n00b. I have a fairly simple project that could well be done in a spreadsheet, but with one complex twist. My project entails a notes database, the records organized by tags. For those using OS X, think of something like Yojimbo or Yep. All I have is a description field, a comments field, and date created/modified fields. I would like to set up another field for tags which is related to a tags table. A tag cloud and autocomplete would be brilliant as well. I have been looking around the web for resources but I am not familiar enough with the Filemaker terminology. "Tags" and "tagging" don't seem to be it. What sort of function should…

I set up privileges in order for each user can have access to the records under his account name, but it brings up other records showing as along. How can I omit those records? Any help would be appreciated.

Hello, I want to be able to search 2(or more) filemaker pro 9 files that have identical inventory tables for similar records. I assume I need to create some sort of script? Any Ideas?

I have a situation with a parent and child records where all child records of a certain type are displayed in a portal, based on a user-specified code (text). Previously, the relationship was defined as _gViewCode = Child::Code But some child records do not have an embedded code, so I need to apply a Parent::Code as a temporary default. Since I want to leave the Child::Code blank for subsequent entry by the user, I set up a separate unstored calculated text field upon which to base the portal display: Child::NType = Case ( IsEmpty (Type) ; Parent::Type ; Type ) However, once I change the relationship to _gViewCode = Child::NType, no records display in the po…

Anyone know where I can download a simple fm database that removes duplicates?

Hi everyone, i have a problem. Is there a way, how to tell Filemaker which records are his last found set? Because i have a database where is normal Find button and "And" and "Or" find buttons, (And = Modify last find, Constrain found Set[]; Or = Modify last Find, Extend found set[]), so for example: I use normal find to find all records which City is Prag. Ok. The i will make Or find to find all which city is Dublin - Ok, Filemaker shows me all rec's where city is Prag or Dublin. But then i want to make one another Or, where city is London. But filemaker shows me only records where city is Dublin or London - its because FM thinks that last find in Modify last Find was fo…

Hi again, i have another question. im making a report, and i want to find all the trailer's in a given date range, whom don't have sales order, i guess the simple way to do this is with IsEmpty Function and a Constrain Found Set, i got Enter Find Mode Set field[EndDate;BeginDate...EndDate] Set Field[status;"Inactive"] Perform Find Constrain Found Set what i dont know is how to join these 2 functions? am i doing it wrong?

Hi everyone. Currently i got BeginDate as timestamp, i want to create a report searching based on BeginDate, but because it's timestamp, brings me all, i guess i got to use a wildcard, but im not sure how. i have: enter find mode set field [Cajas::BeginDate;GetAsText(tempvars::BeginDate) &"..."&GetAsText(tempvars::EndDate)] perform find. how should i use the wildcard? do i have to convert the timestamp to a date, and then search? thanks

I have a layout that displays every single record in an Items table, including the archived items, (which are archived via a Status field). I want to be able to select that layout from the layout dropdownlist and immediately have the item list show only active items. I don't want archived items to show up initially unless the user wants to see them. I know how to do this with a button, but I don't know how to do it automatically when the layout is selected. Is there a way?

I have unique records for Vendors where sometimes the RFQ No. for each could be the same. I have my subsummary template finished but i would like when the user goes to print that a dialog will pop up and ask them which RFQ No. they would like to print so FM will then preform a search and only pull out the records with the same RFQ No. in preview/print mode. Is this possible?

Hi Guys, I run a Macintosh computer rental company and am trying to finally update my database. I would like to create a button or field that searches for all records that begin, end or have an action date (will be all differernt fields) for a specific date which I enter. In other words, I'd like to be able to enter today's date and view all of my computer rentals that either start today, end today, or have some sort of action flagged for today. Can this be done? And how? Many thanks in advance...I'm quite desperate! : -Phil

Hi guys, I'm a relative newbie to Filemaker and have found myself managing and trying to improve upon our existing Filemaker 6 database (using Server 5.5). I work for a company that rents out Macintosh and other computers for tradeshows, training sessions, etc. As a result, one of our most important tasks is keeping track of when equipment comes in, goes out, and when these rentals need attention. The owner of the company had designed the database with the Sart Date/End Date/Action Date as all one field so that he could search one date and find everything...with obvious limitations. Thanks to Fitch and Robert I've separated these and I've figured out how to…

Hi I'm ending up asking my question, because I'm trying to find a solution for hours, but it doesn't work as expected. I have: 1 Table about Persons and 1 Table about Events Each Event is related to just one Person, visible in a Portal on the Persons layout. When pressing a button in the portal, I want to switch to a list view which shows all the events for the particular person. In the script I go to the new layout, enter find mode and perform a find (I copied before the Personsidentifier into a global field to remember which persons event list I'm generating. But the Find-Dialog is not accepting my global field as criteria, it never uses the va…

Hi, I'm pretty new to all this. I've started a database based on a time billing template. I want to add a checkbox for "billed". I've added a text field and set field format to checkbox with value list (empty) or X. The checkbox works, in that I can "check" it. But I want everything checked as "billed" to dissapear from my view, a template form called "billing items". Any help is appreciated. PS, the help file won't launch for some reason. I know it's old software.

I have a sub-summary report that lists phone numbers and frequency of the phone numbers in a report. Some records do not have phone numbers and many records use the same phone number. Is there a way where when I run this report I can count the unique times a phone number is used? The summaries on the report at the bottom account for how many numbers make up the report and not how many unique numbers there are. Likewise I would like to know how to count the number of projects built by phone number. I am using a table occurrence to show related phone number and a calculation field that counts these occurrences. However I cannot figure out how to count the proj…

I want to offer a goto button, where the user can type in an item number, filmaker will bring it up, but will still show all records, so the user can use the previous and next record buttons as well. I have used the 'go to related record' function, but i have a problem - i have an item 22717 and an item 227178 - if I type '22717', filemaker shows 227178... anything I can do? This should be compatible for FM7

I have a field with a drop down list of names: Casey B Casey C John D When I search for records that contain Casey B, it only brings up his records. When I search for Casey C it brings up both Casey B and Casey C record.... Why? The only way I can pull up just Casey C is by putting " " around it.

Hello Using a script, I am trying to execute a Find, then Extend the Found Set with a another qualifier. However, the result is only capturing the value returned from the initial Find. I've included the steps below. Any idea what is missing? Joe Go to Layout… Enter Find Mode [] Set Error Capture [On] Set Field […] Perform Find [] Enter Find Mode [] Set Error Capture [On] Set Field […] Extend Find []

In SQL, I would select records from two different tables based on a similar field in each table, but SQL has the "distinct" limiter, so that you only get one record when there are multiple records with the same identifying info. First of all, is there any online resource that explains how to do in FileMaker all the powerful things that SQL can do? If I find such a resource, I think I will be able to do just about anything in FileMaker. Second, let me give you the brief description of why I want to put such a find together. I have 2 types of records stored in those 2 tables, and the similar field I want to use to find records is "Record requires editing". I want …

Is there a way to do a sort of general search where you can search all fields with one request? It was possible in the old Apple Works database. A simple Find window and it searched all available Fields for the query. Thanks, Erik FM dev 7

Hi All, I have two tables: Students and Programs. Students fields are: StudentID, ProgramID, Status; Program fields are: ProgramID, year, term. I want some way to see all students whose status is "Cancelled" for a given year/term pair. In SQL I think I'd do SELECT * FROM Students S, Programs P WHERE S.Status = "Cancelled" AND S.ProgramID = P.ProgramID AND P.term = "Spring" and P.year = 2007 to get all of the students who cancelled a spring program from 2007. Can anyone help me figure out how to find/display these records in filemaker? Thanks in advance.

I have about 4000 items in my database, what I want to do is filter a portal down to just the Items I want. So first I want a button that that filters the category list, then choosing a category filters the portal. I will be sorting first by a field named type, then by a field named category. In other words, you choose between Fruits, Breads or Drinks. When you choose fruits a second list displays Apples, Bananas, pears. Choosing Apples shows a list of apples. On catch is that the category for some of the breads MIGHT be Apple, and they shouldn't show up under Fruits -> Apple. Do I do this with relationship filtering, or scripts?

Ok. i have a portal that has a todo date, type, info, and notes. i have a button that finds less than or equal to today from the portals todo date. however, often it shows the first entry in the potral which could be tomorrow. im very confused.. any help?

I have a database of developers of affordable housing projects in the US. Developers build many different projects that are located in many different states. Each housing record in the database will include the developers phone number along with other information. When I do a search that includes all the housing projects for a certain area the database gives me a list of all the developers phone numbers for this found set. Is there a way that FM will extend this found set to include all other housing projects that are using the same developer’s phone numbers for the whole database?

Hi all... maybe you can help me with this: Is there any way to sort records by their modification date? I mean, I'd like to know which records were modified lately, and sort them by modification date (not creation date), but without a "modification date" field. FM "takes note" of modification date (I mean, in hours, minutes and seconds) when a field is changed? Because I want to create a button to show users which records have they recently modified, in order to correct wrong modifications made (comparing with a back-up database). I don't know if I am clear... if not, please let me know. Thanks for helping or just reading it. Greetings from Argentina. Jorge

Hi, I have an ApptTable with number of fields, such as PtName, PtDOB, ApptDate and etc. How can I find the last appointment date that is > 1/1/2008, and each person is 50 and older in the ApptTable? Appreciate for any help. Salina

Hello, i hope anyone could help, im new at filemaker so i dont know if im doing this correctly. so, i got customers-->jobs-->jobxactions-->bills. i want to do a report, based on jobs, showing the records of jobxactions and bills, currently the relationships between tables are correct, my problem is, when i try to do a search by dates, (i need the bills and jobxactions fields results) the find mode, omits my search criteria (jobxactions--datesorted) and shows me everything it founds in jobs table, how can i force them to find the dates in jobxactions table, although the report is based on jobs table.?? Please help... thanks.

I have made a database for a school project that lists all the affordable housing units in the country. Each record has the information of the developer that built the unit. I need to be able to list the top 10 developers that build the most units. In SQL there is a distinct count command, can someone please show me how to do this in FMP 9

hey im trying to set up a find field where each contact has 4 todo lists hooked up with a date. and then a button where you can search for everything set to today how would i get all 4 todo lists included in this find by their date, and display the data each list has to do for that date, if i searched by current date..... yowza.

Hi, I've been using FM8 for awhile so I'm not a newbie, but I am perplexed. I have a text field that is indexed but searches on this field (or imports using the matching fields) do not find data that is in this field. I can select the data in the field, copy it, then run the find and paste the exact data just copied, and it won't find it. Other fields seem to find just fine. Any ideas?

Hi, I have been playing around with the attached file called boxes someone posted (I wish I could remember so I could give them credit), anyway I am starting to understand the self-join example of the file a little better. My question is this…is it possible to narrow the search down a little. Example (disregard the active and inactive fields for the purpose of this question): If on a new record I select “Position 3 (no Buildings are checked)” and then create a new record and select on “Position 3 and Building A” for a total of 2 records in the db. Now I do a search via the GTRR button for “Position 3” only, no building box checked I get 2 records found t…

I would like to be able to mark records in a list and then find the marked records. I have done this by adding a text field called, "Marked" formatting it as a checkbox and allowing the user to check the box to mark the record. I then created a button to find marked records then clear the field on all of the records. This setup workes fine for a single user. But, it breaks when multiple users are trying to mark and find their own marked sets. How can I do something like this in a situation with multiple users? Thanks!!

I have a database that is being served to the web and we are using the XML/XSLT to retrieve data and display. Works fine. Presently there are two fields to search, a location and a group of keywords. these are calcultion fields based on other fields in the database. So right now we are doing a -LOP=and (http query) and the results are perfect. HOWEVER, the owner wants the search to work different. He wants it to work like and OR find but not exactly. He wants the first field to constrain all possible choices that match ANY of the second field. SO this is like combining an AND and OR search together and I just can't seem to make it work. …

I have a table that I would like to select a handful of fields from and display the unique combinations of those fields and the count of those unique combinations. Just like a pivot table in Excel. However, I would like to be able to format it so that the unique combination of fields is in a single row with the count at the end. I have done the subsummary thing a but the layout is terrible. Any help would be really appreciated

I want to create a scheduling database with two goups, one a meeting list and the other a list of office groups, that will be able to lists groups that need to be in the meeting at one time. We would like the time to show up using the look up tool. How would I go about doing that?

have a small issue that i'm stumped on ... i've dealt with filemaker a fair amount, but in no way do i consider myself expert (or even close to it) ... step by step help is more than appreciated ... that said, i have a simple call-back report where we can view notes of call backs on a daily basis, and what we are wanting is to be able to search this report by a date range ... i can use either fields like what is there, to type in the date, or use the drop calendar - which ever is easier to implement ... here's a screenshot of the file: http://jleeinc.com/resources/call-report.jpg you'll see at the top Monday: Jan 7, 2008, that field is where we need teh da…

Good morning! I have a little trick i'm trying to do and i have not being able to achieve it properly. I have a field that contains the data from all the fields i want to search into. (I'm trying to do a search for keyword "x" in all the fields of that database). When i search for a keyword, it comes out with only the records that have the exact text in the field. For example, if i search for Sun, it will show me the records that have Sun in it, but not the ones that have Sunny or Bright Sun in the fields. (I have 37 fields on my record that may contain this data, and there's about 400 fields total per record, and about 10000 records total) Is there …

Help building a report or at least the reference table to generate some statistical data To give you a quick overview, we are an archaeology firm so we survey coal permits, highway and other DOT projects, cell tower sites, water and waste pipelines and other developments. We do the cultural surveys and then all the data is published for the client. So the fields I am focusing on for this table are (JobType), (Client), I have a calculated field (Year) that is giving me the 4 digit year based on the field (DateMailed). So what I want to do is either have a sorted table that breaks the clients into their job types and then in Year fields I want a running total…

After looking and looking and looking, I still haven't come up with a good way to do this. Here's what I'm trying to do: 1. I have a birthday (mm/dd/yyyy) stored in a date field. 2. I would like to have a dialog appear that would ask for the month I'm looking for (such as "3" - not necessarily "March") 3. I want to use that input to find all the records with the month of "3" in the birthday field. 4. I then want to sort the records by the day of the month found and then print the list. 5. After printing the list I want to go back to my full layout sorted by name. I've been beating my head against the wall trying to figure out how to do this "simple" task…

Hi Folks, I have the following script that works great when i open the database and use it on the Purchase Order Layout. The user can see the record in preview mode and when they hit the Enter Key, it cancels out of Preview mode and returns the user to Browse Mode. Then they can choose another record to Preview and the script runs again fine. But when i go to another layout and use another copy of this script with the appropriate layout references changed, it does not allow the user to hit the enter key and return to browse mode. Then if i go back to where i know it works on the Purchase Order Layout, it doesn't work again. Only when i close the database a…

I am linking to a SQL database and have a global field where the user enters the project they want to retreive records from and a script returns these records from the correct project entered only correctly. Then if they do another specific find in a layout for a particular record associated with that project, this returns that particular record too because the project number was held in the global field. (I think ) My problem for the user is that after viewing this one record from the specific project, they now want to go back to the same layout where all relevant records for only that project again are displayed so they might choose another one to look at etc…

I have a Purchase Order list layout setup to input fields etc. When the user wants to print, they can go to the Form Layout i have setup to print the Purchase Order etc. But the problem is that this layout shows all records etc. so eventhough the user arrives at the record they want to view in the Form layout, i would like to restrict the user only to see the one record. Is this possible?

I am trying to create a script that will report when a record has been modified, and then display those results in another layout. So far I have everything working the way I want it to, with one exception. I want the script to automatically perform a search and display records that are modified, starting with today's date through seven days prior. I know I want to search a date range using the ... command, but where I'm running into problems is with current date minus the 7 days part of the search script. I can find records easily using //...1/21/08 in the record modified field(Using today's date as the current date) What I want the script to automatically en…

Please help! I have a multi-table related database. When I delete a record on a list layout, all records with the same company field in that table are deleted. Even when only the record I want to delete is showing (the rest omitted) all records with that company field vanish. For what its worth, the company field is the field that relates to other tables. Any clue why that would be happening? Thanks, Sandman18 ps....I'm using FM Pro 9v2

I'm trying to use a script found in another post: Enter Find Mode[] Set Field[MyTable::MyDateField; (Get(CurrentDate) - 30)&"..."Get(Current Date)"] Perform Find[] However, I keep getting an error message that an operator is expected after the semicolon. Am I missing something?

So I just realized that finding/searching in FMPro is quite limited... If I have a field with the text, "Adobe InDesign" and I perform a find for "Design" there are no results. I understand from searching this forum now that this is because FMPro searches for words that start with... I have also seen some posts here about using custom functions to explode the field. My question is, is there a simple workaround to enable searches/finds using partial data? Are these explode custom functions the only way? I ask because I have created a Search field, sort of like Safari's browser has in its window, which enables my users to search for text without actually ent…

This one has me sucking my thumb! I have a situation where I need to COPY a five digit field (CustID) in Transaction Layout. Then, Goto (Member Layout::Member Table). Enter find mode, select (CustID) field and PASTE. Then Perform Find. Problem is, it won't paste from the script! It will paste if I stop the script just before the paste step and manually paste the characters, so the copy part of the script works just fine. This however does not help because everything in this solution is scripted because it is in Kiosk Mode and no keyboard exists. Whats even stranger is that there is another case where the user needs to Copy/Paste the same characters b…

I would like to set up a script that searches for records older than 6 or 12 months from current date (date to be compared is not created date, but rather a date filled in by another script per a change of language field), and then clears specified field. I understand the clear part, but am unsure how to find records. Thanks.

is it possible to view 2 seperate searches at the same time, eg. i search for john smith and all his various details come up, i then search for john jones and all his details come up. but what i wish to do is view both sets of results at the same time in order to compare the averages of both thank you

I have a start up script that finds records from a invoice layout. When the invoice layout closes, the original layout (contacts) shows the related found records from invoices. What I need to add is some script that will show the original record (last viewed) before the start up script performed find.

Hi, Customer --< Jobs. I have got a layout based on Customer where bascially user enters the search criteria and it contains a Drop down list of all the Customers & 2 date fields that are both associated to Jobs::StartDate and a find Button. When find button is clicked i want to search/display all the jobs in a different layout for the selected company where job start date is between the selected date range. The reason i want to display in different layout is to print the found records. Thanks in advance. Mitesh

Im not sure where to categorize this question or even how to word it but I will try... When I go to do a search.. and I am in table view... I generally enter the date I want to search for in the field I want to search for it in then I hit enter onc and my search is performed. However some fields, if I try to search by them, and enter the info i want to search for and then hit the enter button, rather than performing my search instantly I ended up tabbed over to the next field. In some cases I have to hit the enter button 4 times, which tabs me through 4 different fields before my search is finally performed. Ive lived with this for a while but now its just gotten the…

Hi, I wrote a random search script as follows: Go to layout(Data Entry view) Enter Find Mode (pause) Perform Find() Go to Layout (list view) Enter Browse mode (Pause) Go to layout(Data Entry view) Show all Records I get an error message saying "No records match this set of find requests" then I click continue and it shows the found record. What can I do to get rid of the error message?

I have a field using a custom value list. One of the items in the value list was Black/Blue and when a Find was performed, it resulted in 44 records. Then I changed list to have Black on one line and Blue on the next. Now when I search on Blue, I should get 4, but I get 44 and the results look as if the Black/Blue entry still existed. How can I make the distinction? Thanks

Dance students enter the studio and enter in their ID. (Note: the date and time fields are automatically filled in with the correct values.) Students are allowed to attend once a day. Issue: I need to run a report where I display the students name and the last date attended. I'm able to search and find the student's attendance records and sort by date. I cannot figure out how to display only the latest date (most recent) Thanks for any help. M

In FMP6 i had a date field calculated as follows: todays date + 10, 20 or 30 days (value list dependent) I also had a script that could find over due dates, ie / This field used a not-stored calculation that was immediately recalculated if necessary. In fmp7 it is no longer possible to do this search unless i store the calculations first. How do i solve this issue?

Whenever I search for duplicates in my parts database (250 000 records), it treats V = W, wich means filemaker treats the below numbers as duplicates XW4Z-3530-BV XW4Z-3530-BW Why is this?

Now I really feel stupid. Need to do a find on a date field for a given month. The date field is an auto enter date created. I do not want to have to enter a date range as my users would never be able to understand Begindate...enddate. What i would like to do is Hit button, Enter Find mode, Enter Month, Perform find. The month part is what I am having trouble with. Thanks

I have a database that has 2 tables, one is meetings and the other one is documents generated at the meeting. The key field is meeting between the 2. I want to do a search by meeting and get something like a list layout. I would like the list to have clickable buttons to export the documents so they can be opened from filemaker any ideas. I am new to this.

I have a sales table and I want to display sales data from the current date and for the same date last year. So if it 12/01/2007 I wnat to see sales form today and for 12/02/2006 on the form. I have the form with todays sales and 2 tables. One has current sales and the other previous years sales.

When people log in I would like a find to locate only those records that are produced by that user. I have a field (hidden) in the database for putting the user name of the user when they create a new record but how to write a script to search and display only those records created by the user logging in and create a new record if they have no records ? Obviously an admin user would need to find "All the records" and not be restricted....

Hi, I'm very new to Filemaker and am having difficulty being able to manipulate the 'current record'. In particular, if I do a search on a field which returns multiple matches, I then display this set of records in a list layout. When the user selects one of these for further examination I want to take the user to a Form layout which shows him/her just that one record and I can't seem to do that - the window shows all the matching records in the form view (though starting with the selected one). Any suggestions on how to limit the form view to just the one selected record would be much appreciated. Also is there any way to select one record from many in a list view…

Hi, Is there an elegant way to have two fields, side by side on a Header; one showing a total of a field across ALL records in the file; and the other showing a total of the same field that occurs across a given found set? In other words, a "total-of-all-records-regardless-of-found-set" and a "total-of-found-set-only" Sorry if this is a dumb question...

Can you use a local variable in a Perform Find script step? I try and it does not find any records. If I hard code the text value of the variable, the find perfoms perfectly. Thanks, Lewis Howell

I have a database that I'm working on with a People table. So far so good. Well, I go to try the find function, and I can't find records that I know are there. In fact, it NEVER finds anything. I've tried finding on text fields and number fields. Nada. I have full rights, so that isn't the problem. I figure I'm missing something basic. Clues? Thanks! -Jeff

hello, i have a DB that usually has current records, but every so often, there are no active records, it gets stuck in a loop, and i have to user abort it... how do i exit the loop when there are no more records to omit... thanks in advance. Enter Browse Mode Go to Layout ("invoice summary" (invoice table)) Show All Records Go to Record /Request/ Page [First] Loop If [invoice table::invoice status = "current") Set Field [invoice table::days; If ( invoice table::invoice paid yn = "awaiting"; (Get ( CurrentDate) - invoice table::invoice date;"")] Set Field [invoice table::pay beth: If ( invoice table::ER Income paid yn "holding"; "!";…

Searched the forums and couldn't find the answer. If I open a new window that goes to a different layout to perform my find, is there an easy way to pass the results of the find to the original window?

First, here is the situation I'm in. I have a table which contains a duplicate record script. When the user dupes the record, the duplicate does not automatically end up as the last record in the set, which is causing confusion with the users. Users create a found set on any criteria. I need a script that will add the duplicate to this found set as the last and current record. I have built a script that uses the GTRR script step in a new window to create the dupe, then sets the record ID as a variable. I was hoping to simply close that window and use extend found set to add the new record (which by default will add it to the end of the found set), but I can't u…

I need a script that would create a found set consisting of all records that matched some, but not all, criteria. For instance, if a portal contains the years in which each salesperson met their quota between 2004 -2007, how can I find those salespersons that met their critera in three out of the four years?

Greetings from Argentina: I'm pretty new in this, and I need some help from you experts, please! I have a table in which I take notes about my costumers calls. Each call, have a different date field. I mean: Peter Johnson 14/07/2007 Called to ask for a pizza 16/08/2007 Called to ask for 12 hamburguers 19/09/2007 Called to ask for the party I want to find out, for example, how many people called me in August. What do I have to do to specify the find request to make it search into the differents date's fields, of each costumer's record? I know that if I write 1/8/2007...31/8/2007 in the first date field, then ctrl+n and write again 1/8/200…

Hi, I have Customer ,Divison & Contacts Tables. Customer can have many Division and many contacts can exists under this divisions. I have create a little demo file for review. What i want to have is in ContactSearch is have a drop down list of company & Division. User will select Company and Division will be filled with all the division of that company. I want to display all the contacts as soon as user select the company and then narrow it down by division. Thanks in advance. Mitesh Mitesh.zip

I know that this is simple to do, but somehow I can not figure out where to start. I made this really involved and detailed flat file and I simply need to get the number of records created on a per month basis. I need to turn in a report listing the number of items created on a per month basis over a three year period. Do I need to some how make a related table to count how many per month?

I need to find a way to to eliminate the character " from multiple fields in my 18,000+ records with 60 fields. With some of the exported data, it has been assigned a text qualifier ("). Unfortunately, this is now showing some fields with a " at the front and end. This is especially bad when there is a size 8-1/2" because they also have extra quotes. So what I am trying to do is create a script i guess that will go through all the fields and replace the " with a space or delete it. Bonus points if I can remove the extra " in measurements so "8-1/2"" would be 8-1/2". thanks for any help.

FM 7 Pro on a Pentium III has recently started misbehaving. I typically have five open databases & never had trouble switching between them with the WINDOW drop down menu. Now I do, but only after I open a specific one of the 5. It doesn't seem to matter which order I open the databases in; once I open the TroubleMaker I cannot use "open recent" to open others, or the Window menu to access them if they are already open. none of the files are big. Thanks.

Hi all, Please be gentle I am a newb! I need to generate a report that only shows me clients that have a job booked in within the next seven days. How do I set up a script to do this? Thanks in advance!!

I'm developing a database of songs that needs to be searchable by multiple criteria/fields. One of those criteria is Bible reference. The trouble is that such a reference consists of 3 distinct parts: book (Matthew), chapter, and verse(s). A record (song) also needs to be able to contain numerous individual references, (i.e., Matthew 26:26-29 and Mark 14:22-25), perhaps more than a dozen. I'm having trouble determining a way of isolating individual references. For example, if I include both of the above references with some kind of separator in a single field then search for 'Matthew 14', it will return this record even though I don't want it. I've also experimented …

I have a checkbox list that I need to display all the fields that are checked. Also if its possible for it to omit with the State selected. Ive tried a bunch of different things and read lots of tutorials but cant find anything! can anyone help or point me in the right direction please.

Hello, I have a "list view" layout(LayoutA) with a button. The button opens up a "form" layout(LayoutB) displaying the record the user originally selected. It work fine but the user can browse to another record. I want to constrain the record the user selected. How do I do this? I tried this: Go to Layout[layoutB] Go to field [select/perform;LayoutB::Field1] Go to Record/Request/Page [No dialog;LayoutB::Field1] but it doesn't work. Can someone please help me? Thank you

Hi I just wanted to find out how to do a search in a membership database that is set up on FileMaker Pro 6 (on Windows XP). It's a membership database at present with 5000 records and our previous FileMaker person (who no longer works for the organisation) set up a script to search for and export records from Queensland. I'd like to duplicate the script and change it so it searches for the same other fields, but change the value it searches for in the 'State' field to a different state. The script is: Perform Find [Restore, Replace Found Set] Sort [Restore, No dialog] If ['Status(CurrentFoundCount)>0"] Export Records [Restore] End If So this s…