Catalog item Priority Rating Variable auomation

[surajsukuma]

I have a catalog item that includes a field called "Priority Rating," which allows selection from 1 to 50.

The task owner determines the Priority Rating based on the nature of the request.

The requirement is to automatically adjust the Priority Ratings once a previous task is completed.

For example, if the first ticket is completed, the second ticket should be moved to a Priority Rating of 1, and the third ticket should be moved to a Priority Rating of 2.

Is there a way to build this? 

Thanks in advance. 

[Ankur Bawiskar]

@surajsukuma 

Since the task owner should fill the Priority Rating during catalog item submission, how are you informing that user that there are already 4 Request raised and now he/she has to give 5 as next value?

If this is to be automated then why are you allowing them to select that variable?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[surajsukuma]

Priority Rating, will be selected by the Assignment group owner, not on Submission time. 

[Ankur Bawiskar]

@surajsukuma 

so please answer the next question

how are you informing that user that there are already 4 Request raised and now he/she has to give 5 as next value?

[surajsukuma]

When a new ticket is created, the Group Member will check the available next number and update it manually. If a new catalog item is created and the priority is already at 20, the member will mark it as 21 for new item. After that, any subsequent changes need to be updated based on the ticket closing order.

This is something new for me, and I am not sure if I will be able to configure it in ServiceNow.