Creating an app for requesting an Update/Addition/Deletion to Records in a Table with approvals

[joeypro24]

I am currently trying to create an app for my team that a user can make a request to update/add/delete records in a data table. I am currently using the app engine studio to accomplish this, using either a record producer or standard catalog item request as the interface. My biggest issue is having all of this automated so that when a user makes a request for and addition/deletion/update is to have it go through 2 levels of approval and have the app, if approved, make the addition/deletion/update automatically to the table. Any help is truly appreciated. 

[AshishKM]

Hi @joeypro24 ,

It's good that you are trying to build app via AES, so what's issue where you stuck with approvals/or/automation. Do you have high level design, flow and form fields some where documented. On which table you are using to build this app, how users can make a request, from catalog item. 

Please share some more technical details where you stuck, which will help us to understand the app ( in design ) process.

-Thanks,

AshishKMishra

[joeypro24]

Hello @AshishKM ,

I am very new to ServiceNow, so far within AES I have created customized data table that is simply for tracking records with specific fields. Next, I created (in "Experience") a record producer and a catalog item (I don't know which one is more appropriate) for users within ServiceNow to be able to request new additions, changes and/or deletions to that data table. My difficulty comes in tying these together (Data and Experience) with a workflow that when a request is made through the record producer and/or catalog item an approval process is triggered that if approved (through 2 levels of approval) a new record is created or an existing record is updated/deleted.  

I have attached 2 rough workflows, but I am rather lost on tying this all together. Any help is appreciated.

Joey

[Dr Atul G- LNG]

Hi @joeypro24 

I don't think , you need to create app for same. You can achive this via Catalog Item. 

3 Variable 

- Add

- Update

- Delete

Use MRVS to get the data.

- Table name.

Submit.

Once submit, in flow  check is it for add / delete / update and according create task with auto fulfilment. ( Write script to do the work), if work  successful, close the task else crate a new task for manual update and to find cause of failure. 

[joeypro24]

Hello @Dr Atul G- LNG ,

I am brand new to ServiceNow would you be able to elaborate on your suggestion. I have a customized data table that my team needs to track the data in. It will need a workflow to automate any updates/additions/or deletions in, with 2 levels of approval. The requests to these changes in the table would need to be done within a record producer or catalog item. Once the request is made an approval process would need to be triggered and if approved would automatically make the update, addition or deletion to a record within that table. 

Thank you,

Joey