HeavyBid Field Maximum Lengths
Codebooks, New Users
When setting up HeavyBid the help screens do not always list the maximum field lengths for codes. Typically users will set up their longer lists of codes in Excel (like Equipment, Detail Codes and Activity Codes) and then import them in but for example if the description field exceeds what is allowed the description will be truncated. It can be frustrating if you spent a lot of time working in Excel and then discover that you have to start over due to issues with the field lengths. What I always use in my Excel sheets is a column for code length and description length. The @len(cell) returns the length of any cell. Very handy command.