• OG
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
hi,

I'm trying to translate the following Google Sheet formula into in custom field formula on a Contact record.
 
=JOIN("", ARRAYFORMULA(MID(DEC2HEX(A2), LEN(DEC2HEX(A2)) - ROW(INDIRECT("1:"&LEN(DEC2HEX(A4)))) + 1, 1)))&CHAR(MOD(A2, 17) + 65)
Where A2 would be a custom field reference.

The first step is to translate the value in A2 to hexadecimal, the second step is to reverse the string. The third step is to calculate modulo 17 (the remainder when the number is divided by 17).This number will always be a number from 0–16. Map that number onto the letters A–Q, where 0=A, 1=B, 2=C, etc.  Finally, concatenate each of those pieces together.

Many thanks for any help here
 
  • October 14, 2022
  • Like
  • 0
hi,

I'm trying to translate the following Google Sheet formula into in custom field formula on a Contact record.
 
=JOIN("", ARRAYFORMULA(MID(DEC2HEX(A2), LEN(DEC2HEX(A2)) - ROW(INDIRECT("1:"&LEN(DEC2HEX(A4)))) + 1, 1)))&CHAR(MOD(A2, 17) + 65)
Where A2 would be a custom field reference.

The first step is to translate the value in A2 to hexadecimal, the second step is to reverse the string. The third step is to calculate modulo 17 (the remainder when the number is divided by 17).This number will always be a number from 0–16. Map that number onto the letters A–Q, where 0=A, 1=B, 2=C, etc.  Finally, concatenate each of those pieces together.

Many thanks for any help here
 
  • October 14, 2022
  • Like
  • 0