Is there a script that finds all errors in a specific table (or even better in the entire base) and then returns those error fields?
That would help greatly with troubleshooting larger bases, so I don’t have to scroll through hundreds of fields looking for the red error sign when making larger changes.
I have a script that I use with client bases.
Here is a video of me running the script. If you are familiar with scripting, it is a fairly simple script to write. On the other hand, if you are not familiar with scripting and would like to purchase this script, let me know.
I also wrote the Field List app which can help you identify broken fields dependencies among calculated fields before they break.