Number fields on catalog item

[MBMRED]

How do I create pure number fields on a catalog item?

I have a requirement to fire an approval on a catalog item if the field "Hours" is greater than 24.  I created the field as a Single Line Text with a Number validation rule.  The issue is that the validation rule works in that it only allows integers, but it still compares values as text, meaning any number starting with 3 will be evaluated as greater than 24. 

So, how do I create a pure number field? I'm amazed that there aren't any "number" (integer, floating, money) data-type fields available for catalog items. 

Fortunately, I'm able to use the duration data type because the question is related to time.  If I needed to do math on a number field, I'm not sure how I would do that without writing code.

Thanks for any guidance on this.

[Ashish Parab]

Hello @MBMRED,

You can add a logic in a flow as below.

- Create one integer type flow variable.

- Assign your number validated single line variable to that flow variable.

- Use that flow variable to compare if that entered value us greater than 24 or not. And then Ask for a Approval.

Flow actions look something like this.

Please mark this as "correct" and "helpful" if you feel this answer helped you in anyway.

Thanks and Regards,

Ashish

[Ashish Parab]

Hello @MBMRED,

Hope you are doing well.

If you feel my answer helps you, please 'Accept' it, mark it as 'Helpful,' and close the thread so that future community readers can use it.

Have a great day!

Thanks,

Ashish