动态视图:添加字段逻辑

dwallerius98081
dwallerius98081 ✭
编辑06/14/22 在添加插件和集成

我添加了以下字段逻辑，当另一个字段被标记为建议时，表单上需要某些字段。但是，通过应用以下逻辑，表单仍然能够在完成这些字段的情况下保存。尽管我在表格上注明了状态是提议的。这行不通有什么原因吗?我不希望用户能够保存表单，除非这些字段已完成。*注意，我不能在一开始就将它们标记为必需的，因为只有当条目实际上是“建议”时才需要它们。有人能帮忙吗?

image.png


· 在Facebook上分享 在Twitter上分享

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    嗨@dwallerius98081

    动态视图中的字段逻辑在形式上不同于条件逻辑。为了使字段能够识别新条目，需要保存条目，并将该值提交给基础工作表。一旦将该值输入到单元格/基础工作表，字段逻辑就可以识别该值并将逻辑应用到视图面板。

    这意味着更新并保存状态后，然后您将根据需要看到接下来的两个字段。

    因此，如果有人之前提交了这一行的信息，并且状态显示为“Proposed”，那么当用户在Dynamic View中单击这一行时，Panel中的逻辑就会按要求显示这些字段。但是，如果在面板中填写的用户是正在切换Status的用户，则只有当他们点击Save按钮并将新值输入到工作表中时，字段才会显示出来。

    您可能希望在字段中添加辅助文本来识别这一点，并要求用户在每个条目后单击“保存”。或者，如果这是该行的初始输入，则可以将底层工作表中的Form设置为输入表单，而不是Panel。

    我希望这有助于澄清小组的工作方式!

    欢呼,

    吉纳维芙

    · 在Facebook上分享 在Twitter上分享
  • Traci萨默斯
    Traci萨默斯 ✭✭✭


    +1

    我等这个功能发布已经等了差不多2年了。我们使用的大多数动态视图都有利于即时计算，因此可以修改条目以符合我们设置的指导方针。我可以在Smartsheet中构建所有的公式和控件，但是因为我需要动态视图来处理安全性，所以我失去了所有的功能。

    · 在Facebook上分享 在Twitter上分享
  • 艾琳·金
    艾琳·金 ✭✭✭✭

    + 1

    这个增强请求有什么进展吗?这将非常有帮助!!

    · 在Facebook上分享 在Twitter上分享
  • Mark_Berry
    Mark_Berry ✭

    这个增强请求有什么进展吗?这将非常有帮助!!

    · 在Facebook上分享 在Twitter上分享
  • 杰森洗澡
    杰森洗澡 ✭✭

    来这里+1这个请求，使逻辑在动态视图工作像条件逻辑的形式，看看是否有任何运动。才过了两年多。

    如果动态视图的目的是使处理数据更具交互性和直观性，那么它就需要表现得好像它是活的(像表单一样)。在后端，这将需要实时数据连接，而不是数据源的快照动态视图和报表。

    · 在Facebook上分享 在Twitter上分享
  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    嗨@Jason洗澡和@Mark_Berry

    这是一个对产品团队不可见的较早的讨论。ob欧宝娱乐app手机下载

    社区有一个不同的区域来投票或+1产品创意请求，请参阅ob欧宝娱乐app手机下载智能表产品反馈和想法主ob欧宝娱乐app手机下载题在社区里。我在这个类别中找不到相关的想法-请随意创建一个想法!这将允许其他用户正确地投票听你的。投票最多的帖子每个月都会被审查。

    欢呼,

    吉纳维芙

    · 在Facebook上分享 在Twitter上分享
  • 杰森洗澡
    杰森洗澡 ✭✭
    编辑04/05/23

    谢谢你的提醒@Genevieve P。！

    我为这个问题提交了一个新的想法。请在这里投票!

    · 在Facebook上分享 在Twitter上分享

类别

Hi,<\/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-16T04:49:23+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-16T14:58:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"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-16T14:58:06+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":36,"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":[]}">

使用Smartsheet的趋势

  • 自动化和电子邮件收件人

    您好，通过自动化标准发送的电子邮件通知是否仅对拥有Smartsheet帐户的收件人或在收件人字段中输入电子邮件地址的任何人可用?谢谢你！

  • 内容的桥梁

    嗨，我在企业计划，我试图使用桥，但无法登录到它。我实际上不得不从论坛上挖掘登录链接，因为我在其他任何地方都找不到它，当我尝试使用我的Smartsheet帐户登录时，它说“此时无法使用Smartsheet凭据登录，请尝试使用Bridge…

  • 为什么我需要“管理员批准”才能在团队中使用智能表单应用程序?

    我试图将智能表添加到团队频道作为选项卡，我得到错误:需要管理批准。Smarsheet需要管理员批准才能启用此应用程序的通道级共享。您可以在没有此功能的情况下继续，或者，如果您是管理员，您可以使用下面的按钮授予批准。但是点击“grant……”