Format range

​

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Format an order header", () => {
  onDashboardRun({ title: "Format an order header" })

  googleSheets.formatRange({
    spreadsheet: "spreadsheet-id",
    range: { table: "OrdersTable", section: "header" },
    format: {
      backgroundColor: { theme: "accent1" },
      borders: {
        bottom: { color: "#1A73E8", style: "solidThick" },
      },
      horizontalAlignment: "center",
      padding: { top: 4, right: 8, bottom: 4, left: 8 },
      text: { bold: true, color: "#FFFFFF", size: 11 },
      wrap: "wrap",
    },
  })
})

​

Inputs

• backgroundColor: a six-digit hex color such as #1A73E8, or { theme } where theme is text, background, accent1 through accent6, or link
• text: family, integer size, bold, italic, strikethrough, underline, link, and color
• borders: top, right, bottom, left, innerHorizontal, and innerVertical. Each is null to clear it or { style, color? }, where style is dotted, dashed, solid, solidMedium, solidThick, or double
• horizontalAlignment: left, center, or right. verticalAlignment accepts top, middle, or bottom
• wrap: overflow, clip, or wrap. textDirection accepts leftToRight or rightToLeft. hyperlinkDisplay accepts linked or plainText
• padding: integer top, right, bottom, and left pixel values. Google requires all four sides
• rotation: { type: "angle", angle } with an integer from -90 through 90, or { type: "vertical", vertical: boolean }
• numberFormat: optional Sheets pattern and type: text, number, percent, currency, date, time, dateTime, or scientific

​

Output