Finding & Searching

Hi there! I've been going crazy trying to find a solution for this one. I have a database with travel information (arrival and departure dates; resp. ArrDate and DepDate). I have created 2 global search fields (StartDate and EndDate) with a calendar attached to it for easy input, and would now like to perform a search for e.g. all records where ArrDate= StartDate ... EndDate. I had written a script storing the values of StartDate and EndDate in variables and then setting field ArrDate value to $StartDate...$EndDate, but this doesn't work. I've also tried by referring to StartDate and EndDate fields directly, but that doesn't seem to work either. The only …

FYI FileMaker Product(s) involved: FileMaker 10.x - NDA Operating System(s) involved: Tested on OSX 10.5.8, Win XP SP3 Detailed description of the issue: It is not possible to recall find criteria via the "Saved Finds" feature when the status bar is OFF AND LOCKED. Appropriate menu items "Saved Finds" and "Recent Finds" are greyed out. Exact steps to reproduce the issue: 1. open any existing or new FM 10+ database 2. if necessary, switch the status bar to visible and unlocked 3. create a new script with only one step which will HIDE AND LOCK the status bar 4. switch to Find Mode 5. do a search e.g. on a text field 6. exe…

I am encountering some puzzling behavior when performing a find in a portal. To back up and give the groundwork of the situation, I have a database that is a fairly typical students/classes/enrollments database. The database tracks student's enrollments in classes, among other things. It is a multi-year database, and thus has enrollment information from the past as well as the present. To facilitate working with current years enrollments, there are several relationships between tables so that I can isolate this year's enrollments. Specifically for the current enrollments table occurrence, the Students table is related to Enrollments by the relationshi…

Dear geeks I am currently trying to solve a really basic problem, and I reach the point which makes me see that FileMaker 10 has many more secrets to me than I thought. I have a table with names and zip code (among others) and I try to make the names appear in a portal if they have either the beginning numbers of the zip i'm entering or the beginning of the name I am entering (if I enter "R" I could see Ralph and Robert, if I enter "Ro" Ralph disapears from the portal). I'm quite confident that this should be possible, but I had no chance to date... Can anyone help me on that? Cheers EDIT: I managed to do a part solution with script triggering, modifying th…

Hi, Is it possible for a find to look in two unrelated tables at the same time? I want to type a number (10INK123) perform a find, but the find/script would look in two different tables at the same time and some how get a result if it found a record or not. Is this possible? if so how? Thanks

Is there a way to include information from related records in a search? Some auto enter field maybe which aggregates content from fields from related records? For example I have a listing of exhibitions. When searching for exhibitions, I would like to be able to search for the name of an artwork, which is not stored in the exhibition table, but related through a join-table. This would allow the user to quickly get a listing of all exhibitions which contain a certain artwork. Any ideas how to do about this?

I am consolidating a FMP file and an Excel file (Converted to FMP) into a new file for an expanded DB. On either one of these the Find function does not work for certain fields that contain mixed text (e.g. an address or an email address). When I try to do a find for these fields, I get a No Records Found message. If I enter just a the street name, or just the address number, I get hits OK. These fields are Indexed Text fields. Any help gratefully accepted.

I have a script that finds all the Invoices that are billed and have an amount > 0, and prints a list of them. Enter Find Mode Set Field (Invoice:Status = "Billed") Set Field (Invoice:Balance = "> 0") Perform Find It's been working since the beginning. And somehow it just stopped working. The Status is indexed but the Balance is not (Recalculate when needed). Could it be that we have so much records and it failed (4000+ invoices)? Each invoice is linked to a transrecord that consist of every line item on the invoice. So if 4,000 invoice averaged of 4 lines per invoice that's 16,000 records that it has to re-calculate everytime. Could it be the proble…

I have a DB of people that came from Excel. I have multiple records for the same person each with differing other fields - e.g., relative. So Lets say I have 7 records with 5 fields each First - Last - ContactFirst - ContactLast - Relationship John - Brown - Paul Brown - brother John - Brown - Nancy Silver - sister Ted - Steel - Sue Steel - mother Ted - Steel - John Steel - father Jim - White - Carol White - wife Kevin - Silver - Harry Silver - grandfather Kevin Silver - Jane Black - sister So, how do I create a script/ calculation that only returns the 4 unique records based solely on FN-LN I want only to get these 4 records John…

This seems to basic, I am afraid I have overlooked it somehow. My apologies if this is not the right forum toask I have comptuer indexes in Filemaker which I store the file path so that it can be opened on a web page on the company intranet. I want to be able to click a button like "Browse" (similar to normal techniques) and find the file on the computer sytems available and then it will store the files path in FM. Is there some command I am not seeing that allows you to do this? Thanks in advance

