by
1 Solution
Accepted Solutions
by
by
by
by
by
Appreciate the input, thanks! This option will have to do for now. Here's what my implementation looks like:
HHMM is a TEXT field that the user types in, HH is a FLOAT field that gets calculated. Figured reading HH would be more intuitive to understand than MM, but the concept is the same.
I try to use the same "template" for Attribute Rules, so this is probably overly verbose, but here's the automatic calculation from HH:MM text to HH float:
/*
Converts a text HH:MM format field and converts it to a float HH field.
*/
//---------------------------------------------------------------------//
// FUNCTIONS
function calculateHH(hhmm) {
// Set up results dict. If all checks pass, return this as-is.
var result = Dictionary("VALUE", null, "ERROR", null)
if (IsEmpty(hhmm)) {
return result
}
Console(hhmm)
var timeArr = Split(hhmm, ":")
var hh = Number(timeArr[0]) + (Number(timeArr[1]) / 60)
Console(`${hhmm} --> ${hh}`)
result["VALUE"] = Round(hh, 2)
return result
}
//---------------------------------------------------------------------//
// INPUTS
var hhmm = $feature.Hiking_HHMM
//---------------------------------------------------------------------//
// MAIN
var fldUpdates = Dictionary()
// Convert HHMM text to MM float ----------------
var result = calculateHH(hhmm)
if (!IsEmpty(result["ERROR"]))
{return {"errorMessage": `ERROR: ${result}`}}
else
{fldUpdates["Hiking_HH"] = result["VALUE"]}
Console({"result": {"attributes": fldUpdates}})
return {"result": {"attributes": fldUpdates}}
And my solution to verifying the initial HH:MM inputs:
/*
Script provides validation for a TEXT field that should contain a time duration
in the format H?H?:MM. There are several checks, since RegEx is not available.
1) Blank strings are not allowed; null values are fine
2) Format must contain a colon--as in 3:30, 12:04, :37
3) Values on either side of the colon must be numeric
4) Hours are optional, but must be 0 - 23
5) Minutes must always be two characters, and numeric values 0 - 59
This script is meant to be used as Calculation type AR, rather than a
Constaint AR.
*/
//---------------------------------------------------------------------//
// FUNCTIONS
function timeValidate (time) {
// Set up results dict. If all checks pass, return this as-is.
var result = Dictionary("VALUE", time, "ERROR", null)
// First check empty, then null. Can't do both simultaneously nicely.
if ((TypeOf(time) == "String") && Trim(time) == "") {
result["ERROR"] = "Blank input is not allowed."
return result
}
else if (IsEmpty(time)) {
return result
}
// Console(timeArray, Count(timeArray));
// Must contain one ":", yields two elements with Split().
if (Count(timeArray) != 2) {
result["ERROR"] = "Format must contain one colon."
return result
}
// Check if both values in the array are numbers.
for (var i in timeArray) {
var tPart = timeArray[i]
Console(`PART: ${i}, VAL: ${tPart}, ASNUM: ${Number(tPart)}, ISNAN: ${IsNan(Number(tPart))}`)
// If Number returns NaN, "Casting a non-numeric text or undefined to a number".
if (IsNan(Number(tPart))) {
result["ERROR"] = "At least one value is not numeric."
return result
}
// Hours validation, the first array item.
if (i == 0) {
Console(`VALIDATING HOURS: ${tPart}`)
// Comparison operators coerce Text to Number for comparison.
if (tPart > 23 || tPart < 0) {
result["ERROR"] = "Hours must be 0-23."
return result
}
}
// Minutes validation, the second array item.
else if (i == 1) {
Console(`VALIDATING MINUTES: ${tPart}`)
if (Count(tPart) != 2) {
result["ERROR"] = "Minutes must be two digits."
return result
}
else if (tPart > 59 || tPart < 0) {
result["ERROR"] = "Minutes must be 0-59."
return result
}
}
}
return result
}
//---------------------------------------------------------------------//
// INPUTS
// Expects($feature, "Shape_Length", "MPH", "Miles")
var time = $feature.Hiking_HHMM
// DERIVED
var timeArray = Split(time, ":")
Console(`TIME ARR: ${timeArray}`)
//---------------------------------------------------------------------//
// MAIN
var fldUpdates = Dictionary()
// result = {"VALUE": time, "ERROR": error string OR null}
var result = timeValidate(time)
// If an error is returned in results dict, show and make no changes.
if (!IsEmpty(result["ERROR"]))
{return {"errorMessage": `ERROR: ${result} Please use H?H?:MM format.`}}
// Else, add the field update information to the running updates log.
else
{fldUpdates["Hiking_HHMM"] = time}
Console({"result": {"attributes": fldUpdates}})
return {"result": {"attributes": fldUpdates}}
