Conditional Fields With String Functions, Office 2010
Hi,
I am trying to insert string functions in the TrueText or FalseText of a conditional field.
I did not succeed to find any documentation on this topic.
Example:
{IF {docproperty customprop1}<>"" "txt1" "txt2"}
It works OK, returning txt1 or txt2.
What if I want to replace "txt1" with "txt1"+left({docproperty customprop2}, 2)? (+ or & or ...)?
or replace "txt1" with MID("txt1", 1, 2)
The same with MID, INSTR, RIGHT functions
Unfortunately it seems that we cannot use string functions on the TrueText or FalseText of the condition
or manipulate custom property values with string functions.
Any ideas?
|