Coda works on relational principles so having a foundational knowledge of working with relational data is very useful. You don’t need to know about any particular database like SQL Server or Oracle, just relational theory. When I first learned, the bible was “An Introduction to Database Systems” by C.J. Date.
After that, download and play with the examples you find all over the forums. The ability to easily share “code” is one of Coda’s biggest strengths.
Let’s say from the moment that you are able to interact with 3 to 5 tables, get the structure right and abstract the info you need by “views” / “filters” / “get the info on the canvas” you have the basic skills to create your own doc as an app!
This community, the templates and build in examples are a rich resource of know how. Good explanation of formulas you will find in this post, and hopeful we will receive soon more
When trying to get up a higher level and go to more complex use cases, it becomes a must to take pen and paper, write down the structure and don’t forget to create junction tables to get added values from the relation between two tables for example to make calculations.
Airtable guide , especially the “advanced tips and tricks”, is giving me often the right inspiration. In big lines the way of working is the same, but don’t expect to copy past!
Start from the end and go back; envision the expected result, “what do I need to get there”? Then write down or draw the steps to be taken. The result is what counts! Later on you can try to combine the steps.
Last but not least, this community is great, thanks to the active members and Codans, on most of the questions is found a creative solution and the formulas are visible. ALWAYS REMIND TO TRY TO CREATE A DUMMY DOC AND EXPLAIN YOUR EXPECTED RESULT. This will provide the right foundation to receive the support you need. And we all can learn
You are not alone, but beyond everything “CODA” gives the oppertunity to become more creative and encourages you to find different paths.
Will do. I already registered a domain, codatricks.com (nothing there yet), will start putting out materials as soon as I finish with my current other stuff. Firstly I want to write a post about some best practices how to approach Coda and organize your docs. Actually, the Coda team did a very great write-up on that in their recent post about formula performance.
The best way to learn Coda for me was looking at the template gallery. I remember how confused I was the first time I saw Coda (it was Product Hunt Makers Festival), and how quickly up to speed I got when I saw what was possible and how, due to the templates.