How to add the variable information from catalog item to the table

[MG_Azam]

Hi Community,

I have been trying to get the information from the catalog item and store it in a table but I'm facing an issue.

Whenever a new catalog item is created I want it to be stored as a record in a table by copying all the data from the catalog item provided by the requestor.  

[MG_Azam]

the fields which are already created are not being updated

[Danish Bhairag2]

Hi @MG_Azam ,

Oh so the data will obviously will not get populated in project request record. Here is the sample how u can do it. There will be a Record producer script where u can write code as below.

current.short_description = producer.x;

current.work_notes = producer.user_id ;

Please use proper backend name of the variables. Current object refers to the target table where u want to populate data so field names should correspond accordingly. Producer object is ur record producer so map the variable's backend name accordingly after producer.

Thanks,

Danish

[MG_Azam]

noted, and do I need to create new fields in the table that are not available in comparison to catalog item

[MG_Azam]

let me tell you the whole picture once

The Table was created with a record producer(catalog item), and we added a few more fields to the record producer as Variable sets, I want the variable sets to be populated in the table which is not happening. as generally it should inherit the field right.

[Danish Bhairag2]

@MG_Azam ,

Adding some screenshot for better understanding

Right hand side fields are from record producer. Left hand side fields are from target table.

U need to write that record producer script there. Script option will appear when u select redirect to - Generate Task Record.

Thanks,

Danish