Jump to content

Search the Community

Showing results for tags 'search'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 27 results

  1. Hi there, at first I was struggling to find some data which I knew was present and couldn't figure out why... Data in text field (real example): A 0111 B0111 B0116 TZ0113 [...] Search string (quotes not part of search): "0111" finds "A 0111" but not "B0111" etc. But I figured out how to adjust my search so FileMaker will pick up these records accordingly by wrapping it in stars like *TERM* so it performs partial matching: "*0111*" finds "A 0111" and "B0111" Now my question is: How can make this the standard search mode / feature without extensively writing scripts for every layout? I am working with a search layout which includes a lot of fields and I would like to just be able to set "partial search" as default for selected fields or – if that's not possible – for all fields on the search layout, knowing that this can be achieved by using a search script which wraps every input in "*" but that seems kind of over the top. Thanks for your input!
  2. Search in Popover

    Hi gurus, I am sure I’m missing something simple, but for the life of me I can’t figure this out. I have a database with tickets. What I want is when a new ticket is created I want to see a popover (see attached) then I want the user to type in the top box and as they type I want to filter the list below (a portal) and once they client is shown they would select it and a ticker is created for the client. I sound a script and modified to fit my needs but can’t get it to work. Can someone stretch a helping hand? BTW the filtering is working but its not reflecting in the popover its reflecting on the layout.
  3. Search until, then

    Basic question.... Where do I find help on partial word searches? I've been ...searching.... for a good writeup on FMP search operators that cover this to little avail. I need a expression that will search, get to a character, and then ignore/wildcard from there. So a search on "Chicago" will return: Chicago Chicago-IL Chicago-001 and so forth.....
  4. Hello, Noobs here. I am looking for some assistance that when I select a record on a form I am taken to that record. Example below. I am taking this simplified hypothetical example in the parts table with columns: Finished, Shared1, Shared2, Shared3 Row 1 values: A, B, C, D Row 2 values: B, A, C, D When Row 1 loads in the layout you sent, say that A appears on the upper right box. Therefore B,C, D load in the bottom in red Desired behavior: when B is then clicked, you want it to replace A in the upper right box and have A, C, D appear in the bottom in red. Thanks in advance, Brett
  5. Do Find and Omit "clash"?

    Good evening. Once again I find myself stumbling over something that I think will turn out to be very simple. I seek the help of our Filemaker mentors for assistance. I have a table with about 3000 records in it. One of the fields is called "Type" and can contain any one of 7 different values" Another field is "Gender" (containing one of there values: Male, Female, Unstated") Another field ("Duration") is a numeric value that can be anything from 0 to 300 I want to Find records whose Gender is male (easy), the numeric value in a range (also easy), but exclude all records whose Type does NOT equal "Assessment". I found that I can Omit the "Assessment" records OK, but then unable to then constrain the set to show just Gender=Male and a Duration value of choice. After the Omit works, running a Find on the remaining records seems to undo the Omit. So, I tried the Omit stage after the Find of Gender and Duration - still no luck. It seems that a Find cancels out a previous Omit. One cannot do a Find on something that "does not equal" - it has to be an omit process. I am not going to do a Find on the other possible 6 values either - thats not a clean solution. I have been unable to find a solution through Googling on the correct procedure and usage of the Find/Omit tools to achieve what needs to be done. I'm sure it can be done, and I'm just missing something simple. Any help would be appreciated. Thank you, Greg
  6. Help with a find

    Hi guys, Would appreciate your help. I have a database for a university, basically I have students that enroll to a subject and can either : win, homologate, fail, or cancel the subject. I must make a report that shows every student that has failed, canceled or hasn't seen certain subject. The catch is that if the student has seen the subject two or more times and for example the first time he failed it but the second time he won it, that student appears on the report even though he shouldn't because he won the subject on a second try. So, how can I make a report that excludes a student that has enrolled a subject more than one time and has failed and won that same subject?
  7. Highlight Text on Screen

    I am building a custom solution for my company that tries to replicate the functionality people are used to in a series of text-based documents. One of the things I have been asked to produce is a method for highlighting specific text on screen when viewing historic log notes. In some cases, we have decades of notes for a customer, so simply looking through those records is impractical, and the users want to be able to view the found note in the context of other notes, chronologically, so I can't just have them perform a find for the specific text. Is there a way to jump to the specific row of a portal that contains a specific text string without actually filtering the portal results? I am using Filemaker Pro 15 on Windows 7.
  8. Building a Super Slick Search UI

    Hi all, new article just posted over at FM Weetbicks, blurb and link below, cheers! Link to full article here
  9. Hello, I'm running FileMaker Go 15 on iPhone 6 (iOS 9.3.2). I had this same issue on FMGo 14 before I upgraded. When I click Create New Find and enter find mode, I enter data into the fields I'd like to search, but the "Search" button in the top right corner is grayed out/unavailable and clicking "Done" or "Go" in the native keyboard doesn't perform the find. I've attached an image in find mode so you can see what I'm talking about. I even have admin privileges and it doesn't work. The Quick Find search seems to be the only thing working. Any insight would be helpful! Thanks in advance! Arbel
  10. I have two Excel files from a supplier that contain related data. I can import the files and use the Product ID / Item Number as the key to relate the records. The two files may have a different number of rows of items, so I can't just sort them and compare in Excel or TextWrangler. I have over 400 records, but less than 1000 records to analyze. One of the files has data in columns like this: ITEM #, Item Name, Description, Other columns of data... The second file has data in columns like this: Product ID, Status, Description, Category, Notes, Item price, Case price, Other columns of data... I would like to: a.) Match the records using ITEM # and Product ID (they are the same thing, no idea why the supplier used two names for the same data). b.) Display all of the records that match, with all of the fields from each record. c.) Export the matching records and all the fields to Excel. d.) Do the same thing for records that *do not* match. My ultimate goal is to be able to combine information such that I can update inventory status, price, and other data on a web site using a bulk upload, as well as to be able to generate a PDF catalog from FM. I'm open to using a different tool to accomplish this, if that's a better solution. Please let me know if that's the case. I think I need to use a join table somehow, and perhaps a portal to show the records, but I can't seem to make the connection after hours of reading documentation and trying things. My skillz just aren't there yet. Thanks in advance.
  11. Fuzzy match two tables

    Hi I am cleaning up a messy list of doctors names and addresses. I have got a lovely clean and accurate its in a new table. The old table is very unreliable, with inaccurate placement of the data for address1,address2,town, post code etc. This means post code could be found in any of the fields or not at all. My idea is to break out the search terms by "exploding" all the words in all the address fields and using these to search in the clean file. I want to score the results so more finds gets a better score. I can then use this as a threshold to match the records and then store a foreign key. Finally I will replace the links to the messy data from the main application with the key to the clean data. TO ILLUSTRATE Address1 Address2 Town Post Code Messy file 20 High Street Birmingham Clean 20 High Road Birmingham B1 1AA Score 1 +1 +1 =3 Questions Is this a sensible approach? Or is there a better way? I can generate a multiple line search but this will find every High in Birmingham. I think I need to loop into repeated searches and use this to count the results ? Any guidance gladly received. Thanks John
  12. search find and return result.

    Hi guys, it's that time where I think I am way over thinking something and so I have stopped to ask a question. Put simply I am working on a POS for a small business that may have up to 4 terminals in use at any one time. My question is this as layed out by the following scenario. Terminal 1 and 2 and 3 are in use (for example). All terminals are operating and putting customers stock through the checkout. Terminal 1 and 3 both perform a search for product through a search layout, both have results that need to be returned to the terminal and entered into the current sale they are respectively working on. How do I achieve this so they return to their respective records and not each others (if this makes sense). I have a persistant ID for all terminals and currently the result is a scripted return of the EAN (number) via copy into the relevant record on the terminal. ( Simple in it's theory and it works for a single user. I think there could be a far more elegant way of doing this) however, going back to my original question of the multi user scenario how would I make this work? Hope this makes sense.
  13. After converting my database file from its FMP 11 version to the version compatible with FMP 14, a normal behavior no longer functions as it did. In Find mode, a certain field is supposed to autocomplete the search string based on a specified value list. This no longer happens. Instead it functions like the default, which is that typing a letter scrolls down to the first entry in the value list that begins with that letter but does not use autocomplete. I attach a short video to illustrate. Does anyone have any thoughts on why this might have changed in the upgrade/conversion? Thank you! FMP_14_autocomplete_problem.mov
  14. I have a database that tracks submissions we get from our VFX Vendors. I have a field in this database that I import all of the vendor submissions into. I would like to know if there is a way to search for multiple submissions through a custom dialogue. I have successfully created a script for searching for one submission. Is there a way to expand upon what I already have? Here is what I have so far: Go to Layout [ "VFX Notes Original" (VFX Notes) ] Enter Find Mode [ ] Show Custom Dialog [ "Vendor Submission Notes" ; "Enter the vendors submission name down below." ; VFX Notes::VFX Notes_CompDateRecieved ] If [ Get ( LastMessageChoice ) = 1 ] Perform Find [ ] Go to Layout [ "Vendor Issue Notes" (VFX Notes) ] Enter Browse Mode [ ] End If If [ Get ( LastMessageChoice ) = 2 ] Enter Browse Mode [ ] Go to Layout [ "VFX Counts" (VFX Counts) ] End If Any guidance would be greatly appreciated. Thanks in advance!
  15. Hi, Firstly, thanks for the great product. I can't tell you how much it has sped up the solution process for our tutoring business. I have a few questions and issues: The Calendar Search appears not to be working, and my attempts to debug have been futile. For example, I add a ToDo called "Tutoring Session." When I search "tutoring" or "Tutoring" or "Session" or any combination thereof on the search string entry it comes up as empty search. I have gone into the script and everything seems to make sense, so perhaps I am using the search in a way it's not intended to be?I have been having issues connecting the projects module to the timesheets module. When I go to the Add Line Item I can add everything except for a project. The popover displays and I can enter everything. When I click the search icon on the project's field, the projects do show up (someone else had been having this issue before I saw). But after I click on one of the projects it doesn't go put it in the box on the popover itself. I hope this makes sense. I do not have this issue with the staff on the main data entry timesheets page. I noticed that in the relationships section of the data manager the timesheets section only connects to a staff table. Could this be the issue perhaps? I tried to fix it by adding a new table, but my attempts were futile. Is there a way to connect timesheets to Calendar, or simply to have a ToDo connected to a timesheet as well? For our tutoring business, we would like to add tutoring sessions to the Calendar as a ToDo, but we also would like to be able to track the hours each tutor has worked in the most recent pay period with the timesheets functionality. Is there a way you can recommend modifying fmstartingpoint or an easy way to integrate them like this? Having the ability to just add timesheets to the Calendar would remove the need for ToDos at all, which are tricky because they don't allow length of time for meetings, only when they start. I saw in a previous post Richard said that the new timesheets would have the ability to add the functionality easily, which would be awesome.Is there a way to create basic charts off contact data to present to the customers in a module? I have considered modifying the estimates module to do just this, but it would be helpful if there were a better solution, since you guys know better.Thanks so much for any help! Help with #2 and #3 would be greatly appreciated, as our ability to create timesheet structures them around connecting them to projects and putting them on a central calendar. Again, thanks for the great starting solution as well, which has helped so much.
  16. We have a table of job reports which displays the following fields: 1. Job number (unique number) 2. Job Title (text which is autofilled using the job number) Portal results showing a list of work done: 3. Work Done (number) 4. Hours (number) 5. Cost (number - based on an fixed hourly rate multiplied by Hours) Beneath the portal it then shows a total field: 6. Hours Total (Total of all hours displayed in the portal) 7. Total Cost (Hours Total multiplied by a fixed hourly fee) --------------- I want to create a new table with a portal search that I can type in multiple job numbers in a search field and it will display a list from the table above in the following format: 1. Job Number, 2. Job Title, 6. Hours Total Then I will create a couple of fields at the bottom which will add all the hours and give a total cost. The problem is I cannot work out how, or if it is even possible to search for multiple job numbers in a field to display the relevant results in a portal. Is it possible or do I need to go about it in a different way?
  17. FM 13 Is it possible to search a pdf document within an interactive container field or within a "supercontainer" without exporting the document? And then have the pdf within the container scroll to the found text?
  18. Search for Formatting

    Okay… here’s a toughy. I’ve got a corrupt file, so we need to get all the data into a clone of a known-good backup. Obviously I can import it directly, but to be absolutely certain we’re getting rid of all corruption, my supervisor has requested that I export the data to merge files and then re-import it into the known-good clone, which sounds great to me. Unfortunately, there’s a snag: a lot of the data includes formatted text, which is very important to maintain. So, here’s the solution I came up with, repeated for each table in the solution: 1) Export all modification information (mod account, mod timestamp, etc.) to a merge file. 2) Loop through each field of each record of the current table and check for formatted text, using the following calculation: GetAsCSS ( GetField ( $FieldName ) ) ≠ GetAsCSS ( TextFormatRemove ( GetField ( $FieldName ) ) ) Any data that returns True is replaced with its CSS equivalent. 3) Export the data to a second merge file. 4) Import the data from the second merge file into the backup. 5) Perform step 2 in reverse, using a slightly modified version of Christopher Gauntt’s CSStoFMText custom function. 6) Import the modification info from the first merge file into the backup. I’ve gotten the script to the point where it’s working perfectly, but it’s taking forever: it’s been running step 2 on a particular table (62 fields, 2.3 million records) for over 12 hours and is still only about 60% complete. Once it’s done, it still has to run the remaining four steps on that table (I expect step 5 to take as long), then process the remaining 33 tables (most of which are smaller, but still). Any thoughts on what I can do to optimize this further? Perhaps some method of finding formatted text? Thanks!
  19. Search Results Order

    I have created a search field on my database which allows users to search for a particular word on the database, and it will result all the records that match this. However what I want is for the results of the search to be in a particular order. I have many different companies on the database, when a user searches for "iPhone", I want the company which we recommend to purchase iPhones from to appear first on the search results. I am not too sure how to implement this. Any help would be much appreciated.
  20. Value List Based on a Search

    I am happy with being able to create a dynamic list from relationships. What I trying to solve a away to be able to search through (or filter) a Value List of SerialNumbers from a user input of text. Both the search input of text and the calculated value list (calculated SerialNumber field) have a variable number of characters. A user would therefore enter a text string into a field (which can be a related global storage field), then I need the value list to filter based on that string. I can get this working from a exact match (ab=ab etc), but need to know if there is a way of creating a value list based on an index of SerialNumbers? To simply this to explain another way, if I have items: a, ab, abc, e The user would type 'a' into a field and the value list would return all items with an a (a, ab, abc)
  21. Hello Everyone, I'm having a hard time working out how to do a search and replace. How I have my FM project set up is; I have three tables. The first is Staff, it has these fields: id, staffID, firstName, lastName, fullName (caculated). The second is Assets, it has: id, staffIDFK, dn, make, model, etc... The last is Resources, it has: id, staffIDFK, assetsIDFK, addItem. What I have is on the Staff page I have two tabs, the first tab shows all of the staff members information, the second tab has a portal showing all assets assigned to them. Above the portal I have a field(addItem) from the Resources table and a button. What I'm trying to do is have the ability to type in the DN into the "addItem" field and press the "Add" button to add the device to the current Staff member. DN stands for Device Number specific for each item, its like the id for the item but I was told i should always have an id field in each table. How I was hoping the logic would go something like this: If (content from Resources::addItem is found in any Assets::DN fields ) Check Asset to see if Assets::staffIDFK is empty If NOT, Message box: "Currently Checked out to "Staff::fullName" do you wish to add anyways?" Yes/No If YES, Set Assets::staffIDFK to Current Staff::id Else if (Resources::addItem is not found) Message Box: "No Item Found." I really hope this makes sense. Thank you for your help in advance!
  22. Hey guys, I am trying to create a script that will preform a search and pull up a record in my FM database with a barcode scan from CMS Barcode. I have already setup CMS Barcode so that the barcode number imports into a text field in my database with a scan, however from there I am stumped. The script can't be that complex, and CMS only offers limited information. Any help would be appreciated! Tomio
  23. Greetings, I have a global field that is acting as a search bar to perform a find with the data stored in it. I have set an OnObjectKeystroke script trigger to the field to activate a script if the user presses the enter key while inside the field. Since most users are used to hitting enter on their keyboards to perform a search and it's much quicker, I've adopted this method as opposed to a search button. I would like to prompt the user with a warning dialog if they press enter while inside the search field, but happen to leave the field empty. The custom dialog would tell them to type some search criteria in, instead of leaving the field empty to avoid performing a blank search. So far most of the script I came up with works, but for some reason it gets stuck in a loop during the last simple steps and I can't get out of it. I'm trying to have the following occur: - Exit the search field, and make it lose the focus. - Show a custom dialog telling the user of the error and prompting them to press "OK". - Upon pressing OK, enter the search field again and bring it into focus to set the cursor in the field so that the user can retype a correct value. The default FileMaker field validation that is found in the field's Options settings performs something very similar to what I described above. I'm trying to achieve a similar effect, but using a script instead to have more custom control and flexibility with the warning dialogs. Any help much appreciated. Custom validation - Search field.fmp12.zip
  24. I have a table of 200 clients related to a table of each client's visits. The visit table has the date of the visit plus other fields not involved here. These monthly visits numbering 1000 range across all visit records from 2003 through 2013. I put the visits in a portal on the client layout. It all works fine. What I'd like to do is show only those records that have visited recently. The business rule is: If the client hasn't visited since Jan 2008, he's abandoned us and is not longer interested. Of course I'd not delete those abandoned cases but I want FM 11 to show me only those records with a visit from Jan 2008 to now. I've tried doing this with the simple FM 11 menus using the "Date_of_Visit" field which is all I have. I can't use "> */*/2008" becuase that includes all records back to 2003. I can't use "< 12/31/2007" because that again includes all records which I don't want. Perhaps I don't know the sequence of joining a ">" find to a "<" find. How do I filter these dates?
  25. 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

Important Information

By using this site, you agree to our Terms of Use.