Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / February 2007

Tip: Looking for answers? Try searching our database.

Getting a value from a sharepoint list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick King - 28 Feb 2007 13:48 GMT
I have a secondary data source that pulls all ID's from a sharepoint list.

I can populate an infopath drop down list with all the ID's but i would
prefer to put only the highest ID number from the sharepoint list in a text
box (or expression box) on my infopath form.

can someone show me how i can do this?
Thanks.
steve@verizon.net - 28 Feb 2007 21:44 GMT
> I have a secondary data source that pulls all ID's from a sharepoint list.
>
[quoted text clipped - 4 lines]
> can someone show me how i can do this?
> Thanks.

Here's one way....

Add a text box to the form.

Double click the field.

For the Default Value:

  Click Fx
  Insert Function
  Click Math, then Max
  Click double click to Insert Field (from the SharePoint List data
connnection)
  Choose the appropriate field

Preview the form

should work..

hope that helps....

steve

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.