Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Convert Value to Base32

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?

0 1 277
1 REPLY 1

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

Top Labels in this Space