To change a field name, you just have to directly edit the line showing the field. The field type may also be modified in the same way as at its creation by selecting the pull-down menu to the right.
Warning
If you do change the field type, all its properties will be lost. Thus a drop-down list, for instance, will be emptied.
Certain field types take on properties such as a default value or a drop-down list. For each field, these properties may be accessed by means of a pull-down menu to the left. You just need to select the Properties menu.
The window being opened depends on the field type.
This type accepts a default text which appears in all new records. Obviously, the field value may be edited in these records.
This type allows you to set an intial default value, which would appear in all new records if the increment were nil.
The increment serves as a way to create an index if its value is not nil. Then in any new record created by the New or Duplicate commands, the default value is displayed and then incremented by the increment value.
If you created an integer field with the following properties:
default value: 0
increment: 1
the first record created will have a field value of 0, the second one 1, etc.
If you displayed the field properties after creating the second record, you would obtain:
default value: 2
increment: 1
This type allows you to select a default value, which would appear in all new blank records.
The properties correspond to the script of the field. An entire chapter is dedicated to writing a script.
It is possible to select either a fixed default date or for any new record, use the date of its creation as default.
To set a fixed date, in the N/A pull-down menu, choose Select. There will appear a calendar that allows you to set a date. Once you have exited the calendar, the selected date will appear instead of N/A.
To select using the creation date, you need to check off Use Today's Date/Time.
It is possible to select either a fixed default time or for any new record, use the time of its creation as default.
To set a fixed time, in the N/A pull-down menu, choose Select. There will appear a clock that allows you to set a time. Once you have exited the clock, the selected time will appear instead of N/A.
To select using the creation time, you need to check off Use Today's Date/Time.
The properties of a list correspond to its contents. You may add, delete or replace items in the list.
Start by writing an entry in the right-hand field then tap on the arrow to add it to the end of the list.
To delete an item, all you have to do is select it and tap on Delete.
Finally, to place an item in the middle of a list, select another item, enter the new one in the right-hand field and tap on the arrow. The new item will be placed just above the one you selected previously.
Here the properties belong to the database that is being used as a basis for record selection and selection of a field which will be displayed from this record.
In the left-hand list there will appear all the databases that Pilot-DB is able to open. When you select a database, the field names for the records in the database will appear in that list.
First select a database then a field name. If you want more information on the record, see the “linked to” fields.
This field type is the inverse of the link field type. You first need to create a link field. Then you will be able to select the field to be displayed from the same record as the link field.
In the left-hand list appear all the link fields that have been set in the current database. When you select one of these fields, the left-hand list will hold the field names linked by the link field.