Sensible

The Sensible Developer Hub

Welcome to the Sensible developer hub. You'll find comprehensive guides and documentation to help you start working with Sensible as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Matches all lines below the anchor line on the current page if:

  • The anchor line's left and right boundaries ("x extent") contain the target line's x extent, or vice versa.

    Or:

  • The anchor line and target line overlap by at least 50% of the narrower line’s x extent.

Parameters

keyvaluesdescription
id (required)column
tiebreakerfirst, second, third, last, >, <Which line in the column is the target. Use the comparisons > and < to grab maximum and minimum values in the column. By default the comparisons are sorted alphanumerically using unicode values. If you want to compare numeric amounts and ignore non-numbers, then add type: number or type: currency as a top-level parameter to the field.
includeAnchortrue, false. default: falseIncludes the anchor line in the method output

Examples

The following example shows that:

  • If you specify "type": "string" (the default), you get the entire column returned as a joined string.
  • If you specify a tiebreaker, you get a single element in the column.

You can try out this example yourself in the Sensible app using the following downloadable PDF and config:

Example PDF for columnDownload link
{
  "fields": [
    {
      "id": "example_column",
      "anchor": "may 2020",
      "type": "string",
      "method": {
        "id": "column"
      }
    },
    {
      "id": "example_column_2",
      "anchor": "may 2020",
      "type":"number",
      "method": {
        "id": "column",
        "tiebreaker": ">"
      }
    }
  ]
}

Updated 15 days ago


Column


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.