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.  

[Kai Tingey]

you can use flow designer for this. Just have it run on service catalog trigger, get the catalog variables, and then create a new record in your table with the values from the variables. Assign the flow to the catalog item and it will run when the request is submitted.

let me know if you need more assistance with this.

[MG_Azam]

can we do that without triggers and it is a record producer based catalog item.

[Kai Tingey]

sure, just change the trigger to record created, then specify the table that your record producer is for, and any filters you need to make sure you are catching the right items.

[Danish Bhairag2]

Hi @MG_Azam ,

May I know why you want to do this?

For any catalog item whenever any request raised the information related to that are anyways available in the variable editor of an RITM by default. You can just navigate to that ticket & see wht was submitted by the requestor.

The thing which you are asking let's say if we go ahead with implementing that it is not easy as it looks like,the reason being every catalog item will have different set of variables in them & in order to store it in a table u need to have those fields already available in your custom table(assuming here we talking about multiple catalog items which means multiple forms data u wish to store).

If it is just for one catalog item ,then I could suggest you to write an after insert business rule on RITM  table ,once record gets entered in it run the BR which will copy the data to ur custom table.

Thanks,

Danish