从表单输入获取联系人
我正在实施一个表来接收输入的休假请求。对于提交表单，用户将输入自己的姓名、审批人(主管)的姓名和部门的计时员的姓名。
对于这4个雇员列，我将它们创建为联系人列表。我已经创建了一个审批工作流和报告，这些都是建立在联系人列表列功能。
但是，提交表单不允许输入联系人。提交工作表时，将以文本形式输入姓名而不是联系人，并且在手动将工作表更新为联系人而不仅仅是文本之前，无法对该行执行任何操作。
有什么方法、变通方法或联系人列表公式可以用来解决这个问题吗?
答案
-
她名叫Stara ✭✭✭✭✭✭您需要为每个角色添加所谓的助手列，然后使用公式获取电子邮件地址。
有意义吗?
这样行吗?
我希望这对你有帮助!
注意安全，祝你度过美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
Eric角 ✭✭✭
好吧，我想我明白你的意思了(你得原谅我，我是SS的新手)。如果我没理解错的话
- 创建一个Text列，它将接收来自表单的输入。假设用户在表单中输入了电子邮件地址。
- 在联系人栏中加入一个公式，将电子邮件地址复制为联系人，而不仅仅是文本。
对吗?还有，公式是什么?
-
她名叫Stara ✭✭✭✭✭✭
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
Eric角 ✭✭✭
谢谢你！我把零钱放进去了，正好达到了我们需要的效果，所以谢谢你的帮助。
-
她名叫Stara ✭✭✭✭✭✭
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
布雷特•史密斯 ✭✭✭你好,
我也有类似的问题。我想使用联系人列表来审批工作流。但是当我在表单中使用联系人列表时，它基本上只是一个文本输入字段。这会在其他地方创建工作，因为有人需要手动更新工作表，因此条目实际上是联系人。这就违背了自动化的本意。
我可以在联系人列表中添加可选值，但这会产生一个长期的问题，即随着人们的移动/变化等而更新/维护这些可选值。
如何使用表单将实际的联系人传递给工作表?这肯定是以前解决过的??
干杯
布雷特
-
她名叫Stara ✭✭✭✭✭✭
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
戴尔·墨菲 ✭✭✭✭✭✭Andree，我在这里遵循路径，在一个表单中，列看起来像一个联系人。
但是，如果我尝试在“当前用户”上的报告过滤器中使用此列，则报告过滤不能正常工作。我确信这是因为将文本输入转换为联系人的过程不包括姓名和电子邮件地址。
关于如何从表单条目构建联系人列表列，以便它被报告识别，有什么想法吗?
dm
-
罗宾•赫里克 ✭✭
助手列工作正常，但我想知道为什么我不能使用系统列Created By。表格中的公式似乎不能识别这一栏。为什么这不起作用，为什么不可能使这个系统列可见?
类别
I hope you're well and safe!<\/p>
Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":106397,"type":"question","name":"Line Item Signature Requests","excerpt":"I have a database of assets, and want to send each asset owner an automated form, which I can do, with their asset listing. What I need to receive is a \"signature\" that the assets are acknowledged. by the owner, and include verbiage that the asset owner agrees to abide by. I can create the form, automate it, but I have not…","categoryID":321,"dateInserted":"2023-06-13T20:39:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T14:00:24+00:00","insertUserID":162344,"insertUser":{"userID":162344,"name":"Pauline J","title":"Director of Operations\/IT","url":"https:\/\/community.smartsheet.com\/profile\/Pauline%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:53:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-14T19:19:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":28,"score":null,"hot":3373443021,"url":"https:\/\/community.smartsheet.com\/discussion\/106397\/line-item-signature-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106397\/line-item-signature-requests","format":"Rich","lastPost":{"discussionID":106397,"commentID":380488,"name":"Re: Line Item Signature Requests","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380488#Comment_380488","dateInserted":"2023-06-14T14:00:24+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-14T19:19:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T13:05:40+00:00","dateAnswered":"2023-06-13T22:18:29+00:00","acceptedAnswers":[{"commentID":380401,"body":" Hi @Pauline J<\/a> <\/p> I hope you're well and safe!<\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"},{"commentID":380454,"body":" @Pauline J<\/a> <\/p> Excellent!<\/p> Happy to help!<\/p> Here's an example of how it could look.<\/p> ✅Remember! <\/strong>Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up\/Awesome or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]},{"discussionID":106358,"type":"question","name":"Remove Reply in Smartsheet Button from Comment Notification","excerpt":"Hello, I use the Comments of the Sheet to communicate with other people regarding the Requests we have in the Sheet. The comment notification that is sent automatically when a user has mentioned another user in a comment is very useful. However, I would like to remove the \"Reply in Smartsheet\" button that is shown at the…","categoryID":321,"dateInserted":"2023-06-13T10:55:28+00:00","dateUpdated":"2023-06-13T10:55:37+00:00","dateLastComment":"2023-06-14T12:32:44+00:00","insertUserID":160277,"insertUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T12:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":160277,"lastUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T12:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3373400892,"url":"https:\/\/community.smartsheet.com\/discussion\/106358\/remove-reply-in-smartsheet-button-from-comment-notification","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106358\/remove-reply-in-smartsheet-button-from-comment-notification","format":"Rich","tagIDs":[219,441,510],"lastPost":{"discussionID":106358,"commentID":380452,"name":"Re: Remove Reply in Smartsheet Button from Comment Notification","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380452#Comment_380452","dateInserted":"2023-06-14T12:32:44+00:00","insertUserID":160277,"insertUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T12:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/YS8LARGCN51D\/comment.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"comment.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T12:27:37+00:00","dateAnswered":"2023-06-14T12:14:50+00:00","acceptedAnswers":[{"commentID":380442,"body":" Hi @moraki<\/a> <\/p> There currently isn't a way to remove the Reply button or the reply-to email function for @mentions in Smartsheet. (Here's the Help Article on this functionality: Using @mentions in comments<\/a>)<\/p>![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/WLCSO8N85MRQ\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
