2
votes
0answers
24 views

How do you validate a column only if it's new item being added?

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
1
vote
1answer
22 views

List Validation Settings

I am trying to create a list validation rule that works for more than 1 argument. I have 2 dates as input, DATE1 AND DATE2, and a third date which is used to check that the first 2 have not expired, ...
0
votes
1answer
176 views

Conditionally hide/require form column based on radio buttons

I'm sure it's been asked a million times, but after hours of searching and messing around I have been unable to find a solution...Hopefully someone here can help me? I have a SharePoint list that has ...
0
votes
1answer
55 views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error ...
2
votes
2answers
57 views

Date Format Modifcation in List

I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
0
votes
1answer
26 views

Nearest thing to allowing entry of text or date in list

I have a list which collects the dates that systems were lasted tested on. Ideally therefore, I would like it to be a date field. This way, SP uses built-in functionality to validate the entries. ...
0
votes
1answer
47 views

How to validate text input in list is a multiple of 10

I am trying to use a text column, as opposed to a number column, as I don't want any of the number formatting that automatically comes with Sharepoint. I only want this column to accept multiples of ...
0
votes
1answer
2k views

List validation Sharepoint 2010: How do I validate date column based on Status?

I have an Action Items list that captures [Created], [Status], and [Date Completed] columns. [Date Completed] is an optional column to be entered at a later date when the Action Item is closed. If ...
0
votes
1answer
45 views

ETA Field Validation

I have a list which has an ETA data/time control. I'm trying to figure out a way to prevent users from entering a date which is before the current date/time?
1
vote
1answer
561 views

List item validation using .NET Client Object Model

On a SharePoint Foundation 2010 installation, I have a list defined and have set some simple validation rules on a couple of the fields: Text field (required) Number field (required, min: 50, max: ...
0
votes
3answers
210 views

Check if a list has the expected structure?

I must use a list in a webpart and display some data/graph/etc based on the list content (notice: this is simplified, so please do not give it much importance). To be used the list must have a ...
1
vote
0answers
126 views

Updating a value of any item in a list based on a selection of bool for one item - jQuery

So I hope this makes sense. I have a column within a list that I want to use as an active flag. There are 5 possible categories and for each category there can only be one active value. So I need some ...
4
votes
1answer
95 views

formula to limit date entries to specific month

In my "time off" custom list I have start date and end date. I want to make the user splits up the entries if the time off spans months. In other words if the entry starts Oct 25 and ends Nov 5 I want ...
1
vote
0answers
229 views

Validate list item with javascript API

I want to develop a custom datasheet view to edit a list. I add item through the javascript API. The problem is that the service doesn't control fields value. For example : - I add an item with a ...
2
votes
2answers
305 views

Sharepoint multi-column validation

I've got a custom list that contains multi collumns. The validation is made by a custom contenttype. Now I want a combination of two columns to be unique. Until know I did not found a way to solve ...
0
votes
2answers
1k views

programmatically list validation

I'm looking for a way to implement programmatically vallidation for NewListItems/EditListItems. One way I found was: to use the ListEvents and Validate on ItemAdding / ItemEditing. But instead of a ...
2
votes
1answer
489 views

dropdown box(sharepoint form field) validation sharepoint 2010

I have a sharepoint form field(look up field), a dropdown box in a list...below is the screen shot when i type into it it finds the name.. but when i type a text which is not present in the drop ...
1
vote
2answers
221 views

SharePoint List Check whether Value is Checked

I am using Windows SharePoint Server 2007. In a custom list, if I have two columns. One has a list of Categories, and the second has a list of Products. So in my Categories Column its a Choice with ...
1
vote
1answer
4k views

How can use Regular expression for Column Validation in Sharepoint 2010?

Is there a way that i can use the newly introduced "column validation" in Sharepoint 2010 Lists to validate that the value conforms to a regular expression? For example: if i create a column for ...