Finding & Searching

I am being asked to run a report/list that has all job code=2358 that are active or inactive. If there is more than 1 “2358” job table row, then please pull the last 2358 row. I have a list… but it’s incorrect Jane Smith is fine Bob Smith pulled but the wrong row displays Joe Bing displays the 1st row. And Pat Chauncey is correct by not showing Thank you for any guidance FIND2358.fp7.zip

Hope I'm in the right forum, couldn't tell which one is appropriate. Also I'm sure this very basic question has been answered before but I can't find it. Since upgrading to a more recent version of FM, I seem to have lost the ability to have semi- or partially-sorted records. If I edit a record in a field that is one of the sort criteria, the record goes shooting off to a new place in the found set and I lose my place. Older FM left the record where it was in the sort order and changed the found set from "Sorted" to "Semi-sorted". Both ways have advantages, ergonomically speaking. Is there a way for me to choose which way FM does this?

Created a layout to display a complete record pulled from different MySQL tables with no problem only for one table. The relation is a one-to-many and no matter what I tried scripts, searches with AND in record searching I cannot pull the correct record. Each of my products is associated with one, two, three or more categories. One of these categories is marked as "Main Category" and has a "Y" it the field "Main". I only one to display the main category in my layout (I am using it as a header to have together in the same category all the related products) for each of the record being displayed. So we have: Products Table with a unique Product_ID and Product…

I'll try to describe my issue as concisely as possible. I have invoices that I want to try and extract some sales data from without a bunch of Excel manipulation if possible. Basically we have a sales order that we turn into an invoice once an order has shipped. The invoice includes qty, item number, description and price and is 16 lines long. I want to be able to take a subset by invoice date and then be able to see how many of each item that that we have sold during that date range sorted by item number. I am kind of a newbie, but not afraid to try with a little advice or direction. What I have been doing in the past is extracting the data into excel and th…

I am currently creating a database which is used to create quiz questions. I would want to select 10 random questions from the database each time. Though these quiz sessions are unlikely to be very frequent, I would want this to function in a way that every time I open the database different questions need to be selected (I understand that 1 or 2 repetitions are inevitable) The problem that I am facing is that I unable to create random selections quiz questions Currently I am using a script as mentioned below Randomfield (number) in the database And have used the script Go to Layout Replace field contents(No dialog; table name::Randomfield; Random) Omi…

Get(LastError)=401 vs Get(FoundCount)=0 Is there any advantage/disadvantage to using either of these, when scripting and checking if a find returns no matching records? (Obviously I always test for the last error immediately after the find.) Could either ever be tripped up and give a wrong result? I've been using FM since the early days and have always tested against error 401, but in recent months I've started to convert a system and in new scipts I've been erring towards get(foundcount), perhaps for readability... (This particular system I'm working on is v11, and will be upgraded to v12 next year.)

First, if it makes a difference, I work for a law firm. Technology has always been a backburner item so this particular need has not previously existed (at least not here). We have a process called a "lit hold" which I'll outline below. Lit hold process begins, a notification of which client is affected and what attorneys have worked on that client is distributed. An attorney affected by lit hold leaves the firm, their computer must be retained for review (rather than get reimaged or disposed of). Any attorney still working for the firm keeps their computer, only the terminations affected by lit hold need to be retained. (current process) I get the termination no…

Hello I am trying to achieve the following I need to disable the find mode on a particular layout. I need to stop people entering find mode with any method except for a button which runs a script I can't lock the status area as they need the omit box This is because I have two identical layouts one for editing and one for find - the find layout only works with custom buttons (and the omit box) I have looked on privilege sets and can see no option for making a layout edit only and the custom menus seem to apply to all layouts Any suggestions greatfully rec'd

Hello Board! I am importing a CSV file into a table. 3 fields - JobNo, Quantity, ProductCode. Every night the CSV is pulled from Sage and I need to import it into Filemaker, to add new records that are not already in the db into the table. When I import, it duplicates all the records. I've tried doing a Find for (!) but it returns both the original record and also the duplicated one. I thought I could do that search and then Delete The Found Set, but that destroys the table. Does the Script need to be a lot more complicated? Which way should I go with it? Am I missing a 'Do Not Import Duplicates' check box or something? I'd rather build …

Hi: Is there any alternative way (fewer steps) to execute the following find procedures: 1) Multiple criteria in a single field: Example: I want to find the following order #'s on a database: 8302715/830271/8303731 As far as I understand, the way to do it (Windows) is "Ctrl+F 8302715 Ctrl+N 830271 Ctrl+N 8303731 Enter" In the program I used before (Approach) It can be done as follows: "Ctrl+F 8302715, 8302717, 8303731 Enter" (entering the different find criterias at once, separated by a comma) 2) Find records corresponding to certain criteria in a field, omitting fields corresponding to another criteria in a different field. Finding sales in 2010, …

I am sure there is some simple thing I have overlooked. I have a scripted find which works as I want up to the final step at which point the following screen appears: So I have to manually click "perform find". I want/need this script to run to conclusion without my input - what am I missing?

