Error: Formula (18): The field "" is not contained in the record. (Expression #1)

[bcampbell0621]

Hello All:

This error is returned when I run my code in the formula part of the workflow.  

The offending code is as follows:

IF [BN] = "111111" THEN

[SBN] = "222222,333333"

ELSE

"Do Nothing"

ENDIF

BN and SBN are strings, but carry numeric values in this case.

[TomWelgemoed]

The code should just be:

IF [BN] = "111111" THEN

"222222,333333"

ELSE

"Do Nothing"

ENDIF

Regards,

Tom

[bcampbell0621]

Thank you so much, Tom.  

[TomWelgemoed · Accepted solution]

Happy to help.

[bcampbell0621]

Actually, that's not right.  I need to assign those two values to another field. 

[AndrewS]

Hi @bcampbell0621, not sure if I completely follow the request, I think you will need to create a new field within the formula tool, or if [SBN] exists then have the formula assigned to that field? Workflow attached.

[TomWelgemoed]

Is this what you meant?

[bcampbell0621]

IF BN = 11111 THEN

SBN = 22222,33333

ELSE

"Do Nothing"

ENDIF

I'm not sure how else to explain it.  Both BN and SBN exist already in the database. 

[bcampbell0621]

Hi Andrew:

There are two fields, BN and SBN

IF BN = 11111 THEN

SBN = 22222,33333

ELSE 

"Do Nothing"

ENDIF

It's very straightforward, but the code is giving me this error that I posted in the the Subject.

[TomWelgemoed]

I maybe didn't pay attention to the actual error message.

The issue may be that you're not naming the field? That error can only happen when it doesn't recognise on of your fields in the formula, and I don't see a blank in your code.

Alternatively, paste your workflow over to us?