Forum Discussion

Sarah82's avatar
Sarah82
Copper Contributor
Nov 06, 2023
Solved

Custom number format with leading letters and numbers

Hi,

 

I'm tying to create a SharePoint Online List as an incident register. I'm want to have an Incident ID column formatted to display the number like such: INC001, INC002 INC003 and so on.

I can format the number column to have the leading INC but it drops off the leading 0s. I googled some code to format the number with the leading 0s but then it drops off the INC.

"{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=padStart(toString(@currentField),3,'0')"
}"
 
How do I change the code so I can have the leading lettering (INC) and leading 0s so my number column displayed as previously described.
 
Thanks in advance
json
microsoft lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Nov 06, 2023

    Sarah82,

     

    Adding to answer by Rob_Elliott:

     

    If you have some rows with no value in this number column, above JSON will return value like INC000 for all rows: 

    So instead of it, use this JSON: 

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField, 'INC'+padStart(toString(@currentField),3,'0'), '')"
}

     

    Output: 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

3 Replies

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Nov 06, 2023

    Sarah82,

     

    Adding to answer by Rob_Elliott:

     

    If you have some rows with no value in this number column, above JSON will return value like INC000 for all rows: 

    So instead of it, use this JSON: 

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField, 'INC'+padStart(toString(@currentField),3,'0'), '')"
}

     

    Output: 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources