While cruising through the forum, I found myself wanting to try the tricks that are posted and to work through examples in order to see the formulas in action. I decided to create a Playground Doc where I can reference some of my favorite posts.
Check it out and let me know if you like the idea!
If you’d like to edit formulas and test and build further, please copy the doc.
It’s also important to me to always give credit, so if you ever see any solutions posted and you know they are on a Community Post already, don’t hesitate to message me and call me out on it.
Love this @benblee! Super helpful way to learn the concepts. We have a Getting Started doc as well that showcases the basic building blocks, but this is a great way to understand how they work together.
@benblee, Great job.
I started sometime ago to create a similar doc. Just to practice the input from the community and own developments… At least for me, I need to have hands on to learn/remember the formulas.
@shishir has posted a great way to split (multiple) names, works better than mine.
I really appreciate these forms of inspiration, showing the potential of Coda
I’m playing a little bit araound with the " Lookup and Select List Column Schema". I use this a lot. What I’m trying is, to automate the dependency. So, if I choos “Fuite” in the category, the sub category, should sho automatic the first entry from this catagory (Apples).
When I change the valuee in the category, lets say I choos “number”, then I want, that the sub category also changes, to the first Item. Actually the select is not changing automatic, so that its possible to have a combinationen like:
Category -> Number
Sub -> Apples
Is there a way, to force a action like, when changing the value in category, then refresh the sub category and select the first item.
That makes sense, but we don’t have a way to do that right now. I’m not sure how it would be implemented since clicking to change the category, even if you don’t end up changing it, would lead to data being reset every time. I’m not sure of a workaround at the moment.
The first fife numbers are the “Objekt”-Number. The letter behind are the Number for the “Projekt” and “Vertrag”. So there different ways how it should look:
The problem ist, that I allways have to change every tree droptdowns, everytime. If I don’t change it, it could happen that some filter show wrong combinationen of Objekt-Projekt-Vertrag.
Any idea how to do this, or input for thinking different?
We are looking forward to learn from your know how to better design such a supportive doc.
For some this doc is basic, for some this doc is extremely advanced
Please be so kind to respect each others work and note that all community members do this free of charge in their own time, with the intention to support each other and to enjoy