Following a scripted Find, I need to build a variable with a simple "concatenated" list of found IDs. I thought List(Table::RecordID) was the answer, but all I get is the first ID ... not the CR-delimited series of IDs. The Help file hasn't helped me on this one. Thanks in advance for any assistance.

ok, i'm not exactly a noob when it comes to filemaker, but this one is throwing me a curve ball. i've got a fairly massive database. roughly 12k records and quite a few fields. i'm switching the entire database over from MS Access to Filemaker. it's be a year long project to get this thing ready before i roll it out to the company. now, i'm very very close to finishing and so i decided to load all of the actual data in from access and everything worked perfectly. but here's the downside....when i search, it takes (very literally) about 1 and a half minutes to come up with a result. now, ms access doesn't take but a split second to search the same data. so, am i do…

I have a script that goes to one of my tables, creates a new record, inserts the correct record ID then switches back to the first layout to view/input items. My problem is that when it switches back to the first layout it shows all records created and not the record I just created, is there a good find function to help me resolve this? Thanks Matt

Hi, I have a contacts database and I am just trying to copy some information a field of a record and paste it somewhere else. Somehow the copy (both by Ctrl + V and from the drop down Edit menu) did not pick up the copied information and paste is not available. I tried cut, but it still would not paste, even though the information is cut from the field. Any help on this issue is greatly appreciated. The issue seems specific to FileMaker on only one of our clients: In FileMaker, I tried copy from one field and paste in another field - Didn't paste; I tried copy from one field and paste in another software (Word) - Didn't paste; I tried copy random text f…

