Hi Coda community! Still learning the syntax of formula writing in Coda.
I’m trying to write a formula on blank canvas that I want to return a filtered list of the table Wine Database that returns the Producer, Denom, and Wine Named for all rows where 86’d is checked.
Here’s a screen shot of the table and columns in use
You could have a look at the FormulaMap() formula.
Your code could be something like: [Wines Database].Filter(86'd).FormulaMap(Format("{1} - {2}",@CurrentValue.Producer, @CurrentValue.Denom)).BulletedList().
Note:
As you can see, in a checkbox field it’s not necessary to explicitly set equality to boolean.
FormulaMap() processes sequentially all the elements of an array.
Therefore [Table].Filter(condition) (in your case [Wines Database].Filter(86'd))
returns a list of rows. With FormulaMap() you take one row at a time (the @CurrentValue variable) and you can access all the columns of that row.
Format() function allows you to - well - format text along with variables. Number in curly braces are the placeholders of variables, sequentially. So you are able to format the sting and “fill” it with the variables at each iteration.
Sure, just “escape” the quotes with the backslash (\).
Hence: Format("This is my \"quoted\" text") or Format("This is my \"{1}\"", [quoted-variable])
Thank you, @Federico_Stefanato! That makes so much sense now. Learning so much here. Your plain language explanations make more sense to me. I’ve been using the Coda Formula’s Reference but I don’t always find their usage examples applicable or helpful in figuring out the formula for a newbie such as me.
Where could I find a list of the syntax used within formulas? For instance, where would I have learned about “escape” the quotes with the backslash ( \ )?
In Coda’s Help, I would have expected to find that here in the article on Writing in Coda’s formula language. But the list is rather scant.
Hi @Jeff_Fleming,
Yes, you are right…
The Formula Reference could be improved a lot and I’m sure it’s one the things @Codans are thinking about.
My background is software engineering, so I’m helped by similarities among different coding languages.
However, just put your hands on and you’ll see you’ll master Coda in few weeks.
Meanwhile, you can rely on this community that is always helpful and responsive.
