Finding & Searching

Hi, I have a table with the following fields: PlannedDate ActualDate ProjectName PlannedMonth Milestone Category A project can have multiple milestones which would be in separate records. Same milestone can be selected for multiple projects. The project is completed if an actual date is entered. I want to generate a report in the following format: Category1 PlannedMonth(January 2005) Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX Milestone2 TotalProjects: XX ProjectsCompleted:XX Due Projects: XX PlannedMonth(March 2005) Milestone1 TotalProjects: XX ProjectsCompleted:XX Due Projects…

this might be a real newbie thing, but can i actually manually select a number of records from my contact database, and then send an email to all of them? (i know how to send the email, but not how to pick a few records by hand) sometimes i just want to browse my database, and make a selection of several records, and then export those records or do something else with them... thanks for any tips! alexandra

I have a layout which has email addresses. When the user does a find request entering the first characters of an email address it returns nothing. Is there a problem when the field has special characters such as '@'. There is a similar problem with web URLs. What am I doing wrong?

I have a table of Students records related a table of their Grades. There is a one Student record to many Grades records relationship (e.g. a record in the Grades table for each subject a Student studies). Each Grade has a field for "year". As we move into a new academic year, I want to restrict finds on the Grades table to grades for the new year only (i.e. find only those records from the Grades table with an entry of 2006 in the year field, excluding those for 2005, unless the user specifies 2005 in the Year field explicitly). I also have a table with a single record which has constants such as the school name etc, and the current academic year (now set to 20…

Hi, I have an issue with a report which is running really slow. The application is running from the server in LA. I have some users in Indianapolis. The connection there has been a little slower than what users get in LA. I have designed a new report which contains summary part to show group data. I have created a script to run this report where I first find the data, navigate to the report layout and sort the data. I have experienced in the past that sorting has always resulted to make the application slower in Indianapolis. The report needs to be shown with the grouped data and hence I believe that sorting is important. But this time the report generation has …

Hi, I want to create a script that will perform a search on 2 differents field: Name and Status This script will automatically put a Name into the Name field: EX:Joe . at the same time ,I want it to do a multicriteria search for the status field EX: omit "Received" "Send" and "Ready to go". How can i do that ? thx guy

Hi all - hope you can help. I'm creating a report in which I want the first step to be to perform a find on a date field to find all dates in the last 30 days. How do I set a find criteria that is effectively 'today...today-30'? Thanks!

I have a status field in a table that is populated using a drop down list. From this status field I want to give users logging in a count of each status in the database. I'm a newbie and the only two functions that seem relevant are "count" and "exact". The values in the field are: "sold", "available" etc. The formula I was looking at was similar to: count(exact("sold"; status)) but the field type is not appropriate for a text value such as "sold". Am I on the right track or is there something else? Kevin

I have a search problem. When some of our users do a find for a certiain status("Revisions Needed" for example). The search returns all the records that have that status, but occasionally it either returns extra records or reports the correct records, but with statuses that show up as something other than the search criteria status. My first thought was a cached data issue, but even after a restart of filemaker and the machine, they still get it. I can't replicate it, and we have tried a reinstall, including throwing out all the preferences on the machine. No luck. Any ideas would be greatly appreciated. ~Mark

I want to search records that contain data. I use the * to accomplish this, however, I want to exclude Unknowns that appear. How do I do this? Any help would be great, thanks.

I would like to click on a button in Filemaker and send text from a field to the Google Search WSDL-defined web service. I would expect the behavior to be similar to the "Open URL" action and open a window to show the results of the invocation.

Does anybody know of a way to find triplicate records? I know that a "!" in a field will find all of the records with 2 or more matches, but I am trying to just view records that have 3 or more matching values in a certain field. I don't know if this is possible, but any input would be appreciated.

Here's the setup: A db converted from FM6, with several files. table Individuals (in file A) is related to table Services (in file via a number of different relationships. So I have multiple TO's for Services. The relationship in question is multiple-criteria. The match fields are: [color:blue]HouseholdID = HouseholdID gServiceType = ServiceType We'll call this TO ServicesSelectedType It's the second that's the problem. gServiceType is, you guessed it, a global text field in the Individuals table. ServiceType is an indexed (non-global) text field. If I make a portal to Services in the Individuals file, using this relationship, it work…

I am new at this. I am getting some of it but sorting and getting what I want is driving me crazy. I have one field that is a drop down list. You can choose two names from it. The boss wants to be able to run a report by finding one name and printing all related records. So the report has to be seperated by names. Maybe a script would work here. I do not have it as a portal, since I am still trying to grasp that concept. What would be the easiest way to find all records associated with a particular name so I can run a report? Hope this makes sense. Thank you.

hope some one can help me. I setup a find to search on a drop down list that can be either set to Action or Completed. However when the sript runs the find it does not find all the records set to Action. Only about half of them. I have an omit in there after the find to omit all the records set to completed.

Hey Everyone. I'm writing a ticketing system in filemaker 7 which will have several fields in the main Tickets table. It will have several notes fields and follow-up fields. I would like to know if it is possible to search multiple fields in a record in FM7P. For example, to be able to search for a given string and have filemaker query all the fields in a record for that string. Does anyone know how this is done. thanks in advance. JR

In switching from FM7 to FM8, I have encountered I believe a bug. I have a script that goes to a layout, enters find mode without pause, set a time field to a given time, and then performs a find. Worked great in FM7, but in FM8 it sets a ".*" after the time. Attached is an example. I have tried to do a left(time,8) to just use the first correct 8 characters but will not correct. Any suggestions? timeprobs.zip

Hi all, obviously I'm very much a newbie at FM. I run a newspaper website where the prvious database whas a simple flat file text file. I've successfully imported it into FM, but now have an issue I can't seem to solve. Wherever there were html line breaks, I need to turn into normal carriage returns within the field; i.e., find " " and replace with a carriage return. What is the proper way to do that? In BBEdit I would replace with "r", but FM seems to take that quite literally. TIA

Hi Guys, Sorry, but I could not find anything on this when I did a search (never seems to work very well). Anyway I'm confused! I have users enter a find request, they can then flick through the found set and when they find the appropriate record select an edit button. They are taken to an edit screen where they can only edit the record they selected - They then select the commit changes button and return to the main screen - which now only shows them 1 record. I would like to automatically show the previous found set, flick through again and make other edits. The reason for the edit screen showing only the selected record is that I don't wan…

Is there anyway to get rid of that dialog box with Modify Last find, Continue and Cancel buttons when the results of a find request is 0 records? I have several scripts that uses Perform Find and Enter Find Mode and a custom dialog box. I basically want for a custom dialog to appear if the results is zero records. You've all been great. Thanks again. Jean

Hi Guys, I'd like to do a find on a field (defined as text) and depending on whether the 1st character is alpa or numeric, act accordingly. I'm ok on the logic and scripting side, I think I can extract the first character using the *Left ( text , number )* function - but how do I determine if it's alpha or numeric? I can't seem to find the correct function. Help appreciated.

Is it possible to write a script to check whether the function of Modify Last Find is available or not?

Real Newbie Developer Question: I’m doing scripted report printing - and need to select data based on the current record that is on the layout – a pretty common occurrence. A very helpful person has suggested I do the following: Enter Find Mode {} Set Field [field1; globalfield1] Set Field [field2; globalfield2] Perform Find [] Were globalfield1 represents a matching global field for field1, etc. Question: This makes the assumption that the global field is set as a Calculated field that always is fieldname – no? Thanks, Mark

A client of mine, using a runtime solution I created, added 7 records to the database and entered various data into the available fields. Later she selected one record to delete (Ctrl+E), but when she proceeded, 5 other records also were deleted. I have been unable to duplicate this using my version of the database. Is there a way she could have entered data so that the records were linked/associated in such a way that deleting one would automatically delete others?

I'm creating a reservation database for audio-visual equipment and I have already set it up so that a new record is created automatically, which is great. What I need to do is to block the users from seeing where the equipment is already at so that they (the teachers in this school) don't go trying to find that equipment that isn't theirs. I have tried several different scripts and field configurations, but no one seems to have just what I need. If I could just wrap my head around how to do this, it would be much easier (I could do this in MS Access, but I prefer FM Pro). So, if there is some way that I could block the book feature, that would be perfect. O…

I have records with a date stamp that I would like to sort and subtotal by month. can anyone tell me how to do that? Thank you

hi, i posted this in a different spot, and upon revisitation today, i realized that it was in the wrong spot, so i am reposting here in hopes of help. I am back, with more dumb questions about stuff that's probably easy. Here goes: I created a database for the inventory in which each record is one item. There are only about 200 records in it. But now I want to make a database that can take the date it was modified (inventory day) and create a record that would include all items in it, with their count. I am hoping that then, if we need to, we can look back and say, "oh, we had this many this day, blah blah." I also want to be able to track sales by week and t…

I have 1 database, 2 table, a relationship is defined: where table1ID = table2ID My question is how can I display the related records from table 2 inside a layout that belongs to table 1? I'm kinda a newbie. Thanks for any help.

Hi, Through a script, I want to find all the records in a file where creation_date is >= 01/01/<>. The creation_date field is a date field. I tried to execute a script with the following script steps: enter find mode[] set field["creation date, ">=" & texttodate("01/01" & year(status(currentdate)") If I use the above method then FileMaker interprets the the result as a text data because I am concatenating a string to the date. I tried using Insert Calculated Result[] but after concatenation with the text field, it shows the total number of days from 01/01/0001 (for eg: it shows '>= 01/01/2005' as '>= >=731947' and FileMaker giv…

Hi, Sorry if this was already discussed before but I'm new to this forum and searching the forums didn't provide me with an answer. My problem is that I want to substitute a single quote ' with another string. Neither of following worked: Substitute("","'","") Substitute("","''","") Substitute("","'","") Does any of you have an answer?

Hi all I can find the min and max date a welder has welded, but i also need to find the date before the max date. example: Terry welds on 1/3/05 3/6/05 4/6/05 5/6/05 7/24/05 8/23/05 I can find the first date using "min" and the last date using "max" but i can not figure out how to find the date before "max" which would be "7/24/05". Any ideas and suggest would be greatly appreciated Thnaks in advance Lionel

Hi I'm trying to make Filemaker perform a find on text of a specific color, so it can omit the records it finds with text in a given color. Current script: ---- * [color:red]Show All Records * [color:red]Enter Find Mode [Pause] [color:brown]//Search text is entered here// * [color:red]Perform Find * [color:red]Go To Record/Request/Page [First] * [color:red]Loop * [color:green]Go to Field [database::fieldname] * [color:green]If [Get ( ActiveFieldContents ) = TextColor ( database::fieldname ; RGB ( 0 ; 255 ; 0 ))] [color:brown]//should check if text is green// * [color:blue]Omit Record * [color:green]Else * [color:blue]…

I've been doing finds for * inorder to see how many records have data in each field but * doesn't work in date or number fields. Is there a wildcard I can search with for number and date fields that will do the same. Thanks. Filemaker 5.5.

i am creating a reservation database and want to search find records between arrival month and departure month. because i already needed to create fields for each month of their reservation, i am trying to create a current month layout where i enter a search field that returns results from any of the 4 month fields that are already entered. at the moment i am trying to make it work as a calculation, ie, data::field=blah1 or blah 2 and so when i enter a month and year and submit enter, it will return the lodgers staying during that month. i am desparately in need of a solution thanks

Recently, I was sent to a training by my company on how to effectively search and analyze databases. A key componet was doing SQL searches - and using Access. Maybe it was poor research, but my company exclusively uses Mac OS X and Filemaker was the database of choice. As FM 7 translates Access databases, my only concern is whether I can someone make basic SQL searches within filemaker or if I will need to learn how to use a program like CocoamySQL. Using Access is just not possible at my job, they just moved over to Macs. Any thoughts from FM pros would be appreciated.

I have a database that keeps track of the training all of our employees have. If I do a Find of all of the people with "Lift Training" and from that find do a constrained find of all that have been trained for a "Fire Watch", in my report layout, how do I display "Lift Training & Fire Watch" in a merge field so I can display what I was looking for. Thanks, Phil

Hi Guys, Is there any way to disable performing the find when the user hits the enter key? I have a script that enters a layout and then enters into find mode - the user enters data, and then I require them to select a button that performs the find based on some specific calculations. Problem is if they accidentally hit the enter key (which is not unlikely), the find is performed, then they are in browse mode without realising it, and could easily destroy existing data. Is there a work around? Ta.

I have many layouts that are are related by clientID. I want to create a drop down list that shows all the associated company names. When a company is clicked, I wanted the records that match that company name to show up. Right now, I setup a drop down list and that list changes the company name to the one that is clicked. I do not want this functionality. How do I make this list into a button that returns the matching records?

I am sorry to bug you guys and gals but I need some help. I am trying to do a scripted find because I don't want the operators to have to figure out what they need to be looking for. I want to do a scripted find on three fields: SchoolID, EntryDate and ExitDate. The SchoolID and EntryDate fields are global fields and calculated from user provided information. No problem there. These work by themselves or together every time. However, when it comes to adding the third field to the search process it breaks down. I've set up global fields developed from calculations in order to enter variable data based on multiple criteria for the ExitDate field. The fir…

So far, I'm able to 'hardwire' the omitting of records, as per the red 'Declined and Complete' text (button) at the top of the screen in my attached file. I'm wanting to script the 'omitting' of multiple records, based on a user's multiple selection. I've set up two globals, and I'm able to 'find' based on the first, but I'm wanting to omit the records with the RecordStatus based on the user's selection for either. I would need to set up a third global if there is a third option if I continue in this direction. Thanks in advance . . . omit.fp7.zip

Hello, I just started using fmp7 (after 5 and 6 of course) and somehow finding duplicates doesn't work correctly. I keep getting wrong results. Searching number and text fields. Looking in related fields but also in 'native' fields. Is this a specifice fmp7 problem? Might not have been looking thoroughly enough but haven't found any remark on this subject. I know I can also look for duplicates through a self-join but I was just wondering what was wrong with find duplicates. Thankyou for reading and eventually answering this question.

Can anyone tell me if I can place ascending or descending order parameters in a field for sorting without using the cmd-s key stroke for sorting? In other words the field account will always be sorted ascending. Thank you.

I have a found set of 1900 records (from a dataset of over 4000 records) which all need to be updated in the same way--they all need to have the same value in a field defined with a radio button value list. This value-list field is now blank for all of these found records. How can I automate the process of updating all of the records?

I'm cleaning up a flat, one file database that someone made with 869 fields and 4000 records. I was told that there might be fields that actually are empty for every single record so I can get rid of them. Is there a way in filemaker 5.5 or 6 to search for these fields. Thanks.

Hello, I was wondering if it were possible to retrieve a list of all used fields. Fields that are unused within my database I wish to delete. I've gone through every layout and made a list of all fields I saw but I would like to be 100% that I didn't miss any. Any ides?

I have a table of names of software, created to keep and inventory on what my company is running along with the licences we have. I recently discovered that i can use a server application to get a list of all applications currently installed, and how many. The problem is that name exported from the server are often more detailed (ie Adobe Acrobat 5.0 (v1.000.600)) and do not match up with already have in my DB. I have imported the server data to a new table with 'name' and 'number' fields, but i want to share this information with my SoftwareInven table. Since the names don't match up i am having trouble. I tried to create a script that could find server data based on t…

Hello! I have two databases, one is Client info, the other is Billing and Payment info. I want to be able to have a running balance for each client at time of service. If client is seen on 1/1 and is charged $100, but doesn't pay, the balance due is $100. Then when client is seen again on 1/7 and is charged $100 and pays $50, balance due would be $150. This seems like this would be easy enough to do with a GetSummary field, but it doesn't work out that way. I either get the entire client history (future appointments and past appointments) or I get the entire database--all clients' payments and charges--getting added up. How could I go about finding only the client…

I am looking for an elegant way to check a price of something (in a product file)while in an other table (invoices) and I thought i could do it using custom dialog. I have setup a button called check price. the dialog box asks for the product code to be entered (either via barcode which I have set to send a RETURN command after it or manaully via a keypad) I have setup two boxes - Cancel or Check (which is the delfalt one) The tricky bit I am finding is to get it to lookup the retail price based on the product code and return it via another custom dialog box. There is already a relationship between the invoice and product tables. I know i can do this by no…

I am trying to develop a layout that will show items purchased by a customer without showing multiple items on the report. Example: I have 10 customers who have bought thousands of items. I search for customer X, and the list mode shows he has bought Y Y Z B B B J J J items Instead, I want to show: customer name 2 Y 1 z 3 B 3 J Am I making sense? Basically I want it to count up how many of each item he has purchased across literally thousands of records, hundreds of customers and 917 items. Any help would be greatly appreciated. I have searched and searched. It's midnight, and my eyes are glazed over :(

My apologies if the answer to my problem is already somewhere in this forum but I can't find it and after looking and reading for the past two days, I am now totally confused. I have a multiple FIND request problem. In essence there is a choice in one field and I am confused as to what remedy is appropriate. The desired result: A report of attendance for only those students actively enrolled in that class for any particular week. We don't want students who were once but are not enrolled in that class during that reporting period/week. We also don't want students who are on the books but were enrolled at some future date of the reporting period/week. My…

Hello all, I'm having a problem getting my portal to give the results I want. It's a fairly simple structure. Table 1=Sales people; table 2=orders. I have a portal on "sales people" layout listing orders. No problem. What I would like to be able to do is refine it more to show only orders occuring through a range of dates. Thanks in advance for the help.

I have a FM6 db with fields eg code, course, outcome, faculty. I have buttons to select the group of outcomes specific to each faculty. Outcomes can be grouped from Years 7 to 10. I want to script buttons (one for each year) that, after selecting by faculty, the faculty head can select the appropriate year from within the faculty selection. AND, place that button on the layout so that when other faculty heads access their outcomes pressing the year button selects that year only. After selecting the faculty, the year button selects all of the year outcomes across the school. So, in summary again, can I have some help in scripting to find with…

O.k. I would have thought something like this would have been posted but I can't find it. Anyway, I would like to make a report for estimators that calculates all estimated dollars. We have 4 estimators and I would like a report for each of them for each month. How can I search for "name" and "beg. date" to "end date". I understand about the (...) way to search between dates but can't seem to get it to work right. What I would like is to automate it as well with some type of script, if possible. Thanks in advance for any help.

Hi all, I've searched archives and can't find much to help with my problem: I am building a database of tapes which all have unique ID numbers and am wondering if there is a way of automatically adding the * to a find. Many of the tapes have letters/numbers that could be ommitted when searching eg. IS1000394 - it would be easier just to search for 394. So in short, is it possible to automatically add * to the beginning of a search? Any help would be much appreciated. Thanks Taig

I need a way to build a search that will check Three critera instead of one. I then want it to list the results in a list below the boxes you filled in. I then need if the customer does not exist a way to copy the already entered critera into the proper fields in the add a customer page. Ok I need it to do this customername or customeraddress or customerphone If you can just tell me how to do an or search I will figure out the rest. Thanks Tony D.

I add a record to table via a script ... that part works Ok ... but when I add the record it gets added to an existing found set. I want to have it as the only record in the found set. In other words I want to discard the entire found set before I do the new record request. I have been unable to find a straightforward way to do this. Is there one?

I have an election database (FMD7), and the VoteData table has these fields: ElectionYear, County, VotingLocation, Contest, Candidate and Votes. Right now the table is populated with data from both 2002 and 2004. I need to make these two finds: 1. VotingLocations which existed in 2004 but not 2002 2. VotingLocations which existed in both years but reported no votes in 2002. So each record in the table is for one year, one location, one contest, one candidate, etc. Thus for a given location, there are separate records for the two years. I'd appreciate suggestions on how to approach both of these finds. Thanks! James McAlister www.Bulle…

Not sure if asking this correctly... New to FM, previous user of Alpha 5(PC). When I use "find" feature; this works for the field I created called "rep", but I wish for when I find the "rep" name than the "account" field be sorted automatically-alphabetically. In order to do this I must use the cmd-s keystroke to alphabetically sort. With A5 my rep finds were always sorted alphabetically. Any help here? Thanks

Is it okay to search on un-stored calculation fields where a part of the calculaiton field is part of a relationship (so that i can't force it to store the calculation). I'm certain it worked in my testing database but when I empty it all out and give it to the client it stops doing the find on me unless something else is wrong.

Hi there, This may be really simple, but I cannot figure the proper way to write this search criteria in a script. I need to search within a field for all days between 2 weeks before today and all dates after. Hope someone can help, thanks in advance.

Hello, I am using FM7 Server(v3) on windows 2000 server, with several clients running FM Pro 7 on WinXP. I am facing a very strange problem, when we search the calculation fields (cannot indexed), it always return the wrong result. However, this problem only exist for those users login name other than "admin", if we use the "admin" account login and perform the same search, it did not have such problem. I believe the problem mainly coming from the Filemaker Server, because when we stop the server and open the file directly as single user mode. It did not obtain the same error at all. Does anyone know how to solve this problem? Thanks in …

So here's the deal. I have an order entry database. The tables I have are line items, invoices, suppliers, customers. The line items table contains the individual line items for the invoices and is related to the invoices table using a field called invoice number. Each line item can potentially come from a different supplier, so in my line items table I have a supplier # field that the person entering the item needs to populate when entering the item. On an invoice layout there is a portal that shows the line item records including the supplier # field. When the invoice is entered and ready to be printed, you only need to print one invoice, ut I need to …

I thought it will be a great idea to have listing dog foods that I sell with their ingredient list, so that if someone is looking for certain ingredient in the food, I can find them easy. So I started creating a database with name and ingredient list as fields. I was listing the mail ingredients in "ingredient list" field. However the find does not seem to find more than one thing in the same field. is this correct? If so, do I have to make separate fields for each ingredient that I'm inputting?

Hello, I am trying to do a search with the following: Search for information from the table 'Interviews' for records located in the table 'Program'. They both use seperate layouts and tables. I would like to search on one field, however possibly more such as: Search on the field: Interview::Program Name and Interview::Type Thank You and God Bless! David Garza

Hello there, If anybody can help, it will be great. I have to fields: start and stop. each opening and closing of my database put a timestamp in the releated field. a calculation field (stop-start) count the time. how can i calculate the total time? Thanks for your help. Dom

I have a contact management table whose most "natural" sorting order is by the "company name" field. When I view the table in unsorted order, it comes up in the jumbled order of creation, which isn't really useful at all. Right now I have to go to some trouble in scripts to make sure that the found set is always sorted. Instead, would there some way to permanently change Filemaker's default sort order? One possibility I can think of would be to duplicate all the records in the order that I want and then delete the old ones, but that seems risky and clumsy. Doesn't Filemaker have a feature to easily do this somewhere that I've missed? Thanks.

I have a script that does a find then does a couple of constrains to omit some of the found records to get the records I really want. The last constrain Omits ! on the key id for the records. I run this once a week and it has been fine for about 6 weeks. For some reason it it finding records that are not really duplicates and is omitting them. The only thing that was done was that we removed a large portion of the records that were not being used. Would this have possibly created a problem with the ID that can not be seen on the surface? Is there another way to omit duplicates?

Okay...still learning so bear with me. I have 15 text fields, each of which could potentially contain an email address, but only one of them actually will. I need to create a script which looks at all 15 fields, finds the field with the "@" symbol and then copy/pastes the entire contents of that field into another empty field. Ideas? Thanks in advance for any assistance! Kirk

I am trying to develop my own billing software and a script I have written checks to see if a trasaction already exists for a given person on a given day and if found gives a custom message allowing the user to create a second transaction or more commonly back out and not do so. However, most of the time no transaction will be found and the standard message that no records match is displayed. Pressing continue then properly creates the transaction. However, I am trying to avoid seeing this message if no record exists and have not been able to do so. Is there a way?? Thanks. Paul

Hi, I'm having a problem with the database I'm fixing up here at work. When the people entering data leave spaces or returns at the end of fields it creates problems when exporting the database to Excel or publishing it on our website. Is there a way to remove these spaces and returns automatically? I was thinking (or hoping, rather) that perhaps there might be an ASCII character which represents the end of a field in FM so I could do a find/replace and simply get rid of all ending spaces and returns in two find/replace commands. If it's relevant, I'm using FileMaker Pro 7 and I'm on a PowerMac G5. I hope you guys can help me -- it'll save me a lot of time an…

I was practicing with many different searches in find mode when I came across something strange. I have a number of records in the text field "Contact". Two of the many names are Tim and Tom. When I go into find mode and type tim* I get back one record with the name Tim. (This works as planned.) When I go into find mode and type tim*..tz* I only get the record Tom and not Tim. Can someone confirm this program bug? Greg

Help! I am trying to create a simple script that allows the user, at a click of a button, to limit the number of records in the found set based on the status of each record. (The status options are "New Lead", "Old Lead", "Dead Deal", etc.) The global field for this is a checkbox, allowing the user to choose as many different types of records as they want. In trying to solve the problem, I set up two text fields. One again is Global (called "gStatus_Choices"), described above, and is the other is called "Record_Status". I then created a Perform Find request and selected the Specify Find Request feature, where I created my search criteria formula. …

I have a form that I use to order material from suppliers. It has many repetitions for the quantity, unit, desc., price, etc.. It works great for what we use it for and finds are a snap. What I would like to try to do is after I perform a find of say

Hi, I'm trying to mimic the search functions of nearly every website and software search engine which allows you to type in your search and press "enter," thus initiating the search. I'm also trying to have one field which searches across several fields. The way I have it set up is users type their search in global text field in Browse mode (you can't access global fields in find mode). Then they are supposed to click the "Find" button which runs a script that cuts the text from the global field, enters a layout that contains a calculation field which is the cumulative text from several fields, pastes the find in the cumulative text field, performs the find and …

Does anyone know if there are performance improvements when doing finds in FileMaker 7? If so, do these improvements include when your find request includes a related field?

I am trying to set up a database that will allow people to have searchable access to a list of old abstracts from a scientific conference. I spent a lot of time adding, individually, each author's name, the name of the session, and the title of the paper. These are each their own field. I made it so that when the user clicks on the button "Abstracts 2002," it will take them to a layout displaying all of the abstracts that are from 2002. No special code or anything, just a table. Now, I want the user to be able to search for any of these three criteria, as well as for keywords among all three. I cant even make a simple search tool right now because I started using this pro…

Hello guys, Its my first post in here and im looking for your help. Im working on a form View and i have designed a database for keeping details of customers of our company (around 8500 records). In order to print some selections of these records i have defined a temp. checkbox field, so as to use it for my find criteria. My question is that i want by pressing a button to uncheck any "checked" box within these 8500 records. I managed to do for 1 record but not through all the entries.

hey im creating a program for a funclub that I help run and I want to create a section where i can enter the names of people who entered the contest (have them stored) then a box where i can enter how many winners of the contest there are...then a button where i can "generate winners" based on the number of winners specified. Does anyone ahve any ideas on how this would be done?

OK, so here's the problem... I'm building a simple database for local primary schools using local census data from 1900. I want to find things like all the male, married, knitwear workers or all the female, widowed teachers or whatever. Simple multiple searches done by justing putting FMPro into find mode and then getting it to search after kids have ticked off all the criteria they want. But, I would like to keep a record of the search criteria so that I can display this on the 'results' screen. I've set up global fields that grab the search criteria before the search is actualy done and these display beautifully in the header at the top of the results page. …

I have a database with a field named FLDSTATUS that is either "Imported" or "Not Yet Imported" or "Error on Import". Approimately 120,000 of the 130,000 records have FLDSTATUS set to "Imported", there are about 2000 records that are "Not Yet Imported" and only about 7000 records that are "Error on Import". When I enter Find mode and enter "Not Yet Imported" into the field and hit Find, it can't find any matching records. If I insert the find qualifier for a relaxed search (a "~"), then Walla!, the records are found. Is this a new feature in v7, does it sound like database corruption? Suggestions would really help. Thanks

Hi everyone I'm new to this site . I joined because I'm having trouble creating a script and no one in my organization is well versed in Filemaker except me. So I thought I could make use of your expertise. The problem is that I'm created a script that takes the user to a Find mode, populates a field called Form_Status with a valid value of "Active" (the valid values for this field are "Active, Inactive") and then moves to another field called Job_Title and waits for the user to enter the rest of the criteria to search for. The problem start there. I'm trying to create a script that does the following: When the user clicks on the botton I created on the layout to perfor…

I have written a script that I use via a portal to find emails in a text box and then erase them. What I'd like is rather than erase them, is to find them and add "BAD" to the text box, keeping the email address in tact. Any idea?

I work for a large university and we use Filemaker Pro to schedule and track deliveries of equipment. I have been searching for a way to auto-refresh a list view of the current days deliveries but have not found anything. Is it possible to have a list view auto-refresh/update on a set interval say every 10 mins or anytime a new order is submitted?

Hi, i need to select or find records where field nr 1 have de same content as field nr 2 In this case i want a list(selections) of all customers where the billing addres is the same as the delivery addres who can help (fmp7) ? thanks

I'm trying to create a multi-match relationship between a table that holds "projects" and a table that holds "companies" so that i can create a portal in the projects database that displays all the companies that meet criteria, as defined by corresponding fields in the projects database. the portal i've set up is acting very strangely though. what does my relationship graph need to look like? is it an equijoin relationship?

Below See4 records out of 100 that i have. Here is what i want to do. I want to merge or put together record 1, and 2 because for one they have the same P.O. and two they have the same item number except for the last 4 characters (1b05). I want to be able to see one line with the P.O#, Print Date, Item Number (just thefirst 6 characters), and the Total Qty of record 1 and 2 combine. How the heck do I do that??. At this point all i have is one table with these 100 records. can anybody help. Thank you so much.. P.O# PrintDate ItemNumber qty 1 8071 6-7-05 ANM046-1B05 1466 2 8071 6-7-05 ANM046-2B05 207 3 807…

Uniqe value = Startnumbers When I search for ex. startnumber 9 I also get 91, 92, 93, and so on. Yes I know that if I first insert the symbol "=" I only recive the number "9". But (yes there is always a but). I would like to have the symbol "=" always before everything I type in in the searchbox. The reason is simple. If someone else using the searchfunktion and type just "9" they will recive 24 findings that will be exported instead of just one and that will f-ck up everything. Please how do I do to constrain the search to exact match whitout typing in "=" everytime I do a search. I do at least 1 000 searches every time I use the program so 1 symbol less is a lot…

Hey guys/gals, does anyone know how to perform a Find within a found set? Thanks in advance J

I have a simple database comprising of two related files. One file is used to track case information (e.g., case number, party info, settings, etc), the other simply holds attorneys' names. In the Case Information file, there are related fields for the attorneys' names representing the petitioner's and another field for the attorneys' names who represent the Respondent. A given Attorney may represent a Petitioner in one case and represent a Respondent in another case. I am trying to create a summary report, sorted by attorney name, that lists all the cases (aphanumeric numbers) that an attorney has represented - regardless of whether the attorney represented the pe…

I have a series of SET FIELD scripts that change the name of the WORKER OF THE MOMENT to the names of various workers. I would like to script a PERFORM FIND that uses as its search criteria the current value in the field WORKER OF THE MOMENT. I would like this script to be activated with a button without any additional input from the user. Is this possible? Thanks, Jarvis

i am compiling a database of course curriculum in university planning programs for a professor. i have organized the material by university and then by each course, including specific info for each course such as syllabus, prof name, course number, description, etc i would like to include with each course a field that contains keywords to show what category the course falls into: design, economics, theory, history, etc. the issue is that courses will often fall into many categories, so i would like to include 10 or so descriptive words for each course (within one field) then id like the professors to be able to easily search that field for words from the c…

Microsoft access has a nice feature: find as you type. Filemaker apparently is missing this feature. Is anything available in script or other way to get this feature? Thanks

How do I find email addresses with @ in them when @ is already a symbol for single character? Is there a find function which uses "contains" as the parameter.

Ok, I know this is really simple for anyone who uses filemaker all the time, but here is my problem. I have a home finder database that lists community, address, home style, etc. I created a layout with checkboxes to search the database and it works fine if I only make one selection in the checkbox list. If I select more than one checkbox or category, it won't find any of the records. I tried setting it up with a loop, with an else if type of arrangement, etc., but I still can't make it work. If you want the url to the database I can provide it, it is online.

i'm having trouble with finding invoice records without a certain date range. i have 2 global date fields in a "Totals" layout. they are "Start Date" and "End Date". i'm not sure what kind of relationship to set up between the "Totals" table and the "Invoices" table for that date range find to work. I have it set up a relationship for "Totals::ID = Invoices::ID". In the "Totals" layout i also have a portal set to show records from the "Invoices" table it show just about every field. I have a scipt attached to a button that will take the start date and end date, and perform a date range find and it looks like this: Enter Find Mode [] If [ not Is Empty ( …

I've got a really not fun situation for me. I'm working with FileMakerPro version 5, and I'm managing a database with a few thousand video records in it. I'm updating these videos with a new numbering system (a new field in their database) which is auto-generated by Filemaker, starting at some arbitrary number. The new numbering system hasn't been a problem, especially for new videos. As I put a new video in the database, the new numbering system field is automatically assigned to the new videos, and I can choose to enter the video with the old numbering system as well. My problem is this: I must have some representation of this new numbering system ON the video…

This may be a silly question but the genuises out there continually surprise me so... is there a way to sort records in the reverse order in which they were created w/o making a "creation date" field and sort by that in descending order? I have a GTRR in a script and, for various reasons, ... oh forget why. Is it possible?

Hi Everyone I am having trouble searching using a check box set up. I have two values for the check box - achieved and awarded. I need to find a way of only finding the ones that have achieved filled in and awarded empty. I also need to run another search prior to this as i need to separate out beavers, cubs and scout records prior to this search. so i need a solution that uses the 'specify find requests' box from the scripting section thanks Sarah Desperate Cub leader

I have a series of SET FIELD scripts which set the value in a name field based upon which button is pushed. For example: If the button that says SKIPPY is pushed, the name SKIPPY shows up as the worker's name. I also have a global text field called: WORKER OF THE MOMENT. Value in this field is equal to whatever name button was most recently activated. What I would like to do is select a name button then perform a FIND for all records with that name. Is there a way to perfom a find with criteria from a global field? Thanks for any help. Jarvis FINDWORKEROFMOMENT.fp72.zip

Hi, I am new to filemaker, and I am trying to create a database to hold and manage my research data. Periodically I have to add large quantities of new data to the database, and I am hoping to find some tricks to save time and reduce errors. One issue is, some fields in the records I enter at a given time will often have the same value. Also, I sometimes need to find a subset of records, and edit them by adding the same value into a particular field in all of the found records. Is there an easy way to do this without manually entering each one? (I have other questions but I think I should post separately.) Marcel