在基于行而不是基于列的表单中构建问题
这可能吗?
我有一张清单,每一行都有多个问题。我宁愿避免使每个问题的一列,所以是否有可能创建一个表单基于问题的第一列为每行?
谢谢,
杰克
最佳答案
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
最简单的方法仍然是将问题添加到列中,并为每个问题/部分添加评论列。(我创建了一个解决方案,通过部分收集的评论部分,但仍然可以对该部分的每个问题发表评论,并在字段中已有文本)有意义吗?
我最近也有一个客户,我几乎把列都填满了,因为表单太彻底了。这是一个类似于你的吸收过程。
另一个选择是考虑第三方服务/集成。例如,Google Form可以设置条件,但它仍然需要列。
你觉得呢?
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
答案
-
她名叫Stara ✭✭✭✭✭✭
嗨,杰克,
不幸的是,目前这是不可能的,但这是一个很好的主意!
也许有一个变通办法。
这是什么问题?是/否?
有多少不同的问题?
你能更详细地描述一下你的过程吗?也许可以分享一下表格之类的截图?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护))
我希望这对你有帮助!
祝你度过美好的一天!
最好的
她名叫Stara
工作流程顾问/ CEO @工作大胆
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
Gunn_Jack ✭✭✭✭
嘿,她名叫,
一如既往地感谢您的及时回应。
这些问题需要回答Yes / No / N/ a,但这也是一个“评论”栏。在此期间,我希望能够只有是/否/否/否的答案,但如果你能在每个答案下面放一个评论框来扩展它,那就太好了。
提交的增强请求,也附上截图,没有敏感性,只是一个程序/项目的通用清单。
欢呼,
杰克
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
最简单的方法仍然是将问题添加到列中,并为每个问题/部分添加评论列。(我创建了一个解决方案,通过部分收集的评论部分,但仍然可以对该部分的每个问题发表评论,并在字段中已有文本)有意义吗?
我最近也有一个客户,我几乎把列都填满了,因为表单太彻底了。这是一个类似于你的吸收过程。
另一个选择是考虑第三方服务/集成。例如,Google Form可以设置条件,但它仍然需要列。
你觉得呢?
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
Gunn_Jack ✭✭✭✭
谢谢她名叫,
我将在这篇专栏文章发表之前,看看我的进展如何
杰克
-
她名叫Stara ✭✭✭✭✭✭
不客气!
听起来像个计划!
如果你有任何问题,请告诉我进展如何!
智能表专家顾问兼合伙人
W:www.workbold.com| E:一个(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
类别
It depends on your automation settings. If you set it to unrestricted, you can send to an email address in a cell without giving them access to the sheet. You can also specify which cells are provided in the update request within the automation builder.<\/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":106840,"type":"question","name":"Report not showing all rows that match the filter parameters","excerpt":"Hello! I have a sheet that has 3424 rows with a specific Due Date. When I look at that filter option in the report, I see that it sees 3424 for that field. However, when I add that parameter, only 2500 rows display. I can't find a row limit to reports that would cause this. Is there a row limit to reports that I'm unaware…","categoryID":321,"dateInserted":"2023-06-23T16:50:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T17:36:10+00:00","insertUserID":74136,"insertUser":{"userID":74136,"name":"asimcock","url":"https:\/\/community.smartsheet.com\/profile\/asimcock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T17:45:49+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":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3375083206,"url":"https:\/\/community.smartsheet.com\/discussion\/106840\/report-not-showing-all-rows-that-match-the-filter-parameters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106840\/report-not-showing-all-rows-that-match-the-filter-parameters","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106840,"commentID":382043,"name":"Re: Report not showing all rows that match the filter parameters","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382043#Comment_382043","dateInserted":"2023-06-23T17:36:10+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":"2023-06-23T19:11: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-23T17:47:12+00:00","dateAnswered":"2023-06-23T17:02:03+00:00","acceptedAnswers":[{"commentID":382031,"body":"
See this article. There is a 2500 row limit for reports.<\/p>