Disabling check box based on counted values in rows

  • 27 July 2018
  • 1 reply
  • 8 views
M

Hey guys,

 

I am struggling with a problem. I am trying to create sort of registration form where people can check the button at the training, if they want to attend next months. The button should get disabled as soon as in that very column the number of attendees reaches 10. as shown on the picture, there is 12 times yes and 2 times no, so the count function of the sharepoint list works great.

 

217282_pastedImage_1.png

As soon as I try to put this in the rule in the nintex form for sharepoint, it gets tricky. The check box does not get disabled if I use count(PMOoverview)>=10. If I do it the other way around count(PMOoverview)<=10, it works well. Obviously its not counting the boolean "yes" as the sharepoint list does.

 

217283_pastedImage_2.png

 

Could you please help me solve the problem. Even suggestions to go around it somehow are welcomed. I am no developer and I am new with Nintex, so I will welcome any suggestion happy.png

 

Thanks,

 

Milan

1 reply

SimonMuntz
Userlevel 6
Badge +22
Hi,
I dont think this is possible to acheive.
Nintex forms cannot reference the count in of a column in SharePoint.
You can use a list lookup runtime function to retreive every item that is Yes but there is no function to count how many items were retrieved to use in a rule.
The count runtime function you are using is to count the number of rows in a repeating section that have a specified control that is populated.
Cool Nintex courses: https://learn.nintex.com/

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings