Debugging formula errors.


Can anyone tell me how to debug a formula error.  More specifically, I have a form in which there is a large number of computed fields.  An error occurs in one of them as follows:

  Incorrect data type for operator or @function:  Text expected.

How can I find quickly the field to which this error applies?  Currently the only thing I can do is to check all the fields.  Surely there must be a better way than this!!


Sotiris Georgiou, CTL, Cyprus
Who is Participating?
HemanthaKumarConnect With a Mentor Commented:
Cut half the number of fields and test. similarly do it for other half to narrow down ur search.

There is a way to debug formulas in R5 but in R4.x you don't have a lot of options.  Most folk put alot of @Prompts into the code at various places to check values and locate possible problem areas.

'Fraid there just ain't alot you can do otherwise.  It is very tedious working with formulas.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.