I've seen a few example of this using table view, but... My program is for a tutoring service and here is how I'd like to implement this: I have a table for Children, a table for Parents, a join table to join parents with children. I also have a Contacts table for all contacts (parent and children). On the Children layout, you have the option to relate a parent to the child and this shown using a portal. Currently, I have it set up to change layouts, search parents, then add the parent, via the found set, and child to the join, then back to the Children table. This works fine. I'd like to add a portal to the Children layout so i could search the parents, display them…

Hello and thank you in advance! I am trying to use a "form" to perform a search in a script. I have an unrelated table set up that I am using to create a layout and the values from that layout are copied into global fields. I would like to use the values in these global fields in a "perform find" where (for example): MembersTable::member_number>ComparisonTable::GlobalField This find would change every time we filled out the form, but that is the point. I am using the Script Manager, but i don't know the syntax to bring the values from the global field into the find. Again, thank you for your help. dp

Not sure how to go about this but.... I have a DB of Athletes that compete at various levels, both men and women. I would like to add a way for a user to select A) Pro or Amateur and Men or Women, and then show only records that coincide with those selections. Ideally one option from each category would always have to be "on" so that it would never show all records. I have a "gender" field ("Men" or "Women") and a "type" field ("Pro" and "Am"). Anyone want to point me in the right direction? Many thanks.

Hello i have a column called organization, how do i force the information in this column to be in small letters (not capitals). Also in my phone column, i want all the phone numbers with an international extension to be removed (just the extension not the hole number). For example I live in Australia, the international is 61 7 or 617. How do i remove it, without doing it manually.

I have what I thought would be a simple task. It may very well be that I am brain dead but I did spend a good bit of time looking for answers and failing in a variety of frustrating ways. I have an entry field based on a value list. I'd like users to be able to enter find mode, select multiple categories from a check box and have an OR find occur. To clarify, the user selects the following categories; vision, goals, strategies The desired result is that records having any of those categories are found. Currently, I can only figure out how to make fields with all three of those terms show up. I appreciate any help you can offer.

in employee table having field designation and values are in this field as admin,head,technician,lab assistance,etc. and want to filter values in other layout as two fields one is designation and other is emp name and as we select the lab assistance designation only lab assistant employees list show in drop down in emp name field. how can i do this? explain with example file..

I have a find result that I don't understand, and I was hoping somebody could shed some light for me. I manage and develop a FileMaker database for my lab. In one particular text field, among many other values, we have the following two values: HLA-B-1501 DRB1-1501 It was recently pointed out to me that when you do a find in that field for: 1501 You get hits for the HLA-B-1501, but not the DRB1-1501. Perhaps there is a good reason for this, but I am at a loss to explain this behavior. Does anybody have any insight into this?

Hi, This is my first post ever, I need help creating Find script for invoice program.I have 3 invoice tables, Invoice1,Invoice2,Invoice3...each table has unique field "voucherNo.", On the startup page i would like to have 1 field where users could enter voucher number and hit Find button.it would take them to appropriate layout.invoice1,2 or 3 I dont even know how simple it is?but i am stuck here.Can anybody help me please in this matter. Thank you ATLEAST LET ME KNOW IF ITS POSSIBLE

I have a layout called "Assets" where I would like to insert a portal. The portal information is coming from another table called "Service". However, the data that I would like to see in this portal is only the data that relates to the asset record that is displayed or searched on. For an example: Laptop 13 is an asset, so when I select laptop 13 from the "Asset Table", I want to see all the data that is associated with that laptop. That part I have manage to complete using fields. In addition to that information I wanted a portal that would show all of the service tickets that pertains to laptop 13. Instead of the portal I have created where it is showing "al…

Hello, I have an omit view issue after filemaker 10 upgrade. For a large found set that's a couple of pages long, when I omit a line in the middle found set (let's say on the second or third page of the found set) it bumps the cursor to the next line and pushes the cursor to the bottom of the view window, which make it hard to follow where i was. I've sorted the found set before doing the omit record. And this only happen when I omit something where the scroll bar is not on the top. Please advise. Thank you very much, Jeanny

Hi.. I'm new to FM. How do I replace ^p with carriage return in a field? I tried Find mode or Find/Replace, but no dice. Thanks...

I am looking for suggestions for creating a way for Users can “mark” records and save those groupings over time. I have a client who wants to be able to mark groups of records, and add individual records in easily retrievable found sets. Sort of like the way FMP 10 can save finds, but this would be more similar to saving found sets, and updating them. Currently they have simple checkboxes to mark records which they check and then clear, as needed. They have to let the office know when they are using the mark records checks and can only have one User marking records at a time. They have 4 such checkboxes, but in reality, they would like each User to be able to mark up to 1…

Hi! and Happy new year! I have a simple question but I didn't find my answer here. (and anywhere). My records have adress fields: Name,Company, City, Adress, Zip code, Telephon No., Fax no. etc. If I create a new record I start fill the form with Company field, so there is a drop-down list and I can choose a company that already in my database. I want to FM autmatically fill other fields from an exsisting record wich contians the chosen company. How can I solve this?

