Extracting data from Project Organizer projects

This page displays formulas that extract information from Project Organizer projects.

Information related to projects
To extract Use
The name of the project. $PO.ProjectName$
The code by which the project is referred to in Project Organizer. $PO.Code$
The date when an order was made. $PO.OrderDate$
The date when delivery is due. $PO.DeliveryDate$
The current status of a project. $PO.Status$
The price of the project. $PO.Price$
Notes entered for a project. $PO.Note$
The material used in a project. $PO.Material$
How many pieces have been ordered. $PO.PcsCount$
How many colors are needed in the project. $PO.ColorsCount$
The width of a design. $PO.Width$
The length of a design. $PO.Length$
The height of design. $PO.Height$
Information related to customers
To extract Use
The name of a customer. $PO.CustomerName$
The code identifying a customer. $PO.Customer.Code$
Whom to contact about a project. $PO.Customer.Contacts$
The phone number entered for a customer. $PO.Customer.Phones$
The mobile phone number entered for a customer. $PO.Customer.Mobiles$
The fax number entered for a customer. $PO.Customer.Fax$
The email entered for a customer. $PO.Customer.Email$
A second email entered for a customer. $PO.Customer.Email2$
A customer's website. $PO.Customer.WWW$
A customer's address. $PO.Customer.Address$
Notes about a customer. $PO.Customer.Note$
The last time a customer was contacted. $PO.Customer.Contacted$
Information about users (designers)
To extract Use
A user's login name. $PO.Designer.Name$
A user's full name. $PO.Designer.FullName$
A user's email account. $PO.Designer.Email$
A user's phone number. $PO.Designer.Phones$

See the general rules for how to write formulas and format formula results.