Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am adding a trigger to a field in document properties using the following if statement
=If(GetFieldSelections([Analytical Type])='Timeliness',1,
If(GetFieldSelections([Analytical Type])='Accuracy',2,
If(GetFieldSelections([Analytical Type])='Completeness',3,
If(GetFieldSelections([Analytical Type])='Validity',4,
0))))
However I keep getting the error above.
Any ideas what wrong?
Don't see anything wrong, but you can try with this
=Match(GetFieldSelections([Analytical Type]), 'Timeliness', 'Accuracy', 'Completeness', 'Validity')
Are there any hidden brackets before adding your IF script just click Ctrl+A and delete. Then add the IF statements. Just in case..
remove the = sign infront of the expression
If(GetFieldSelections([Analytical Type])='Timeliness',1,
If(GetFieldSelections([Analytical Type])='Accuracy',2,
If(GetFieldSelections([Analytical Type])='Completeness',3,
If(GetFieldSelections([Analytical Type])='Validity',4,
0))))
Hello Ziad,
i wonder why = sign would effect here?
Hello,
I came across this problem recently...you can put the GetFieldSelections([Analytical Type] in a variable and then use your expression like this:
If($(YourVar)='Timeliness',1,
If($(YourVar)='Accuracy',2,
If($(YourVar)='Completeness',3,
If($(YourVar)='Validity',4,
0)
)
)
)
Hope it helps,
Andrei
Maybe replace the second equal sign by a comma?
Fixed