@SETFIELD Error

HCL Domino Domino Forum
1

If I use the following formula to set the PERMITSTARTDATE it works fine.@If(DocAndDrawingStatus=“”&(GMR=“MP”|GMR=“NM”)&(ZEM=“MP”|ZEM=“NM”);@SetField(“PermitStartDate”;@Today);“”)

If I use the following formula to set the DOCANDDRAWINGSTATUS it works fine.

@If(DocAndDrawingStatus=“”&(GMR=“MP”|GMR=“NM”)&(ZEM=“MP”|ZEM=“NM”);@SetField(“DocAndDrawingStatus”;“Passed”);“”)

If I combine the SETFIELDS I get an error, it sets the fields but has any eror for incompatability.

@If(DocAndDrawingStatus=“”&(GMR=“MP”|GMR=“NM”)&(ZEM=“MP”|ZEM=“NM”);@SetField(“PermitStartDate”;@Today)&@SetField(“DocAndDrawingStatus”;“Passed”);“”)

Is there a way to combine2 @SETFIELDS in the same If statement?

The error is “incorrect data type for operator or @function :number expexted”

Thanks in Advance

JA

2

Subject: @SETFIELD Error

Try this@If(DocAndDrawingStatus=“”&(GMR=“MP”|GMR=“NM”)&(ZEM=“MP”|ZEM=“NM”);@Do(@SetField(“PermitStartDate”;@Today);@SetField(“DocAndDrawingStatus”;“Passed”));“”)

3

Subject: RE: @SETFIELD Error

Thanks Steve,Very helpful.