Automaticly copy value of one field to another field on same table

[Igor Baldi]

Hello, I want to know how to copy value from one field to another. It should be automatic for every other entry.

"customer_contact" table, it should copy value from field “email” to “user_name”.

I tried to create BR, but it did not work.

Any suggestions?

[Saiganeshraja · Accepted solution]

In business, rules use actions to set the value. (If both are of the same type) as email and user id fields are the different types we need set from the script :

When to run: before (insert,update)

current.user_id = current.email.toString();

Mark correct and helpful.

[Igor Baldi]

I already try that, but if I try to set actions User ID> same as> email. But email is missing

[Saiganeshraja]

It's because the email field type and user id field type are different. You need to use the script mentioned above.

[Igor Baldi]

I tried this script but it does not work. I set parameters as you wrote down.