How to move data between tables from one field to another

terrieb
Tera Guru

So I have a question I am seeking a solution for:

 

I have a Idea Record that has on the catalog item to produce the record a set of questions for the submitter to answer.  Once sumbitted, it creates an Idea and fills in the answers to the questions in the fields on the form.

 

The workflow behind it works that if the Idea is approved, it creates a Demand.

 

What the Demand manager wants to know if there is a way that those answers in those fields on the Idea record could auto populate into fields on the Demand record once this workflow completes.

 

The questions on the Idea item are mapped to the fields on the Idea form, so can they be mapped to the Demand form as well?  Maybe a business rule or a client side script???

 

Thanks!

1 REPLY 1

Jaspal Singh
Mega Patron
Mega Patron

Hi,

You can instead use a BR that runs after insert on Demand table that GlideRecords Idea table and get the values.