It’s possible to make a different field the key field after the fact, but because this field must be the first field it limits how you can place fields on the form. iDatabase also makes the first field you create a key field, which means it must appear as the first field on your form. You can move fields up or down on the form, but it’s not possible to put fields side by side. When it comes to making changes to your forms iDatabase offers little in the way of customization. Also, iDatabase’s media field only allows for image files, not video or audio files-a limitation that makes the field less useful than it should be. While all the fields handled the data they were designed to, I found the calculation field to be limited, only offering options for basic math. Password Fields offer a way to hide and secure the data you enter and, if you secure all your databases with a password, can require the entry of that password before someone is allowed to view or copy the information stored in the field. Calculation Fields take the data entered into two Number fields and perform a basic calculation using the data in those fields. Large Text fields handle an unlimited amount of text, which you can use for notes or other multi-line text.

Small Text fields offer a single line of text you can use to enter something like a name, address, city, or state. IDatabase offers 14 field types for handling the different types of data you may want to enter. But, out of the box, the templates that ship with the app are not complete enough to be useful. These are easy enough to add to the template and once you’ve made these changes you can use your updated database as the basis for a new template. For example, if you use the built-in movie database you’ll notice that, among other things, it is missing pick lists for movie genre and lacks a release date field. All of the the templates provide a good foundation for creating databases that suit your specific needs, but as they are they lack necessary fields and need further configuration to be truly useful. Among the included templates are forms for book and CD collections, class lists, computer inventories, and exercise logs. When creating a new database, iDatabase offers the option of starting from a pre-defined template or from scratch using a blank file. IDatabase offers a simple drag-and-drop interface for adding fields to forms, but has limited form customization options.

Idatabase 3.14 mac torrent