Validation checks that the product design satisfies or fits the intended usage (high-level checking), i.e., the software meets the user requirement. This is done through dynamic testing and other forms of review.

learn more… | top users | synonyms

0
votes
1answer
72 views

Task %Complete calculated column show date/time

Im trying to create a calculated column to show completion date of a task based on %complete. So if the task has hit 100% then it should autofill a date/time value based on this percentage.
0
votes
1answer
174 views

Person Group type column not listed on a custom list's Validation Settings page

I have a Person Group type site column that I am using in a custom list through content types. On the Validation Settings page of the list I cannot find that column listed in the selection list of ...
0
votes
0answers
71 views

SPUtility.ValidateFormDigest breaks ASP.Net server side validation

I have a Web Part which is using SPSecurity.RunWithElevatedPrivileges, and thus needs to call SPUtility.ValidateFormDigest. However, this apparently causes it to ignore all ASP.Net validators server ...
0
votes
1answer
40 views

ValidationFormula to include 2 datetime fields

I have a custom list which is created via code. It has 2 fields for start and end date. When I specify the ValidationFormula with the 2 fields, the code errors out. Is there a way to validate the 2 ...
0
votes
0answers
54 views

MAC input validation in SharePoint 2010 list

I would like to validate the input of a MAC address in a list and have gotten the formula 90% there. The final step that I'd like to accomplish is to set any upper-case characters to lower. I know ...
0
votes
1answer
177 views

validate Unique users in 2 columns sharepoint List

I have a list which stores information about new sharepoint site requests. Where i have 2 fields (people and Groups) Primary Site Collection Admin Secondary Site Collection admin Both of this ...
0
votes
1answer
675 views

Calendar Column Validation for booking after a specific time

I'm trying to write a column validation for a SharePoint calendar to ensure all bookings are after 8.30am in the morning and before 5pm at night. I've tried the following: =AND(TIME(8,3,0) < ...
0
votes
1answer
34 views

How to validate on an absolute date?

I have a datetime field named "Date", and would like to only allow values within a specific range, say March 2015 - June 2016. Is there an easy way to do this? This rather hard one doesn't trigger any ...
0
votes
0answers
120 views

Validate Google Re-Captcha Server Side (Sandboxed solution)

I tried validate google recaptcha at server side, and according it's documentation, I had to do a request to an address (https://www.google.com/recaptcha/api/siteverify), passing three parameters ...
2
votes
1answer
91 views

Show error message when custom Ribbon button is disabled

I have a custom button added to SharePoint Ribbon. And there is EnabledScript attribute of the CommandUIHandler for the button. This attribute contains a javascript code to conditionally ...
3
votes
4answers
290 views

Validate a column only on edit

I have a date field that's now allowed to be >=TODAY(). But this validation should only be run IF the field have been edited. The field is present in a form with other fields. And if any of these ...
0
votes
1answer
27 views

Document validity in sharepoint 2013

I have some documents which are valid only for 3 months. It consists of some tax rates.Is there any possibility to show that the uploaded document is valid only for 3 months and further it should be ...
0
votes
0answers
121 views

SP2013 Column Validation Length without spaces

I have a Column Title, and need to get its length but not counting any spaces. This is a test should give me the length of 11 With LEN I can get the length of a string, but with the spaces. After ...
0
votes
2answers
209 views

Why does this multi-field validation forumula work in Excel but not in SharePoint 2013?

Why does my simple formula work in Excel but not-work in SharePoint? Why does this formula... =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) ...work in Excel but fail ...
1
vote
2answers
107 views

Validating Sharepoint Column doesnt contain word Sharepoint

I want to create a single line of text column that validates following items: Unique:can be done using OOB column settings 10 character: can be done OOB column settings All Lower Case: How do I do ...
2
votes
0answers
96 views

Person Is Valid SharePoint User [MultiUser]

I have a list with column named 'MultiUser' [DataType: Person or Group, Multiple Selection Yes] I want to validate all the Users in List using SharePoint Designer. I can do this if there is only one ...
0
votes
2answers
58 views

List Validation

In attached sharepoint list column "Status" Data Type is "Number", Column type is "Calculated", Formula :- =IF(NOT([Balance Qty]=0),"OPEN","CLOSED"). Here the requirment is if "PO Date" is not ...
1
vote
1answer
103 views

Validation formula on new items only

I'm using the following formula to prevent users from entering spaces on the article name field. =ISERROR(FIND(" ",ArticleName)) The problem is the users have already entered data in this field ...
0
votes
0answers
83 views

jQuery .validate - submit don't fire after error

Validation plugin works fine except following scenario: user click submit button while text box is empty, get error message, then fill text box and click button again. This time nothing happens. Any ...
0
votes
0answers
20 views

SP2010: Add validation to a wiki page

I have a table on my wiki page. Is it possible to validate the data in those tablecells?
0
votes
1answer
52 views

Basic List Validation

I need to have a list validation using SharePoint 2010. What I am looking for is something like this: if( ( A && B ) || C ) Where A, B and C are expressions. I have the first part, A ...
0
votes
2answers
172 views

Column Validation for Choice column