can i create pop up menu for navigating from one layout to other layout? if yes then how? please Reply with example.

I just need to get the value (price) of a field for an invoice. The pricelist obviously changes, but i want each invoice to keep the value from when it was created, not update when the pricelist is updated. Please help. John (Chase)

I would like to create a script that looks through all of my fields and lists any records that contain a particular word. I can do it manually of course by typing that word into a new find request but that is cumbersome. Is there a way to paste a word from the clipboard into the new find request? Or something like that? Thanks, Orlando

Hi, I need help creating a simple script which I have no idea how to dispute my efforts of searching through the forums. The database I'm made has only 1 table. Field A contains a list of Last Names. Field B contains a list of First Names. Field C contains a list of Last Names then First Name separated by a space. I need a script that takes value from field C and searches records matching Both A & B fields, or at least find matching records for Field A. Any help is appreciated, if anyone could make a sample document of this so I can see how it works it would be wonderful.

Hi Guys, At the moment I can save finds in fm 10 which is a great feature. The only problem I have is I would like to share that find with other users on our network who all log in with different account names through active directory. Does anyone know if I can programmatically do this through scriptmaker (i.e. allow saved finds to be accessed by other members in the same active directory group)

how can i prevent creating duplicate record when multiple fields are match such as first name,last name,date of birth,father name while primary key is different?

I couldn't seem to find any topics that already addressed so sorry if I'm repeating a topic. Just a quick question, I have a portal with several records and I tried to make a script to filer those records and it didn't seem to ever return any results. Then, I tried doing this manually with the find button and still perpetually receive the no records message. So is it possible to perform a find inside a portal? If so what is the best way of doing so and can I automate it using a script?

Hello！ How to design a multi-level menu with FM 10? There are 3 fields:"company","product type","product series",I want it work like this:if you select/type a company name in the "company" field there will list the product type related to the selected company in the "product type" filed,then select a "product type" there will list the "product series" which related to both selected company and product type in the "product series"filed. The Filemaker can do it?HOW? Thank you!

Hello, I am new to this forum. I was reading through the posts here, which is the forum that is appropriate for my question, and was not able to find an answer to my problem. I have a Client Table and an Address Table, (the Address Table related to the Client Table by the ClientID) In my Client Table I want to create a field which contains various search criteria, one of them being the addresses. The way I went about it was to create a calculated field with the List Function that lists all the addresses related to the client. However, this calculated field would be unstored because the referenced field is from a related table. This would make my s…

I have a flat file table and I'm looping thru each record and creating new records in a child table. As I'm looping thru in order to create the child record I use a New Window command, Goto Layout, Set my fields, Commit record and then close the window. But what I'm finding is that I'm getting duplicate records in my child table. The looping seems to go thru ok part of the way but then for some reason it will go back some records and start over. I'm not sure why I'm losing the pointer in my parent table. I'm thinking it has something to do with the New Window command. Any ideas? Dom

Hello. I have recently started developing databases in Filemaker after using MS Access (advanced user). Although this platform is MUCH better I am still a little stuck on how to navigate around my database (I am not a fan of the standard Filemaker menus). In Access I used to use a drop down menu to select a record i.e. you click on the field, a drop down menu appears and you click on the record you want to view and it brings up the info. I have spent HOURS trying to figure out how I can do this in Filemaker with no luck - I am probably missing something simple. Can someone please help me? Thanks. PS if it involves a script please remember I am completely ne…

Hello guys, Anyone know any good tricks/techniques in storing find requests (which could be criteria based on related tables), so users can call those foundsets up in the future? I know FM 10 provides this sort of functionality natively, but anyone knowhow easy it is to script in v9? Thanks Jalz

