Add Approval to a Record Producer before record creation

[Dan R3]

I have a situation where I want to use a record producer to allow users to add their own locations to the cmn_location table, however I want to have an approval on submission so we can confirm the record is accurate and appropriate. 

What would be the best way to do this? 

I don't see an easy way to add an approval to the RP, only by using a SC item and adding a workflow w/ an approval in it...

...thought this would be easier then it apparently seems. Maybe the easy solution is going over my head...

Thanks in advance.

Dan R

[Mark Stanger · Accepted solution]

No problem!  Actually, the request item table is the only table that associates workflows directly in a reference field on a record.  For the rest of the system you go directly to the graphical workflow editor, create a new workflow, and then specify the table and the conditions for which the workflow should be invoked and bound to a record.  Check out this doc and give it a try.  Again, you'll just specify the 'Location [cmn_location]' table as the table for the workflow.

https://docs.servicenow.com/bundle/london-servicenow-platform/page/administer/workflow-administratio...

[Dan R3]

ahh there's the kicker.

1 final question (hopefully):

in the workflow itself, would it just be a single approval activity that exists? If so, then it would just look like:

start --> Approval activity --> end

Does the system know, if approved, create record, and if rejected don't create record? or is that something I need to put in? (if so, how would that be added?) 

[Mark Stanger]

This solution won't prevent the creation of the record.  It runs because the record has already been created.  The idea here would be to create the record in some pending or inactive status and then once the approval has been approved you could change the status of the location record to make it usable.  If the approval was rejected you could delete the record.

If you wanted to wait until you created the location then you would probably want to use a request item (or maybe some other ticket type).  You're not going to use a record producer running against the 'cmn_location' table specifically.  Your workflow would run against the ticket (or item) you create and run an approval.  Once the approval was processed as approved you could run a script to create the location record.

[Dan R3]

thanks for all your help on this. Marking correct and helpful.