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


  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 15
    • FileMaker Server 14
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • 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


  • 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


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


  • FileMaker User Groups

Found 20 results

  1. Hi all, new article just posted over at FM Weetbicks, blurb and link below, cheers! Link to full article here
  2. 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
  3. 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.
  4. 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
  5. 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!
  6. 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.
  7. 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.
  8. 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!
  9. 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?
  10. 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?
  11. 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!
  12. 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.
  13. 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)
  14. 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!
  15. 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
  16. 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
  17. 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?
  18. This was taken from 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: -ian
  19. I am a novice at layouts and filemaker language, So this is what I am trying to do and I thank anyone who helps me figure out how to get this completed. I am trying to create a database search filter that will be able to return any and all records that fit the filter but can have an unlimited number of search criteria that are based on "and"/ "or" strings. I'm not sure if using a portal can solve this but this is what I'm talking about. example, search: first name="" , and, age<"" , and, height<>"", + or last name="" , and, team="" , and, record>"", + + The plus signs are buttons I would like to have to automatically add to the search criteria to tag as an "and" string or an "or" string. So when you go to click one it adds a box to enter the "field" from the database then the command "<=>,<>" then the "value/comparing field" I'm not sure if I'm asking/trying to do something complicated here or this is a walk in the park, but any help will be greatly appreciated. Thank you.
  20. How do I do a search if I want records where the field is blank?