最终用户能够在WorkApps中的工作表上创建自己的过滤器?

朱莉娅·C·彼得森
朱莉娅·C·彼得森 ✭✭✭✭✭✭
编辑06/14/22 添加Ons和集成

我只是第一次尝试workapps,在我看来,除非你是workapps的管理员/所有者,否则你不能在workapps中查看表时创建一个新的过滤器。这使得工作应用在很多情况下都毫无用处。

是这样吗?我很惊讶他们会这样设计。我觉得无论项目/功能/行业,无论人们需要能够过滤他们正在查看的任何电子表格。如果不能,他们就会用excel代替

我知道您可以作为管理员创建共享过滤器,但这将是耗时的,它仍然不允许某人自己查找特定的行。叽阿…

标签:

答案

@jlykens<\/a> <\/p>

Happy to help!<\/p>

No. A helper column, in this case, would be a column you add (checkbox), and then you'd add the last step to the Workflow that checks the box the first time it's run and add a condition to the Workflow that it should only trigger if the checkbox in the helper column is unchecked.<\/p>

Make sense?<\/p>

<\/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>"},{"commentID":348598,"body":"

@jlykens<\/a> <\/p>

Excellent!<\/p>

The checkbox column would be near the bottom of the list.<\/p>

Did it work?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-25 17:00:05","updateUser":{"userID":152079,"name":"jlykens","url":"https:\/\/community.smartsheet.com\/profile\/jlykens","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wSDa8Inp0_Q!ZMNa2ZXlZLo!iUNAUXqg-pi","dateLastActive":"2022-10-25T17:04:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":96943,"type":"question","name":"Is there a there a way to securing share Smartsheet links without requiring end users to sign in?","excerpt":"","categoryID":321,"dateInserted":"2022-10-24T20:28:35+00:00","dateUpdated":null,"dateLastComment":"2022-10-25T13:14:35+00:00","insertUserID":154061,"insertUser":{"userID":154061,"name":"anovosel","url":"https:\/\/community.smartsheet.com\/profile\/anovosel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T13:49:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-25T20:52:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3333348790,"url":"https:\/\/community.smartsheet.com\/discussion\/96943\/is-there-a-there-a-way-to-securing-share-smartsheet-links-without-requiring-end-users-to-sign-in","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96943\/is-there-a-there-a-way-to-securing-share-smartsheet-links-without-requiring-end-users-to-sign-in","format":"Rich","lastPost":{"discussionID":96943,"commentID":348547,"name":"Re: Is there a there a way to securing share Smartsheet links without requiring end users to sign in?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348547#Comment_348547","dateInserted":"2022-10-25T13:14:35+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-25T20:52:26+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":"2022-10-25T13:49:34+00:00","dateAnswered":"2022-10-25T13:14:35+00:00","acceptedAnswers":[{"commentID":348547,"body":"

It is as secure as your practices. It can only be accessed by someone that has that specific URL.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-25 13:49:34","updateUser":{"userID":154061,"name":"anovosel","url":"https:\/\/community.smartsheet.com\/profile\/anovosel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T13:49:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96844,"type":"question","name":"Question Regarding Smartsheet-gSite Connectivity","excerpt":"Hello, I currently have a Smartsheet that allows users to post questions. I also have a gSite pertaining to this process with a \"list of questions asked\" section. Is there a way to connect Smartsheet with the gSite in a way so that, when a user posts a question in the Smartsheet, the question is automatically added to the…","categoryID":321,"dateInserted":"2022-10-20T17:54:58+00:00","dateUpdated":null,"dateLastComment":"2022-10-25T15:29:10+00:00","insertUserID":130903,"insertUser":{"userID":130903,"name":"Benjamin O'Leary","url":"https:\/\/community.smartsheet.com\/profile\/Benjamin%20O%27Leary","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T14:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T00:23:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3333002048,"url":"https:\/\/community.smartsheet.com\/discussion\/96844\/question-regarding-smartsheet-gsite-connectivity","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96844\/question-regarding-smartsheet-gsite-connectivity","format":"Rich","lastPost":{"discussionID":96844,"commentID":348585,"name":"Re: Question Regarding Smartsheet-gSite Connectivity","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348585#Comment_348585","dateInserted":"2022-10-25T15:29:10+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T00:23:26+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":"2022-10-25T14:19:40+00:00","dateAnswered":"2022-10-20T19:54:15+00:00","acceptedAnswers":[{"commentID":348056,"body":"

@Benjamin O'Leary<\/a> <\/p>

Hi Benjamin, not natively. This also depends on your gSite setup. You have a few options, depending on your situation:<\/p>

1) You could \"publish\" your Smartsheet sheet of questions and embed it on your gSite<\/p>

2) You could send your Smartsheet questions to a Google sheet (via Zapier) and connect the Google Sheet to your gSite <\/p>

3) You could connect your Smartsheet to the gSite through a custom API build, but you would stll need something on your gSite to \"receive\" the data coming from Smartsheet. So this might be overkill for what you're trying to accomplish.<\/p>

Without knowing your gSite setup and the way that data is configured, it's hard to offer a solution for you.<\/p>

Ryan<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-25 14:19:40","updateUser":{"userID":130903,"name":"Benjamin O'Leary","url":"https:\/\/community.smartsheet.com\/profile\/Benjamin%20O%27Leary","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T14:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">