Agent tables: a simple CRM

The lines the agent sends:

table create crm Name:text Stage:text Value:number:$ Next:date Won:bool
put crm acme Name="Acme Co" Stage=Proposal Value=12000 Next=today+2
put crm bolt Name="Bolt Studio" Stage=Lead Value=3000 Next=today+5
put crm cedar Name="Cedar Dental" Stage=Call Value=8000 Next=today+1
put crm dune Name="Dune Coffee" Stage=Won Value=4500 +Won
query crm where=Stage!=Won sort=Next cols=Name|Stage|Value|Next as table "Open deals"
query crm group=Stage sum=Value as chart bar x=Stage y=Value "Pipeline"
query crm sort=Next cols=Name|Stage|Won as list check=Won "Mark a deal won"

• Edit it in the playground
• See it with the rest
• YUI-33 on the board
• Get Yui on your iPhone