Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SharePoint Required column on list; how can I reset to be NOT required?

Posted on 2014-03-24
1
Medium Priority
?
3,507 Views
Last Modified: 2014-03-24
I have a user SharePoint list where a field was originally created as required, but need to make it not required. The field is a choice datatype with choices of yes/no. While the list will reflect that it is not required the form shows that it is required.  Trying to save produces an error and refuses to save.

The error is as follows:

The form cannot be submitted because it contains validation errors. Errors are marked with either a red asterisk (required fields) or a red, dashed border (invalid values). Field or group: my:Associated_x0020_Cost_x002f_Savi Error: Cannot be blank

Using the datasheet view of the list produces a warning that the fields could not be updated; If I want to wait (yes/no). Selecting no will display that the information was saved correctly. I need the form to be able to save with this field being blank.

I have already tried the following:
1. Simply unchecking the required field checkbox in list.
2. Changing dropdown field to Check box or options.
3. Dropping field from list and adding back in. (This also confirmed that form works without this field).
4. Changing required through InfoPath 2010 or SharePoint Designer 2010.


Other Information:
Working in SharePoint 2010.
Working with InfoPath 2010.
0
Comment
Question by:macarrillo1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 0 total points
ID: 39950860
Found Solution.

field was associated with content type.
When field was deleted and recreated the content type was not removed.

Resolved problem by creating new field: TestX defined the same as the original.
Refreshed fileds in InfoPath. To ensure new TestX field appears in data selection.
Deleted problem field.
Refresh fields again in InfoPath. Old controls associated with problem field are now unbound.  
Renamed TestX to old field name.
Refresh fields again in InfoPath.
Associate field to unbound controls.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

704 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