This topic is 2584 days old. Please don't post here. Open a new topic instead.
By Richard Carlton
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
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 is stored in a "Name Theme" field and displayed at the top of each kitten/cat record.
Each time I weigh or give a de-worming or flea medication to a foster group I open the FM db, do a search for the group (e.g. "Gins") in the "Name Theme" field and then I have the medical charts for that group to mark my progress.
The complication is I often have 3 different litters in three different areas of my home.
What I want to do is to have 3 Global Fields - which store the 3 "Name Theme"s I am fostering at a given moment.
Find_3 "Marx Brothers"
Then I want to place these global fields on the main layout that my db opens to. I would define each Field Label to be a Button and have each button search for the appropriate Find_x content in the "Name Theme" field.
I cannot figure out how to capture the value of the "Find_x" Global field and insert the value into the "Name Theme" to then Find.
Nor do I see in the Find function a way to specify that the value comes from the Find_x field but the search itself involve this value in the "Name Theme" field.
I feel there must be some simple scriptable way maybe involving an additional layout and a calculation but the how to escapes me.
I would be very grateful for any help.
Bill qb Quattlebaum
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'.
Greets, and a happy, holiday season to all.
This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command:
"cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" )
...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, " Command is unavailable (for example, wrong operating system or mode)".
So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix?
By Matt Navarre
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, watch me do it 5 minutes (and 12 seconds).