question Re: Show Hours Only in Duration in Developer forum

Show Hours Only in Duration

Beto — Wed, 21 Mar 2018 17:43:59 GMT

How can I see only hours? Either removing minutes and seconds fields OR having them disabled (read-only).

Re: Show Hours Only in Duration

Oleg — Wed, 21 Mar 2018 18:06:14 GMT

There are currently no option/attribute of duration, which will display the duration in the form in which you need. I had the same requirement and wrote small function, which use DOM manipulations to hide unneeded input fields. To de mostly safe I initialized doc, win and table variables first of all by the following code:

var doc = g_form.getControl("someElementFromTheForm").ownerDocument,
	win = doc.defaultView,
	table = g_form.getTableName();

where someElementFromTheForm is the column name of some element of the form. The main code is the following:

var hideMinSecFields = function (field) {
		function getElem (field, suffix, prefix) {
			return doc.getElementById((prefix || "") + table + "." + field + (suffix || ""));
		}
		var controlHour = getElem(field, "dur_hour", "ni."),
			controlMin = getElem(field, "dur_min", "ni."),
			controlSec = getElem(field, "dur_sec", "ni."), cs;			

		if (controlMin != null && controlMin.style != null) {
			controlMin.style.display = "none";
		}
		if (controlSec != null && controlSec.style != null) {
			if (win != null && win.getComputedStyle != null) {
				cs = win.getComputedStyle(controlSec, null);
				if (controlHour != null && controlHour.style != null && cs != null) {
					controlHour.style.borderRightStyle = cs.getPropertyValue("border-right-style");
					controlHour.style.borderRightWidth = cs.getPropertyValue("border-right-width");
					controlHour.style.borderRightColor = cs.getPropertyValue("border-right-color");
					controlHour.style.borderBottomRightRadius = cs.getPropertyValue("border-bottom-right-radius");
					controlHour.style.borderTopRightRadius = cs.getPropertyValue("border-top-right-radius");
				}
			}
			controlSec.style.display = "none";
		}
	};

To hide the min/sec fields you need just call hideMinSecFields function with the name of the duration field as parameter.

Re: Show Hours Only in Duration

Beto — Wed, 21 Mar 2018 22:41:29 GMT

How do I run this? onLoad client script?

Re: Show Hours Only in Duration

Oleg — Thu, 22 Mar 2018 04:22:45 GMT

Yes of cause. It's a part of code, which will be start onLoad.

Re: Show Hours Only in Duration

Beto — Thu, 22 Mar 2018 17:45:12 GMT

Sorry, can you give me the steps? I'm not sure where and how to implement this.

Re: Show Hours Only in Duration

jayesh mohan2 — Thu, 22 Mar 2018 19:18:13 GMT

You cannot use getControl with duration field.

Re: Show Hours Only in Duration

Oleg — Thu, 22 Mar 2018 21:57:21 GMT

I'm not sure what you mean under "You cannot use getControl with duration field". Do you mean that it's not allowed? I posted fragment from the code of application, which is certified by ServiceNow and which is available on https://store.servicenow.com/.

Re: Show Hours Only in Duration

Oleg — Thu, 22 Mar 2018 22:01:09 GMT

I'm currently in business trip, but I'll try to post at the weekend more full example of the code or small demo application on GitHub, which uses the code, which I posted.

Re: Show Hours Only in Duration

Oleg — Thu, 22 Mar 2018 22:24:52 GMT

Let us you have the table with some duration fields, for example, field1 and field2. You can create Client Script with type onLoad, which has the following code:

function onLoad() {
	var doc = g_form.getControl("field1").ownerDocument,
		win = doc.defaultView,
		table = g_form.getTableName(),
		hideMinSecFields = function (field) {
			function getElem (field, suffix, prefix) {
				return doc.getElementById((prefix || "") + table + "." + field + (suffix || ""));
			}
			var controlHour = getElem(field, "dur_hour", "ni."),
				controlMin = getElem(field, "dur_min", "ni."),
				controlSec = getElem(field, "dur_sec", "ni."), cs;			

			if (controlMin != null && controlMin.style != null) {
				controlMin.style.display = "none";
			}
			if (controlSec != null && controlSec.style != null) {
				if (win != null && win.getComputedStyle != null) {
					cs = win.getComputedStyle(controlSec, null);
					if (controlHour != null && controlHour.style != null && cs != null) {
						controlHour.style.borderRightStyle = cs.getPropertyValue("border-right-style");
						controlHour.style.borderRightWidth = cs.getPropertyValue("border-right-width");
						controlHour.style.borderRightColor = cs.getPropertyValue("border-right-color");
						controlHour.style.borderBottomRightRadius = cs.getPropertyValue("border-bottom-right-radius");
						controlHour.style.borderTopRightRadius = cs.getPropertyValue("border-top-right-radius");
					}
				}
				controlSec.style.display = "none";
			}
		};
	hideMinSecFields("field1");
	hideMinSecFields("field2");
}

It's the same code, which I posted before, but where I posted before. The controls in the form will be displayed without min/sec. Something like on the picture below:

Re: Show Hours Only in Duration

Oleg — Sat, 24 Mar 2018 12:04:34 GMT

You can download a test application with one table and one form, which uses the script, from here: https://github.com/OlegKi/Show-Hours-Only-in-Duration

Re: Show Hours Only in Duration

dmullinax — Tue, 30 Aug 2022 18:22:26 GMT

Thanks everyone. So there is no out-of-the-box solution other than high-level customization through the use of DOM manipulation which could be prone to errors during new releases?

Re: Show Hours Only in Duration

zynsn — Tue, 21 May 2024 00:19:34 GMT

Was anyone able to hide the seconds field box on the portal?