Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [validation]

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.

0
votes
1answer
23 views

Sharepoint Column Validation from another list

I have a custom list where a user enters information about a vehicle. I want to validate what the user enters as Vehicle ID, against a master Vehicle ID list contained in a seperate custom list. Is ...
0
votes
1answer
27 views

Is there a way to add the Content Type title inside our custom list validation settings' Formual

I have a cusotm list inside our sharepoint team site, and inside the list Validation setting i define the following formula:- =IF(Status="Invoiced",IF([Invoiced Date]<>"",TRUE,FALSE),TRUE)=IF(...
0
votes
0answers
8 views

75% duration of 'Start Date'

Using SP 2016 with a site list where users can pick a Start Date and End Date. Included a formula where the Start Date can not be set to the past: =[Start Date]>=TODAY() Included a formula where ...
0
votes
1answer
26 views

How can i nest column validation in SharePoint

How can I nest column validation =IF(OR( [Position]="Ground Support Equipment - Ramp Equipment Operator (GSE-REO)", [Position]="Ramp Equipment Operator (REO)", [Position]="Cargo Checker", ...
3
votes
1answer
33 views

Individual column Validation Based Off The Previous Date Columns

SharePoint Online Classic View Really need some help with this. I have a custom list with 8 visible date columns Column name examples: Create Date, Start Date, O365 Queue and Date Closed. Create ...
0
votes
1answer
43 views

Validation of lookup fields

I am using the following Javascript code using Script Editor on NewForm.aspx. It supposed to be working but by debugging I can see that the value returned from the dropdown select is empty. I looks to ...
0
votes
0answers
11 views

InfoPath form on SP Browser Jitter/Jumps

IP forms in the browser have this nasty functionality where they jitter / shake the form pretty badly when they're sending data to the server. If you disable this in the properties it can break rules ...
0
votes
2answers
42 views

I'm trying to figure out how to add two validation rules to One SharePoint list

I'm trying to figure out how to add two validation rules to One SharePoint list. If the user selects 'Risk' from the 'Risk/Issue?' column, then they must not leave the 'Risk Mitigation Plan' field ...
1
vote
1answer
168 views

List Item Validation Failed

I'm trying to use the UPPER formula for a column input, in my case the column name is "Client" and I want the user to enter the client's name as an uppercased string I tried: =UPPER(Client) and =...
0
votes
0answers
62 views

How to check valid user of Sharepoint?

How can I check a valid user of SharePoint and then use him in workflow without getting error? I know, that exist SPD validation "Is user valid user of SharePoint", but there is issue, that the valid ...
1
vote
0answers
81 views

How to validate non-clashing time ranges on items submitted through PowerApps?

I have a SharePoint list with a start time and an end time, which will be entered through a PowerApps app. One of the core rules is that those time ranges should not clash, similar to a meeting room ...
0
votes
2answers
31 views

SP2013 Validation - If NULL, show N/A

I have a list that I'd like to do some validation on, but I'm having trouble with the exact syntax of the idea (if it's even possible). The idea is that if a list item's field is NULL, then the ...
0
votes
1answer
21 views

Conditionally Trigger Column when creating Calendar Events

When creating an event in a calendar, I list 4 standards for the creator to choose from. I want the chosen standard to then trigger a drop down of locations for that standard. Can I do this? For ...
0
votes
1answer
228 views

How do I “validate” a column/field only if it's not blank

I currently have a column called "MAC Address" - it is not a required field as some pieces of gear do not have an address, but unique values are enforced. If a user puts in an address I want to (at ...
0
votes
0answers
11 views

Hidden text box cannot be blank if tick box is present

I have a hidden text box which appears when user checks a box that contains written justification that a record is complete. I want this form to be unable to be submitted if the box is checked (record ...
0
votes
2answers
49 views

limit edit item in list to 12 hours

I have a SharePoint 2016 team site with a list that will be used for a shift log. I want to limit the ability to modify a log to only be editable for 12 hours. Currently I am using list validation ...
0
votes
1answer
184 views

column validation in sharepoint list formula

Dears, Hopefully someone can help with composing a formula for a validation of a column in a sp list. I've have 3 columns with the choice "pending" or "completed". The validation would take place ...
0
votes
2answers
58 views

Validation for hidden fields

I have a small request. I am validating few fields in pre save function through j query. The problem that i am stuck on is that, i have a drop down named = "Is the Process flow document available?" ...
1
vote
1answer
798 views

People Picker Validation

I want to perform client side validation on people picker where in if the people picker is empty just to show an alert saying it is required. I am aware of java script and j query so if you guys can ...
1
vote
1answer
252 views

Remove validation on hidden fields

I am stuck on one condition where in I am trying to check if drop down value = select a value then show alert and then again if it is yes it makes two more columns visible. But there is a condition ...
0
votes
1answer
54 views

Using Choice Data Type in Validation Formula

I am working on a validation to determine if a selected choice is okay based off a previous selected choice. There are a number of categories (labeled 1 thru 13). Category #1 and Category #13 can ...
2
votes
1answer
274 views

Column Validation - Simple comparison

I'm attempting something fairly simple but seem to be coming across a few issues. I have a custom list containing 2 currency fields what I want to do is add validation to the second column so that it ...
0
votes
2answers
158 views

Column validation for datepicker - end date must be within 2 years of start date

I have a datepicker. I went into list settings for the start date and set the validation to =Start Date >= today() That works great. Now I want the End Date to be within 2 years of that End Date or ...
0
votes
1answer
74 views

Sharepoint 2010 list column to not to allow special characters and white spaces

I want to to some validation for Sharepoint 2010 list column to not to allow special characters and white spaces. Please let me know if any JS or Validation formula.
0
votes
0answers
40 views

Sometimes my validation works and sometimes it breaks. It's set to limit dates to valid dates within an event

I have this formula for validation on a "Date" Field: =AND(Date>=DATEVALUE("3/18/2018"),Date<=DATEVALUE("5/12/2018")) With the User Message: "Your date is outside of the wellness event. (3/...
0
votes
1answer
40 views

validate the date & time

I am trying to create a validation that checks the following: IF the days difference between FromDate and UntilDate is larger than 1 AND the time difference between FromDate and UntilDate is less ...
0
votes
2answers
66 views

error when trying to set multiple list validation formulas inside my custom list Validation Settings

I want to add these validations to my list:- if the status= "Invoiced", then user must enter a value inside the "Customer Invoice Date". if the status = "Paid", then the user must enter a value ...
0
votes
2answers
38 views

how to provide validation on to create SharePoint Date and time Column?

I want to create a SharePoint Date and time Column, so that the user is only allowed only to select a date 20 days ahead of today's date.
3
votes
1answer
295 views

How to customise date picker validation in sharepoint

In sharepoint, the date picker function has a limit such that if you pick a date beyond what the system gives, it produces the following error: "You must specify a valid date within the range of 01....
0
votes
1answer
107 views

Validate choice from a Drop Down menu if that choice was chosen by another user

We have SP2013 (PREM). I have a custom list with a date-picker column and another column called "Timeslot" which is a dropdown menu of about 15 20-minute choices. The desired end state is to be able ...
0
votes
1answer
25 views

Check for person prior to save

I have a SharePoint form (not in InfoPath) that can be created by numerous personnel. In order for us to accept a request, the form must have acceptance from two people--one inside our shop, one ...
1
vote
1answer
117 views

Column Validation for new items only

I have the following in the column validation on a SharePoint 2013 site =[Load Date and Time]>=TODAY() The above works well however I have a flaw in my logic! I want users to be able to change ...
0
votes
1answer
86 views

Column valiudation - restrict one choice based on another choice

Is there an OOTB way using validation / forumula to restrict choices in Column B based on the choice selected in Column A?
1
vote
1answer
123 views

Column validation with multiple arguments

I have two columns that wish to validate on. Column A is a number field and Column B is a choice (drop-down) field. I wish to restrict the options that can be selected in Column B if the number ...
0
votes
1answer
51 views

Calendar date/time validation syntax help

I'm trying to prevent users from submitting calendar entries after 10am for day-of appointments. So, no restriction for submissions any day other than today, just no updates to current day after 10am....
0
votes
1answer
405 views

How to Validate Date-picker in Infopath in such a way that user should select only Future Month?

I have Datepicker in Infopath 2013 where I need to put validation in such a way that user should select only Future Months Date. Past month dates and current month dates should not be selected. Any ...
0
votes
1answer
96 views

Change column to required in response of another column

I have two columns: Valor de Estatus and Comments Valor de Estatus is a select box with values: 0 1 2 3 4 Comments column is a multi line and is not required as default I want to make column ...
0
votes
1answer
81 views

How to make Attached File mandatory base on the fields chosen

I have this validation formula that will make a field mandatory base on the choice of the user =IF([Column1]="Completed",AND(NOT(ISBLANK([Column2]))),TRUE) But this can only be applied on the ...
1
vote
1answer
989 views

How to validate Sharepoint 2013 lookup column

I am (very) new to Sharepoint and am a little stuck. I have created a list containing a number of dropdown columns which are all required fields. Sharepoint defaults the list to the first item on ...
0
votes
2answers
26 views

SP 2013: PreSaveAction validation of Enterprise Keywords column

In my list, I am validating a lot of columns using the PreSaveAction. I have many look-up columns that I want to be required and the OOTB required field way doesn't cut it. OK - that's cool. I have ...
1
vote
0answers
64 views

Alert you must specify a value for this required field alert in newform.aspx

I just added this code to trigger an alert on newForm.aspx. Unfortunately, after I applied this code Formula column Validation, my form is not working. Any solution? Formula column validation is not ...
2
votes
0answers
17 views

Info Path form - validation to only allow selected choices from a dropdown

Summary - I have a field in a SharePoint (2010) list set to be selected from a drop-down, choices hard coded: The field is entered using an InfoPath designed form. There's a request to reorganize ...
1
vote
0answers
219 views

Sharepoint DataFormWebPart and ListFormWebPart validation SP2016

I'd like to add some custom validation to custom NewForm for external list. The default new item form has in the ZoneTemplate ListFormWebPart but if i add a new form in SPD2013 there is ...
1
vote
0answers
35 views

Sharepoint 2013 Form validation - I have 4 date fields I want to validate on. The first 2 are compulsory second 2 can be blank or filled in

I am having dificulty getting my validation formular to work. Field Names: DateAdded (first date) Expectedleave (second date) these are compulsory and the Expectedleave must be equal to or greater ...
1
vote
1answer
79 views

Online, JSOM, Add new Choice value to Lookup dropdown - cannot save form, “Invalid postback or callback argument. ”

I had a code that dynamically creates items and adds them as lookup values. I used CSR but CSR is unavailable on calendar forms (EditForm/NewForm.aspx), so I try to re-write it to vanilla javascript. ...
0
votes
1answer
123 views

Calculated Column Formula Field Count Numbers of days unles status = X

We want to create a list of contracts currently underway. We have created a column with a calculated formula: Time in progress =TEXT(NOW(),"dd/mm/yyyy")-Created what we need to add to this formula ...
1
vote
0answers
21 views

Overactive Infopath form validation

I have a date cell set to require entry if there is an action item entered in another cell (using the rule on the date cell if Action is not blank and Date is blank) which works normally if text is ...
1
vote
0answers
25 views

SharePoint List To and From date/time not within and existing entries

I'm creating a car booking system. The idea is that individuals can book from 3 pool cars. I've created a list with a from and to Date and Time. I want to prevent the user selecting an existing ...
0
votes
1answer
81 views

Validating decimal input in increments of 15

I have created a time entry form using a SharePoint list and InfoPath. One of the requirements is a column called 'Time spent' where they are to input the amount of time they spent on a project. It ...
4
votes
1answer
55 views

Does List Validation recheck itself when fields are changed?

This question might be confusing but I wasn't sure how to word it. SP accepts the syntax fine and the validation stops incorrect data from being submitted, but won't let me progress after fixing what ...