How to load a relate field into another field

Forgive me, but I would question the underlying requirement, what is the basic reason behind the request?

It looks like you are taking the name, or user_name, of the related User and putting it in a Text field, is that correct?

What will you do with that text field that you can't do with the Relate field?

FrancescaS

Hi Francesca Shiekh - The main reason that you can create a workflow based on a text field and not a relate field. The goal was to auto generate an email when the text field changes which is not available using the standard workflow tool in the professional version.

In that situation I would do a logic hook that looks to see if the relate field has changed, and if so triggers your workflow. It's a simple process of comparing the field content before and after the changes are made. 

I have not played with Workflows in Professional, we only had a couple when it was communicated, quite some time ago, that workflow would go away from Professional version so I converted those few to logic hooks, but I am guessing there is a way to use workflow, perhaps by checking the relate field's ID rather than the field itself, and you can find that name in the vardefs in your cache file.

Best of luck.

Francesca

In that situation I would do a logic hook that looks to see if the relate field has changed, and if so triggers your workflow. It's a simple process of comparing the field content before and after the changes are made. 

I have not played with Workflows in Professional, we only had a couple when it was communicated, quite some time ago, that workflow would go away from Professional version so I converted those few to logic hooks, but I am guessing there is a way to use workflow, perhaps by checking the relate field's ID rather than the field itself, and you can find that name in the vardefs in your cache file.

Best of luck.

Francesca