Using two choice fields to select a unique sharepoint list submission and then edit it back to the list

Hello,

Goal: I am trying to filter against two choice parameters in order to find the unique ID of the item shared between the two. I would then open that unique item entry, edit it, and overwrite it back to its original list.

Background: My sharepoint list is simply a technicians name X 12 months. So Rob will have Jan, Feb, Mar, ..., Dec and Adam will have the same scheme, etc. Each month/name combination only occurs once. I'd like to have a form where the form reaches out to the list to populate the choice field of technician and month (see below). The user would then select the technician, select the month, and the form would filter the unique combination of technician/month to find that single entry ID.

Once the ID is found, I wish to be able to edit the yes/no status of that submission, and submit it back to that same list.

I used nintex's query builder, and built a query that returned the ID for a specific technician and month (see below). I'd like the form to allow the user to select these parameters, then edit the unique item found, and submit it back to the list.

Is there a simple way to do this? Would the method here be part of the solution?: http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Add-SharePoint-List-Items-with-InfoPath.aspx

<Query>
  <Lists>
    <List ID="{A0A98C84-4527-4EF7-A71B-55B4A0E908A8}" />
  </Lists>
  <ViewFields>
    <FieldRef Name="ID" />
  </ViewFields>
  <Where>
    <And>
      <Eq>
        <FieldRef Name="Title"  />
        <Value Type="Text">Smith, Adam J.</Value>
      </Eq>
      <Eq>
        <FieldRef Name="colMonth"  />
        <Value Type="Text">FEB</Value>
      </Eq>
    </And>
  </Where>
</Query>

September 6th, 2015 2:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics