关于表单、自动工作流和请求更新的问题。
我有一个自动工作流程的表单。其中三个单元格是姓名——实际上是电子邮件地址。列属性设置为“Contact List…”
表单上的最后一个问题是“请求更新”。默认选择为“Yes”。
我希望这将如何工作如下:
John Doe输入三个带有姓名(电子邮件地址)的单元格
完成表格或尽可能多地完成。
提交。
“Request an Update…”函数将表单发送给所有三个人。
这三个人中的任何一个都可以添加/编辑/更正表单并重新提交。
这个过程再次重复，除非这个人现在对“请求更新……”说“不”。
这听起来是否符合我希望实现的目标?
谢谢
答案
-
吉纳维芙P。 员工管理如果您设置了一个表单来在工作表上创建一个新行，然后是一个带有三个操作的更新请求工作流(如果选中“是”，则三个更新请求操作将发送到三个不同的联系人单元格)，然后是，您将向每个选定的联系人发送一个更新请求类型的表单。
看到的:自动请求任务更新
棘手的事情是，如果您希望在初始更新请求之后重复此过程。在这种情况下，您需要第二个触发器，而不是使用前面相同的“Yes”。
例如，您可以有另一个名为“请求更多更新?”的字段，并让用户在从他们的电子邮件中填写表单时选中该框。第二个复选框可能是第二轮的触发器，发送另外3个更新请求。
请记住，如果其中一个联系人没有填写他们的第一个请求，而另一个用户选中了“请求更多更新”框，这可能意味着他们最终在收件箱中收到了同一行的两个请求。我可能会建议“请求更多更新”是一个框，只有当初始更新不够时，管理工作表的用户才会选中这个框。
欢呼,
吉纳维芙
0
帮助文章参考资料欧宝体育app官方888
类别
I hope you're well and safe!<\/p>
To add to Darren's excellent advice\/answer.<\/p>
Try something like this.<\/p>
=IF(OR([Jul Accidents]@row = 0, [Jul Accidents]@row = \"//www.santa-greenland.com/community/discussion/89697/\"), \"No Accidents\", IF([Jul Accidents]@row = 0, July@row, SUM([Jul Accidents]@row * 200000 \/ July@row)))<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
- Create a date column to track when the task is completed<\/li>
- Create a workflow automation to record a date in that column when the status changes to \"Complete\"<\/li><\/ol>
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 01:13:21","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-23T01:19:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":[]},{"discussionID":95791,"type":"question","name":"COUNTIF\/CONTAINS","excerpt":"Hello, I am attempting to count how many times a specific word appears in a text entry in a column. I normally achieve this by filtering by \"contains\" on the actual data sheet. My goal here is to automate this with a formula. Example: Count how many times the Resolution column contains \"duplicate\" I have tried the COUNTIF…","categoryID":322,"dateInserted":"2022-09-22T15:33:14+00:00","dateUpdated":null,"dateLastComment":"2022-09-22T17:12:39+00:00","insertUserID":152723,"insertUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152723,"lastUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3327728753,"url":"https:\/\/community.smartsheet.com\/discussion\/95791\/countif-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95791\/countif-contains","format":"Rich","lastPost":{"discussionID":95791,"commentID":344455,"name":"Re: COUNTIF\/CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344455#Comment_344455","dateInserted":"2022-09-22T17:12:39+00:00","insertUserID":152723,"insertUser":{"userID":152723,"name":"chelsi.johnson","url":"https:\/\/community.smartsheet.com\/profile\/chelsi.johnson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wx9nv0OzvvM!c5lk5xPUwzs!ncykvroFsEa","dateLastActive":"2022-09-22T19:03:55+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\/2Z271KRUD1QT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-22T17:44:54+00:00","dateAnswered":"2022-09-22T15:45:40+00:00","acceptedAnswers":[{"commentID":344433,"body":"I hope you're well and safe!<\/p>
=COUNTIFS(Resolution:Resolution, CONTAINS(\"Duplicate\", @cell))<\/p>
Be safe, and have a fantastic week!<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
