如何设置列表中列的验证? [英] How to set validation for column in list?

问题描述

你好

我想为列表中的列设置验证.条件是:

I want to set validation for column in list. The condition are :

1. 此列不需要包含信息
2. 但是，用户插入信息时会进行验证.
   
   示例:
   列电子邮件.
   
   这不是必填字段，但是一旦用户插入电子邮件信息，就会进行如下验证
   
   = AND(ISERROR(FIND(;" Emel; 1)); IF(ISERROR(FIND("@"; Email; 2)); FALSE; AND(ISERROR(FIND("@" ;;电子邮件； FIND("@"；电子邮件； 2)+1))； IF(ISERROR(FIND(."；电子邮件； FIND("@"；电子邮件； 2)+2)))； FALSE; FIND(."; Email; FIND("@"; Email; 2)+2)< LEN(Email))))))

1. This column not required contains information
2. But, there is validation when user insert info.
   
   Example:
   Column Email. 
   
   It's not mandatory field but once user insert the email info, there is validation as below
   
   =AND(ISERROR(FIND(" ";Emel;1));IF(ISERROR(FIND("@";Email;2));FALSE;AND(ISERROR(FIND("@";Email;FIND("@";Email;2)+1));IF(ISERROR(FIND(".";Email;FIND("@";Email;2)+2));FALSE;FIND(".";Email;FIND("@";Email;2)+2)<LEN(Email)))))

谢谢

推荐答案

你好Ameenah，

Hi Ameenah,

您当前遇到什么问题?请提供有关您遇到的挑战的更多信息?

What is your issue currently? Please provide more information about the challenge that you met?

无论如何，有一些博客使用计算所得的列来验证电子邮件地址，您可以参考它们:

Anyway, there are some blogs about validating email address using calculated column, you can refer to them:

http://lealesolutions.com/sharepoint-2013-column-validation-for-电子邮件地址/

https://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/

谢谢

Wendy

这篇关于如何设置列表中列的验证?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！