I'm trying to build a nested IIF statement in a dynamic table that will populate a field I'm using to show an image in my popup window on Portal.
Works:
IIF([MUTCD_ID]="UNK", "no image",IIF([SIGN_CATEGORY]=1,"regulatory","no image"))
Doesn't work:
IIF([MUTCD_ID]="UNK", "no image",IIF([SIGN_CATEGORY]=1,"regulatory/[MUTCD_ID]","no image"))
Row Info
Row Number 2
TableName: Sign
FieldName: EXISTING_IMAGE_LINK
ValueInfo: IIF([MUTCD_ID]="UNK", "no image",IIF([SIGN_CATEGORY]=1,"regulatory/[MUTCD_ID]","no image"))
ValueMethod: EXPRESSION
On Create: 0
On Change: 0
Checking for Subtype Restriction
Field Name: EXISTING_IMAGE_LINK was found at index: 31
Trying: EXPRESSION
replace field: SIGN_CATEGORY with a value
replace field: MUTCD_ID with a value
replace field: MUTCD_ID with a value
Checking to verify there is a field to store the expression
Expression to be eval: IIF("R7-1"="UNK", "no image",IIF(1=1,"regulatory/"R7-1"","no image"))
ERROR: evaluating the expression for feature in Sign with OID of 10419
Expected ')'
Finished: EXPRESSION
I don't know why it is expecting a closed parentheses. I've tried various things and it keeps throwing out this same error. The expression that works has the same number of parentheses.