How to deduct the quantity from consumable table when any item(mouse, keyboard) is consumed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2024 12:14 AM
Hi All,
I am having a requirement, in a catalog item, there are variables such as what type of mouse needed, what type of keyboard needed, etc
When they select type of mouse, it should then check in the alm_consumable table which contains the name , quantity, status availability and assigned to , etc fields
If quantity is available for the mentioned type, then the quantity count has to be deducted from that record in consumable table and it has to be assigned to the user who raised the request.
If quantity is 50, then 1 has to be deducted and the quantity should gets updated as 49 and it has to get assigned to the requested for
In the workflow , I am writing the Run script but not sure how to get that assign to requested for and quantity updation
Please guide here