RAHULGANDHI
Forms Fledgling

Count the repeated values in a column using lookup

Hello,

 

I have a column for status. Status is a choice type column with three choices 'Not Started', 'In-Progress' and 'Completed'. Let's say in this list I have 5 items. Each item will have a status. Let's say these status values for 5 items are [Not Started, In-Progress, Not Started, Not Started, Completed].

 

In Nintex form, I have created three calculated value control fields: Number of Not Started Items, Number of In-Progress items and Number of Completed items. 

 

How can I use lookup to calculate the number of Not Started, In-Progress and Completed items? In our case, there are 3 Not Started, 1 In-Progress and 1 Completed Status item. I would like to calculate these numbers using the same sort of functionality that may be calculated value field. Please let me know if there's more easier or better way to do it.

 

0 Kudos
Reply
4 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Count the repeated values in a column using lookup

It is not possible to do a count of returned items of a lookup control on a Nintex form.

If you want to display this information I suggest creating a list view that shows the count and then use a list view control on the form that shows the view you created.
0 Kudos
Reply
RAHULGANDHI
Forms Fledgling

Re: Count the repeated values in a column using lookup

I didn't understand what you suggested. Can you elaborate or share some documentation? Can also share screenshots of what you are trying to tell.

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Count the repeated values in a column using lookup

OK,

So you have a list with a status column which is a choice column with three options 'Not Started', 'In-Progress' and 'Completed'

When the column has data it would look like:

Status Column.png

So create a view in SharePoint which shows the count for each status.

CreateView.png

Standard.png

Group by the Status column.

Group.png

 

When choosing this view in SharePoint it will look like the screen shot below which shows the count for each status.

View.png

In the Nintex forms add the list view control to your form.

FormListView.png

List View Control Configuration:

ConfigControl.png

When creating a new form you will see the following which will give you the counts that you are after.

FormNewMode.png

Hope this helps.

 

0 Kudos
Reply
MegaJerk
Automation Master
Automation Master

Re: Count the repeated values in a column using lookup

This is a trivial thing depending on your circumstance. 

Are you using Classic Forms? 

Is there any relationship between the Items with Statuses, and the Item containing the Form you'd like to use to show those Items? (That is: Is it a Single Parent Item that is tracking the statuses of 1 or more Children Items on a different list?) 

 

0 Kudos
Reply