Change Count text in SharePoint List with Code

Some very useful code that can change more than 1 Count property's text in a SharePoint list webpart.

For example I want Count = 10 to be changed to Total = 10

Code below can change 2 webpart's count that are on the same page.

NB.. Some of GUID IDs for Table needs to be substituted.

<script type="text/javascript">
//
// Some code to change the label for each of the list view tables with the Count = xx to Total = xx

var aggrHTMLInProgress = $('TABLE[id*={1973257D-0EF7-4C2A-AB5C-8E92348673F3}-{79952389-ED0A-44B2-B8D7-805CE39F0F38}] > TBODY[id*=aggr] > tr > td > table > tbody > tr > td > nobr > b');
           var aggrTextInProgress = aggrHTMLInProgress.text();
           var newTextForInProgress = "Total" + aggrTextInProgress.substring(5);
           aggrHTMLInProgress.html(newTextForInProgress);

var aggrHTMLCompleted = $('TABLE[id*={1973257D-0EF7-4C2A-AB5C-8E92348673F3}-{038EBE13-6C6B-47E2-A695-CFBAC095F365}] > TBODY[id*=aggr] > tr > td > table > tbody > tr > td > nobr > b');
           var aggrTextCompleted = aggrHTMLCompleted.text();
           var newTextForCompleted = "Total" + aggrTextCompleted.substring(5);
           aggrHTMLCompleted.html(newTextForCompleted);

//-->
</script>

The id*={1973257D-0EF7-4C2A-AB5C-8E92348673F3}-{79952389-ED0A-44B2-B8D7-805CE39F0F38} and TBODY[id*=aggr] can change on different list and views.  These are variables and must be looked up in the view source to match your list and view that you are using.  They change on every list and every view.

If there were only one webaprt that is grouped.  The text can also be changed with this technique in principle.

Consider below.

Where you have to change the Count to show Total

The following script will change it.

<script type="text/javascript">
//
// Some code to change the label for each of the list view tables with the Count = xx to Total = xx

var aggrHTMLInProgress = $('TABLE[id*={1973257D-0EF7-4C2A-AB5C-8E92348673F3}-{6DAB6104-AF6B-43E6-AF81-9B6F1FC4AC94}] > TBODY[id*=aggr3-1__] > tr > td > table > tbody > tr > td > nobr > b');
           var aggrTextInProgress = aggrHTMLInProgress.text();
           var newTextForInProgress = "Total" + aggrTextInProgress.substring(5);
           aggrHTMLInProgress.html(newTextForInProgress);

var aggrHTMLCompleted = $('TABLE[id*={1973257D-0EF7-4C2A-AB5C-8E92348673F3}-{6DAB6104-AF6B-43E6-AF81-9B6F1FC4AC94}] > TBODY[id*=aggr3-2__] > tr > td > table > tbody > tr > td > nobr > b');
           var aggrTextCompleted = aggrHTMLCompleted.text();
           var newTextForCompleted = "Total" + aggrTextCompleted.substring(5);
           aggrHTMLCompleted.html(newTextForCompleted);

var aggrHTMLTotal = $('TABLE[id*={1973257D-0EF7-4C2A-AB5C-8E92348673F3}-{6DAB6104-AF6B-43E6-AF81-9B6F1FC4AC94}] > TBODY[id=aggr] > tr > td > table > tbody > tr > td > nobr > b');
  var aggrTextTotal = aggrHTMLTotal.text();
           var newTextForTotal = "Total" + aggrTextTotal.substring(5);
           aggrHTMLTotal.html(newTextForTotal);


//-->
</script>

The result is this shown below.  Notice the Table id is now the same.  But the TBODY is different for each.  Both highlighted in the code above.