With a data base with 200+ layouts when in manage data base can one find out what layout /s a field is used on?
Start with this help topic (and follow the links):
Documenting database schemas
aka DDR, this document links the objects. There are tools that help "analyze" this DDR further.
Using a simple "Find" in DDR you can retreive immediatly how many times a string that represents a field is used.
If it is used only one time, it is never used, only defined and can be suppressed.
It's the same for global or simple variables.
Finding the word "unknown" is also a good manner to look for undefined script launch and "missing" can show you where there is undefined field in calculation.
This depends on how much you will need to do this...
My chosen tool is FMPerception which will search the DDR faster than you can blink for this kind of query... That may be enough to warrant buying it.. or not.
As Bev said other tools are available depends totally on your use case
I should note that doing a text search on the HTML DDR will work, as long as the name of the field is not common. So, for example, if you need to see where the Status field from the Projects table is being used, but you also have a "Status" field on the Customer, the Invoice, and the Task tables, this won't work well. You'll need something that will analyze the XML DDR if you want that kind of specificity.
Problems also arise when using the HTML DDR for multi-file systems, as your field may be referenced from layouts in multiple files.
My tool of choice is also FMPerception, but I am the developer of FMPerception, so that's to be expected. :-)
If You have to do that once, a pure DDR might be ok. If You have to do that frequently, one of the analyzing tools is a great help and the way to go IMHO
FMPerception is the tool here
Can you remind me the price of FMPerception vs the price of Find in the Edition menu
You can built a DDR with multiple files FM solutions and made search in all files of your solution.
FMPerception is definitely not free. But we're all FileMaker developers, rather than PHP/MySql developers. We regularly trade money for time and easing the mental load of the work that we do.
The HTML DDR is generally a useful tool... until it isn't. But it is not the fastest tool, nor the most powerful. There are systems so large the HTML DDR just flat out doesn't open at all. And if the original poster's system has 50 or 60 files, it's painful to get anything useful out of it when you're trying to query across multiple files.
If the free tool meets your needs and you are happy with it, then by all means use it.
But there are other options.
Which is why I talked about use case.
Those here who understand the value of 'my' time saved because of the speed of response, will have saved that cost many times over in a year...
But then you get other things, like this I knocked up in about 15-20 mins to show the frequencies of script complexity for a validation event I need to do on a multi-file system...
Re-run the DDR, import to FMPerception (automatically using my AppleScript thing) , export to CSV, import to this and there we have latest data before your very eyes.. In under 2 mins for each refresh.
and that is something that would be pretty hard to do with the HTML DDR...
And yes that is a script with a complexity score of 100+ !!
as long as the name of the field is not common.
Before getting a copy of Base Elements, I frequently would rename a field, table or table occurrence by putting some characters into the name xxxStatus for example, run the DDR and when through analyzing where that object was found in the DDR, change the name back.
So the HTML based report can pretty easily be used even when the object's name is not unique.
Did you ever use FMPerception ?
Try it, you may download the trial version that works for 14 days. This is an amazing tool. Check all the functions, and then try to do the same with Find in the HTML DDR.
FM developers, don’t leave without it !
I echo others here with another shout out for FM Perception, but you can also check this out:
What Layouts Is This Field On? | Soliant Consulting
Retrieving data ...