Solved

Bulk Update Infopath Data

Posted on 2009-06-30
5
663 Views
Last Modified: 2012-05-07
I've created an infopath form that has a field on it which signifies the status of the record.  The status can be "open", "closed", or "postponed".  Users have been using the form to create records, but now I need to change about 100 records from open to postponed.  Is there a way to bulk update these records without opening each record, changing the status, then saving?
0
Comment
Question by:aoca
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 24745576
Create a data sheet view for the form library and then change the value in there.
 
:-)
0
 

Author Comment

by:aoca
ID: 24745628
The datasheet values are readonly when the record was created using an infopath form.  I've only been able to edit the values by opening the infopath form for each record.
0
 
LVL 25

Accepted Solution

by:
Robbie_Leggett earned 500 total points
ID: 24745807
Republish the template and change the settings for the field in question. Publish the field selecting the allow users to change this field check box.
 
:-)
0
 

Author Comment

by:aoca
ID: 24746262
That is almost it.  Is there a way to update checkboxes and datetime pickers?  They still seem to not be editable.
0
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 24752262
Unfortunately they don't work in the same way. I have a feeling you may be able to do it with checkboxes.
 
Give it a go.
 
:-)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now