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.
441 questions
0
votes
2
answers
528
views
How to make PeoplePicker a required field?
I have a form with a couple PeoplePickers and I'd like to require the user to make a selection for the people picker, but unlike a text box field, I can't figure out how to require a peoplepicker. ...
- 141
0
votes
1
answer
438
views
Conditional validation of SharePoint Online column
I am trying to validate a SharePoint online task list column, in the way that the column "Assigned" (People column) must be populated for the user to be allowed to save with info in "Due date" (Date/...
- 25
0
votes
2
answers
128
views
Gender based validation
I've a Leave form in SharePoint list. when a female logins with her credentials, she can be able to see 'Maternity leave' drop down. Whereas, when a male candidate logins with his credentials, he ...
1
vote
1
answer
2k
views
How to validate date in datepicker with jquery (no with validation column)
I have two date-pickers in the same list but each have a different validation rule (in configuration of column) and the user can choice set date in one or other field on the form (but not required to ...
0
votes
2
answers
1k
views
Javascript to retrieve and validate file attachments in new item form
I have a requirement to inject javascript via a script editor web part into a form and validate that it's not a macro enabled Excel file (xltm or xlsm), and throw a validation error if it is and not ...
- 744
1
vote
1
answer
195
views
How do i get a mandatory attachment when a list item is of a certain value?
Hopefully someone can help. I am trying to get a SharePoint new item form to raise an error message if an attachment is not included when a certain choice is selected in a drop down menu.
I have the ...
0
votes
1
answer
93
views
Approaches to prevent submitting a modern create/edit forms if a status = close while a date field is missing
I am working on a sharepoint online custom list, and the list contain these 2 main fields:-
Status. drop-down with options; new,open,closed
Publish Date.
now i want to prevent users from creating/...
0
votes
2
answers
133
views
How to Validate SharePoint column by Date using IF
I want to validate column by Type of employee.
Type of Employee:
- Contact
- Full Time
I want to validate a column for "Hire Date"(Type: Date) by "Employee Type" column.
I want the date to Null/...
- 113
0
votes
1
answer
195
views
Column Validation only when item has a value
I have a list where I'd like to enforce that for one of my Single Line of Text fields, the user must enter a value with exactly 3 characters. However, the field is not required so I only want the ...
- 97
0
votes
2
answers
638
views
SharePoint 2013 - How do I save the value of a read-only or hidden field?
I'm trying to set a field in a list's edit form with a value after the user clicks "Save." Here's the catch: I don't want the field to be editable by the user (only JavaScript should set its value).
...
- 25
0
votes
1
answer
730
views
Sharepoint list column uppercase validation
So I'm basically trying to validate a column in my SharePoint list to have a Specific letter as the starting character of the field. I'm running into an issue with capitalization. I need the first ...
0
votes
1
answer
82
views
Sharepoint List VAlidation setting
I am trying to add validation for my share point lists. I have List with items containing some fields [Delete Item] ,[Scored Status] and some other. I want if the item is scored than user should not ...
- 3
0
votes
1
answer
1k
views
SharePoint Foundation SSA certificate validation error
I am experiencing some issues on my SPF Server.
Everytime I search, it takes about 15 seconds or more. I tracked this down to a certificate error.
A certificate validation operation took 14581,...
- 35
0
votes
2
answers
204
views
SharePoint 2013 List Checkbox validation
I've created a list with Test Check Box column contains two check box choices choice 1, choice 2.
When user's click choice 1 or choice 2 or both and click save a pop-up needs to show up how do i ...
- 3
0
votes
0
answers
45
views
List Validation settings (Required Fields)
I am trying make the Billing Status (Dropdown) field required only when the A La Carte (Yes/No) field is checked (true) or not blank (otherwise it is not required).
Bascially, I only want to have ...
- 145
0
votes
3
answers
514
views
Setting a column value in SharePoint validation
I want to do an IF statement and if its true then I want another column to be set.. I am using list validation on a Sharepoint list:
=IF([Master vs Copy])="Master",([Duplicate Rationale])="None"), ...
- 327
1
vote
1
answer
27
views
Problem with app validation - SharePoint online
I have a very simple validation script , which compares a date added to the created date and if there is 6months after then it will NOT show an error but if it is before 6months after the created date ...
- 327
1
vote
1
answer
395
views
document library validation formula
I have a CATEGORY column which has 4 choices (A, B, C, D) and is mandatory.
I have a second column (lets call it TYPE) which can have content (but is not mandatory).
What I want the validation to do ...
- 11
0
votes
1
answer
1k
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 ...
- 127
0
votes
1
answer
342
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]<>"",...
0
votes
1
answer
54
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",
...
- 13
3
votes
1
answer
198
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 ...
- 155
0
votes
1
answer
359
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 ...
- 1
0
votes
2
answers
539
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 ...
- 3
1
vote
1
answer
2k
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 =...
- 13
1
vote
0
answers
216
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 ...
- 55
1
vote
2
answers
3k
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 ...
- 164
0
votes
1
answer
37
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
1
answer
4k
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 ...
- 15
0
votes
2
answers
130
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
1
answer
456
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 ...
- 3
0
votes
2
answers
432
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?" ...
2
votes
1
answer
5k
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 ...
2
votes
1
answer
1k
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
1
answer
226
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 ...
- 407
3
votes
1
answer
1k
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 ...
- 187
0
votes
2
answers
1k
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
1
answer
351
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
2
answers
439
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
2
answers
48
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.
- 393
3
votes
1
answer
638
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....
- 43
0
votes
1
answer
476
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
1
answer
32
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 ...
- 55
1
vote
1
answer
867
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 ...
- 113
0
votes
1
answer
482
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?
- 25
1
vote
1
answer
572
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 ...
- 25
0
votes
1
answer
97
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....
- 1
0
votes
1
answer
2k
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 ...
- 480
0
votes
1
answer
148
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 ...
- 465
0
votes
1
answer
1k
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 ...
- 53