Help me! I am ready to jump off a bridge on something very basic, at least it should be.... I want to get a count records based on two tear criteria, my scipt works great but when I do a find and there is nothing to find, it pops me out of my script loop. How do I ignore the find error of "no records match this set of Find Requests" Two data bases related by school, storing count in the "school" table and counting the SE._Case_..... Here is my script: Go to Layout [ “School Data” (schools) ] Go to Record/Request/Page [ First ] Loop Copy [ schools::schoolName ] [ Select ] Go to Layout [ “Student Information Entry Page ” (S.E._Case_D…

Is there a way to have a script insert text into a certain field that is blank? I need the script to find all records that have this field blank and then insert a value into the field. Is it possible?

I am trying create a script that does the following performs a find based on my criteria sorts records based on 'qty sold' then exports only the first 5 records to a csv file. I have scripted the find, sorted based on 'qty sold' and the export to a file. The only bit I don't know how to do is constrain the found set to only the top 5 records. Any help would be appreciated. thanks

I need to find all records with duplicated values of a field within a found set. When I use the '!' value and 'constrain' the found set, FM applies the '!' on the entire set of records, not just on those records in the found set. So I get a much larger set of records than I expect.And records that do not meet the criteria I was hoping for. How does one find duplicated values of a field within a found set? TIA

Hello, I've run into a frustrating problem. I have a custom dialog box which appears in my script and the user inputs a certain year. What I want to do is then perform a find on a date field and just keep the records that have the same year as was inputted by the user. I what to have the set the satisfies the calculation Year(dateField)=input However, the find function does not seem to let me do this... Thank you in advance. Ryan

Attached is snippet my code If I use Delete All command.... Its deleting other records not in foundset ? So i put it in a loop Why am i exiting loop after 2 deletes not loop Enter find set field Perform find Get foundcount >0 # comment it is about 100 Go to first record Loop delete record Goto Next record Skip if LAST Endloop

I had the idea of providing the user with a list of search symbols in find mode, even when the FM status area is hidden. For that purpose I added a field "Search Symbols" with a drop-down value list such as: = == ! < * etc. When entering a field in Find Mode, a triggered script memorizes the field name and content. A second trigger acts upon choosing a search symbol in the Search Symbols field, and inserts into the field the user was in prior (including prior content). This works nicely, except that I get a field validation warning for the Search Symbol field for some symbols. While a * is a valid search criteria on its own, < is not, and …

Search returns wrong results when running in server/client environment. No problems in stand alone. I have two related tables: Items(ID,...) and Transactions(ItemID, Date, Quantity). I want to compute the total quantity of transactions of an item before a specific date. So I add a global in Items (gEndDate) and add another relationship Transactions_OnDate where ID=ItemID AND gEndDate >=Date I then add a calculated field in Items Qty_OnDate = Sum(Transactions_OnDate::Quantity. Everything works perfectly. I see correct records in both portals. I am also able to search in the calculated field Qty_OnDate. BUT when I move the database to server, porta…

I have 2 tables that are related via a number field[CSID]. One is on a costing layout, the other on a quote layout. I have created a script, that IF a quote is required, then a New Record{quote} is generated, and the [CSID] from the Costing layout is copied and pasted into the Quote layout [CSID]field. The script also copies the New Record[QTquoteID] that was generated, and pastes it into the Costing layout[CSquoteID]. All is well with that. However, i want to create a script for the user to run, to be able to navigate from the Costing layout, to the related Quote layout. I have tried a variety of different methods of Find etc, but cannot get the correct…

I have this tipology of Find.. the first show that ID 16 is composed by ID 17 and ID 28 and 12. But the ID 17 is composed by ID 18 and 12 and... But the IB 18 is composed by ID 12 and ID 10... OK, I would like to create the list (or label) with single weight assembled without repetition name.. how can do that? andy

Hi, Hope someone can help. I want to customise the Task Manager template that comes as part of FMPro 10. But first I want to be able to find tasks with an open status and a due date, between and including "Date A" and "Date B". I have read some previous post but I still don't understand how to do this. Do I need to setup new global fields or can I work with the fields that template already has. Until I can find out how to do this it is not feasible to proceed with other changes as this is the make or break script, so any help I can get would be great. And yes i am new to scripting. Thanks in advance for any help anyone can offer

A Custom Dialog allows user input for "Initial Date" & "Final Date". These 2 dates are stored. I would like to create a script that uses a date range in order to find all invoices within that specified range by the user through the Custom Dialog variable # 1 & variable # 2. Nevertheless the Perfom Find [] within the script doesn't allow "Date" to use the stored value in those two variables (it is expecting a "valid" date and not the name of another date variable name). Any suggestions? How can you use the range specified by the user in the Custom Dialog in order to perform the find ? Thanks!

Hi all, I'm trying to defint the values of one drop down field by the selection made in the first drop down field. e.g. 1st drop down: course name, 2nd drop down: course starting date When choosing a certain course in the 1st, I'd like the second value list to only include the starting dates that pertain to that course (since the course could be offered multiple times, it's ok to have multiple starting dates in the 2nd drop down, but I want to eliminate dates from 'other' course names) thanks for your help, Mat

Hi. I have a database that has two tables. The first being the client list itself, and a second being of their visits to a store. Clients have between 0 and many visits recorded in the second table and they are related. When I go to a related record from the client table and there are 1 or more visit records then I can get an accurate count, but if there are no visit records then I get a return FoundCount of the number of client records. I have been experimenting with errorcodes and the like to try and establish how I can accurately detect zero visit records, but with no luck. Anybody got a suggestion please? Greg

Problem: If you perform a script with a "Perform Find" command and it does not find any records, FileMaker will return the message "No records match this request. (Cancel, Continue, Modify Find)." I would like to customize this. Instead of: "No records match this request. (Cancel, Continue, Modify Find)." Can I have a custom dialog pop up and say "No records match this request" but with only one button that will say "continue". When the continue button is pressed my script will resume which puts me into browse mode. Any thoughts? Thanks for your help. Greg I

Ok, this is basic. It'S starting from a layout displaying a selected event, from events table and that has a portal showing contacts you can assign to this event. As the contacts table is pretty big, I need a search field to filter them. I tried google-like search filter from: http://filemakerinspirations.com/2009/01/google-like-search-through-relationship-filtering/ but didn't like the way it works, as it will not find parts of words. For example, if I am searching for "Marc", the entries containing "Jean-Marc" will not show in the portal (Yet if you search for "Jean", it will work.) And when you search for multiple words (like a full name) it gives unexpected …

Hi all. I have a simple radio button set with two values, "Confirmed" and "Not confirmed", without the quotes. When I search by "Not confirmed" the results are as expected. However searching by "Confirmed" produces the results for both of those values, obviously Filemaker thinks it's not a literal search and just tries to find a match somewhere in the field which is not what I want. Short of changing those values to different things is there anything one could to to alter the search behavior for this specific case?

I encountered a problem recently for a genealogy database that I'm developing. As an example, if I am to search for 1B's downlines (you can see on the illustration pic that I attached), I'm looking for a way to find all the "A" downlines strictly following the left connection (encircled) which should give a result like 1B->1BA->1BAA->1BAAA, etc. I'm planning to use a script for this type of search, but I came to a dead-end when I tried to solve this logic. What would be your approach to this?

When I sort a list of dates, fields with dates are at the bottom of the list, behind all the records where the date field is empty. Is there a way to sort a list so that the empty fields appear at the end of the sorted list rather than at the top??

I'm thinking this is gonna be one of those.."I was dumb not to think of that" type of moments. What I'm trying to do (if possible) is go to a record based on the result selected in a drop down box. I'll set the scene: On my clients form, in the header, I have a drop down box which has a list of my clients. When the user selects a client from the box I want it to show that record. I can do this easily through a Find script but I don't want to filter, I just want to go to the appropriate record. I thought it was going to be a using something like Go To Record... but doesn't seem to be right. Any help will be cool. Thanks

I imagine this is FM101, but here goes. The following scripted find works if I use "=" (but with different effect, of course), but when I use "≠", I get unexpected results (I get records with two fields that both are equal and not equal.) Doesn't work as expected (I'm trying to end up with a found set of records where the value of two fields match): fieldA and fieldB are number fields. Perform Find [Restore] [Find all records with a non-null value for fieldA - this step works] Go to Record… [First] Loop If [table::fieldA ≠ table::fieldB] Omit Record End if Got to Record… [Next; Exit after last] End Loop Thanks, Ken

This is difficult to describe and perhaps difficult to answer in a forum, but I'll give it a go. I have a complex database that collects information on medication use in a hospital. Each occurence of a medication is its own record in the drug table and is associated with a patient and a date. Everyday that that medication is active for that patient will generate a new record. I generate charts of specific medication use. To do this I have a global check box field with all medications of interest and global fields to create a date range. The check box field is related to the medication field and via a relationship will generate a chart of only the checked medications in t…

I wasn't quite sure which sub-forum this would go into so my choice was quite arbitrary. I've had a problem with this for a long time and haven't heard from anyone despite searching the forums and google. The issue is when manually performing a calculated replace on a field with over thousands of records. The little status window pops up and starts counting down how many records are left and too often it does the replace on the first 500 then just stall until cancel is clicked. Many times this forced me to omit 500 records a time and do the replace in batches, pretty annoying. 500 is the magical number of records which are processed before it stalls. Sometimes i…

Item: I have a tab delimited list with a single parameter. I need to assemble a FileMaker found set from this data. Currently, I'm converting the file and running a looping script, etc. etc. My solution is too convoluted and clunky. Any help would be greatly appreciated.

Well I've gone through a lot of the topics in the Find subforum and can't seem to find what I'm looking for. My problem is in 2 parts. The first is the locating of the right records: I come from an Access background so excuss some of my terms if they're wrong. I'm still trying to get my head around how things wrong on the "greener" side : I have a layout for staff which is just simply their ID and their name. Under this I have a portal based on a Shift table (fields are Shift ID, client name, staff name, start etc) What I would like to do is a staff member tells us what shifts they would like to do based on the shift ID. We then go to that staff memb…

I have user who entered SSN numbers inside a paragraph style text field. I need a way to find and remove the SSN numbers. I can find them all by doing a find on (###-##-####). But now how can i do a replace or delete on just that text within the paragraph?

Hi ! I'm using found set to find records after todays date and then I want to remove the duplicate records of the namecode (unique value in the related table but not in the main search table) with either omit !(duplicate) records or a similar request with using constrained set. Both times it removes ALL of the duplicates without even leaving one instance. There must be an easy way to do this without creating calculations or complicated combinations of relationships... nO? [color:blue]more detail: 2 tables...list of events with dates including the name code date, time, place, namecode etc. other table.. is a profile of the namecode of a band (o…

Hi, I'm performing a search on an unindexed field and it takes forever ... it has improved a little bit after I included a "replace field contents" script step before, so the search is done in a numeric field. Still it's slow ... I'm sure this topic has been treated here before, that I didn't find much info. Are there any tips or workarounds for performing finds in unindexed fields? Any help would be greatly appreciated, thanks!

I'm looking for a method of turning a field into what I call a 'type ahead' field. I'm creating an invoicing system and we're converting a user over from Quickbooks (for many reasons, including multi-user). One of the things that the client wants is the ability to type into either the part number field and/or description field during invoice entry and have the system start to create smart matches, similar to the way that Spotlight will start to filter search results more with each character entered. Not sure where I would place the results. In Quickbooks, it keeps it right in the same field with an arrow beside it to allow the user to see a drop down. Is this p…

I am currently using filemaker to track appointment and results for our company. I have come across a problem when I add a second appointment. Filemaker generates an ID for each customer and we make an appointment for them. When we need to set a second appointment for the same customer, we enter the information on the same record for that customer/ID # as "appointment 2". The problem occurs when we need to do a search for the appointments within a given time period for our schedule. Because the fields have two different names (appt 1 and appt 2), we have to specify in which field we are searching, which eliminates the appointments in the other field. Is th…

Hey everyone, I apologize if something like this has been asked before, but I haven't found anything using the search function. Here's the scenario: We import records of software installed on computers owned by our college (collected via RemoteDesktop) into a table in the database. We want to keep a reference list of some sort that labels a particular software as "important" and that it should come up in our reports/portals. Basically, the simple description is that we want reports and portals to "check" the list and see if a software is marked as important, and if so, show it in the report/portal, otherwise not. I'm posting because I'm looking for advice on …

First let me say that I am using FM Dev 6. I have 40 fields that collect data on an individual. Is there a method to return only data entered into any of these 40 fields and ignore the fields that are empty? so, I have folks searching for individuals based on some search criteria. The search completes and then users are forwarded to a layout. that layout currently has all 40 fields on it. Typically, there are only 3 or 4 of the possible 40 that have any data in them. I'd like to be able to only see the fields that have data in them without having to place all 40 fields in a layout. so, the search result would bring a name and a list of attributes…

I have a database of manta rays with 290 individuals, all with unique ID's. Each individual has multiple photos in a "child" table showing various attributes of that animal. The photos are identified as primary or secondary. Each individual has one primary photo (the best photo) and multiple secondary photos. I would like the parent layout to show the individual ID and ONLY the primary photo. Would I need to script this or can it be done with an "if then" calculation (if photo status = primary, then...)? Because of the parent-child relationship, I'm not sure how to do this. This layout will be used to match new manta ray photos to the catalog.

Hi there I am having a problem with this report I am trying to generate. From the table supplied, I am trying to produce a single list as supplied: Screen 1 Screen 2 I am thinking with some scripting and variables I can achieve this. Thanks, Mika

I have what I thought was a simple scripted find to implement. But after trying about nine different combinations of Find/Omit/Constrain -- and then reading 100 topics here -- I've come up empty handed. Here's a summary: I pass the script a parameter with the Test Type request. The script just needs to locate all of those (Table::TestType = $$Type) entries that haven't been marked Result=X. Table::Result field is a text field that normally holds either a word or a number -- or "X" if the test is invalid. If I find the Test Type first, I can't constrain for "result not equal to X" because that's not a comparison choice. If I find Result=X and then s…

I have a formula to count total records and show the one record I am using-- "Total Records " & Status(CurrentRecordCount) & "¶" & Status(CurrentRecordNumber) & " of " & Status(CurrentFoundCount) I there a way to display the number of found records? Thanks in advance.

Hi all, This seems like an easy thing to do, but I just can't seem to script it correctly. What I have: --a drop-down global field called USER, containing a list of users from another table. --a list of records with different USERS in the table ENTRIES. I just want to choose a user from the drop-down list, click a find script, and that user's entries only are shown. I tried to script it so it copies from the global field, goes to find mode, pastes into the correct field and performs search -- can't get it to work. appreciate your tips!

Hi, I am very new to FM, so please be gentle on me if I post in the wrong category. I just bought FM 10 advanced for windows. Developed a database for Miniature figurines, now I like to add a - search field -, like a drop-down list with a - go - button next to it. The user either select pre defined words or can edit his own word. Then he clicks on the go button and the results are shown. If there is a script somewhere I would be very happy.

Whenever I try to search for an email address and put in the full email address with the @ symbol it comes up with no records found. when i do a search in the same email field of everything before the @ symbol it finds the record. Why cant i search for full email addresses in this field? how do i fix it . please help thanks so much.

ok, so, i'm trying to create a simple field that will show the number of found records when the user is filtering in find mode. basically, i just want to recreate what filemaker already has showing in the top menu bar...like this: but when i do it....it comes out like this.... what could i be doing wrong?

Hi All, I am performing a find in a script with error capture on to display a custom message depending on the results. When no results are found, how can I restore the found set instead of displaying zero results or showing all records? Thanks

Hi all. I am looking for a dynamic teqnique for allowing the user to enter a find criteria in a global field and have a script then search all fields on the current layout. Can anyone point me in the right direction? Thanks

On each of my tables I have a 'LastUser' field that should show the name of the last person to modify a record on that table. How do I get the name of the last user who has modified that record to be written automatically into that field? Can't find this in any of the documentation or google, but it must be a standard operation for most tables!

I've just started using FM again, this is probably a simple question! I have two tables one is called "Sellers" the other "Buyers". When I add a seller to the DB I would like to perform a search so that any matching Buyers will pop up. There will be two fields, both need to match, the fields are: Aircraft Manufacturer Aircraft Model Any advice will be greatly appreciated :thumbup:

Greetings, I am using FMP10adv on Windows Server 2003. I have a field containing one or more of the following characters: SMFOICVPHX (but only one of each), so a particular field could contain S or SM or MS or FM or FMSO or any combination. I am writing a script fed by checkboxes on a layout to search for all fields containing a character selected by the user. If I manually go into Find Mode and enter *M* it will find all the correct records. ... but trying to script it as follows (after entering find mode): Set Field[Table::Field;"*" & LeftValues($values;1)& "*"] (where the LeftValues($values;1) pulls the M out of the checkbox…

Was reading the forums about conditional dropdown lists and started playing with it. It appears I have it working correctly. Now I want the following - when I find the record in the last dropdown list, click a button to go to that record. The database is simply several policies relating to different subjects in a company. The problem as it stands is when I click go to record it changes the title of the record. I've attached the db for clarity. Copy__2__of__Help_Guide.zip

I have two tables: Projects and Outcomes. A Project can produce multiple Outcomes. When an Outcome record is created, users specify the "Mother Project" through a dropdown populated with values from the Project Number field in the Projects table. I want to create a button in the Projects table that finds and shows Outcome records with the Mother Project value that is the Project Number of the Project record they are currently viewing. Can someone help me? I'm a complete FileMaker neophyte...

Hi -- I have adopted a technique for "boolean fields". It entails the following ... make the field a Number (that can accept nulls) ... create a value list that has a single value of "1" (I usually call the Value List a Switch) ... and use the checkbox as the display type in layouts. I am sure you have all done and seen it. My question is how can you make the negative (null) value easily "queryable thru Find" on a ListView (for users)? --Rich

Hi all, i'm looking to create a pricing tool and im not sure how to make it work. Basically I need to price windows, but there are say 100 styles, each with a price 'grid' (i.e - a price for 400mm x 400mm, a price for 400mm x 500mm etc etc - there can be up to 200 different prices per style). I'd like to have this data arranged in a kind of grid, and then be able to lookup the values in that table from another part of the database. So, i can enter "Style 2" for example, then use dropdowns to set my width and height, and the data will come back with the correct price for that particular size, in that particular style. Anyone got any ideas? I'm stumped.

I have filemaker Pro Advanced 8.5 for the mac on OSX Leopard. I would like to know how to make it so my numerical search automatically does a wildcard search for any files that contain the number set I enter. For instance, if I want to search for Item # 345 and I do a search in the "Job" field for 345, I want it to show me all the records that contain 345. I want it to display 345.5, 2345, 21 345 (with the space). Some of my job numbers have notes referring to the old quote like "09.345.6 (see also 08.456)" Right now I have to do *345* to accomplish what I want. Please forgive this basic question -- Steven

My job is that I count a keyword in the file maker database. I created a database file(a template), and I put some news articles in my database file So, do you know(or let me know) How can I count a keyword(e.g.: "Food" "storage") and a group word(e.g.: "Food storage") in the filemaker software? I really need to know the function (counting a word or a phrase) I used the "Find" function the function only shows me that how many news articles include "Food" keyword. But, it can not show that how many times "Food" keyword include (or is counted) in each news article and whole news articles(a month or a year amount) I made a script for counti…

Howdy, all: I have a solution but just can't get the Constrain Found Set to function the way I want it to. Here's the scenario: Two related tables: Main and Costs In the first part of the script, it jumps from Main to Costs to perform a find for all the records within a user-defined date range (for the field, Date.) I encoded a simple Enter Find Mode--Set Field--Perform Find set-up and it finds 10 out of 15 records within the entered date range. Cool. A few lines later in the script, the user selects a cost category from the Main::Cost_Cost_Category field. The script then jumps to the Costs table where Constrain Found Set will look through the 10 found…

Basically... I set up a Find mode Set field clientname using the isEmpty(clientname) Perform Find Results is i still get all records? HOW would I remove all records with a certain field is blank?

I have a search set up that looks through a number of fields. You can select data for each of these fields and then through the script steps enter find mode, set field and perform find it performs a find that meets all of the criteria set. This works fine however I wish to amend this search because two of the fields data is entered by check boxes and so can have multiple search criteria. For these fields I want the search to be able to do the search so it looks for each of the possible entries in the field. At the moment the search looks for record that match exactly the search request for these fields (ie multiple possibilities) and not any of the possibilities. Is …

Hello all, I cant seem to find a solution for my problem though I have RTFM'ed for a couple days. I have two databases with two groups of customers. I want to be able to search by name through both groups of customers. Is there a way to do this with filemaker relationships? Also it would be good if the results would also tell which database the customer is in. Thank you. Jeremiah

What is the best practice method for creating unlimited search tags in a database? The only method I can think of would involve a portal. A tag, in the sense that I mean it, would let the user organize contacts around keywords that make sense to them. For example, the user could add a tag called “Lead” and then tag everyone who’s a lead as “Lead”. Clicking on the Lead tag would then list everyone who has been tagged Lead. Other tag examples include “Vendor” or “Press” or “Client” or “Investor” or whatever else they’d like. Other database systems offer this feature, such as the web based CRM Highrise. This is a very powerful search method.

I wonder if it has to do with my layout changing or my criteria referring to a different, yet related table. My script goes like this: Go to Layout ["Specific Week Attendance" (tblStudents)] Set Zoom Level [150%] Enter Find Mode [Pause] Set Field [tblAttendance::dateWeekEnding[8/21/2009]] Constrain Found Set [] this is a script that is performed after a "manual" / "user input find" searching for a student by last name in the "tblStudents". The tables: "tblStudents" and "tblAttendance" have a relationship by unique index key. What it returns is the accumulated hours for each weekday of all related records, not constraining by the "weekEnding…

I have a database from which I produce a number of summary reports. Because of the dynamic nature of these reports I can perform finds based on various selected parameters and then the reports reflect summaries based on the found set. However... When viewing a summary report, one has no way of knowing what the last find request was that the report was based on (unless one carried out the find personally of course). What I want to know is if there is a function such as (for example) "Get(LastFindParameter)" that I could then append the report title with to indicate what parameter the report is based on? For example I have a report titled "Summary Sessio…

I have a script which performs a find by using the three steps Enter Find Mode Set Field Perform Find I would like to be able to perform a further search on this data but when I do this it does a search on all of the data rather than just the previous search results. Is there a way to tell the search to just search the results of the previous search. Many thanks John

Hi, I'm trying to write a script which removes a specified item from a found set, ie. the found set contains 1 2 The user specifies '1' as the item to remove, now the found set just contains 2 I can do this 'manually' - enter find mode put '1' in the relevant field select omit constrain found set But I don't seem to be able to do it in a script since I can't put a field value (my input field) into the constrain found set dialogue box, and if I just set that box to be 'omit' with nothing in 'omit records when', nothing happens. This feels like one of those things that should be easy but involves some kind of trick. Anyone c…

Hi everyone. I have a simple problem I'm not able to solve, due to my lack of experience... I have a layout showing the records of a table, called ITEMS. This table is related to another table called COMMENTS, through a field called ItemID on both the tables. What i'm trying to do is browse the ITEMS layout, and find the item I'm interested to. Once there, with a button and a script, I wish the program to open the COMMENTS layout, showing only the comments related to the ITEMS record shown when I pushed the button. Not so difficult, is it? But I lost the way with parameters, variables, global fields and so forth. The result I got is this: push…

... I just don't see it.... I have a field called Symbol In this field there are these records: GLD, GRD, etc... When I search for duplicates, if the user has typed a 'g' in the field and then the script does a FIND, it returns all fields that start with 'g'. I want it to return just fields that are identical to the search field; ie, 'g'. How do I do that? THanks

Just recently, I now have a problem with my database where the found set will revert to all the records when I close it and open it back up again. The weird part is that the last time I worked on the database it was not doing this. I've tried to retrace my steps (e.g. undoing some things I added today), and checked everything I can think of (e.g. I disabled the startup script), and nothing seems to help. Here's an overview of the database: - It stores the title, composer, lyrics, etc. to music that are sung at church services, so that the music committee can search the text, keep track of what has been sung, etc. - There is a menu view that launches the other scr…

Why are Saved Finds and the Saved Find menu greyed out and unavailable in a Edit Only filemaker privilege set? Darren Burgess

Hi, I am using show custom dialogue option to take user input.in the user input three input are there 1.From Date 2.To Date 3.Text Field is there. I want to know that it's possible to show drop down calender in the custom dialogue box to take user input and drop down for text field so that value is coming from database table. Plz Tell Me.