I made a new required Choice column with these choices: "", "Yes", and "No". Is it possible to use the built-in Sharepoint 2010 Column Validation to validate that the user chose either "Yes" or "No"? ...
0
votes
1answer
64 views

Sharepoint Column Validation

Can someone kindly give a short explanation of how SharePoint column validation works. As I tried to validate one column I didn't know if its working or not coz I wasn't getting any error message or ...
0
votes
1answer
58 views

validating textbox's value according to regional and language settings

I have created an application page which contains many textboxes some of them must accept only decimals (amount). Administrators can change the language and regional settings and some counries has ...
0
votes
1answer
171 views

How to validate SharePoint form field using regular expression?

I am using SharePoint form field. I used regular expression for allowing only numbers not less than zero, but it is allowing alphabets and throwing error if I enter number less than zero. function ...
3
votes
1answer
183 views

Survey, validate today's date question

We have a private survey. The date the survey was completed is to appear in an Exported Excel sheet. To do so, I have added a Date Field question in the survey named something like "Today's date" ...
1
vote
2answers
2k views

Insert a list item using REST form webpart: 403 error even when X-RequestDigest is present

I intend to insert a list item from the main page in intranet to a list hosted on another site collection. I made this simple HTML & JS to get it done, but I always get the 403 / FORBIDDEN error: ...
0
votes
1answer
54 views

Give users specific options in a single line text field - Sharepoint 2010

I have a list with a single line text field - [title]. Due to users being difficult, I now need to tighten this field down and only allow them to enter certain options. I was trying to do this via ...
3
votes
1answer
720 views

Form validate - New item

I have a list on Sharepoint, and when some user add a New item, I need to validate fields... I would like something in jQuery... something that if the field is not validated, it shows a msg error and ...
3
votes
0answers
82 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
47 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, ...
2
votes
2answers
356 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
1answer
55 views

List Validation Settings: Ignore case when finding word

I am validating a column to see if it contains blacklisted words. I want to capture the words whether they are upper case or lower case but I cannot seemed to find any solution on the internet. Does ...
0
votes
1answer
22 views

Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule

I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
1
vote
1answer
2k 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 ...
1
vote
2answers
5k views

infopath > How to make sure there is an attachment

Creating a resume upload form where user must upload attachment. On submit button I want to disable submit button if attachments is not present? I added Attachments is not present and this seems to be ...
0
votes
2answers
250 views

String validation with variable length?

I am using SharePoint 2013 and I am trying to validate a field that has a variable starting length but a certain format. The format I am using is XXxx-123456. Where 123456 is any 6 digits and XXxx is ...
0
votes
1answer
43 views

validation in sharepoint

I have a textbox field. I want to put a validator for the textbox that if it contain any special character in name then need to throw exception. Below is the code I used but not working. Please let me ...
1
vote
0answers
108 views

column validation across survey questions

I want to validate responses to a question in a survey using information from a previous question and I just can't get the survey to take the validation formula. Basically: Q1 = How many hours do ...
0
votes
1answer
61 views

Validate entire column with condition

I have a list that has a column which is an integer. Is it possible when selecting a number to validate if this number has already been chosen in the list. For example List Title Order ...
0
votes
1answer
383 views

Infopath Form requires me to Submit twice due to Slow Validation

I have created an InfoPath form that is connected to a SharePoint list. Apparently you can't use the Developer option in InfoPath if it's a List Form (Stupid, but hey). Form Contents (in Order): 4 ...
0
votes
0answers
1k views

Column validation formula within and outside of a list

I used to have this problem some months ago using SharePoint 2010, now it's back (SP 2013). Unfortunately I cannot remember what my "solution" was back then. Anyway I would be very grateful for some ...
0
votes
2answers
1k views

Client side date validation in SharePoint List form using jquery

I want a validation for no past dates i.e something like StartDate>=Today Is this possible can anyone help? Thanks...
0
votes
1answer
734 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 ...
0
votes
1answer
17 views

2 base items change the items in a form

Not really sure how to go about this, I want this vanilla sharepoint if possible. I have two 'Base Items' Player and Manager. These both have different forms. Some columns will be the same but some ...
0
votes
1answer
35 views

make something a required field depending on value

How can I make a column required depending on another columns value. Is it possible to do this without javascript?
0
votes
1answer
63 views

Recalculate Calculated Columns with Javascript

Has anyone some sample javascript code to recalculate a calculated column in SharePoint 2013 tasks? This should work on new and edit form and also with the AllItems view. Many thanks.
0
votes
1answer
33 views

change value of an item in validation

I am using list validation and I want to use an IF statement where is changes the value of a field. Say IF([column 1] >2, column2 = 'hello' If true, column3 = 'no' if false) Is this possible using ...
2
votes
1answer
927 views

Making Presaveaction() wait for SP.UI.ModalDialog response

I am using the Presaveaction() to perform pre-new/edit form validation. Once all fields have been validated successfully I would like to offer my users the ability to 'Save and Exit' or 'Save and ...
1
vote
1answer
229 views

Check for Valid User via Button

Ok, so I have a form that has multiple views, some read only and some editable. Each form has buttons to open the other forms in either edit mode or read only mode based on a field being set to ...