data connect issue - InfoPath Dev
in

InfoPath Dev

data connect issue

Last post 12-11-2013 12:01 AM by Mo Alshorbaji. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-07-2012 10:41 AM

    data connect issue

    I am trying to count the number of items in a document library using infopath. I can do that if I create a receive data connection. However,  if I add another file to the library then the item count would not change because data is saved in th form template.

    I was using count(@ID)

    Does anyone know how I can do it real time, so that when the item numbers change in the library, I can click refesh on the form and the correct number will show up and I do not have to manually modify the data connection.

    Smile is a charity, so let's be selfless, smile and give people a reason to feel good.
  • 12-11-2013 12:01 AM In reply to

     Hi,

     Well what you can do is create a refresh button that will retrieve the new count of the library every time you click it.

     All you have to do is add a Button then add a rule "Set a field's Value". "Field" being the textbox in which you want the number displayed ( in your case the one fitted with the count(ID) formula).

     and "Value" should be set at "count(ID)" the ID field being the one from your Data connection.

    Now add another action  to the same rule to "Query for Data" using that same Data connection and you should be set.

    Mohammad Alshorbaji
    Qdabra® Software / InfoPathDev.com / 877.544.2389
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.