Text Area fields in Triggered actions?

[roattw]

I have a triggered action that copies fields from one table to another when a certain condition is met.  It works well.  However, I just tried to add a text area field to be copied from one table to another with that triggered action and it errors on validate, highlighting the text area field as the issue.  Is it because a 64000 Text Area cant be used in a TA?  Nothing special about the field (not calculated, etc) - just text.

[cheonsa]

14 minutes ago, roattw said:

Thanks for the reply IIyrian, and sorry for the late response.  It is interesting why mine is a mismatch.  Verified both are TextArea (64000).  But get 2088: Mismatch data type error.  Obviously, Im missing something  ;^)  Doe the #insterted change things somehow?  This is on an update trigger.

 

Hi @roattw,

The reason why you are getting a Mismatched Datatype error is that your destination field is a Text(255) field only.  Though they are both texts, the number of characters in your source field might exceed the number of allowed characters in the destination field.

You can use this block under the Text tab to make it work.

 

Hope this helps  

 

[Ilyrian]

Hi @roattw,

I have checked your suggested workflow on my end. For me, I could use TextArea in the Triggered Action.

 

One thing maybe to have into consideration is that you need to pay attention to the datatypes. For example, you can not save TextArea value to Text255 field.

[roattw]

Thanks for the reply IIyrian, and sorry for the late response.  It is interesting why mine is a mismatch.  Verified both are TextArea (64000).  But get 2088: Mismatch data type error.  Obviously, Im missing something  ;^)  Doe the #insterted change things somehow?  This is on an update trigger.

 

[roattw]

Thanks for that answer!  Cant believe I missed that.  Never knew the small case vs large case "T" icon.