There are several field types that are variations of the “text field” including:
Both the Email & Website fields are based on the standard Text Field. You may want to check out the page on the Text Field as it contains some helpful hints on manipulating text. Both the Email and Website have additional features and constraints explained below.
The number field is actually a very versatile field, allowing to use it in a variety of circumstances for everything from quantities and dollar values to units of measurement, etc. Just as important as the field, we created a custom keyboard that doubles as an in-app calculator you can use for data entry.
The phone number field is a strictly formatted field. It will allow you to enter numbers in number of standard formats.
The date fields include 3 different fields:
The checkbox field is remarkably simple. Tap to select, tap again to de-select.
The Rating field allow you to set up a simple touch-based rating system using anywhere from 1-10 max rating. It’s pretty simple but here’s a few things you might want to know.
The image field is used to store… well, images. You can grab images either directly from the camera or from your photo library. Images can be viewed in full-screen by tapping on them (same as for all the fields), and you can Pinch on an image to zoom into it. Note that Flexile stores two copies of each image you add: A full resolution copy, and a smaller “thumbnail” it uses to load up images quickly in the record list.
The Pick List field allow you to create a set of values you can then select from in a record. The Pick List offers a convenient way to limit the value of a record field to only a certain set of values.
The audio field is used for recording audio with your device’s microphone. While recording, Flexile can pause & resume recording. Flexile can record separate segments (stop and start instead of pausing) and it can delete individual segments if needed. Flexile can also append a new recording to an old one.
The location field will store addresses as well as GPS location (Latitude/Longitude) and display a map you can use to set the position of an address, search for an address and edit an address. Note that the map will only work if you have an internet connection or (on occasion) if the address location happens to be cached in Apple’s maps (hey, it happens…).
The calculated field allows you to perform calculations on other fields. Flexile uses a drag and drop interface with an active alert system for creating the calculation formulas. This should make it very easy to develop the calculations (yay! no formula typing). Formulas are updated whenever any of the fields they reference are updated.
The aggregate field will combine the values of a particular field in linked records. Aggregate fields are updated when any of the records they refer to are changed. The aggregate field is also updated when links are added to or removed from the record.
The running balance field is used to create a running balance on another field in the same table. Unlike every other field, Flexile doesn’t store running balance calculation in the table. Instead, it calculates the balance when the record is displayed in the record list and updates those balances whenever the record set changes. If you open a record from the record list, the detail view will also display the balance.
The reference field is a simple but powerful field that allow you to reference another table field. It pulls its data through through either the first or last link for each record and displays the data in the same control the referenced field uses.
The Concatenation field will allow you to take the text values from other fields and combine them into a single field according to a formula you create. A simple example of this would be to take separate name fields (First, Middle & Last) and combine them into a single field (Full Name). Formulas can range from being fairly simple to remarkably complex, depending on how much control you want over the formatting of the text.
While editing a field’s options, you may notice a curious option called “Enable Copy”. This is a unique option that will allow you to copy in a value from another table (or even the same table) field. This can allow you to use another record (in the same table) as a template, or you can even setup another table that only contains templates you can use to add records to this table.