对基于更改行自动创建工作范围包有什么想法吗?

mccoy_FSI
mccoy_FSI ✭✭
编辑02/08/23 展示和讲述

我有一个大型数据库,用户可以对其进行更改,然后将这些更改放入工作范围进行处理。我认为我不想使用突出显示更改功能,因为有时更改在处理之前可能会停留一两个月以上,而且我不想使用显示更改,因为我上次查看工作表选项,因为我经常查看工作表。

目前,我有它的设置复制行到另一个表时,任何变化。很好,效果很好。然而,在新的表格上,我看不出有什么变化。我真的需要它将它们复制到一个新的工作表,并突出显示在新工作表上的那一行所做的更改。

什么好主意吗?

答案

  • 迈克电视
    迈克电视 ✭✭✭✭✭✭

    @mccoy_FSI

    使用表单让用户提交更改请求(向另一个工作表)怎么样?然后你必须自己做出改变,但你知道要改变的是什么。

  • @Mike电视是的,我可以这样做,但是我想要更精简的工作流程。更改数据库条目时,将启动我的组的应用程序流程。然后,当批准时,数据库被标记为已批准,该数据在内部更新特定的文档。重要的是,它是一个闭环过程,所以我真的不想构建一个没有直接绑定到数据库的工作范围。

    我想我会创建几个表来复制数据,并建立工作范围。因为我的数据库中只有几个主要项目发生了变化。所以,当x发生变化时,我将把它移到x变更表中,当Y发生变化时,我将把它移到Y变更表中,然后从这些变化中构建一个合并报告。不像我希望的那么干净,但我真的没有看到一种方法,除了在他们的主工作表上跟踪变化,捕捉行中发生的变化,而不是根据变化将行移动到不同的工作表。一个问题是,有时X和Y都改变了,那么我该把它发送到哪里呢?因此,最后,您提到的构建工作包的表单可能必须是我所做的。

  • 寻找一个类似的解决方案来跟踪对项目组合所做的更改,这些更改都更新了进项表(基于模板集“项目管理办公室”)。将行复制到另一个工作表不起作用,因为有几个列通过单元格链接更新,这不会触发工作流自动化。


    我想知道两个日期之间发生了什么变化。例如,5月1日和4月1日有什么不同。


    谢谢!

2023-05-11T08:24:05.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":106161,"type":"question","name":"Process Doc for my SS","excerpt":"Is there a place to create and attach a process document on how to use all of the fields in my ss for my coworkers to view? I have created several sheets over the past few years and now I am moving to a new account. I want to create a process document that I can attach to each overall sheet on how to use each sheet. To be…","categoryID":346,"dateInserted":"2023-06-07T18:51:54+00:00","dateUpdated":"2023-06-08T11:07:43+00:00","dateLastComment":"2023-06-08T00:51:20+00:00","insertUserID":154302,"insertUser":{"userID":154302,"name":"Mark Muenzen","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Muenzen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":154302,"lastUser":{"userID":154302,"name":"Mark Muenzen","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Muenzen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3372350594,"url":"https:\/\/community.smartsheet.com\/discussion\/106161\/process-doc-for-my-ss","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106161\/process-doc-for-my-ss","format":"Rich","lastPost":{"discussionID":106161,"commentID":379472,"name":"Re: Process Doc for my SS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379472#Comment_379472","dateInserted":"2023-06-08T00:51:20+00:00","insertUserID":154302,"insertUser":{"userID":154302,"name":"Mark Muenzen","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Muenzen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T21:57:46+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":105912,"type":"question","name":"June Question of the Month 💭 Join the conversation and receive a badge","excerpt":"Hi everyone, We love seeing your participation in the Question of the Month and getting to know you better through your answers. Your responses to the May question were especially touching, inspiring and thought-provoking. Thank you to all our participants and congratulations to our top answer (by Community vote) winners.…","categoryID":346,"dateInserted":"2023-06-01T17:43:37+00:00","dateUpdated":"2023-06-08T12:22:59+00:00","dateLastComment":"2023-06-11T00:41:21+00:00","insertUserID":145232,"insertUser":{"userID":145232,"name":"Arsineh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Arsineh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDsrqb_Bq8s!xPC1MQ0l5vQ!cZTCNClbVWr","dateLastActive":"2023-06-11T00:46:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":162273,"lastUser":{"userID":162273,"name":"JessicaDiPietro","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/JessicaDiPietro","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k7lfvzRGRDo!hGvV4Tn85Lw!TZdT56qjFvV","dateLastActive":"2023-06-11T01:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":86,"countViews":769,"score":5,"hot":3372138598,"url":"https:\/\/community.smartsheet.com\/discussion\/105912\/june-question-of-the-month-join-the-conversation-and-receive-a-badge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105912\/june-question-of-the-month-join-the-conversation-and-receive-a-badge","format":"Rich","tagIDs":[324,493],"lastPost":{"discussionID":105912,"commentID":379994,"name":"Re: June Question of the Month 💭 Join the conversation and receive a badge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379994#Comment_379994","dateInserted":"2023-06-11T00:41:21+00:00","insertUserID":162273,"insertUser":{"userID":162273,"name":"JessicaDiPietro","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/JessicaDiPietro","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k7lfvzRGRDo!hGvV4Tn85Lw!TZdT56qjFvV","dateLastActive":"2023-06-11T01:23:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/E2D8BCGHXM5T\/screenshot-2023-05-31-at-6-02-34-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-05-31 at 6.02.34 PM.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-01T17:55:56+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":2},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":493,"urlcode":"qofmonth","name":"QofMonth"}]},{"discussionID":106021,"type":"discussion","name":"Community Intro","excerpt":"Hi everyone, my name is Melissa and I have been working with Smartsheet for about five years in the financial services industry. My expertise spans a wide range of Smartsheet functionalities, including advanced formulas, data validation, conditional formatting, automated workflows, and integration with other popular tools.…","categoryID":346,"dateInserted":"2023-06-05T18:17:42+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T18:31:59+00:00","insertUserID":162073,"insertUser":{"userID":162073,"name":"Melissa Yamada","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Yamada","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/JBO7YXU6221D\/nLL8MQQWP4C8M.jpeg","dateLastActive":"2023-06-09T20:19:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126614,"lastUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-06-09T22:48:47+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":31,"score":3,"hot":3371980481,"url":"https:\/\/community.smartsheet.com\/discussion\/106021\/community-intro","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106021\/community-intro","format":"Rich","lastPost":{"discussionID":106021,"commentID":378861,"name":"Re: Community Intro","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378861#Comment_378861","dateInserted":"2023-06-05T18:31:59+00:00","insertUserID":126614,"insertUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-06-09T22:48:47+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":3}],"tags":[]}],"title":"Trending in Show & Tell","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">