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

Hi,

when you want to copy value after or before changing the executive summary field?

Thanks.

John Oliver Man · ‎01-17-2020

It was after changing the executive summary field

Dhananjay Pawar · ‎01-17-2020

Hi,

Then change before BR to after BR.

John Oliver Man · ‎01-17-2020

Hi,

It was already in After BR.

Dhananjay Pawar · ‎01-17-2020

Hi,

have you checked update tick box,If not then make it true and check once again.