filters:
  and:
    - file.inFolder("01 Projects")
    - file.ext == "md"
    - type != "dashboard"
    - file.basename != "Projects Index"
    - file.basename != "Dashboard"
formulas:
  age: (now() - file.ctime).days.round(0)
  stale: if((now() - file.mtime).days > 30, "⚠️ stale", "✓")
properties:
  name:
    displayName: Project
  client:
    displayName: Client
  status:
    displayName: Status
  tech:
    displayName: Stack
  deploy:
    displayName: Deploy
  formula.age:
    displayName: Age (days)
  formula.stale:
    displayName: Activity
views:
  - type: cards
    name: Cards
    order:
      - name
      - client
      - status
      - tech
  - type: table
    name: All Projects
    order:
      - name
      - client
      - status
      - tech
      - deploy
      - formula.age
      - formula.stale
  - type: table
    name: By Client
    groupBy:
      property: client
      direction: ASC
    order:
      - name
      - status
      - tech
      - formula.stale
  - type: table
    name: Active Only
    filters: status == "active"
    order:
      - name
      - client
      - tech
      - deploy
      - formula.age
