Is there a way to get a list of all scripts that contain the "FIND" command?
If you have FileMaker Pro Advanced, you can generate a DDR (Database Design Report) and search in the DDR.
+1 to philipHPG's suggestion. Aside from that...what are you hoping to accomplish, and how many scripts are involved?
And if you have Base Elements, you can use it with that DDR to get every script step that uses Perform Find.
I do but I only have one box of paper.
I need to modify my find commands with the "==" and there must be close to
300 scripts to paw through.
What are "Base Elements"?
I'm glad I asked what you're trying to accomplish. Why are you so sure you need to replace all of the find commands with "=="? A lot of those commands are probably looking for IDs, which are supposed to be unique. What's the bigger issue?
I highly recommend 2empowerFM Developer Assistant
Base Elements is a third party tool that can take a DDR and generate reports and help you find issues with your database. There are a number of such developer tools available.
+1 to that. I think it is the most singularly useful Filemaker add-on I have ever used. In fact is is the best. Ever.
We must, perhaps next Devcon, get Chris Dragon (cool name for a code-slinger) to show up. Many are those who who profer a beverage to this reluctant hero.
"Some are born great, some achieve greatness, and some have greatness thrust upon them." ~ William Shakespeare
in general: You'll find almost everything in the DDR - but to deal with a DDR, one needs some helper apps..
- there are several DDR-Analyzers that build FM Databases with the DDR data, so one can search in a familiar way
- FMPerception is by far the fastest of these tools, creates an environment without FileMaker tables/layouts
There is one Plugin that allows searches in almost every FileMaker text-box (field definitions, scripts, - relationship graph as well,) - the 'developer's assistant from 2emPower. Not cheap - but one won't miss that after using it once
The MBS plugin allows Mac users to search in the current script, 2emPower searches through all scripts in one FM file
The analyzers allow to deal with DDR from several files from a FM solution at once
Since without FileMaker Pro Advanced, DDR are not possible, that is one of several reasons to get the advanced version. If You don't have that, maybe a kind soul could run the DDR for You... (files and master credentials needed..)
I am looking for a Report Number in the form of 090616A. What I have found
is that if I am looking for 090616AX (with only one of those in the file) I
am returning 2 records; the 090616A AND the 090616AX. If I use the "==" I
only get the one I define.
I'll look into them. Thanks.
Thanks. I'll look into that.
Thanks. I'll look at that one too.
In the instance you describe, where you're thinking about looking at every script in order to find scripts where you're using Report Number to base your finds on, I think you'd be better off by changing the finds so they use your primary key ID fields (or foreign key ID fields) instead of the report number field. Since primary keys are supposed to be unique by nature, using them for finds is definitely the best way to go.
Good luck, whichever way you decide to go.
Good tools have been mentioned for searching through the DDR, however if cost is an issue it is possible to search the DDR without printing it off (I certainly wasn't recommending that you print out the DDR). Generate an HTML DDR and then you can search in your browser. It is certainly much easier to use one of the tools suggested, but this is still a viable option, depending on your budget.
If you have an Apple Mac and don't have any of the plugins/analysers, you can select all the scripts in Manage Scripts... / Script Workspace... and then go to Print. Rather than print to paper you can save as PDF, then use Preview or Skim to search for the text you need.
The print to PDF may take a while depending on the speed of your Mac. I understand that Windows 10 and Windows Edge may allow you to do the same.
Excellent idea! Yes, cost is an issue after just upgrading to FM15 and the
"client" being a family member. Thanks.
I have question about the FM Developper assistant advanced. Is it possible to replace in multiple scripts a layout name ?
I've seen for text, variables, etc ... But for layout names ?
thanks a lot.
Even though I don't have a Mac (but I love my Dell XPS 15 9550 with SSD)
Windows 10 does come with a free PDF writer and your suggestion worked like
a champ. I setup the search for "Find" and it highlights and zooms to all
scripts with "Find" in them.
Thanks so much.
I was going to suggest what philipHPG suggested. In Internet Explorer, I just right-clicked on the report > View Source. Then found keywords. The word "Find" is used a ton in field definitions. So looking for "Enter Find Mode" or "Perform Find" might be much easier.
Thanks. Windows 10 has a PDF viewer with search capabilities and the works.
You'll want to use 2empowerfm Developer Assistant for that task from Dracoventions. This is the #1 most important tool that any FileMaker developer can own. I can't even develop a database anymore without this tool.
The #2 most important tool is BaseElements: BaseElements | Goya Pty Ltd. This tool actually interprets your DDR report in an understandable, usable, and searchable way.
Hi Scott, I ll gonna go the website but to be 100% sure this plugin can do the renaming in multiple scripts to change a layout name for another ?
Retrieving data ...