Set a color in conditional format by formula

[Paul_Danyliuk]

@Denis_Peshekhonov @Nick_Milner — I dug into Coda’s source code (JS) and here’s the most complete list of hidden functions that there can ever be.

• _Bold()
• _Code() — should apply code styling but doesn’t
• _Color()
• _Highlight() — no way to specify color though
• _Italicize()
• _RichText() — seems to be useless, basically does the same as Concatenate()
• _Strikethrough()
• _Underline()

Next ones I haven’t tested, just listing here (case-insensitive). Some are experimental and may not work at all.

• _MergeConditionalFormats — “Deeply merges objects”
• _PROJECT_COLUMN_FOR_ROWIDS — “Filters rows in a table to the set of rows with ids matching the values”
• _HASH_MATCH — “Filters on column equivalence on some or all matching columns”
• _TRUE — not sure why it exists along with just True().
• _RandomImpl — “Generate a random number”
• _CREATE_ERROR — “Create an error”
• _DELAY — “Returns a value after some delay”
• _FAKE_ARRAY — “Returns an array with a schema”
• _FAKE_OBJECT — “Returns an object with a schema”
• _WRAP_INVALID_FORMULA — “Used to wrap an invalid user formula so the invalid input does not break AST parsing.”
• _MERGE — “Deeply merges objects”
• _DEREF_OBJECT — “Dereferences the given path”
• _DEREF — “Dereferences the given input with the given reference”
• _DEREF_OPT — “Dereferences the given input with the given reference”
• _ROW_KEY — “Returns the reference key for the given row”
• _SORTED_SEEK — “Filters on column equivalence on some or all matching columns”
• _RANDOMIZE_CURRENTLOCATION — “Random travel”
• FormatCurrency()
• FormatDateTime()
• FormatDuration()
• FormatNumber()
• FormatPercent()
• FormatTime()
• ATTACHMENTCONTROL
• BUTTON
• CHECKBOX
• DATEPICKER
• DATERANGEPICKER
• FORMULACONTROL
• MULTISELECT
• SELECT
• SCALE
• SLIDER
• HTML()
• BLOB — for system use only
• STDEV and STDEVP
• Identity
• ToHtml
• Project — “Projects one or more columns from the given result”
• CurrentLocation
• RegexExtract

There are also some undocumented (and perhaps experimental) actions:

• _NoOp() — no operation to use in IF statements for an action
• DuplicateSection()
• Xhr() — make an XHR request to an URL with arbitrary method and body
• RefreshPack()
• StartSync()
• FinishSync()

I also found some experimental formulas for charts — although those use ugly Google Charts API and not Coda’s default Highcharts. I suggest you don’t use these unless Codans give us a leave to do so:

• PieChart()
• LineChart()
• BarChart()
• PieChartAggregate()
• Histogram()

Also using Google APIs:

• GoogleDirections()
• GoogleMap()
• LaTeX()