Aug 26, 2021 10:16 AM
Hi,
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.
Aug 26, 2021 11:18 AM
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.
Aug 27, 2021 08:25 AM
@Tiberius The List Invalid Fields script is now available on my Gumroad store.
You can also purchase a license for the Field List app. For tips on how to use the Field List app (including how to see field names in dependencies), see my website