Sharepoint user validating

There is a trick for columns of type ‘Multiple lines of text’ which I will talk about later).For the customer I assisted with this, both of their columns were choice fields.Sometimes it can take a couple of tries, but Share Point is nice enough to let you know if it’s not happy with your formula.Microsoft does have some really great tutorials and example formulas as well.[su_row][su_column size="3/4"]Let’s take the following scenario as an example to understand how this could be beneficial: A user is filling out a form on their medical history.

(Note: I have not tested every scenario, but this should work with any type of column except for columns of type Lookup.Let’s break down the formula so we can really understand what it is doing. The bold portion of the formula is checking to see if the value of Allergies is equal to ‘Yes’: =IF([Any Allergies?]="Yes", IF([List Allergies Here:]"", TRUE, FALSE), TRUE) B.If this validation passes (the selected value is Yes), then the next bolded portion of the formula ensures that List Allergies contains data.If it does not, the validation returns False and it will fail, returning a message to the user.

Search for sharepoint user validating:

sharepoint user validating-18

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “sharepoint user validating”

  1. Vertebrate Publishing publishes high-quality outdoor books, including the UK’s most comprehensive and modern range of mountain biking guidebooks, and award-winning climbing and mountaineering literature Bradt Travel Guides have a reputation as a pioneering publisher: for tackling ‘unusual’ destinations, for championing the causes of sustainable travel, and for producing colourful guidebooks that are entertaining as well as useful.