Hi,
Looking for a solution for the problem below.
The use case Example: We have a list named grocery as per following table structure. We need to get the count of items which has price less than 10 in the form designer before it is submitted.
Item | Price |
Mangoes | 25 |
Apple | 10 |
Orange | 5 |
Grape | 3 |
Banana | 13 |
Output should be: 2 (as there are only 2 items which has value less than 10).
P.S.: Someone suggested using a SharePoint CAML query filtering, and using it with calculated column. Or perhaps use SharePoint column of type “Lookup” and type of “Calculated” column.
But I am not able to get them or integrate with Nintex forms. Can anyone help?"