Convert Decimal to HEX Format

[Wernon]

Hi,

I want to create a  converter from decimal to HEX format. All the values are saved in the table.

So the form should take the decimal number from the table field 1, convert and save the HEX value to field 2. 

 

I did not find any SQL solution. 

 

I would appreciate any ideas regarding the solution. 

 

 

 

[George43]

I had this case and I just used single update form as Data Page.

• I Used "NumberNormal" as column name i should to convert.
• Added another column with name HexNum.
• After that i added simple HTML block in the bottom of Update Data Page and put this snippet of code.

 

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {

var normal = Number(document.querySelector("#EditRecordNumberNormal").value);
hexString = normal.toString(16);
if (hexString.length % 2) {
hexString = '0' + hexString;
}

document.querySelector("#EditRecordHexNum").value = hexString;
});
</script>