JCards Tutorial

Contents

  1. Introduction
  2. Create the fields
  3. Change the table view
  4. Add cards
  5. Editing data

1. Introduction

This tutorial will guide you through the initial steps of using JCards by showing you how to define the database fields for a simple task manager. This tutorial assumes that you are starting with a blank database - if you have any fields already defined select File | New to create a new, blank database.

Note that icons and screenshots may differ slightly from the running application.

The following key is used to distinguish between different items:

KeyDescription
ItalicsOn screen GUI control such as a menu item or button.
TextUser entered text

Note that specific topics are covered in the Help document.

2. Create the fields

StepDescriptionScreenshot
1Select the Database | Fields... menu option to open the Database dialog. DB menu
2
  1. Before defining the first field change to the Counters tab.
  2. Click the Add button to add a new Counter. Give it a name of idcounter, but leave the value and increment values at their default values.
  3. Switch back to the Fields tab and click the Add button to create a new field.
  4. In the Name field type in ID.
  5. New fields always default to a String as it is the most used field type. Change the type to Counter.
  6. Select the idcounter value in the Counter field.
  7. Leave the other fields at their default values and click the Update button. You'll notice that the field name is added to the list on the left. If you select this field you'll notice that the Mandatory check box is now checked. This is because the first field in a database is always mandatory to ensure that by default something is always displayed in the main table.
Counter

ID field

3
  1. Click the Add button again to define a new field.
  2. In the Name field type in Summary. Tick the Mandatory check box and then click the Update button.
Summary
4
  1. Before defining the next field which will be a category we need to define the available items.
  2. Click the Categories tab.
  3. Add a new Category with a name of Task Type by clicking the Add Add button at the bottom left.
  4. Add an item to the category by clicking the Add button on the right-hand side.
  5. Type in Personal in the dialog box and click the OK button.
  6. Add another category item with a name of Business.
  7. Switch back to the Fields tab and add a new field with the name of Type.
  8. Change the Field Type to Category. This wasn't previously available because no categories were defined.
  9. Against the Category field select the Task Type category.
  10. In the Default field enter Personal.
  11. Click the Update button to create the field.
Task Type Category

Type Field

5
  1. Add a new field with a name of Start Date.
  2. Change the Field Type to Date.
  3. Set the date format to DD/MM/YYYY (or select a different format if not in the UK).
  4. Check the Date as today check box.
  5. Click the Update button to create the field.
Start Date Field
6
  1. Add a new field with a name of End Date.
  2. Change the Field Type to Date.
  3. Set the date format to DD/MM/YYYY.
  4. Click the Update button to create the field.
End Date Field
7
  1. The final field is a description of the task. Create a new field with a name of Description with a field type of Memo. Click Update to save the new field.
  2. All fields are now defined so click the OK button on the bottom left of the dialog window.
Description Field

3. Change the table view

Now that you've defined the fields you'll notice that the main table view is only displaying the ID field. To change this click on the Column selection button button in the top right corner of the table. This displays all the defined fields with a check mark against fields which are displayed in the table. Select the Summary, Start Date and Type fields.

Columns pop-up Table view

You can now rearrange the columns by right-clicking on the field's column header and selecting move left or right. Try this by moving the Type field in between the ID and Summary columns.

4. Add cards

  1. Click the New card button on the toolbar Add card button to add a new button. The card editing dialog is now shown with the ID field automatically set to 1. Fill in the other values as follows: Click the OK button to save the new card.
  2. Add a new card with the following values: Note that the ID field is automatically set to 2.

5. Editing data

Data can either be edited directly in the table (for most field types) or you can open the card and edit it there instead. To edit the data directly in the table just double-click the relevant cell. To open the card: