How do I insert text into one field based on the contents of another field?

[M. Swartztrauber]

I'm trying to use rules to insert different text strings into one
field based on the existence of a few letters or a phrase present or
not in a previous field. Is this possible?

 

[Josh Bertsch [MSFT]]

Set the condition to evaluate based on "contain" or "does not contain"
certain characters or strings.

--josh bertsch

 

[M. Swartztrauber]

Thanks.

However, none of the possible actions seem to accomodate an automatic
text entry. I thought it might be "Set a field's value" but this
appears to be for a logical or numerical result.

Am I missing it?

 

[Josh Bertsch [MSFT]]

You are on the right track.

There are two things to keep in mind. Rules fire based on the field with
the rule changing. So if you want to populate field2 when field1 contains
something specific, set the rule on field1.

The second is that the Condition Builder that is part of the "Set a field's
value" is just an XPath builder. So any XPath will work. Quotes are used
for literal strings. Further, literal strings can just be typed into the
text well without having to go into the condition builder.

If this still isn't what you are looking for, you may need to provide a more
detailed explanation of your scenario.

In it's simplest form, with Rules in your scenario as i understand it, you
can type "foo bar" in field1 and field2 will be populated with some text
because "foo" is contained in field1.

--josh bertsch

Thanks.

However, none of the possible actions seem to accomodate an automatic
text entry. I thought it might be "Set a field's value" but this
appears to be for a logical or numerical result.

Am I missing it?


"Josh Bertsch [MSFT]" <[email protected]> wrote in message

Set the condition to evaluate based on "contain" or "does not contain"
certain characters or strings.

--josh bertsch