0

Example: I entered 10 items in a list this month and now I would like to see the number 10 display in another web part in another page. I don't want to see the individual items I just want to display something like this:

Current Month submission = 10

Each item has a different date time stamped on a custom field.

4
  • Do you want SharePoint OOTB solution or custom code? Commented Apr 1, 2016 at 14:34
  • I prefer OOTB but if custom code is easier I can do that as well.
    – F.Rosario
    Commented Apr 1, 2016 at 20:26
  • I should have elaborated a little more than what I did. I am creating a splash page. I was tasked to create a little web part about 205 Pixels wide that would display abstract information from another SharePoint survey list. They want to display the number of submissions that were completed during the current month. The display on the web part will be as follows: "Current Month Count 10 Submissions" it is just counting the number of items submitted for the current month.
    – F.Rosario
    Commented Apr 5, 2016 at 19:11
  • Can you use JavaScript to get the data and render it on the splash page? Commented Apr 29, 2016 at 21:09

2 Answers 2

1

Try using Group BY in a view:

1) Create a calculated column to obtain the month

2) Create a view and group by the calculated column. Use option "collapsed groups"

2
  • Thank You, this works but it is only part of the solution.
    – F.Rosario
    Commented Apr 5, 2016 at 19:15
  • Yes because you can not order by the rank. Commented Apr 5, 2016 at 19:21
0

There is Total section in list view section, but you would need entering current month in view filter and there will be items in view...

So, there is simple custom Javascript solution with SharePoint JSOM:

  1. Use JS to query SharePoint for list items by CAML: https://msdn.microsoft.com/en-US/en-en/library/office/jj163201.aspx "Retrieve items from a list" section. You should set date start and date end variables and use them in your CAML, here is the nice post: CAML Query with Date Range

  2. Use collListItem.get_count(); to get items count and then add value to your HTML.

Hope this helps, welcome to ask any questions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.