表格条目是否定的
每周我有大约15个网站完成下面链接的表格。问题是,我每周大约有两个随机用户在表单中输入负面信息。一位非常精明的用户表示,该表单默认为负数。https://app.smartsheet.com/b/form/ebc99e53148a4a479060b3d695321030
我没有设置任何形式的逻辑。我对学生和工作人员的问题应用了数字验证,但默认值为空白。然而,我不确定字段如何默认为负字段。
在表单中,我没有看到如何防止用户输入负数。
我的下一个想法是,我应该设置自动化,如果数字小于零,则向提交条目的人请求更新。
有人遇到过这种情况吗?有人有别的想法吗?
提前感谢
答案
-
MVP行动 ✭✭✭✭
你可以把这个列做成下拉列表。把你的数字放在excel或谷歌表格中,然后复制粘贴到你的专栏中。
最好的
布莱德
www.MVPOPS.com
-
她名叫Stara ✭✭✭✭✭✭
我希望你一切安好!
补充MVP的优秀建议/答案。
作为一种解决方案,您可以添加一个工作流,并结合一个自动更新请求,例如,如果有否定答案,它将触发,以便它们可以将其更新为正确的值。
这样行吗?
我希望这对你有帮助!
注意安全,周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
克里斯·K ✭✭✭
我们刚刚也遇到了这个问题。有时,当在表单中输入0时,它会在单元格中放入一个随机的负数。我们创建了一个条件格式,以便在输入负数时突出显示行,并添加了一个工作流自动化来提醒我们注意负数。
类别
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":[]},{"discussionID":106511,"type":"question","name":"Smartsheet Form & File Attachment","excerpt":"Hello, is it possible to have the file uploaded on a smartsheet form to be attached to the email notification?","categoryID":321,"dateInserted":"2023-06-15T17:47:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T18:45:05+00:00","insertUserID":162431,"insertUser":{"userID":162431,"name":"Syd","title":"Analytics Manager","url":"https:\/\/community.smartsheet.com\/profile\/Syd","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!CRvWwjtq8Dw!neNVX5cBEbo!R6y12vmDgYo","dateLastActive":"2023-06-19T18:44:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":138637,"lastUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-19T18:44:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":53,"score":null,"hot":3374056368,"url":"https:\/\/community.smartsheet.com\/discussion\/106511\/smartsheet-form-file-attachment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106511\/smartsheet-form-file-attachment","format":"Rich","lastPost":{"discussionID":106511,"commentID":381199,"name":"Re: Smartsheet Form & File Attachment","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381199#Comment_381199","dateInserted":"2023-06-19T18:45:05+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-19T18:44:32+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-19T18:44:06+00:00","dateAnswered":"2023-06-15T18:43:26+00:00","acceptedAnswers":[{"commentID":380872,"body":"