Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Count instances of an item with certain values and display in infopath

Posted on 2011-09-30
3
Medium Priority
?
1,146 Views
Last Modified: 2012-05-12
Hi everyone,

I have infopath form and I have a data connection in it connecting to the sharepoint list I am working with.

Now I am trying to read certain column, let say column 'x' in sharepoint list and count the number of instances in that column that contains certain value, let's say 'y' and finally display that count information in infopath form.

How do I do that? I looked around and couldn't find any quick solutions.

Any helps will be highly appreciated.

Thanks,
Prem
0
Comment
Question by:KoolAsIce
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Expert Comment

by:SharePointGirl
ID: 36901667
You need to do it in code bwhind. Write a CAML query and select your data.

Alternatively write a web service to get the data back.

0
 

Accepted Solution

by:
KoolAsIce earned 0 total points
ID: 36906933
I was able to do it with infopath formulas. thanks for your input!
1
 

Author Closing Comment

by:KoolAsIce
ID: 36935310
I was able to figure out it myself.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question