Custom Fields & Data Types

Posted Nov 02, 2011 in Features

We’re hard at work on some major new additions coming to the ReadySuite and ReadyConvert product lines. We’ll be discussing some of these in detail here as we get closer to releasing them.

First up, we’ve added the ability for you to specify data types for custom fields (aka metadata). An immediate benefit of this feature is how we allow you to sort and filter on columns in the grid. See illustration below – you can now filter on a date column by year, month and day.

Filter Dates in Grid

In addition, date columns will be correctly sorted by oldest to newest or vice versa. Initially, we’re going to support the following data types: Boolean (Yes/No), Number, Decimal, Date, Time, Date/Time, Text and Memo. Other enhancements to the grid will allow you to correctly summarize number/decimal columns, see a checkbox for boolean types, and make coding changes using specialized editors in each cell.

Grid Changes

With this change, we’ve added a new ‘Modify Fields’ dialog. Here you’ll be able to add, modify and delete fields. You can set a field to read-only mode by setting its Locked property, preventing accidental changes made to that field.

Modify Fields

Fields will also support an export mask. This is particularly useful for Date fields. For example, if you specify an export mask on field ‘DATESENT’ and the date you imported was ‘2011-11-02’, on export you’ll be able to retrieve it as ‘11/02/2011’. You can specify export masks for Boolean, Date, Time, Date/Time, Decimal, and Number fields.

Further to supporting custom fields, we added an option to re-adjust the internal DOCID field. Using the Modify Fields dialog, you can set any field as the internal DOCID field.

In our next post, we’ll discuss how we’re adding support for saving projects.