New answers tagged validation
Column validation has an implicit "IF" already built in: =AND([column a]="Test",(NOT(ISBLANK([column b])))) will only let the item be saved if "column a"=Test AND "column b" is not empty. So take the IF out and it should work.
If all instances of the Web Part have the same properties, maybe you can try to: Do the job once (i.e. add the Web Part, edit its properties, fill form required properties, apply). Export the Web Part from the Web Part's top-right menu Save the exported file (XML file with extension .dwp or .webpart) On every other pages, instead of adding a Web Part ...
The 'Cannot be blank' option works great if you set the 'Value when cleared' option to (blank) instead of FALSE.
Even I have the same requirement. But Unfortunately we don't have any option like enforcing unique by combining 2 columns by default. Even I have researched a lot. But we can achieve this by using only info-path form. Hope the below link may help you ...
How you can do this: Open your list and open the list settings Select the column "Plan start date" Under Validation setting type in the below formula : [Plan start date]<=[Plan end date] This help you to validate your dates before saving them. Hope this helps !
I tried it in my German SharePoint 2013 on-prem environment, but maybe it is working in SPO as well. The formular itself after you saved it looks like this: =ODER(Datum=DATWERT("20.01.2016");Datum=DATWERT("27.01.2016")) You can also use the english formular: =OR(Datum=DATEVALUE("20.01.2016");Datum=DATEVALUE("27.01.2016")) Assuming your "Datum" field ...
While SharePoint is typically backed by a SQL Server database, the SharePoint platform is not a traditional database and thus does not provide features like composite keys for list item identifiers. You are correct that you would need to add this type of functionality yourself and one such way is event receivers. Event receivers would work because they ...
Top 50 recent answers are included