安排表单停用和友好表单结束信息

你好所有的,

我搜索了这个主题,但只找到了2019年左右的旧想法,所以我希望Smartsheet有一个更新,或者有人找到了比之前建议的更好的解决方案(意思是用户友好)。

1)我想安排一个表单在指定的日期/时间取消激活。我不认为这是一个选择。有什么变通办法来实现这一点吗?我甚至查看了工作流选项,但这并不影响表单提交。

2)根据取消激活表单的表单培训资源,执行以下操作:“欧宝体育app官方888禁用URL(访问它将显示错误消息),但保留它和表单,以便将来使用。”我的问题-有没有一种方法有一个用户友好的消息显示类似于什么用户将收到,如果他们提交的形式?或者是否有一种方法将他们重定向到另一个页面,一旦表单被停用(如果这是一个选项,我知道我必须创建一个网页登陆)?如果有人收到错误消息,这对用户来说是不友好的,这只意味着我将收到电子邮件,以找出它为什么不能工作。我绝对不希望他们认为过了截止日期就能得到他们想要的东西——这绝对不是把用户放在第一位。

我确实看到验证选项使用一个设置的日期作为结束日期,但这并不阻止它们提交。作为一名用户,如果我填写了一个表单,却在提交截止日期过后收到消息,我会很生气。

对其他以用户为中心/友好的想法和解决方案持开放态度。

此致敬礼,Sarah

标签:

答案

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

    @Sarah J Huibregtse

    1 -你是正确的,目前没有自动取消窗体激活的选项。您可以设置一个提醒来自己做这件事,但是此时取消激活表单是一个手工过程。(请将您的反馈提交给产品团队ob欧宝娱乐app手机下载通过这个形式,这里).

    2 -目前也没有办法改变当你停用一个表单时的错误信息。它将有标准的消息:

    屏幕截图2018-06-01:1.59.36 PM.png


    我建议做的是创建一个副本的形式,所以你有你工作的布局。然后,删除当前表单中的所有字段,除了标题和描述:

    屏幕截图2017-06-01在2.02.06 PM.png


    这样当用户访问你的链接时,他们就会看到你添加的自定义信息:

    屏幕截图2014-06-01 15:49:30 PM.png

    即使有Submit按钮,用户也不能提交表单,因为什么都不存在。

    我希望这能有所帮助!

    吉纳维芙

  • 吉纳维芙,

    这是一个很好的解决办法!非常感谢。虽然不理想,但肯定比标准的消息更友好。

    非常感谢您的意见和时间回复。

    亲切的问候,

    莎拉

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

    你好,萨拉,

    没问题!这是我目前在一个特定表单上使用的。

You can use Conditional Formatting to set a color based on the value in a cell, but not to randomize the colors unfortunately. It's a fixed color per formatting rule. You could use a contact field to use different colors for different people though...maybe have every project that George is managing be in dark blue, Wanda in orange, etc. Or some other value that you preset (big projects in red, small in green, etc) that has enough variation to help with the visuals.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-25 18:00:14","updateUser":{"userID":151609,"name":"longlive289s","url":"https:\/\/community.smartsheet.com\/profile\/longlive289s","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-25T21:17:53+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":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]},{"discussionID":94645,"type":"question","name":"When will report card views be editable on dashboards and workapps","excerpt":"The sheet card view functionality works so beautifully on dashboards and workapps 😍 (image attached of sheet setting options on workapps). Will this be available soonish for card views on reports? Currently, the only editable report option is grid view on workapps. The workaround I'm implementing is to add the card view…","categoryID":321,"dateInserted":"2022-08-25T01:27:07+00:00","dateUpdated":null,"dateLastComment":"2022-08-25T13:29:01+00:00","insertUserID":122359,"insertUser":{"userID":122359,"name":"Amanda G Lima","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20G%20Lima","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTlUGrCEcLw!XmjWXyseFaQ!SRWK24M5uLR","dateLastActive":"2022-08-25T14:28:55+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-08-25T13:34:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3322825568,"url":"https:\/\/community.smartsheet.com\/discussion\/94645\/when-will-report-card-views-be-editable-on-dashboards-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94645\/when-will-report-card-views-be-editable-on-dashboards-and-workapps","format":"Rich","tagIDs":[265,292,371,391,444],"lastPost":{"discussionID":94645,"commentID":341152,"name":"Re: When will report card views be editable on dashboards and workapps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/341152#Comment_341152","dateInserted":"2022-08-25T13:29:01+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-08-25T13:34:15+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-08-25T14:29:27+00:00","dateAnswered":"2022-08-25T13:29:01+00:00","acceptedAnswers":[{"commentID":341152,"body":"

Fell free to brows the Ideas Topic. If someone has already made the suggestion, you can vote for it. If no one has then you can submit the idea yourself to let Smartsheet know it is a requested feature and allow others to vote for it.<\/p>


<\/p>

\n \n https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas\n <\/a>\n<\/div>


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-25 14:29:27","updateUser":{"userID":122359,"name":"Amanda G Lima","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20G%20Lima","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTlUGrCEcLw!XmjWXyseFaQ!SRWK24M5uLR","dateLastActive":"2022-08-25T14:28:55+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":444,"urlcode":"card-view","name":"Card View"}]},{"discussionID":94633,"type":"question","name":"Unsubscribing to Scheduled Reports using \"Send as Attachment\"","excerpt":"Hello, I found where I can see who has unsubscribed to an Automated Workflow, but is there a way to check the same for scheduled reports? Thank you!","categoryID":321,"dateInserted":"2022-08-24T17:50:42+00:00","dateUpdated":null,"dateLastComment":"2022-08-25T16:21:49+00:00","insertUserID":147591,"insertUser":{"userID":147591,"name":"HutchL","title":"","url":"https:\/\/community.smartsheet.com\/profile\/HutchL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/MS5IUXHEYLVH\/nVG0881A294A3.jpg","dateLastActive":"2022-08-25T16:18:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-25T23:08:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3322809751,"url":"https:\/\/community.smartsheet.com\/discussion\/94633\/unsubscribing-to-scheduled-reports-using-send-as-attachment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94633\/unsubscribing-to-scheduled-reports-using-send-as-attachment","format":"Rich","lastPost":{"discussionID":94633,"commentID":341192,"name":"Re: Unsubscribing to Scheduled Reports using \"Send as Attachment\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/341192#Comment_341192","dateInserted":"2022-08-25T16:21:49+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-25T23:08: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\/BU1ZGD355NWU\/smartsheet-unsubscribed-to-report-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Unsubscribed to report.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-25T16:18:51+00:00","dateAnswered":"2022-08-25T13:33:41+00:00","acceptedAnswers":[{"commentID":341157,"body":"

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

I hope you're well and safe!<\/p>

Unfortunately, it's not possible now, but it's an excellent idea!<\/p>

Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/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","log":{"dateUpdated":"2022-08-25 16:18:51","updateUser":{"userID":147591,"name":"HutchL","title":"","url":"https:\/\/community.smartsheet.com\/profile\/HutchL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/MS5IUXHEYLVH\/nVG0881A294A3.jpg","dateLastActive":"2022-08-25T16:18:54+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":[]}">