Jump to content

Search the Community

Showing results for tags 'search'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • 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
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development
  • FileMaker Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he breaks down the Search function! Future live streams: https://fmtraining.tv/#LIVE support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  2. I am a foster volunteer for a kitten and cat rescue. Each foster has daily medical and health items we preform for our little wards. Years ago I created a simple Foster Tracking database in Filemaker 16 and now use FM 17 on Mac OS Catalina 10.15.x Many of these chores repeat at a regular interval so so my Foster Tracking has charts that when given a start date propagates repeating fields with the next occurrence. Typically foster arrive in litters of 3, 4, 5 or more kittens and all have a naming theme. I've used "Companions of Doctor Who" and "Gins of the UK" for example. This i
  3. Hi all I have a customer list in a drop down. The drop down field has an On Save script trigger which then performs a find in the same layout for the selected customer. The drop down field is configured to 'go to next object using' return. There is also an On Record Load trigger on the layout which pops up with a dialog if the customer's Attention field is populated. This all works fine unless I utilise the option to save the drop down field with the enter button. It ends up looking like this, with the white background. Once the user clicks OK the layout 'appears'. Th
  4. Announcing fmSearchResults 5. This latest download delivers new features with simple implementation. And it's free! fmSearchResults 5 adds fast, multi-table searching to your FileMaker solutions by importing a few scripts and pasting a simple search field on to your layouts. It feels like the type of Google search that all your users are already familiar with, and it’s far more powerful than FileMaker’s Quickfind feature, because it searches across multiple tables and has data-type awareness. Read more about the new features and download it now! Implementation is so simple, watc
  5. I have a database that we use to update our website inventory. A few years ago we began offering customized merchandise that gets dropshipped direct from suppliers. Suppliers give us data feed files with their inventory levels, pricing, etc. and this file manipulates the data. It takes our current web database, compares values and exports those products with their updated values. Importing the data and exporting used to take less than hour but now it takes several since the size of the web database has grown and the number of suppliers has grown. Everything is automated through scripts.
  6. 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 / featur
  7. 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
  8. 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.....
  9. 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 bot
  10. 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
  11. 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
  12. 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
  13. Hi all, new article just posted over at FM Weetbicks, blurb and link below, cheers! Link to full article here
  14. 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 i
  15. 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 pric
  16. 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
  17. 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! FM
  18. 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 respect
  19. 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 is
  20. 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 Note
  21. 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
  22. 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?
  23. 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 a
  24. 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.
  25. 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
  • Create New...

Important Information

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