View Single Post
 
Old 02-15-2013, 10:45 PM
thpanos thpanos is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Nov 2012
Posts: 6
thpanos is on a distinguished road
Default 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?
Reply With Quote