Forum Discussion
It would be really cool to be able to identify all of my formulas across my app that have an OR condition in them, so that I could visually view them one-by-one to make sure the logic is optimized for short-circuit evaluation. I was hoping that maybe the Replace Term in Schema utility would help me here, but alas, it's not looking inside the formula code - just the names of the objects. Is there any way to do this, or do I have to go manually through all my 71 tables and probably over a thousand formula fields across my whole application to check on this? I doubt it would be worth the time, but it would be if I could quickly identify those formula fields that involved ORs.
- Hi Michael,
Unfortunately we don't currently have a way to search the contents of formulas (meaning the formula code, rather than the formula results) so I recommend you consider the few tables which either have the most records or see the most traffic from your users. If those tables themselves have a very large number of formula fields you can go to the table settings > Reports & charts and see which reports are used the most. That way you can review the formulas which are used on those reports.
Here are a few other strategies you could use which may be quicker:
- Review formulas which are used on big reports which take a while to run
- Review formulas used on the app/table home pages of your most used apps/tables.
I hope this helps!
