Copy / Move field values from one table to another

John Oliver Man · ‎01-16-2020

Hi,

I have 2 tables:

task table (task)
reason for change table (u_reason_for_change)

I have fields named "executive summary" and "cause of outage". Once I input one of those in task fields and submit the task, it was not copied in the reason for outage fields named "executive summary" and "cause of outage" also. Can you give me a idea on how to do it? Thanks.

Tony Chatfield1 · ‎01-16-2020

Hi, if you are copying the data to another table and not updating the currect with a relationship to the new record you would use and after business rule. If you want to update a relationship back into the current table you should use a before br so you can update current with details after your related insert. You need a glide query to initialise a new record, map the values you want to populate and then insert the new record.

View solution in original post

Dhananjay Pawar · ‎01-17-2020

Check attached screenshot for reference.

Shrutika Surwad · ‎01-17-2020

Hi,

Everything is fine but u need to add

rfo.update(); because u r writing a after BR.

Hope this helps you

Thanks,

shrutika

John Oliver Man · ‎01-17-2020

I tested the code. It works, but the values goes to another record and didn't matches the child table (u_reason_for_outage)

Dhananjay Pawar · ‎01-17-2020

Hi,

Do you have any common field between both table?

Make sure both table have at least one common field.

Thanks,

Dhananjay.

John Oliver Man · ‎01-17-2020

Okay,

We'll be creating a common field.