TraciSchefdoreQrew Trainee8 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
Related ContentLeading LA QrewLeading Detroit QrewPipelines - Get Length of List of Pipeline RowsFormula - Rich Text field is not displaying zeros after the "."Need an Average, but it's counting NULLS as a zero
Recent DiscussionsMany to Many too Many...Selecting which fields to display from Formula URL searchesBulk create child records from selection listSolved(Pipelines) Get Users in Role / Process XML from HTTP APIHelp Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting