How To Get Current Crypto Prices into a Google Sheet Using Google Scripts and the CoinMarketCap API

1. Sign up for an account with CoinMarketCap at coinmarketcap.com. 2. Get an API key: Go to Settings > Products > Crypto API, or just click here. 3. Create a Google Sheet where you want the prices to update, like this one. You can actually make a copy of that one and use it as … Continue reading How To Get Current Crypto Prices into a Google Sheet Using Google Scripts and the CoinMarketCap API

Smart Contract Coding Learning Resources

Here are some really simple examples of code that actually creates the foundation for everything you need to know. Try these in remix as you go:https://solidity-by-example.org/ All of Patrick Collins's videos are great. Here are a few:https://www.youtube.com/watch?v=M576WGiDBdQhttps://www.youtube.com/watch?v=GBc3lBrXEBohttps://www.youtube.com/watch?v=bdXJmWajZRY Buildspace has some really good, hands-on courses:https://buildspace.so/ A few videos I've made:https://www.youtube.com/playlist?list=PLA1j0xIg3Mt9DIDBPl49XBirGUnZ--_kx And if you want to start … Continue reading Smart Contract Coding Learning Resources

The Best Thing About Teaching Myself to Code Wasn’t that I Can Code

I love learning but never liked school. School told me that the time to learn math was 12:55 to 1:50. School made me read pages 142–175 and answer problem set 7 on page 176. School gave me a quiz the next day. School often made me sit quietly in a chair while someone talked at me. … Continue reading The Best Thing About Teaching Myself to Code Wasn’t that I Can Code

How to automate filling out Google Doc templates

Lawyers, operations teams, many of us perform repetitive, time-consuming, error-prone tasks, including filling out templates for NDAs, offer letters, employment agreements, consulting agreements, and more. Save yourself time and reduce errors by automating those tasks. Here’s a relatively simple way to take data from a form or spreadsheet and use that data to perform one … Continue reading How to automate filling out Google Doc templates

From Lawyer to Deploy

I’ve learned a ton of great stuff in the last year and I’ve had a lot of fun learning all of it. Most of it is not easy to just throw onto a webpage, but some of it is exactly that. So, I’m working on a website to display a lot of what I’ve learned … Continue reading From Lawyer to Deploy

The wrong question: “I want to learn to code, what should I do?”

If you want to learn to code and build stuff and you’re starting by asking someone else what you should do, you’re already thinking about it the wrong way. Immediately, right now, with no preparation, in the blink of an eye, you can take a huge step toward your goal by realizing that you don’t … Continue reading The wrong question: “I want to learn to code, what should I do?”

Learn the Basics of Computer Science and Web Development

Two and a half years ago, I started doing every computer science and web development tutorial I could find. If I were starting again today, knowing what I now know, I’d do it something like this. Start with the basics of computer science and programming. Introduction to Computer Science I, David Malan, Harvard Extension School … Continue reading Learn the Basics of Computer Science and Web Development