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-19-2020

Hi,

Any updates on this.

Thanks,

Dhananjay.

John Oliver Man · ‎01-20-2020

Hi,

Upon checking, the Parent.Number is the common field. Is there anyway to copy the values of fields from parent to child?

Thank you.

Dhananjay Pawar · ‎01-20-2020

Yes,Using script include you can copy one table value to another.

Shrutika Surwad · ‎01-17-2020

hey,

Create an after update Business Rule

In Script section write the below code.

var gr = new GlideRecord("u_reason_for_outage");

gr.initialize();

gr.u_executive_summary = current.executive_summary;

gr.insert();

Hope this helps you

Thanks,

shrutika