nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

calculation for turn HEX to decimal in survey123 connect?

anonymous55

Hello

I need to turn Hex number to decimal values in survey123 connect for one question?

do we have any formula or work around to achieve this?

Best

Trouver plus de publications taguées avec

Accepted answers

Raul

You could use the parseInt() javascript function to convert hex numbers to integers.

function hexToInt(hex) {
    return parseInt(hex, 16);
}

Then use the survey123 calculation:

pulldata("@javascript", "functions.js", "hexToInt", ${your_hex_field})

abureaux

While java can do this with less steps, not everyone can use Java in their environment. To do this inside of S123 natively, you can use the attached (at least as a starting point).

input_txt
Your HEX input (only built it for 4 digits, but didn't add a bind::esri:fieldLength).

input_stuff
These calculates isolate the positions of the characters. E.g., substr(${input_txt}, 2, 3) will grab the third character of the string within input_txt. It starts from 0, and reads left to right.

convert_stuff
Will convert the alpha character (A to F) into a decimal number (10 to 15), or return the decimal number (0 to 9) without changing it.

calculate_stuff
multiplies the number by 16^x, where x is the position (This will explain better than me)

output_txt
Your decimal output

S123:

Verification:

Two things:

You can simplify what I have done. I just have all the steps broken down and visible like that so you can see what it is doing. I also stopped at 4 digits because the pattern should be visible from that point.
I kind of messed up my original workflow. The 4 calculates under the input_stuff group were originally in reverse order. Rather than redo everything, I choose to swap their order (see below), which fixed everything. I am telling you this because, unfortunately, this adds an extra step for anyone that wants to expand this beyond 4 digits. Sorry!

Form 1.xlsx

All comments

MobiusSnake

Is everyone using the form in your organization? If so, you could use a JavaScript function, JS can convert hex to decimal pretty easily

abureaux

Should be doable via calculates.

From https://www.binaryhexconverter.com/hex-to-decimal-converter

anonymous55

@MobiusSnake Hey unfortunately I don't know JS. 😞

anonymous55

Thanks @abureaux do you know how can I use this calculation in survey123 Calculate field.

Raul

You could use the parseInt() javascript function to convert hex numbers to integers.

function hexToInt(hex) {
    return parseInt(hex, 16);
}

Then use the survey123 calculation:

pulldata("@javascript", "functions.js", "hexToInt", ${your_hex_field})

abureaux

While java can do this with less steps, not everyone can use Java in their environment. To do this inside of S123 natively, you can use the attached (at least as a starting point).

input_txt
Your HEX input (only built it for 4 digits, but didn't add a bind::esri:fieldLength).

convert_stuff
Will convert the alpha character (A to F) into a decimal number (10 to 15), or return the decimal number (0 to 9) without changing it.

calculate_stuff
multiplies the number by 16^x, where x is the position (This will explain better than me)

output_txt
Your decimal output

S123:

Verification:

Two things:

You can simplify what I have done. I just have all the steps broken down and visible like that so you can see what it is doing. I also stopped at 4 digits because the pattern should be visible from that point.
I kind of messed up my original workflow. The 4 calculates under the input_stuff group were originally in reverse order. Rather than redo everything, I choose to swap their order (see below), which fixed everything. I am telling you this because, unfortunately, this adds an extra step for anyone that wants to expand this beyond 4 digits. Sorry!

Form 1.xlsx

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.