Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-19-2015, 02:13 PM
sukeshkhare sukeshkhare is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Oct 2015
Posts: 1
sukeshkhare is on a distinguished road
Default multiple row updates

Hi,

May be my questions sound little novice, I will ask the question anyways and then also explain the requirement, if what I am asking is not possible in InfoPath , let me know an alternative approach within InfoPath.

I am using InfoPath 2010 with SharePoint 2010.

Is it possible to Update value of a field for multiple rows of a SharePoint list using InfoPath , not using Repeating controls interface which end user interacts with but using Rules or Code such that only Form designer can update it behind the scenes ?

My requirement is , I need to fire a workflow that can inspect all items of a list (say "Shopping Cart") and accordingly Add/Edit items in another list (say "Bought Items") - when an end user clicks a button manually (say the button is called "Place order"). The solution I am using is to maintain a field which is set to 0 when the items are originally added to "Shopping Cart" and I want to be able to set the value of this field for all items in "Shopping Cart" to 1 when the button is clicked by end user. And then I have a workflow firing at Edit Item which can check if the value is 1 it will do what's needed else exit. I Created the required View of the "Shopping Cart" list, and then further modified this View page by adding another InfopathForm webpart on top of the default ListViewEditor webpart to accommodate the button that end user can click called something like... "Confirm Booking and Buy". However I can NOT find a way using which I can construct any rules on the click of this button which can Update the field called Status (which I created to store 0 or 1 as explained earlier) for ALL the rows. Using the Main Submit connection I can only Set value of a field for the 1st row AND there is no way to Set Value of a field for any other Data Connection ?

So just to re state the question - how to Set value of a field in SharePoint List for MULTIPLE ROWS using InfoPath when the InfoPath Form is already a Edit/New form for a SharePoint List .

Regards,

Sukesh
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updates tries to install Office 2010 updates which I don't use jlumbtx Office 1 03-13-2015 04:50 PM
Updates rbul1 Office 1 11-29-2014 10:35 PM
AutoText Updates Ludovico Word 0 07-11-2010 06:10 AM
Office updates B0B_E Office 0 08-07-2008 03:26 PM
Problems w/BCM updates? Godwulfe Outlook 0 08-04-2006 09:22 AM


All times are GMT -7. The time now is 02:34 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft