Skip to main content
Nintex Community Menu Bar
Question

Formula producing phantom error

  • July 11, 2024
  • 1 reply
  • 2 views

Forum|alt.badge.img+18

Here’s my formula:

IF(
  {{Signatures\_\_r.records}}, 
  {{Signatures\_\_r.records.0.Signature\_Name\_\_c}} + " (" + FORMAT\_DATE( "m/d/yy", {{Signatures\_\_r.records.0.Signature\_Date\_\_c}} ) + ")" ,
  ""
)

Here’s the error I’m getting on runtime:

The funny thing is, the formula is actually working. It’s returning the results I expect. But it’s a bad user experience to have an error that isn’t really an error.

1 reply

Forum|alt.badge.img+3

Hey Matt!

Can you double-check that the formula is correct in the XML itself?  I’ve run across a similar issue, and ended up finding that the XML itself had invalid syntax, even though the formula itself was evaluating correctly.

Thanks!
Christine