MyWraps data types

This help page describes the data types provided in the MyWraps report generator, and the signature properties that can be requested.

Unlike most other development environments, you don’t define the database, it’s tables or columns before you use them. WrapCreator automatically saves all wrap data in the database in the most efficient way.

The ability to select a data type for a column in MyWraps has nothing to do with how the data is stored, it is only used to define the features of the existing data in the database for the report generator. If a cell always contains an integer, you should define the corresponding report column as an integer, so that it is formatted and sorted correctly. For an integer value, you also have access to additional aggregation functions like min and max.

Data types

This metadata controls how a cell appears in the report, e.g.

Options.Columns= ... %2Cpartcost.double.f2%2C ...
  • string designates a text field, e.g. “This is a text string”.
  • int is an integer, a whole number without decimals, e.g. 42.
  • double defines a floating-point number with decimals, e.g. 3.1415
  • percent is a percentage with decimals, e.g. 314.15%
  • date formatted according to the Wrapsite settings, e.g. 14/10/1955 for local UK day/month/year.
  • time formatted according to the Wrapsite settings, e.g. 23:45 for local UK time a quarter to midnight.
  • datetime date and time together, e.g. 14/10/1955 23:45
  • oadate is a date in Excel format, i.e. as an Excel serial number, an integer value for dates, e.g. 20376 for Oct 14, 1955.
  • oadatetime refers to a time and date in Excel format, i.e. as an Excel serial number, a decimal value for time and date, e.g. 20376.9895833333 for 14/10/1955 23:45
  • anchor designates a field as containing HTML code that will be rendered in the MyWraps result, e.g. to add images or hyperlinks to a report.

Signature properties

This metadata can be requested from signature fields, e.g.

Options.Columns= ... %2CSignature.sig-datetime%2C ...
  • sig-detail returns all the below information
  • sig-summary is the contents of the signature field, e.g. CM 14/10/1955, i.e. user nickname and date
  • sig-date returns the date when the signature was made, e.g. 14/10/1955
  • sig-time returns the signature’s time, e.g. 23:45
  • sig-datetime returns both the above, e.g. 14/10/1955 23:45
  • sig-username the name of the signee, the user that made the signature, e.g. ChrisMartin
  • sig-firstname is the first name of the signee, e.g. Chris
  • sig-lastname is the surname of the signee, e.g. Martin
  • sig-nickname returns the nickname or initials for the signee, e.g. CM
  • sig-company contains the company name registered for the signee, e.g. Fleischmann
  • sig-location says where the signee is located, e.g. Exeter