TraciSchefdoreQrew Trainee9 years agoAdd leading zeros to Form ID # to make even length I am using the following formula to add leading zeros to a request # field I created on a form. "Request"&Right("000" & ToText([Record ID#]),5) I would like to limit the number of characters to 1...Show More
QuickBaseCoachDQrew Captain9 years agoCorrected formula "Request"&Right("0000" & ToText([Record ID#]),4)
Related ContentHow to keep the trailing zeros in a numeric fieldPipelines - Get Length of List of Pipeline RowsFormula - Rich Text field is not displaying zeros after the "."Keep Trailing Zeros on CSV ExportLeading Detroit Qrew