新!向表单上的字段添加实时验证

学习管理

@Matt Stofka<\/a> , @Chris Mondeau<\/a> , @cthrasher97141<\/a> , @Karen Botha<\/a> , @S Wood<\/a> <\/p>

Thank you all for your excitement for this new feature and for trying it out right away!! <\/p>

So astute of you to see that the validation for contact list fields didn't quite fulling make it out to our users. We resolved that and you can now see the validation option for the following: <\/p>

1. Contact list - single select - no values <\/li>
2. Contact list - multi select - no values <\/li>
3. Contact list - single select - values - not restricted (allows submitters to type in their own value)<\/li><\/ol>

   For 'Contact list - multi select - values - not restricted' we already do email validation as a requirement because the sheet does not allow a combination of text and emails to be entered into the sheet. As a form builder you do not have the option to change the validation functionality there as it is defined by the sheet. <\/p>

   We are so excited for this new validation and are already adding it to our own form. Please share any other feedback with us.<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Matt Stofka\",\"userID\":761}}},{\"insert\":\" , \"},{\"insert\":{\"mention\":{\"name\":\"Chris Mondeau\",\"userID\":17346}}},{\"insert\":\" , \"},{\"insert\":{\"mention\":{\"name\":\"cthrasher97141\",\"userID\":97141}}},{\"insert\":\" , \"},{\"insert\":{\"mention\":{\"name\":\"Karen Botha\",\"userID\":80901}}},{\"insert\":\" , \"},{\"insert\":{\"mention\":{\"name\":\"S Wood\",\"userID\":134916}}},{\"insert\":\" \\nThank you all for your excitement for this new feature and for trying it out right away!! \\nSo astute of you to see that the validation for contact list fields didn't quite fulling make it out to our users. We resolved that and you can now see the validation option for the following: \\nContact list - single select - no values \"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Contact list - multi select - no values \"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Contact list - single select - values - not restricted (allows submitters to type in their own value)\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"For 'Contact list - multi select - values - not restricted' we already do email validation as a requirement because the sheet does not allow a combination of text and emails to be entered into the sheet. As a form builder you do not have the option to change the validation functionality there as it is defined by the sheet. \\nWe are so excited for this new validation and are already adding it to our own form. Please share any other feedback with us. \\n\"}]","format":"rich","dateInserted":"2021-08-05T14:07:34+00:00","insertUser":{"userID":120943,"name":"Caroline Sheldon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Caroline%20Sheldon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/871\/nFF3KAQJUW5NV.jpg","dateLastActive":"2022-11-09T20:02:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/300424#Comment_300424","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/300424#Comment_300424

嗨@Caroline谢尔登-我有“联系人列表-多重选择-无值”，并看到启用电子邮件验证的选项;然而，当我打开输入表单并输入多个以逗号分隔的电子邮件时，我得到一个“无效的电子邮件”消息。只要我输入逗号，就会出现这种情况。

除此之外，它工作得很好。

卡罗琳·谢尔登

逗号分隔不是有效的输入法。如果你输入一个有效的电子邮件并按键盘上的enter键，它将保存该电子邮件并显示在一个灰色的“药丸”中。然后，您可以开始输入下一个有效的电子邮件并再次按ENTER。此字段中有20个触点的限制，因为单元格只能接受20个触点。

学习管理

Comma separation is not a valid input method. If you enter a valid email and press ENTER on your keyboard, it will save that email and display it in a gray 'pill'. You can then begin typing the next valid email and press ENTER again. There is a limit of 20 contacts in this field because the cell can only accept 20 contacts.<\/p>","bodyRaw":"[{\"insert\":\"Comma separation is not a valid input method. If you enter a valid email and press ENTER on your keyboard, it will save that email and display it in a gray 'pill'. You can then begin typing the next valid email and press ENTER again. There is a limit of 20 contacts in this field because the cell can only accept 20 contacts. \\n\"}]","format":"rich","dateInserted":"2021-08-10T03:43:16+00:00","insertUser":{"userID":120943,"name":"Caroline Sheldon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Caroline%20Sheldon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/871\/nFF3KAQJUW5NV.jpg","dateLastActive":"2022-11-09T20:02:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/300816#Comment_300816","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/300816#Comment_300816

嗨，卡洛琳——抱歉，如果我在最初的帖子中没有说清楚。对我来说，按ENTER键只在工作表中有效。我最初谈论的是填写表单时的电子邮件验证。在表单上按ENTER没有任何作用。我提供了一个截图供参考。

卡罗琳·谢尔登

@Learning管理你好，谢谢你提供了你所提到的截图。不幸的是，我们只允许以下电子邮件验证:

1. 文本字段
2. 联系人列表-单一选择-与值
3. 联系人列表-单一选择-无值

多选择联系人字段没有电子邮件验证选项。

她名叫Stara

谢谢,@Caroline谢尔登& Smartsheet团队。

这是对Forms的一个极好的补充。

japalo

有没有允许电话号码扩展的计划?目前，我不能使用电话验证来收集有扩展的桌面电话/固定电话号码。

朱尔斯佩提特金

这是一个伟大的功能，谢谢!

接下来可以将其应用于更新请求表单吗?使用这个新特性可以很容易地在用户创建的表单上使用数据验证，但是当响应更新请求时，人们仍然可以在% complete列中键入“on schedule”。

卡罗琳·谢尔登

@Jules佩提特金我们有更新请求的大计划，以匹配我们当前的输入表单的功能。明年会有更多的消息:)

马特·拉斯穆森

嗨@Caroline谢尔登-在表单上的联系人列表上的电子邮件验证，是否有一种方法可以打开相同的Smartsheet联系人列表，可用在工作表上的同一列?电子邮件验证要求用户输入有效的电子邮件地址格式但它不会验证电子邮件地址是否真的存在。此外，对于我们公司内部的用户来说，从列表中选择要比输入电子邮件地址快得多。

这是工作表上的Smartsheet联系人列表的截图。注意，最上面一行有一个在表单上输入的Michael Jordan的电子邮件地址。我向你保证迈克尔·乔丹不在我的公司工作。有什么办法让这个列表在表格上工作吗?

卡罗琳·谢尔登

@Matt拉斯穆森如果希望联系人显示在联系人下拉列表中，则需要在联系人字段中添加这些值，以便在人们填写的表单中显示它们。出于安全原因，我们不会自动填充您的Smartsheet帐户中的每个联系人的联系人字段-我们不希望有人染指您的整个电子邮件列表:)

然而，我们目前正在探索升级联系人选择器，以便它可以引用一个组。此外，我们正在更新一些后端流程，我相信这些后端流程将接收某人插入到表单的电子邮件字段中的电子邮件，并将其转换为工作表中的联系人。我们目前没有计划做验证，以确保电子邮件是贵公司的一部分。同样，最好的方法是将这些联系人添加到值列表中。

马特·拉斯穆森

@Caroline谢尔登非常感谢你的回答!我认为将表单中的条目转换为表单上的联系人的过程是理想的，特别是对于位于公司防火墙内且不面向公众的表单。它将为表单用户提供更好的用户体验，并提供在表单中使用联系人实现自动化和报告的好处。再次感谢，节日快乐。

杰夫瑞斯曼

@Caroline谢尔登

这是一个很好的功能，但理想情况下，我们将能够指定字符长度、数字数量、字符/数字模式等。自定义模式验证将是关键!就目前而言，Numbers Only验证对我们不起作用:

在我的组织中，我们让仓库管理员将提单号条形码扫描到输入表单中，这是8位数字;扫描镜头被弄脏或条形码打印不好有时会导致误读，导致数字被特殊字符或字母取代。为了测试扫描仪的验证，我为文本/数字字段打开了“仅限数字”验证，并创建了两个测试条形码，一个有8个数字，另一个包含8个字符:6个数字加上一个感叹号和一个字母H。扫描8位条形码效果很好;对于另一个，系统简单地忽略非数字字符，只收集6个数字。快速工作的管理员甚至可能没有注意到数字丢失，并且会提交带有丢失数字的条目，从而使验证无效。

如果Numbers Only验证有一个收集非数字字符并显示验证错误的选项，那么这个功能在我们的过程中会很有用。就像这种验证目前太“聪明”了。

VictorAguiar

非常感谢这个更新。

我目前正在使用加拿大的电话号码验证。

当我进入表格时，美国国旗出现了。

这个问题能解决吗?

感谢您的支持!

卡罗琳·谢尔登

@VictorAguiar

嗨,维克多,

在表单构建器中，您可以单击美国国旗并将电话号码格式更改为任何其他支持的国家。这将设置当您的表单用户打开它时选择电话号码的默认国家，但是他们仍然可以通过单击标志并更改为另一个国家来更改他们填写的表单的格式。这一点很重要，因为我们希望您作为表单构建器将默认设置为最常用的电话号码格式，但如果回答者的电话号码不在该国家，也可以灵活地更改它。

coeptis

嗨@Caroline谢尔登，

这对所有国家都适用，除了加拿大。出于某种原因，当选择它时，它仍然显示美国国旗。任何想法?

我想这可能是因为国家代码是一样的，默认是美国，尽管我们选择了加拿大…?这不是什么大事，但它也困扰着我:)

@VictorAguiar<\/a> <\/p>

Hi Victor, <\/p>

When you are in the form builder, you can click on the American flag and change the phone number format to any of the other supported countries. This sets the default country that the phone number is selected in when the user of your form opens it, but they can still change the format on the form they fill out by clicking on the flag and changing to another country. This is important because we want you as the form builder to set the default as the most commonly used phone number format, but also have the respondent have flexibility to change it if their phone number is out of that country. <\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/I4R4QX0MPORK\/screen-shot-2022-01-31-at-5-00-55-pm.png<\/a><\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"VictorAguiar\",\"userID\":144332}}},{\"insert\":\" \\nHi Victor, \\nWhen you are in the form builder, you can click on the American flag and change the phone number format to any of the other supported countries. This sets the default country that the phone number is selected in when the user of your form opens it, but they can still change the format on the form they fill out by clicking on the flag and changing to another country. This is important because we want you as the form builder to set the default as the most commonly used phone number format, but also have the respondent have flexibility to change it if their phone number is out of that country. \\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/I4R4QX0MPORK\\\/screen-shot-2022-01-31-at-5-00-55-pm.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/I4R4QX0MPORK\\\/screen-shot-2022-01-31-at-5-00-55-pm.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2022-01-31T22:03:46+00:00","insertUser":{"userID":120943,"name":"Caroline Sheldon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Caroline%20Sheldon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/871\/nFF3KAQJUW5NV.jpg","dateLastActive":"2022-11-09T20:02:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/318097#Comment_318097","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/318097#Comment_318097