Developers Blog

Under the Hood of the Sheet Tweetr Sample App Taylor Krusen February 16, 2018

In this post we’ll take a look at the guts of Sheet Tweetr to see how everything works. This is a deeper dive than the intro article, API Sample App: Sheet Tweetr. The source code for Sheet Tweetr is available on GitHub.  

Sheet Tweetr is a simple application that sends tweets from Smartsheet and serves as a sample app for working with the Smartsheet JavaScript SDK. Sheet Tweetr reads a sheet, checks each row to see when the tweet is scheduled to go out, and posts the tweet when the time is right. The tweet can go out multiple times depending on the frequency set by the user.

DeveloperWeek Hackathon 2018

Scott McAllister on February 14, 2018
DeveloperWeek Hackathon at Galvanize in San Francisco

Over the first weekend in February 675 hackers gathered to form over 165 teams at the Galvanize offices in San Francisco to participate in the Developer Week Hackathon. Smartsheet was on the scene to challenge the hackers to use the Smartsheet API and incorporate Smartsheet into their projects, and we were blown away by the reception that we received.

We kept the hackathon challenge broad, inviting teams to come up with the best usage of the Smartsheet API (with bonus points given for use of webhooks). Fourteen groups registered for the Smartsheet challenge, and the groups kept the Smartsheet team busy throughout the weekend with questions about the product, the API, and developer tools.

Abacus Product Release

Scott McAllister on February 6, 2018
Abacus by Eric Heston

 

A couple of weeks ago, Smartsheet pushed out a product update we called Abacus. It doesn't always happen that the code name for a release and its features relate, but this time the two fit together nicely, as the main feature unveiled was an improvement to our in-cell Formulas. With this release, users will be able to write formulas that cross into other sheets.

Until now, all formula data had to live in the same sheet, making it difficult to perform lookups or calculations on data in different sheets. There were workarounds, where users could use complex combinations of cell links and hidden columns, but these were fragile and difficult to use.

Now, with cross-sheet formulas, users only need a formula to calculate data from other sheets. But, coming up with the syntax that would be used to reference other sheets took some thinking.

Smartsheet Sponsors Developer Week 2018 Hackathon

Taylor Krusen on January 26, 2018
Smartsheet sponsors Developer Week 2018

Developer Week 2018 is shaping up to be the largest developer expo+conference series in the world, offering the chance to mingle and learn from the leading tech companies and professionals from all around the world. This year, Smartsheet will be in attendance as one of the top sponsors.

Developer Week offers the nation’s largest challenge-driven hackathon with over 1,000 participants (registration here). This year Smartsheet will be challenging participants to find innovative and effective ways to use our platform to improve the experience for our users.

Smartsheet is no stranger to innovation and looking for effective ways to help our users with our product. Just last month we held our third annual employee Hackathon, Hack the Sheet. We were impressed with how far our employees were willing to push the envelope.

Creating a Smartsheet OAuth Flow in Node.js

Taylor Krusen on January 23, 2018
Creating a Smartsheet OAuth flow in Node

This article will cover OAuth at a conceptual level—following the flow of information through the authentication process. The snippets of code in this article are from Smartsheet’s Node OAuth Flow Sample. The sample is in Node, but the concepts carry over to other languages.

Accessing Smartsheet through the API requires an access token to be included in the Authorization header of each request. For standalone applications that only access your personal Smartsheet data, you can generate an access token in the Smartsheet UI. However, if your application needs to let multiple users login with their own account, then you will need to implement the full 3-legged OAuth flow.

Please refer to the diagram below for an overview of Smartsheet’s OAuth flow.