You are viewing limited content. For full access, please sign in.

Question

Question

Field Constraints Won't Fill In With "Assign Field Values" Task

asked on April 14, 2015

I am in the process of changing templates on existing files.  One of the templates I am changing to has a field for Social Security Number (text field) with constraints for SSN applied (\d\d\d-\d\d-\d\d\d\d).  The template I am removing has a field for Social Security Number (text field) but no constraints.

When I use a workflow to retrieve data from the old template and assign it to the new template it will not copy over the Social Security Number.

 

This is the error message I get in the workflow.

 

Suggestions on how to get the SSN into the new template?

 

Thanks.

0 0

Answer

SELECTED ANSWER
replied on April 14, 2015

Hi Jennifer,

See the screenshot below for a sample workflow. Note that I'm using a Pattern Matching activity to split up the social security number (without formatting) into three different segments. Then I'm assigning the pattern matching values to the new social security number field as "segment1-segment2-segment3"

1 0

Replies

replied on April 14, 2015 Show version history
 
 
Hi Jennifer,

 

You'll have to convert the data being pulled from the old template 333224444 to accommodate the new constraint 333-22-4444.

 

To do this use the Token Dialogue and apply the format \d\d\d-\d\d-\d\d\d\d to the value before assigning to the new field.

 

 

 

Cheers,

Carl

 
 
 
 
 
 
 
0 0
replied on April 14, 2015

Already tried to apply formatting.  Unless I am typing something it does not work for me.  I still get the same error as when I don't apply formatting.

 

0 0
replied on April 14, 2015

Perhaps my constraint is set up wrong?

 

0 0
replied on April 14, 2015

Splitting into 3 parts worked great!  Thanks.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.