Skip to main content

I would like a formula that take a blockchain address in string form and converts it to its case-sensitive checksum format.  

For instance calling this function on ‘0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2’  would return  ‘0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2’

 

The process is fairly simple

  1. Convert the original Ethereum address into lowercase.
  2. Compute the SHA-3 hash of the lowercases address.
  3. Take the first 40 characters of the hash (which is a 64-character hexadecimal string) and replace the corresponding characters in the original lowercase address. If a character in the hash is a letter (A-F), then the corresponding character in the address should be uppercase. If a character in the hash is a number (0-9), then the corresponding character in the address should be left as lowercase.
  4. The final result is the checksummed version of the address.

 

https://www.alchemy.com/docs/how-to-handle-checksum-addresses#what-are-checksum-addresses

+1

This is 100% needed.


You’ll want to submit this here: https://community.airtable.com/p/product-ideas


Hey ​@Accipiter,

Would you mind sharing some additional details re: item 2 of your list/request?

I’m wondering whether this can be actually handled with a formula without any additional features/expressions.

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel 


You’ll want to submit this here: https://community.airtable.com/p/product-ideas

Appreciate it, the AI chat helper sent me here.