Hello all, I've got a record with about 100 fields that I would like to save to a pdf and then to have printed. But before saving and printing I would like to replace all the empty edit fields with "N/A". I've done Find/Replace with "=" into the Find field. But this doesn't seem to be working...? I've tried """", but no luck with this either. What might I be doing wrong? Any guidance would be greatly appreciated.... Thanks.

Not sure how to ask. I cannot test on server. Every time in every one of my scripts, if I have performed a find and whether I have results or not, I end with show all records because I am afraid that other people when they view the table, if it is 0 found set they will freak. Or if they have a found set. If I show all records when unserved in the data file and then will it always be that way when different people first view the records or should I handle it differently? I read somewhere found sets are user specific similar to global experience different for each user. Perspective would be appreciated.

In MS Access, I can easily create query that contain the criteria and that query can be used as the data source for the table. How can I do on FM 12? 500.zip

Hello all, in my attempts to perform a simle find I have a table that has values from a lookup table (they are football play descriptions) as I am a high school football coach that are described as follows: 33 CROSS 33 TEXAS and many other similar play descriptions. when performing the find if i type in "33" all plays show up but If I type in "CROSS" I get a message stating no matching records found. In addition I have this field pointing to a related "lookup" table as a dropdown list and when I select the text "33 CROSS" from the list and perform the find I also get the message "no matching records found" I am wondering if the space betwee…

I'm sorry if i'm in a wrong subject for the topic since is the first time I write. I have a field with text, e.g. "CSSS". Each character of the string is a number acording to a code. How can I create a script to automatically convert that text into is number. example: CSSS - 1 000 BSS - 300 CLS - 150 PS: sorry for my English ;)

We are using iPads in our shipping department with FMGO 12 to prepare shipments. We would like to put QR codes (or some other type of bar code) on our boxes and have the ability to scan them with the built-in iPhone/iPad camera and have it take the user to the record in FileMaker GO. I realize that we can do this via a web browser lookup to our FileMaker Server but is there a way that we can scan the QR codes and keep the user in FileMaker GO?

So I made a "Google Search" style Search Field based on the informations I found on a FMP blog, it's all nice and dandy except for one thing. I would like that when the user enter the text in the search field instead (or in the same way) of having to go and click on the search button (which performs the search script) he could press "enter" and it would perform the search anyways, is that possible? Also, it would be cool that when the user selects the search field the text inside gets erased (at the moment I made it so it gets all selected). I tried to attach a script to the search field to achieve these two things but if I do that you can't enter text into the field…

Not sure if this is possible, but is there a way to trigger a script when the "quick find" feature is used? For example, if a user types something into quickfind, can I switch layouts?

I am using FileMaker Pro 12 and I have a main self-join MS SQL table that has four other tables related to it. Three of the four tables related to it are MS SQL tables. I need to pull data from certain fields from those tables into the main self-join table. The data that needs to be pulled are summaries based on a find. The main self-join table is related to the other four tables by a field called Project Id, and the self-join is related to the main table, where I want to show the results, by a field called Project Code. There are several Project ID records per Project Code. I want to show all the records related to the Project Code based on a find. I …

All -- Trying to do a "simple" customer find using any of 3 fields or a combination of the fields. I have not a clue, so I've tried a script linked from a button(in shorthand): Enter Find Mode Set Field First Set Field Last Set Field Custnum perform find How do I know if it finds anything and then choose the one I want and go to it I've spent 1/2 a day on this and I'm about 4 days old with FMP Help would be great - pointing me to something I can read and understand would be great. thanx, Greg

Hi, I hope someone can help. I have database that has contact info for bowlers in a bowling center. If they bowl in multiple leagues in a year, or for that matter, across multiple years, when I do a find on the email field to find all the people who have supplied an email, I may get the same email address multiple times. I know how to find duplicates, but how do you find duplicates and eliminate all but one occurence of that email address? I'm stumped. Thanks for any help you can give me. All the best, Jim

Hello everyone. Using Filemaker Pro 11 and I'm going nuts creating a simple script that looks through all 92,000 records, finds only ones with zipcodes 40502, 40503, 20202 and 21214 and shows them as a found group. My problem is creating the script to accomplish this.... Yes...it's simple but I'm getting nowhere...any help?

As I look through the posts here, looks like it's mostly developers. If I'm in the wrong place, someone let me know? I need to count things. I have a DB of hundreds of yoga poses. Ever record has, among many others, a field called 'Type'. This field is controlled by a value list. The value list is populated like this: Inversions, Forward Extensions, Back Bending, etc. What I want to know is this: how can I determine how many Inversions are in a found set? Or how many Back Bends in a different found set? I've experimented with summary functions but I am not getting anywhere. Thanks!

Hi all, I have the product table. For this I have to add multiple keywords for product. For keywords I use the another table. Now I need search the product based field keyword. Based on the keyword search, I need to show the products having the same keyword. Kindly give the solution for search based on relation table. Thanks

Hello to all, I am writing a script for a simple verification of already existing records before a new record is created. The script begins with a custom dialog asking the user to enter the date for the record being created. That input field is stored in a "Temporary" field on the current table. I then Set a local Variable with that date using the Temporary Field. It then goes to a Find Request that matches any existing records in the current table with that Date. When using the Debugger, I can see that it when the script operation reaches the Request Find step it loops back and opens the above mentioned Custom Dialog. I cannot find a reason why i…

In browse, in find, I have always been able to type any string of characters from a single character to the limit and I get results (unless there's no record with the search string). No operators needed. Now it only works a little. What I mean is this: I want to search for the string "meetup" which is in a field I use for URLs (the full value of the URL field I'm looking for is "http://www.meetup.com"). Because I wanna just search part rather than all of a URL. 'Cause I'm lazy. I enter "m", I get 56 records -none of which are the Meetup URL (!) I enter "me" I get one: https://members.cafepress.com -but no http://www.meetup.com (!!?) I enter "mee", or "meet, or…

Hope its known issue.. I have set of email id in my contact table, When i try to find the particular email id in particular field filemaker will not help.. but Quick find will find exact email id.. Please share your experience if any.. thanks in advance for your valuable time.

I’m working on an idea to use it in the whole DB. Date Range search. By now it makes the work, but the question is, Am I doing it too complicated? One Table: - Searches Two fields: - StartDate: date (global). - EndDate; date (global) . Two scripts: First: - DateRange Set Field [ Searches::StartDate ; "" ] Set Field [ Searches::EndDate ; "" ] Beep Show Custom Dialog [ Title: "Date Range"; Message: "Please set dates"; Default Button: “Accept”, Commit: “Yes” ; Input #1: Searches::StartDate , "Start Date"; Input #2: Searches::EndDate , "End Date" ] Set Variable [ $StartDate ; Value:Searches::StartDate ] Set Variable [ $EndDate ; Value…

How can I find next value in table. By example; Table: Letter Extratext A GO A GOA B ABD C DE D E D FE E FGE I wan't to filter on the Letter Field by button. Want to have to buttons, next en previous. By clicking need to have the unique value. How can I fix this ?

Hi. I have a scenario that I cannot quite resolve and would like to know if anybody can point me in the right direction please. I have a table with a list of about 500 clients and a unique ID for each. I need some of those clients hidden (by omission) to certain users (logged in) when browsing lists. Currently I have a global variable with the ID of one or more clients in it, and as the list is opened, if the variable is not empty, then it runs a loop from record 1 to n omitting each record that meets that pattern. It works OK, but as I have several ways of manipulating that list (Live Search etc), it's become a headache to ensure that omission script is run a…

OK, here's my set up. LayoutA based on tbl_Session_Ops. This records daily activity (bags of food given out). Foreign key here set to ::tbl_HH_Members:RecNo. Relationship set between the two TOs using RecNo. Portal set to ::tbl_HH_Members which has field_LastName and field_FirstName along with RecNo as primary key using auto-enter serial no. I have a design which drops-down ::HH_Members:field_LastName which works. Problem is ::HH_Members:field_FirstName doesn't follow in. It's blank. I've tried a myriad of different techniques to have FirstName automatically follow the drop-down selected LastName. Probably something very simple. I'm dying to g…

Hello, I am using quick find on two of my layouts. When i have used quick find (in a pop up window - which has a fixed set of search criteria) in one layout it sorts out records in all layouts (possibly because they are both linked to the same table) But when I try to search records in another layout, it seems to remember the first search and then searches for records within this first searched group of records. Because my second layout is a search layout, I want to use a script function whereby when I go to that layout it clears all previous searches and shows me all records and I can quick find the records based on the criteria I want I am trying to redu…

I've looked through here and other places, but I'm still finding it hard to do the following: I have table with records of performing artists and their associated concerts. The fields I have are ArtistID, ConcertSeason, Artist Full Name, (and recently added Mark, Global --trying to follow instructions from a Filemaker Tutorial) Some artists perform in more than one concert in one season, but I need just a count of the number of artists who performed in a certain season-- without a repetition of their names. I've tried a few scripts, but doesn't seem to work well... Any suggestions would be greatly appreciated. I've also got another step to do after and …

My solution finds houses in neighborhoods, then through sub-summary parts it will show: Neighborhood Main street Each house Members of house I am trying to create a drop down that will reorder the Main street sub-summary through a script trigger. I have the drop down showing the proper fields. How can I sort the data so that the sub-summary fields keep the data showing correctly, but reorders the data.

This should be simple: I have a relationship: classes:className::Students:className... In the table classes it shows all classes... When I choose a class from a drop down menu, I have a script trigger that gets related record and shows me the students for the class in a new layout. I have a field that shows current grade from 0-4 (students:current grade). I tried to create a value list based on this field so that I can have a drop down menu. This will allow me to choose 2.0 for example... I want to constrain the previous find of the related records so that it only shows 2.0 or less in the same layout. Cannot figure it out... Help

Hi there, I have a field call CompanyName. When user enter data into this field, I have script that breaks the data into 4 variables. So for e.g., the user key in Bank Of America , so I have 4 var $Name1=Bank, $Name2=Of, $Name3=America and $Name4="". The problem is when the input is something like "Bank of America (NY)" and using what I did above I get $Name1=Bank, $Name2=Of, $Name3=America and $Name4=NY. The last var is puzzling because what I wanted was to also include the brackets i.e.. $Name4= (NY) instead of just "NY" Hope someone can show me how I can achieve this. Thank you so much.

Hi everybody, I am trying to find a way to work this into my script. I have a search field. (Text) When I type "Test 1"(notice that there are many spaces), I am trying to convert my text string to just "Test 1". Or when I type "Test 1 2", I hope to convert the text string to "Test 12". At first I though I could use the Trim function but apparently it didn't seem to work. Hope someone can help. Thanks.

Hi... trying to do something straight forward which is to find records between a start and end date. I did this to filter of files that are deleted i.e. deleted = 1. But when i tried to add a value from a global field named start_date and sort_date which are both date fields, and tried to do Table::Created_date < Table::sort_date for example.. it tells me i need a date field. Can i not use a variable value in a find or find supports only absolute values... like the "0" above

Hey all. I know I've read up on this somewhere before on this site, but after a search I cannot seem to find the thread(s) that described it. I am looking to have one field in a dialogue box that searches two or more separate fields. For example, my database contains movie theater projection booth data. Each time a new movie comes in the user enters the data and print numbers. I want the user to be able to enter either the movie title ("movie title") or the print number ("print number") in the search field and still be able to return the same results. If someone could point me in the correct direction I would be much obliged. Thanks!

Say, I have a file which has 1000 records in it. Is there a quick and easy way to find record numbers 500-900, for example? I could write a script that would go to record 500 then put something into a field up until 900 and then do a 'find' on this field but that all seems rather complicated. Thx.

Hi everyone, I was trying to modify the contacts starter to suit my usage... i have 3 layouts in particular, the original contacts layout, the staff layout and the class layout. All 3 are similar as i just duplicated all 3 of them and modified the scripts for it to work. However the ones i duplicated have a problem sorting with their indexes... what should be as below Became as below... no indexes... I have checked all the scripts there are in there... and have no idea why the sorting is not working properly... Please could someone help me out and see what i missed? I have attached the source files together here... http://www.chizuoka.…

Hi Lee, Here is my file please take a look to see what is wrong. Cheers Stock Journal.fmp12.zip

When my database loads it is slowed down by an info window telling me a sort is in progress. Does anyone have a suggestion how to manage this situation. I want to control the sorting and summarizing function of my database so that it is not slowing me down so much.

(Wow, I sure post a lot of 'find' problems... I wish I would 'get it') Here is another one. I have a table called Members It has these fields: PK_TypeID, Type I need to go into Members and 'find' an 'old value' ($$OldType) and then replace it with $$NewType. Here is what happens. I open a window I put a layout that shows the Members table in the window. I run script code that does this: Enter Find Mode Set field [Members::Type "="&$$OldType (I can see =Regular entered into theType field) Perform Find[] I run debug and watch as everything works until I get to Perform Find[] which finds nothing. I can see the get(foundco…

As container fields, or supercontainer, now provide abilities for filemaker to manage a significant amount of data. I'm trying to determine the feasibility of indexing the container contents to allow searching for records in which the container data matches some text or number query. The only thing I've seen that looks like it fits the bill is 360 Works Scribe. It appears to be able to read and write text contents of Word, Excel and PDF documents, which would allow the contents read into text fields to be searched. I haven't inquired as to whether this plugin could also extract text contents from other types of files (ie, Powerpoint, Visio, EXIF data from image files,…

I have a membership 'type' of Regular. I can, via script, change it to Regular#. OK. But, if I run the same script to change it back to Regular it doesn't work. The get(foundcount) is 0. Ideas? Thanks Ron

Hi I have a table of words and I want to perform a find in order to get all the words consisted of certain letters and only them. For example: The words in the table are: door, red, deer, dream, men Each word in a field called: Word I want to find all the words consisted of the letters: d, e, r and only these letters. The result of the Find should be the words: red, deer (and only these words) I tried two approaches: A. Performing a find with the following requests: Word: *d* And Word: *e* And Word: *r* The problem here is that it is not possible to perform an ‘And’ request on the same field. B. Putting each letter of a word in a field …

Greets, all: I apologize if this topic has been covered before--I searched the Scripts and Find forums but nothing turned up, so... I'm trying to find a way to not have the user press the Enter key twice when performing a scripted Find on a related field that has a drop-down list. The script, so far, is relatively straightforward: Allow User Abort [off] # Go to Field [HEALTH_RECORD_CARD::NAME] Pause/Resume Script [indefinitely] Perform Find [] Exit Script [] So the user would: Click a button to fire the script. Select a name from the drop-down list. Press Enter to set the name in the field. Press Enter again to perform the Fin…

I'm needing to clear out redundant records in a table where there is, say a Foreign Key field linked to 'People' and a Content field like, oh, "Activity" (Golf, Chess, etc.) The gist is the table 'tags' people with various activities, but there should be no duplicate tags -- we only need to know that Janice plays Chess *once* -- not several times. This seems like it should be simple, but I'm not immediately seeing it -- and I'm wondering whether there's (a) A direct way to find all such records via a Find technique that would give me a set of all records where the FK and Activity are both matching any other record. (This need just comes up in various scenario…

Yes, I know I've asked this question before. And yes, I got it working before. But, with this 'little' script, FM refuses to find all members of a field that are empty. There is a Members table. There is Members:Type which holds the membership type: 'Yearly', 'Honorary' etc. There is a field called Mem_Can which holds either 'Member' or 'Candidate' This is the script: Specifically, this is the FIND: And, this is the error: I just want to find all the 'Members' who have a blank Members:Type. (There are 48 records that meet the criteria) What am I missing? Thanks

I have a membership table. There is a field called Mem_Can that holds either "Member" or "Candidate" There is a field called TYPE which holds the membership 'type' (Life Member, year member etc) After importing records, it is possible for Type to erroneously be "" There is a calculated field called TypeIndex which calculates the numerical position of the 'Type Dropdown' list of types. It holds 2 if the chosen Type is the 2nd choice etc... If a list of Types is imported the stated Type can be wrong. In this case, the TypeIndex is 0 (zero) So, I need a way to PerformFind: Members with a Type of "" OR Members with a TypeIndex of 0 …

Hi, I am trying to write some scripts to bring users to a dedicated Find Staff layout (to be used for instant web publishing), enter Find mode, and then search for whatever the user types in the fields, perform the find, and go to the Staff List layout. However I want the user to be able to perform the find either by clicking a button, or by hitting "enter", and prevent the user from ever entering Browse mode in the Find Staff layout. The current scripts are as follows: Go to Layout ["Staff Find" (Staff)] Show All Records Enter Find Mode [Pause] The button's script: Perform Find [] Go to Layout ["Staff List" (Staff)] Sort Records [Restore; No dia…

I am new to this Filemaker What I am trying to do is match up moies names and sort out who has what One this is that file size is same for 90% Where it get's tricky for me at least is that I put my name like this The Fog (2053) How I put them The Fog (2053) Mary Jones & Harry Fonder Mate number 1 Fog The 2053 To give you an idea I have created a File and put list from Ecell to each person Fields are Person 1 Person 2 Person 3 File Size 1 File Size 2 File Size 3 File Name 1 File Name 2 File Name 3 I am gettng frustrated as to the best way to go Have 3 Find buttons for each person or …

Hi I'm trying to write a script which says: "If [ProductName] includes the word "Jacket"; .36; .15" where the numbers are the weights of packaging used in sending the garments. "Jackets" use packaging that weighs 360g. All other products use packaging that weighs 150g. I don't know how to write the "includes" bit. The word Jacket could appear at the beginning of middle or end of the Product Name. Any clues? Thank you.

I created a subset of my Members table. It holds PK_ID and Type I collect into $$PriorType the value of the PRIOR value of the selected 'Type'. I collect into $$NewType the value of the CURRENT valaue (collected on EXIT) of the 'Type' From a script, everything works as expected until I get to the Replace command: At best, I can change the first Type in the first record. Additional Types remain unchanged. I am not real clear on the optional settings on Find/Replace but I have tried all the different combinations and permutations with frustrating results. I can 'see' in debug that everything is working as expected. But, when I…

Dear all, I need to make a report that displays the repertoire performed in a certain concert series season (or some or all the seasons) according to certain parameters such as: 1) Female composers 2) Canadian composers 3) Living Composer 3) World Premiere 4) Canadian Premiere I have checkboxes for the the above--so the data is entered. But I want it to display the number of pieces that are in the found set. For example: Please display the number of repertoire performed in Season 2 that is composed by a female, the name of the work, and the concert in which it was played. Also is there any way to do this by "find" rather than making a l…

Is there any way to set or clear the text in the QuickFind in the toolbar via a script? Also is there any way to capture when a quickfind is done via custom menus (for handling of errors like 0 results)?

Is there a way to fire a trigger on a quickfind? If there's one result I want to show the records in form view, if more than one, list view and I can't figure out how to do that.

Hi ! I'm working with a student testing solution. The student gets a certain amount of questions and he has unlimited time to solve them all. When he has done them all it's time for results. But only the last 30 minutes counts. If the student have used 45 minutes to complete all the questions, only the questions answered during last 30 minutes counts. So when the final question is answered FileMaker performs CountResult -script and a Find -function. One script step goes like this: Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp ) It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when…

dear fmforum users, if you could help me, i would be very grateful. i am trying to add a find script to my database. i have a database on my pc with products. i printed labels with barcodes. i installed filemaker go on my iphone and copied my database to it. i used this script to add a SCAN button and launch a script which starts PIC2SHOP app, scans my barcode and returns it to filemaker GO. http://www.skeletonkey.com/blog/filemaker_go_barcode_scanning_with_pic2shop everything works except the last part. the scanned value has to be put in a search script and i cant find how to do this. i want to be able to scan my product and automatically find it in…

Hello I have a scripted find function using; a global showing a drop down value list based on a field (Vendor_Name), and a calc field to Set Field in Find Mode. I am wondering whether one can add another step to this script so that the value list display shows the VendorsName and those records within a specified year, in this case my Invoice_Date. So for example I might see a value list as follows: UPS 2010 UPS 2011 UPS 2012 Fedex 2011 Fedex 2012 etc.. In the Fedex case shown there are only records from 2011 and 2012. Thank you

Is there a technique or special character I can use to perform a "loose" find? i.e. Perform a find on "Randy Johnson" and find results would produce... >Randy Johnson >Amy Johnson >Dale Johnson >Dr. Johnson >Johnson's Family >Randy Travis >Randy Myers ---------------- With standard find a search on "Randy Johnson" would only result in... >Randy Johnson Any tips on this would be great! Thanks! :D

Hi everyone, complete Filemaker noob here so I apologize if this is a remarkably stupid question (which I assume it is!) I have a list of approximately 350,000 gene mutations that occur over multiple patient samples. We have a known gene, which these patients can be either positive or negative for. We are trying to find other genes that may be involved in a specific disease. I want to take a list of all of the genes that are found in the positive-gene patients, and eliminate that list of genes in the negative-gene group. I envisioned doing this by searching and greating a positive gene group, omitting the duplicate finds, and then deleting all occurrences of the…

I'm looking for a way to remove duplicate records that have an identical value in one of the fields (X) across the found set. It doesn't matter which duplicate records are omitted as I only want to use the said field (X) on a report. I only want unique records to be on display before I go to my report layout. Is there a quick clean way of doing this?

Hi, I need to be able to make a search of the People table from the Meetings table, and make the search results display in the form view of the Meeting table for referencing during data input. My database has a list of Meetings, a list of People, and the joint table that bridge Meetings with People. There is a portal in Meetings that displays the list of People present in a given meeting. The portal displays: People ID - On click, a drop-down list of People ID plus the full name of each person is displayed Full Name - Field entry disabled on Browse mode. Changes according to the People ID selected However my People table has over 3000 records, so it …

Im not sure what im doing wrong here; set error capture [on] enter find mode [] Set field [Account ::Status; "Active"] Set field [Account ::Richmond; "1"] Set field [Project ::Month January; "1"] perform find [] if [not get(foundcount)] Show custom dialog [ xxxxxxxxxx] go to layout[original layout] else go to layout[report] end if Im trying to create a script that performs a find on those 3 specific fields and only reports the records that match those 3 fields and those three fields only , Status is an edit box with the word Active in it where richmond and month january are check boxs, for some reason though only month january s…

Howdy, all: I just want to see if my logic is correct in what I want to do: Goal: to find all records in Layout/Table B using Find criteria Layout/Table A. I have a field in Layout/Table A called SerialNumber. There's also a field in Layout/Table B called SerialNumber which, as it so happens, is the field used to connect to Layout/Table A in a one-to-many relationship, i.e., A -< B. What I want to to do is take Layout/Table A's different serial numbers and find them in Layout/Table B. So, say for example you have two records in the found set for Layout/Table A: one with SerialNumber 123456 and the other 654321, and there are dozens of records in Lay…

My application is a Membership application. There is a field named: Membership::Mem_Can which holds a value of "Member" or "Candidate" In the database there are 55 Members In the database there are 8 Candidates Of the 55 members, 2 are deceased. (The DOP field has a date in it) I am trying to do a find all members who do NOT have a date in the DOP field. (They are no deceased) There are 53 members who meet this criteria. =====THE PROBLEM====== I write a script with these steps: FIND Mem_Can="Member" OMIT DOP<01/01/50 What results is a found set that shows 55 records. I am using a script LOOP that goes through the fo…

We have a field that builds its value list off of itself. When a user enters find mode, the list will display the same value, in this case 2011. How does one change the value to display 2012?

Hi all, I am trying to work with Invoices and the programs looks fine the only thing i want to change is that in the Menu -> Invoices -> Product Id. I want to add a button in the left of Products Id called "Find" and when i will insert an Id for example 3 and press the botton, i want to appear a drop-down menu to the current Line Item and show me a list of Id, Name of producst that have similar name as the name of the product that i entered. I came with an algorithm in my mind but i have never worked with FileMaker scripting and i dont know how to implement this onButtonClick { myId = take from the current selected line item the Product ID; …

Hey guys. I might not even be in the right spot. I am building an invoicing program with filemaker for my work. I have built a database where I can enter products (name description price ect...) And I have made a layout where I can enter a customer name and start entering products in the lines below. But I want to be able to scan a barcode and have the item name show up in the next field automatic. I don't even know where to begin with this. Is this a script or a function that is already built in or do I have to write it. I don't mind doing the work and learning how to do it but if someone can point me in the right direction to where I need to be looking …

I would like to make my report have a drop down menu that will select records from Today Last week Last month 6 month to today 1 year to today last year I am completely unsure how to do this. I am assuming there must be a script needed. In my database the dates are for when the invoice was charged/billed. No other dates to speak of. Would someone mind walking me through this please ? I know how to make buttons, and get them to run a script. But I don't know where to begin with the script to make the desired output / result Thanks... Brian [email protected]

I have a simple date search: global (startdate), global (enddate) and a Search script that throws that into a find on a list of records. works just fine, but the startdate and enddate global fields always retain their old values and never update. minor, but I don't want my clients to scroll months ahead to get to the current date. Maybe i'm doing the whole thing wrong, any advice? Update: I forgot to say, they do update for the search. Upon exiting filemaker and going back in, they default to old values.

My apologies if this isn't in the appropiate place in the forums, I am totally new to filemaker and I'm stumbling a bit... So here's my problem. I have a "simple" task to complete for class, creating a database to record the information of research journals (author, publication date, name of journal etc etc...) What I would like to do is have a drop-down menu (so far I know how to do it) to specify which field I want to search and an "blank" field next to it so that the user can input the information he's searching. Then while hitting enter I'd like the results to show considering the data introduced. To clarify, if I select "author" from the drop-down list…

Hi. Can someone provide some assistance please. So , heres what I am trying to do. I have several fields that contain different dates. I want to be able to find all records where that date occur for example in Jan. The year is not required part of the search. So, I have the fields: Item 1 Exprey date 01/25/2012 Item 2 Expirey date 05/31/2001 Item 3 Expirey date 01/17/1967 The script or find should ask "What month do you want to find?" User should then be able to enter a month or a range of months, eg. Jan, Feb or whatever. The scipt should then return "Exprey dates occuring in Jan (or whatever month) and then show rec…

Using FM Pro 6. Is there a way to perform a find that returns all records where the contents of several fields are the same? My attempt using a calculation field with an IF statement did not work as expected. Here's the calculation: If( (PublicationLatin = OR_WA_Plants::ScientificName = FNA Name = Hitchcock Name = Jepson Name = Oregon Flora Name = WA Checklist Name = CalFlora Name = e_Flora BC Name), "match", "variance") I should get "match" in my calc field (result set to text) when all the referenced fields are the same, "variance" when they're different. Those words show up, but when I page through my found records it's obvious that something isn't …

This was taken from filemakerhacks.com website as i just did not understand what Matt was saying. Can someone please tell me what exactly he is saying here? My question is, Where do you do the loop set var : $searchString : value: test::note; Enter Find Mode set field : test::note $searchString; perform find [] Here is attached link to article: http://www.filemakerhacks.com/?p=3501 -ian

Hi all, Probably this is a simple issue but I'm lost. In my database is a field called "Row" In this field there are values such as: Sl 1-1 Sl 1-2 Sl 1-3 Sl 1-3a Sl 1-4 Sl 1-5 and so on. I set a variable $$CHECKROW with a value form one table and the find is performed in another table. When I do a search in a script for $$CHECKROW ( value Sl 1-3a ) it is working great. Only one record found wich is matching the criteria. However when I perform this find for Sl 1-3 it also finds Sl 1-3a and that is not ok. In the find dialog I can set the criteria to ==$$CHECKROW but that don't work. I think FM is searching for…

Hi there I am facing a problem with my search tool. I want to perform a search from a small layout. The search works fine except the record found is not displayed in the original layout. I can see the result in the small window but when it closes, I am back to the original layout without the search result. The original and the small layout share the same table. By the way, my search script opens a new window in Find Mode and then it closes at the end. Any tips is welcome

Hello all, I'm a beginner using FMPA11v4 on Mac OS X Lion. I designed a basic database that helps analyze financial transactions in various ways using standard double-entry bookkeeping journal entries. It suits my needs so far, but I'd like to add more features, etc. as I learn new skills in FileMaker. I'm trying to automate these steps in FileMaker using a script, etc. Here are the steps I currently do manually in FileMaker: 1) Enter the LEDGER layout in table view (LEDGER tracks JOURNAL details or line items, with an amount field that has positive amounts for debits, negative amounts for credits, so the sum of all child records equal zero indicat…

When I write in find mode, Whatever I write, I want all caharacters to be shown in password caharacters (******). How can I do this ?

if is it possible to fınd the words in "..tiff" format file in container type field ?

Hi everyone, It's been a while since I've used FM, and I'm very rusty! So, I have some spare time and am going to build a CRM for myself. I basically want to electronically store my clients portfolios (I'm a bookkeeper). I'm going to use tabs for the various headings & activities relating to the client. I'm stuck on the best way to structure a find. I want to filter find results into a portal based on the letter of the alphabet. What is the best, easiest way to do this? In my client portfolios I have A-Z tabs with information on my clients Debtors & Creditors , so would love to be able to add all that info into FM. It doesn't need to be A-…

Is there a way to use a Quick Find to constrain a current found set, instead of having it search the entire table? I'd like to be able to use a List View to present a found set to the user via a script, then give them the ability to search within that found set. I suppose I could make my own "Quick Find" box on the layout but I was hoping I could use the actual box for it.

sorry for my english I hope I can write my problem. for example, There are records in a field.and there are records starting by "B", for example "Book" when I write "B" in field, all records starting by "B" are coming , I dont want like this.ı want a limit searching, When ı write "book" in field than I want the result. How can I do this ?

I have the following relationship: Patients -< Patient Diagnoses Every Patient Diagnosis displays fields to record the diagnosed condition (selected via drop-down) and several related descriptors RE: severity, treatment, etc. I know how to search the database for all patients who are diagnosed with a particular condition, but is it possible to search for all patients who were NOT diagnosed with a particular condition? This is a research database and the end goal is to determine the prevalence of a condition among our study patients. Any feedback would be much appreciated.

Hi, I've 2 tables, Jobs and Invoices. Each job can have a number of invoices What I want to do is find all the invoices done in November, but also include in the found record set all the other invoices for those jobs which did have at least one invoice in November. I thought it would be easy but I come to a complete block cheers in advance MJK

I am trying to build a reminder feature that could include a 'time' of an event. I would like to be able to script a find whereby the event time field could be searched for the current time plus 15 minutes, and this script would be timed to run several times during the day, hopefully catching any scheduled event within 15 minutes of when the script runs. I know there is the // symbol for searching current date, is there a symbol for current time? Otherwise, how would anyone suggest this could be done? Thanks!

I have encountered a new problem which I have never seen before. A script is performing a find with Set Error Capture [On]. I have the script performing a find and immediately following the find, Set Variable[$lastError = Get (LastError)]. However, after the find fails to find any records, it is still reporting the last error as "0". I have verified this by running it in Script Debugger and it fails to produce the 401 error after not finding any records. Have any of you encountered this issue?

Guys im new here and im already having trouble. I used Invoice template and i wanted to change one thing, is it possible to make one button on invoice tab that when is clicked opens the products DB in list mode and let you pick what items you want to add to invoice. Solution provided in template seems a bit wierd to chose from drop down list especialy if you have 200-300 items to sell, and especially that wont let me add items by part number or item name, only by itemd ID. Thanks

How do I make a find show records from 2 different values in the same field. For example: a find to show all Blonde haired and Brown haired people.

Not positive if this is a script syntax issue or a server performance issue. I do know that the following error was not happening when I had the DB local. The FM Server 11 hosted database is a simple checkout system for students to checkout equipment. I am worried that there may be too many scripts being executed consecutively over the network (these scripts are run locally). An item number is entered into a custom dialog box (2 buttons, cancel, ok). The first script checks to see if an item is broken, missing or has been blocked from checkout, the next script sees if the item is currently checked out, the third checks to see if the item is reserved by someone.…

Hi there... like the title says, this must be a common problem I just wondered how people go about overcoming it.. We have a customer order database.... obviously there is a balance outstanding for each order and obviously we need to search on it sometimes.... With 100,000+ orders this search is taking 1/2 hour each time! How do people cope with this..? I need the search to complete in 30 seconds not 30 minutes!

Ever since we switched to File Maker 9 we have not been able to preform a find when certain characters -like this character: # (the pound sign) are in the find criteria : For example we may have inventory of product identified in the database as #AO55687. If I copy find paste this number I receive the "No records match this set of find request". If I do the same however and remove the # sign then all the records show up without any issues. Is there a way around this problem? Because we have scripts that are using the "copy - find - paste" procedure and this becomes a problem.

Hi Guys, I have an "expenses" table which includes project, account number, payment date and payment number fields. In the case where one payment may represent two or more expense items, I can have two or more records with the same payment number, such that when those records are added together, the total payment amount for the same payment number matches the amount debited from the account in the bank statements. For example, if a hotel bill containing room charges and restaurant charges is paid with one cheque or credit card transaction, two records are entered with the same payment number, one for the room and another for the restaurant. Or when reimbursing e…