How to calculate total recurring cost in Service Catalog item field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2018 10:53 AM
I have created a Service catalog item with 2 Single Line Text fields. The first Text field is for the Monthly Recurring Cost while the second field is for the Yearly recurring field. I would like the Yearly recurring field to automatically calculate the sum of monthly x 12 when a number is entered in Monthly recurring field. Can someone please show me how I can achieve this? Thank you!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2018 12:03 PM
You need to write onsubmit catalog client script to achieve this.
For setting Currency via client script there is a great post here
https://community.servicenow.com/people/russ.sarbora/blog/2012/07/20/2543
Regards,
sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2018 08:49 AM
Thanks but can you provide me a sample script. I am still new to this so cannot wrap my head around the post you referenced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2018 12:17 PM
Thanks but the post you referenced is not quite what I am looking for. If you think it is, I am not that great at scripting to make the translation.
I need to be able to enter an amount in a field called "monthly recurring cost" and have another field called "Yearly recurring cost" automatically show the sum of the amount entered in monthly recurring cost field x12. In simpler terms, I need the yearly recurring cost field to auto calculate based on what is entered in monthly recurring field. Any body else with ideas on how I can achieve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2022 09:33 PM
Please have a look into this article. This might be of some help: