链接到智能表功能

Mr.Hyde ✭

07/02/18 编辑12/09/19 在API和开发者

我见过一些包含创建动作的链接的帖子，比如"点击这里，该表单的副本就会出现在你的Smartsheet实例中"

我找不到OP，也想不起来她是不是工作人员，但链接起作用了。

它是可能的，然后为我创建链接到行动，例如，从链接，将导出一个报告或报告的数量为PDF。或“将特定工作表另存为新副本”。

这将有助于自动化工作流程，这将使我成为一个非常快乐的PM，并且将在仪表板上非常性感。

标签:

0 ·

喀拉广告员工

07/03/18

你好，海德先生。

请给我发一封电子邮件(电子邮件保护)我们可以进一步讨论。

最好的

喀拉海

0 · 在Facebook上分享在Twitter上分享
nishat722 ✭

07/03/18

我还想知道是否有可能创建一个链接，将导致保存为特定工作表或文件夹的新菜单。

0 · 在Facebook上分享在Twitter上分享

类别

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

I have also identified such a problem when importing a grouped Excel sheet into Smartsheet using the API and specifying a Header Row.<\/p>

Here is the Python function code to fix this problem<\/p>

First, import with header_row_index=None.<\/li>

Next, update the Columns of the sheet with the values of the header_row cells.<\/li>

Finally, delete the unnecessary rows.<\/li><\/ul>
\n \n https:\/\/gist.github.com\/jmyzk\/fc19c95a8da132aa624a33c0a50bfd86\n <\/a>\n<\/div>

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":227,"urlcode":"api-and-developers","name":"API and Developers"}]},{"discussionID":106078,"type":"question","name":"Python SDK API to add rows with Multi Columns to Smartsheet","excerpt":"I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…","categoryID":320,"dateInserted":"2023-06-06T17:04:21+00:00","dateUpdated":"2023-06-06T19:16:22+00:00","dateLastComment":"2023-06-07T16:05:05+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-07T21:50:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":148855,"lastUserID":148855,"lastUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-07T21:50:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":111,"score":null,"hot":3372226766,"url":"https:\/\/community.smartsheet.com\/discussion\/106078\/python-sdk-api-to-add-rows-with-multi-columns-to-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106078\/python-sdk-api-to-add-rows-with-multi-columns-to-smartsheet","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":106078,"commentID":379322,"name":"Re: Python SDK API to add rows with Multi Columns to Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379322#Comment_379322","dateInserted":"2023-06-07T16:05:05+00:00","insertUserID":148855,"insertUser":{"userID":148855,"name":"cabbsman","url":"https:\/\/community.smartsheet.com\/profile\/cabbsman","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!88cq90f5xTs!8sDpd7uL9Ps!kj4X4avpgGN","dateLastActive":"2023-06-07T21:50:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T16:26:26+00:00","dateAnswered":"2023-06-07T12:52:19+00:00","acceptedAnswers":[{"commentID":379249,"body":"
Hi @cabbsman<\/a> <\/p>
I see you've received a response in the StackOverflow Community on this thread:<\/p>
\n \n https:\/\/stackoverflow.com\/questions\/76417418\/python-sdk-api-to-add-rows-with-multiple-columns-to-update-to-smartsheet\n <\/a>\n<\/div>
I would suggest following-up on that thread as it looks like there are some good tips\/tricks!<\/p>
Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":227,"urlcode":"api-and-developers","name":"API and Developers"}]},{"discussionID":105822,"type":"question","name":"Smartsheet IP Addresses for Network Restrictions","excerpt":"Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?","categoryID":320,"dateInserted":"2023-05-31T04:25:53+00:00","dateUpdated":null,"dateLastComment":"2023-06-01T12:28:16+00:00","insertUserID":161903,"insertUser":{"userID":161903,"name":"Shravan A","url":"https:\/\/community.smartsheet.com\/profile\/Shravan%20A","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T18:35:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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":89,"score":null,"hot":3371130249,"url":"https:\/\/community.smartsheet.com\/discussion\/105822\/smartsheet-ip-addresses-for-network-restrictions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105822\/smartsheet-ip-addresses-for-network-restrictions","format":"Rich","lastPost":{"discussionID":105822,"commentID":378281,"name":"Re: Smartsheet IP Addresses for Network Restrictions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378281#Comment_378281","dateInserted":"2023-06-01T12:28:16+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":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T18:36:38+00:00","dateAnswered":"2023-06-01T12:28:16+00:00","acceptedAnswers":[{"commentID":378281,"body":"
Hi @Shravan A<\/a> <\/p>
Smartsheet publishes a DNS A record at aws.relay.smartsheet.com which can be added to the Allowlist in your firewall. We recommend using the DNS record and not<\/strong> IP addresses because our IP addresses may change in the future. <\/p>
Here's the link to Authenticating Webhooks<\/a> in the API documentation. <\/p>
Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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=320&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":199,"limit":3},"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

链接到智能表功能

评论

类别