在表单上输入时,Webform名称与联系人列表不匹配
当使用web表单和提交者输入他们的名字时,如果他们的名字已经在联系人中,那么它与联系人的名字不匹配。因此,最终得到的新名称条目与联系人列中已有的名称相同。它们之间有联系吗?
评论
-
特拉维斯 员工
嗨,Mark - web表单没有办法查看您的联系人或链接输入的名称到您的工作表中的智能表用户。最好的选择是在提交表单后在表单中修改名称。
-
斯蒂芬妮·泰勒 ✭✭✭✭✭✭
你能在网页表单中预先填充名字吗?这样,它们就会与您的联系人列表相匹配。还是有太多不同的人在使用你的网页表单?
-
特拉维斯 员工
Stephanie -您可以用单个值预填充联系人列表字段,但这将作为文本输入,而不是作为联系人(就像您键入它一样)。目前没有将输入的名称链接到用户的解决方案。您需要在表单中修改名称。
我会把这个功能建议传递给我们的产品团队!ob欧宝娱乐app手机下载
-
马克·博纳姆 ✭
谢谢你的建议。修改名称以匹配先前存在的提交者是现在必须做的事情。这是一个繁重的手工过程。如果web表单的提交者之前已经使用过该表单,那么它可以将名称提供给提交者。因此,当提交者开始从智能表预先存在的信息中输入他们的名字时,这将允许他们选择匹配。这是smartsheet能想到的吗?谢谢。
-
特拉维斯 员工
Mark -这个功能近期没有任何计划,但是我已经把这个请求发送给了我们的产品团队,以便在未来的开发中考虑。ob欧宝娱乐app手机下载谢谢马克!
-
大卫•鲍曼 ✭✭✭
我同意马克的观点!这太有帮助了。在工作表中,联系人是从下拉菜单中选择的,但是Webform中的相同字段没有给您下拉选项(不像其他下拉字段可以工作……)看来这是一件很重要的事。
谢谢!
戴夫
-
如果你使用联系人的电子邮件地址而不是他们的名字,那么SmartSheet就会建立连接。这在webforms和将excel数据复制到具有联系人字段的Smartsheet中非常有用。
-
Kegan ✭
嗨,伙计们,
这个功能什么时候会加入有什么消息吗?
K
-
马克·博纳姆 ✭
嗨,伙计们,
只是一个关于联系人姓名的网络表单问题的想法。假设智能表单促进协作的逻辑,在这种情况下,您可以确定正确的名称和人员正在协作,那么您在现有智能表单用户的webform上有一个下拉名称选择不是很有意义吗?
如果这个人是新来的,他们需要一个基本的注册来保持他们的联系方式的一致?当然,只在需要联系人姓名的网页表单上。
具有自由形式的不一致的名称和手动纠正的可伸缩性不适用于大量人口。
谢谢,
马克 -
特拉维斯 员工
大家好!我们感谢您的反馈并理解您的担忧。我们的目标是使Smartsheet成为协作,计划和监控项目和任务的最佳和最简单的方式,并不断改进产品。ob欧宝娱乐app手机下载我没有任何关于这个特殊功能的更新,但你可以查看我们的产品路线图,看看我们目前正在做什么:ob欧宝娱乐app手机下载www.santa-greenland.com/ob欧宝娱乐app手机下载product-roadmap
-
R.Holden ✭
这是一个很好的请求,我将检查路线图,看看它是否很快!
-
戈登 ✭✭✭✭✭
根据Brian Veasman之前的建议,我尝试在webform联系人列表字段中输入电子邮件地址,但S/S似乎仍然无法将工作表中的电子邮件地址连接到我现有的团队帐户/联系人数据。
这个关键功能有什么更新吗,或者有什么创造性的解决方案?我正在寻找一种方法来设置提醒和警报绑定到一个联系人列表字段的表是通过webform输入。
-
肯特·沃恩 ✭✭✭✭
我加1分。
这是另一个我很难相信没有实现的功能。除非我遗漏了一些关键的细节,否则如果我没有联系信息,那么提醒/提醒将无法发送电子邮件,对吗?因此,这意味着尝试通过web表单做一些简单的操作项列表意味着您必须进入工作表以输入实际的联系信息。(也许可以在联系人栏中输入电子邮件地址,并在联系人栏中添加“链接”。但是必须为每一个“待办事项”输入一个电子邮件地址似乎非常低效)。
-
Rob借给 ✭
我加1分。
我参加了一些SS培训,并且我在基于最佳实践创建表格和报告方面做得越来越好,但是我使用的功能越多,SS产品中出现的漏洞就越多……ob欧宝娱乐app手机下载
类别
Ok I think I got it. It's due to the times you need to combine the dates and times to get it to consider both as a whole and not individually. So you will need a helper column for your start date\/time and end date time. I titled mine as Start Date Time Helper and End Date Time Helper. If you title them the same you should be able to copy and paste formulas.<\/p>
Start Date Time Helper<\/p>
=IFERROR(VALUE(YEAR(DATEONLY([Start Date]@row)) + \"//www.santa-greenland.com/community/discussion/comment/3723/\" + IF(MONTH(DATEONLY([Start Date]@row)) < 10, \"0\") + MONTH(DATEONLY([Start Date]@row)) + IF(DAY(DATEONLY([Start Date]@row)) < 10, \"0\") + DAY(DATEONLY([Start Date]@row)) + IF([Start Time]@row < 1000, \"0\") + [Start Time]@row), \"//www.santa-greenland.com/community/discussion/comment/3723/\")<\/p>
End Date Time Helper <\/p>
=IFERROR(VALUE(YEAR(DATEONLY([End Date]@row)) + \"//www.santa-greenland.com/community/discussion/comment/3723/\" + IF(MONTH(DATEONLY([End Date]@row)) < 10, \"0\") + MONTH(DATEONLY([End Date]@row)) + IF(DAY(DATEONLY([End Date]@row)) < 10, \"0\") + DAY(DATEONLY([End Date]@row)) + IF([End Time]@row < 1000, \"0\") + [End Time]@row), \"//www.santa-greenland.com/community/discussion/comment/3723/\")<\/p>
Formula to get your Yes\/No's<\/p>
=IF(COUNTIFS(SAP:SAP, SAP@row, [End Date Time Helper]:[End Date Time Helper], @cell >= [Start Date Time Helper]@row, [Start Date Time Helper]:[Start Date Time Helper], @cell <= [End Date Time Helper]@row) > 1, \"No\", \"Yes\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106584,"type":"question","name":"Index Match, how to recognize multiple values?","excerpt":"Hello, I have an issue with my index match formula. I want to locate the facility for a serial number. This works perfectly when there is only one value inside. However to reduce the amount of columns and options on the corresponding form, I changed it to one column that has multiple values. The formula is having…","categoryID":322,"dateInserted":"2023-06-18T21:21:35+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162488,"lastUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3374265958,"url":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","format":"Rich","lastPost":{"discussionID":106584,"commentID":381112,"name":"Re: Index Match, how to recognize multiple values?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381112#Comment_381112","dateInserted":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NDLYM9DFIQOI\/f1-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"f1.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T02:22:26+00:00","dateAnswered":"2023-06-19T02:12:19+00:00","acceptedAnswers":[{"commentID":381111,"body":"