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.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

How to validate the wrong date time entry in SharePoint using column validation?

I got these 3 fields in the form where in text form my colleges input date and time. But sometimes they put in wrong times in the fields, and I want a validation for that. See the picture, if "Ärende ...
0
votes
1answer
15 views

Problem with PreSaveItem

I have some code in my PreSaveItem event that checks to see if there is a conflict on the calendar with the item being created. The code itself executes just fine and properly checks the calendar for ...
1
vote
1answer
18 views

SharePoint list validation formula

I need help with the following: I have 2 columns in a list and when "Yes" is selected in column 1, then "Yes" must be selected in column 2 also What I need is: If [column 1]="Yes", then [column 2] ...
1
vote
1answer
19 views

multivalidation in sharepoint list [closed]

I am working on sharepoint 2016 and having issue in applying multiple validation between date column Column A should not be less then Column B Column F should not be less than Column C Column E ...
0
votes
0answers
9 views

Validation settings acting weird

So I got this problem with validation settings on a sharepoint list.. I use the formula below and it kinda works. I cant choose "tekniker klar" and save the form if I havent filled in these columns [...
0
votes
1answer
15 views

Custom column validation formula for ensuring every item is selected in a choice question

I have a choice column (Required Checks) with CheckA, CheckB, and CheckC as options; multiple options is turned on. I have another choice column (Verdict) with Approved and Denied. (and other options,...
1
vote
1answer
24 views

Column Validation AND OR - Prevent Save

I have a SharePoint list with Column Status and Impact. I need to validate If Status equals "Pending" or "Approved", then Impact can NOT equal "U". At this point I want the users to change their ...
1
vote
1answer
19 views

Multiple Validation Rule

I have the following validation rule that works perfectly which makes mandatory [Customer] and [Member] columns if column [Feedback Type] equals "Ticket" from a drop down list: =IF([Feedback Type]="...
4
votes
1answer
179 views

Column validation on a non required field

I would like to have validation on a column that IF you type in the field you have to use 19 letters. But if you leave the field blank you can still save. Right now I use this: =IF(LEN([column 1])=...
1
vote
1answer
28 views

Can I set List Validation Settings programmatically?

I want to set the Validation Settings of a List with PnPJS. Is this possible? alternatively: Is it possible to provision a List with specific Validation Settings in place? Thanks!
0
votes
1answer
45 views

Problem with validatin settings “columns jumping around”

So I got my formula to work the way I want it to a point. Here is my formula (I guess its kinda bad, but it kinda works out). =IF(AND(Ärendetyp="LSP";Status="Tekniker klar");IF(AND([Ärende tilldelat]...
1
vote
1answer
27 views

Validation on column between 2 values

I am using SharePoint 2016. In a list, I created a column hostname of type single line of text. I would like to limit the values between r000xxx and r399xxx where (x= any letter). What's the right ...
1
vote
1answer
21 views

Field Level Validation - Require Non-blanks on Numerical Fields

I have a custom SP list with a handful of non-required numerical fields. I'd like to write a column validation rule for each that would force users to enter any value >=0. Our users will be using Data ...
2
votes
2answers
17 views

Sharepoint list validation syntax question?

I'm trying to get this SharePoint list validation formula to work. I ultimately want to make sure the date value in my [Date of Appointment] column is greater than the date value in my [Date Followed-...
0
votes
1answer
16 views

Validation Settings for column

I'm trying to eliminate other users from seeing other users SS in list group. Is there a formula that I can write in the Validation settings for that Column?
0
votes
1answer
14 views

Validate attachment in browser enabled infopath form

I have a browser enabled Infopath form and in that there is an option to upload attachments. I want to restrict the attachments to be jpg/ jpeg only. Is it possible to resolve this? Any help is ...
0
votes
2answers
55 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. ...
0
votes
1answer
64 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/...
0
votes
2answers
54 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
1answer
311 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
2answers
169 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 ...
1
vote
1answer
22 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
1answer
17 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
2answers
27 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/...
0
votes
1answer
34 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 ...
0
votes
2answers
99 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). ...
0
votes
0answers
15 views

Validation expression between two dates

I have two columns to support Out of Office request (MS Flow). I would like to create a formula to validate a situation like this: 1) START DATE cannot be lower then today (formula cannot allow the ...
0
votes
1answer
131 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
1answer
16 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 ...
0
votes
1answer
113 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,...
0
votes
2answers
67 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 ...
0
votes
0answers
35 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 ...
0
votes
3answers
191 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"), ...
1
vote
1answer
26 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 ...
1
vote
1answer
129 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 ...
0
votes
1answer
148 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
65 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
1answer
32 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
127 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
166 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
2answers
135 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
806 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 =...
1
vote
0answers
165 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
488 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
25 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
1k 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
2answers
51 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
348 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
93 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
1answer
3k 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
2 3 4 5
8