I am trying to auto populate a number field from a custom text field on transition using automation.
I have a custom text field that holds a hexadecimal value, which I would like to convert to decimal value and populate that in to a number field when transitioning the state from any-state to "done".
I am able to read the string from the custom-text field using automation but am unable to change the format to decimal
tried using field.asNumber.format option, but its not working (changes value to None)
Example value in text field - 0xA
Expected value in number field - 10
How can I achieve this during the automation?