Can we create a new table record instead of Request Item when we click on order now in catalog item page ?

Ajai S Nair
Giga Guru

Hi All,

I have a requirement to create a catalog item in such a way that when submitted it will create a record in another table not in request item. The details entered in the form should not be saved in variable ownership table. It should be only visible to some security group. So the record should be in a new table. I have different levels of approvals and a workflow in it so wont be able to do this with record producer.

I tried creating a workflow on the new table and attach it on the catalog item but it is creating a new request item and attaching this workflow to that.

Any help is appreciated .

Regards,

Ajai

7 REPLIES 7

palanikumar
Mega Sage

Hi Ajai,



I suggest you to use Record Producer rather than Catalog Item for your requirement. You can map record producer to specific Catalog / category and make it work like Catalog Item except that it will be mapped to a table in the backend.



Please refer this URL for more details:



http://wiki.servicenow.com/index.php?title=Record_Producer#gsc.tab=0


Thank you,
Palani

Hi Palani,



As I have already mentioned in my question, I have different levels of approvals. Upon approvals from all the item should be created. So as per my knowledge a workflow cannot be tagged directly to a record producer and so the producer will create the record as soon as we click on the submit button.It wont wait for any approvals to be done since we cant assign a workflow directly.So I can't achieve this using a record producer.



Refer link below for details:


http://wiki.servicenow.com/index.php?title=Record_Producer#gsc.tab=0



Only way to attach a workflow here is create some condition based on the fields in record producer and thereby attach a workflow. I am already checking the same but confused with the condition and that is why I have posted this here.


If you have any ways to do approvals in Record producer then please tell me.


Hi,



You can create workflow and attach it to the table. Once the record is inserted into the table(via record producer or directly using a form) workflow will get triggered and you can trigger the approval process.



Thanks!


Thank you,
Palani

Change is a non RITM table and you sure must have seen workflow on that table. Correct? So does that answer your question of record producer and workflow ?