动态视图:添加字段逻辑
答案
-
吉纳维芙P。 员工管理
动态视图中的字段逻辑在形式上不同于条件逻辑。为了使字段能够识别新条目,需要保存条目,并将该值提交给基础工作表。一旦将该值输入到单元格/基础工作表,字段逻辑就可以识别该值并将逻辑应用到视图面板。
这意味着更新并保存状态后,然后您将根据需要看到接下来的两个字段。
因此,如果有人之前提交了这一行的信息,并且状态显示为“Proposed”,那么当用户在Dynamic View中单击这一行时,Panel中的逻辑就会按要求显示这些字段。但是,如果在面板中填写的用户是正在切换Status的用户,则只有当他们点击Save按钮并将新值输入到工作表中时,字段才会显示出来。
您可能希望在字段中添加辅助文本来识别这一点,并要求用户在每个条目后单击“保存”。或者,如果这是该行的初始输入,则可以将底层工作表中的Form设置为输入表单,而不是Panel。
我希望这有助于澄清小组的工作方式!
欢呼,
吉纳维芙
-
马克班子 ✭✭
请更改动态视图中的字段逻辑以匹配表单中的条件登录。它现在的运作方式没有任何意义。当表单加载任何现有数据时,以及当用户更改下拉字段中的值时,都应该应用字段逻辑。
当前的方法也不能很好地与其他自动化一起工作,这些自动化可能是基于状态列的更改而触发的。假设状态列改变时,其他值也会随之更新,但不能保证会发生这种情况。
-
费利西亚威尔逊 ✭✭✭✭
我同意马克·萨拉蒙的观点。动态视图中字段逻辑的工作方式对用户并不友好。要求用户在每次输入后保存是一种快速挫败用户的方法。当用户更改下拉字段中的值时,应用表单上的条件逻辑的方式要好得多。
-
艾伦Rappa ✭✭
+1这个增强=因为我正在寻找这个非常的功能。
我想使一个字段需要在动态视图中,如果用户做出特定的选择。
如果它只适用于他们保存选择之后,那么它就违背了目的。
谢谢
-
杰罗德·多尼展开 ✭✭✭
此强化+1。
干得好,伙计们……Smartsheet请找到一种方法来改进动态视图中的显示面板,以更好地反映表单在使用条件格式时的显示方式,使用条件格式需要填写额外的字段,但在过程中中途保存表格是没有好处的。谢谢。
-
Traci萨默斯 ✭✭✭
+1
我等这个功能发布已经等了差不多2年了。我们使用的大多数动态视图都有利于即时计算,因此可以修改条目以符合我们设置的指导方针。我可以在Smartsheet中构建所有的公式和控件,但是因为我需要动态视图来处理安全性,所以我失去了所有的功能。
-
艾琳·金 ✭✭✭✭
+ 1
这个增强请求有什么进展吗?这将非常有帮助!!
-
这个增强请求有什么进展吗?这将非常有帮助!!
-
杰森洗澡 ✭✭
来这里+1这个请求,使逻辑在动态视图工作像条件逻辑的形式,看看是否有任何运动。才过了两年多。
如果动态视图的目的是使处理数据更具交互性和直观性,那么它就需要表现得好像它是活的(像表单一样)。在后端,这将需要实时数据连接,而不是数据源的快照动态视图和报表。
-
吉纳维芙P。 员工管理
这是一个对产品团队不可见的较早的讨论。ob欧宝娱乐app手机下载
社区有一个不同的区域来投票或+1产品创意请求,请参阅ob欧宝娱乐app手机下载智能表产品反馈和想法主ob欧宝娱乐app手机下载题在社区里。我在这个类别中找不到相关的想法-请随意创建一个想法!这将允许其他用户正确地投票听你的。投票最多的帖子每个月都会被审查。
欢呼,
吉纳维芙
-
杰森洗澡 ✭✭
谢谢你的提醒@Genevieve P。!
我为这个问题提交了一个新的想法。请在这里投票!
类别
<\/p>
You can send notifications to any valid email address. If you're planning to send alerts or reminders with a link to the sheet, the user will not be able to click the link and access it if they do not have a Smartsheet account and not shared to the sheet.<\/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":106482,"type":"question","name":"Smartsheet Bridge","excerpt":"Hi, I'm on Enterprise Plan and I'm trying to use Bridge but cannot log in to it. I actually had to dig the login link from the forums because I could not find it anywhere else, and when I try to sign in using my Smartsheet account it says \"Unable to log in with Smartsheet credentials at this time, try using Bridge…","categoryID":321,"dateInserted":"2023-06-15T08:35:55+00:00","dateUpdated":"2023-06-15T08:38:14+00:00","dateLastComment":"2023-06-16T08:51:39+00:00","insertUserID":149908,"insertUser":{"userID":149908,"name":"orad","url":"https:\/\/community.smartsheet.com\/profile\/orad","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDFQaXDtqPs!u9_Rl3ztpP0!b22gvzMblTD","dateLastActive":"2023-06-18T01:37:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":149908,"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-18T10:02:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":43,"score":null,"hot":3373725454,"url":"https:\/\/community.smartsheet.com\/discussion\/106482\/smartsheet-bridge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106482\/smartsheet-bridge","format":"Rich","tagIDs":[369,448],"lastPost":{"discussionID":106482,"commentID":380976,"name":"Re: Smartsheet Bridge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380976#Comment_380976","dateInserted":"2023-06-16T08:51:39+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-18T10:02:18+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-16T04:53:08+00:00","dateAnswered":"2023-06-15T09:36:11+00:00","acceptedAnswers":[{"commentID":380710,"body":"
Hi @orad<\/a> <\/p> I hope you're well and safe!<\/p> Bridge is a Premium Add-on\/app that needs to be acquired separately. It's not included with the Enterprise license.<\/p> Here's a possible workaround or workarounds <\/strong><\/p> I recently developed an SMS solution for a client using 3rd-party services, Zapier and Twilio.<\/p> Is that an option?<\/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":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":106462,"type":"question","name":"Why do i need \"admin approval\" to use the smartsheet app in teams?","excerpt":"I'm trying to add a Smartsheet to a teams channel as a tab and I get the error: Admin approval needed. Smarsheet needs admin approval to enable channel level sharing for this app. You may continue without this feature, or, if you're an admin you may use the button below to grant approval. But hitting the \"grant…","categoryID":321,"dateInserted":"2023-06-14T20:14:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T20:43:43+00:00","insertUserID":161989,"insertUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161989,"lastUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":45,"score":null,"hot":3373550314,"url":"https:\/\/community.smartsheet.com\/discussion\/106462\/why-do-i-need-admin-approval-to-use-the-smartsheet-app-in-teams","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106462\/why-do-i-need-admin-approval-to-use-the-smartsheet-app-in-teams","format":"Rich","lastPost":{"discussionID":106462,"commentID":380649,"name":"Re: Why do i need \"admin approval\" to use the smartsheet app in teams?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380649#Comment_380649","dateInserted":"2023-06-14T20:43:43+00:00","insertUserID":161989,"insertUser":{"userID":161989,"name":"PGoodwin86","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/PGoodwin86","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:41:48+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-14T20:42:10+00:00","dateAnswered":"2023-06-14T20:41:29+00:00","acceptedAnswers":[{"commentID":380647,"body":" You will have to get an admin of Teams to allow the Smartsheet for Teams app in the admin console of Teams.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5380,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">