An overview of dashdash's unique features

#1

Welcome to dashdash!

dashdash is where you create custom tools using only the spreadsheet skills you already have. You can type formulas in cells and connect to online services, grab data and automate your app with the functions you already know. No scripts, no plug-ins.

What is unique about dashdash?

  1. Connected to web services. Talk to useful services and APIs from inside a cell, just like web developers.
    • Use our integrations to send emails & slack messages, search maps and your CRMs and more!
    • Hackers: There’s also GET() and POST() with which you can talk to the vast majority of APIs. Read more about APIs here.
    • We also support handling data inside the responses of Integrations and web requests. Check more about json.
  2. Automated and always-on. Run a certain action periodically, without needing to manually update it, even when you are offline.
    • REFRESH(range, ...) makes a range of cells refresh at every minute, hour (default), month, etc. It’s very powerful, and works even if you don’t have your app open.
  3. Smart at handling data. Update and Insert rows from a table into another without ever lifting a finger.
    • INSERT(source_header, data, target_header) inserts the data rows under source_header into the next available row below target_header.
      • Use INSERT_DATA() to insert from a cell with data (JSON) instead a range.
    • UPDATE(source_range, key, data, target_range) updates the rows below target_range with the data rows provided under source_range. If it doesn’t find a matching row, it will even insert a new one! To determine if a row needs its data updated or if a new row is needed, it considers the cells on source_range, from 1 to keys_number.
      • Use UPDATE_DATA() to provide a cell with data (JSON) instead of a data range.
    • Also check FILL().

Our team is working hard to build even more new functions and features in these categories and more. We want to provide you with a modular way of building your apps.

Limitations: dashdash is permanently being improved in functionality, stability and performance. Check Dashdash limits to know the current documented limitations of the platform.

5 Likes