Convert Value to Base32

[Cody_Dante]

I’m working with ID card values. I use excel to convert the values into base32 and it extracts the data I need.

Currently, I use the following excel formula to convert the values(cellA1 used as example):

=decimal(trim(mid(A1,9,7))32)

Unfortunately this expression doesn’t work in AppSheet. Any suggestions?

[Pooja2]

Use that formula in initial value like A1 define which column name in google sheet or may be excel sheet .