对于具有高级日期字段功能的第三方表单构建器有什么建议吗?
我正在寻找一个第三方表单构建器,与Smartsheet集成得很好,并提供了额外的功能,围绕日期字段。我们需要能够根据预先设定的截止日期轻松限制日期(即报告请求不能在未来少于12个工作日的任何日期)。理想情况下,我们希望报告请求者能够查看日历,并且只看到满足特定条件的日期(即,未来超过“x”天,分配给每个分析师的请求少于“x”#)。有什么建议吗?
答案
-
保罗新来的 ✭✭✭✭✭✭
-
她名叫Stara ✭✭✭✭✭✭
我希望你一切安好!
为了补充保罗出色的建议/回答。
在没有任何第三方服务的情况下,有一些解决方案可能可以在Smartsheet中工作。我建议开始探索它是否可以以这种方式工作。
你能更详细地描述一下你的过程吗?也许可以分享一下表格/表格的副本或一些截图?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护))
你觉得呢?
我希望这对你有帮助!
注意安全,祝你度过美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
布雷特埃里克 ✭✭✭✭
我认为没有多少表单服务与Smartsheet集成在一起,因为Smartsheet也可以做表单,所以这是竞争!我做了一些搜索,看起来一些Form服务可以做到这一点。
Formstack可以处理基于今天日期的Date Field逻辑,看起来就像Formstack与Smartsheet直接集成。如果你正在寻找一些直接与Smartsheet一起工作的东西,我认为这是你的赢家。
谷歌表单可以做到这一点,但它似乎需要一些精通技术的人使用谷歌表单API和一些编码/脚本。它直接与Smartsheet集成了。
JotForm也有日期限制,包括一个“动态”的方式,通过简单的“今天+7”来添加一周,但不允许与Smartsheet直接集成。但是,可以使用第三方连接器服务(详情如下)。
你最好设置一个应用到应用的连接器来做一些事情,比如“当表单完成时,在Smartsheet中插入一行”。你可以使用第三方工具,比如微软被低估的工具电力自动化(以前称为Flow),集成,或稳定的服务Zapier。
事实上,如果您的组织拥有Microsoft E3许可,那么您可能已经拥有访问权限电力自动化。
但是,请记住,大多数应用到应用的自动化服务都允许对Smartsheet进行相当通用的更新——也就是说,简单的事情,比如“表单完成后,插入一行然后插入到您选择的纸张的顶部或底部。如果你正在寻找更具体的东西,我确实提供了一些服务,可以做一些事情,比如在特定的标题下插入一行(即,标题为“Phase”的项目在另一行名称为“Project Plan”),根据特定列中找到的动态文本添加表单响应作为评论,等等。联系方式如下。
我希望这能让您的组织更好地了解可用的表单服务,并帮助您对表单服务做出决定!祝你一切顺利!
如果这个答案回答了你的问题,请按上面的“是”——它可以帮助社区(以及那些随机的谷歌用户)更快地找到像你这样的解决方案。
布雷特埃里克;您友好的邻居自由职业顾问和智能表助手。在领英上和我联系。
-
保罗新来的 ✭✭✭✭✭✭
-
约阿希姆Mund ✭✭✭✭✭✭
@Margaret格里芬我相信https://www.appsheet.com/将做的工作和工作完美的智能表。成本取决于你的谷歌工作空间计划。它似乎是免费的测试,我们有谷歌工作空间企业,它包括在内。
希望这对你有帮助!
-
她名叫Stara ✭✭✭✭✭✭
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
布雷特埃里克 ✭✭✭✭
@Margaret格里芬我刚从Smartsheet上找到一个30分钟前发布的公告:新!为表单上的字段添加实时验证- Smartsheet Community
但遗憾的是,可用的验证仅适用于以下内容:
现在,您可以向文本/数字字段添加实时验证,以帮助收集无错误的数字、百分比、电子邮件地址和电话号码。电子邮件验证也可用于联系人字段。
我评论说,这是伟大的,但现在我们需要更多!然后补充说我也参与了这次讨论。任何想要动态日期验证的人也应该评论!
如果这个答案回答了你的问题,请按上面的“是”——它可以帮助社区(以及那些随机的谷歌用户)更快地找到像你这样的解决方案。
布雷特埃里克;您友好的邻居自由职业顾问和智能表助手。在领英上和我联系。
-
金米。 ✭
我正在创建一个培训请求接收表来预订/安排现场培训课程-用户将填写相关详细信息,包括他们要求预订培训的日期(现场工作),以及培训课程的开始时间/结束时间。我需要做些什么才能允许用户选择培训课程的开始时间/结束时间和时区?
类别
<\/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-17T07:25:12+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-17T20:37:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"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-17T20:37:18+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":41,"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":[]}">