动态视图:添加字段逻辑

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上分享

类别

Happy to help. 👍️<\/span><\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106616,"type":"question","name":"Groups - how many users in a group?","excerpt":"The help files indicates you can bulk upload 1,000 emails to a group. Is that the maximum number of users that can be in a group? I could not find documentation indicating how many users could be in a group. TIA","categoryID":321,"dateInserted":"2023-06-19T21:51:09+00:00","dateUpdated":"2023-06-20T08:19:00+00:00","dateLastComment":"2023-06-20T09:36:32+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T23:25:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":3374465861,"url":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106616,"commentID":381246,"name":"Re: Groups - how many users in a group?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381246#Comment_381246","dateInserted":"2023-06-20T09:36:32+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-20T15:23:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-20T11:01:39+00:00","dateAnswered":"2023-06-20T09:36:32+00:00","acceptedAnswers":[{"commentID":381246,"body":"

Hi @ker9<\/a> <\/p>

That limit is specific to bulk-uploading the emails into the group, to ensure that the request is processed successfully. I don't believe there's currently a hard limit for the number of users that can be in a group. I have seen some groups with around 10,000 contacts, if that helps. <\/p>

Cheers,<\/p>

Genevieve<\/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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106596,"type":"question","name":"Changing a font in a dashboard","excerpt":"I have a dashboard using reports and metrics widgets, using sheet summaries and grid data, but the font is too large. How do I change that? In the screenshot, the red dot and the blue dot show the data that is coming from the grid data of a sheet. Is there any way of changing the font of the blue dot?","categoryID":321,"dateInserted":"2023-06-19T13:37:23+00:00","dateUpdated":"2023-06-19T13:49:50+00:00","dateLastComment":"2023-06-19T14:36:05+00:00","insertUserID":128842,"insertUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2023-06-19T14:33:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-21T02:54:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":58,"score":null,"hot":3374370208,"url":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","format":"Rich","lastPost":{"discussionID":106596,"commentID":381155,"name":"Re: Changing a font in a dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381155#Comment_381155","dateInserted":"2023-06-19T14:36:05+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-21T02:54:10+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HHR250SXIUPY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T14:35:02+00:00","dateAnswered":"2023-06-19T14:34:51+00:00","acceptedAnswers":[{"commentID":381154,"body":"

OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/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":5389,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 公式设置任务运行状况。

    你好，早上好，我有一个关于这个公式的问题。你能告诉我我做错了什么吗?谢谢你的帮助。

  • 组——一个组中有多少用户?

    帮助文件显示，您可以批量上传1000封邮件到一个群组。这是组中的最大用户数吗?我找不到说明一个组中可以有多少用户的文档。蒂雅

  • 在仪表板中更改字体

    我有一个使用报告和指标小部件的仪表板，使用表格摘要和网格数据，但是字体太大了。我该如何改变呢?在截图中，红点和蓝点表示来自工作表网格数据的数据。有办法改变蓝点的字体吗?