Okay, please hear me out on this! I understand that many people will not like this or agree with me, but allow users to insert and/or create actual spreadsheets inside Coda documents.
Currently, users are only able to create or insert tables that are relational databases (relational tables) in Coda documents, copy/paste portions of a spreadsheet that become relational databases, or import CSV files that also become databases.
I understand the power of relational databases, but Coda has a schizophrenic feeling for me when I use it. On one hand, the Text & Layout (i.e., “word” part of it) functions feel simple to use. I put what I need where I need it to go, and it works. The tables aspect, however, feels like overkill for much of what I am trying to accomplish and if I do need the power of a relational database (which I usually don’t), I feel overwhelmed by what it requires of me. In many cases, I am told to rethink what data I actually need or how to restructure the data so that it will work better in Coda.
Essentially, I am preparing reports that use a variety of formats or I am aggregating information in such a way that long-term storage and retrieval is not needed. If I am preparing an annual budget for my organization to present to my board of trustees, for example, inserting or embedding a spreadsheet inside the document works great. Doing it in Coda makes sense because I can add all sorts of other goodies like PDFs, images, media files, maps, and so on together in one place. Coda actually handles these items quite well. Using relational tables for the financial part of things does not make sense though and that’s where using Coda falls apart for me.
I guess I’m just a caveman. As a caveman, is it possible to just give me a simple tool for simpler tasks? Having such a spreadsheet option is no threat to Coda. It’s just another way for people to get work done. Yes, documents evolve, but is it not true with evolution that the evolved form and original form can co-exist at the same time?