Quickbooks & Smartsheet

JeremiahHorstick
JeremiahHorstick ✭✭✭✭✭✭
编辑12/09/19 在API和开发者

所以。为了我自己的内部使用，我已经在Quickbooks & Smartsheet集成上工作了几年。

它有很多应用&概念的证明存在，我们使用它。

我们将其用于审批流程(用于发票):

智能表单(审批、沟通、备注)的强大功能使其成为管理发票的绝佳方式。它使我们在工作流程发票方面比Bill.com走得更远。

我们将其用于帐单(创建AR发票)

我们正在做的事情还有很多，比如合理地对费用进行分类，与投资者和主要利益相关者分享数据。

我们在Smartsheet中有供应商更新的预算，保持供应商定价。

我们根据预算和项目时间表创建了现金预测，以显示实时更新的现金需求。

我们还让它做了一些其他的事情，我只是想说一下，让你们知道我在做什么!如果有人感兴趣，请在社区中留言。

关于我们如何使用Smartsheet的列表还在继续。它基本上适用于所有事物。我下次再详细说明。

标签:
· 在Facebook上分享 在Twitter上分享
«13.

评论

类别

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":[]},{"discussionID":105733,"type":"question","name":"Reseting a row parentId","excerpt":"Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; \"0\"; \"null\" and none of them made any positive result :","categoryID":320,"dateInserted":"2023-05-26T14:22:47+00:00","dateUpdated":"2023-05-26T14:40:07+00:00","dateLastComment":"2023-05-26T20:12:12+00:00","insertUserID":105856,"insertUser":{"userID":105856,"name":"Etienne Mermillod","url":"https:\/\/community.smartsheet.com\/profile\/Etienne%20Mermillod","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mjjbH0nZWJQ!cu9Yh9XS-Xo!wwrdU3Cq-QN","dateLastActive":"2023-05-26T20:49:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"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-06T19:28:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":41,"score":null,"hot":3370244699,"url":"https:\/\/community.smartsheet.com\/discussion\/105733\/reseting-a-row-parentid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105733\/reseting-a-row-parentid","format":"Rich","lastPost":{"discussionID":105733,"commentID":377787,"name":"Re: Reseting a row parentId","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377787#Comment_377787","dateInserted":"2023-05-26T20:12:12+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-06T19:28:40+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8JN94KOJFPH3\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-26T19:50:49+00:00","dateAnswered":"2023-05-26T19:47:30+00:00","acceptedAnswers":[{"commentID":377776,"body":"

Are you trying to outdent a row?<\/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":[]},{"discussionID":105573,"type":"question","name":"How to update picklist column","excerpt":"Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?","categoryID":320,"dateInserted":"2023-05-23T11:04:52+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T14:36:12+00:00","insertUserID":161700,"insertUser":{"userID":161700,"name":"Jagdeep","url":"https:\/\/community.smartsheet.com\/profile\/Jagdeep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T10:01:33+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-06T19:28:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":65,"score":null,"hot":3369780664,"url":"https:\/\/community.smartsheet.com\/discussion\/105573\/how-to-update-picklist-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105573\/how-to-update-picklist-column","format":"Rich","tagIDs":[227,334,446],"lastPost":{"discussionID":105573,"commentID":377376,"name":"Re: How to update picklist column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377376#Comment_377376","dateInserted":"2023-05-24T14:36:12+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-06T19:28:40+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-05-24T14:31:01+00:00","dateAnswered":"2023-05-23T13:12:19+00:00","acceptedAnswers":[{"commentID":377108,"body":"

There needs to be a line break delimiter between options.<\/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"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

API和开发者趋势

  • 网络限制的Smartsheet IP地址

    嗨！我正在使用Smartsheet webhook来流式传输项目更新事件与hmac授权一起，我还想限制网络访问，以便来自Smartsheet服务器的请求将得到满足，所有其他未经授权的请求我可以获得Smartsheet的ip集吗?

  • 重置一行parentId

    嗨，对于一些需求，我想重置给定行的parentId值。我应该使用什么值来强制parentId重置?我试过了:0;零;“0”;"null"，它们都没有得到任何阳性结果:

  • 如何更新列表列

    嗨，目前我有几个列，其中包含个别列表项，但当我通过API发送更新时，它们显示为单个字符串是否有一个特定的方式，我需要发送列表项，以便每个项目单独出现?