Page
|
|
|
Next Page |
|
| Contents > Adding and viewing data > Entering data in records > Entering and changing data in fields |
|
|
| Entering and changing data in fields |
| You can enter data into text, number, date, time, timestamp, and container fields. You can also change or delete data in fields. |
| If a field contains a valid URL, you can open it in another application that you specify. See Using URLs in a field. |
| You can enter data in a field up to the character limit for the field type (for example 1 billion characters in a text field). |
|
| Important To avoid confusion when using dates in FileMaker Pro, always enter four-digit years. For more information, see Working with data in date fields. |
| To delete data from a field without putting it on the Clipboard: |
 |
Select the data, then press Backspace or Delete. |
| To type a tab character into a field: |
|
Click where you want to insert the tab, then press Ctrl-Tab (Windows) or Option-Tab (Mac OS). |
| Notes |
|
When you start typing data into a text field set up to auto-complete, FileMaker Pro will attempt to match what you have entered against either the field's index or a value list. The best match automatically appears in the field. Other matches may also appear in a drop-down list. For more information on auto-complete fields, see Setting up a field to auto-complete during data entry. |
|
In Browse mode, you can use the keyboard to enter values for radio buttons and checkboxes. Tab into the field and type the first letter of the value that you want to enter, or use the arrow keys to select it. Then, press the Space bar to enter the value. |
|
The way data appears depends on how a field is formatted in Layout mode, on the system formats used when the file was created, and on your computer's system formats. See Formatting and setting up field objects in Layout mode. |
|
When working with files created on a computer using different system formats, you can choose whether to view data in its original system formats or in your own system formats. To use your own formats, verify that Use System Formats is checked on the Format menu. See Opening files with foreign system formats. |
|
A field can be defined to make sure data is entered in a specific format, or within a certain range. For example, you may be required to enter a four-digit year in a date. See Defining field validation. |
|
You may not be able to enter or change data in some fields (for example, calculation or summary fields, or fields that are formatted to prevent entry). You can copy the contents of calculation and summary fields to other fields. |
|
If you mix numbers and text in a number field that's used in a calculation or summary field, FileMaker Pro ignores the text when performing the calculation or summary. |
|
Numbers can be entered using scientific notation, for example 1.23e+15 or 1.23e-15. |
|
You can view and print only the data that fits within the field boundaries. You can change the boundaries by resizing the field in Layout mode. See Resizing and reshaping objects. |
|
There are other ways to enter data, like importing or copying it from another source, pasting a value from the field index, using a related table, and setting options to automatically enter the data when you create a record. |
|
You cannot type text directly into a container field. To enter text in a container field, copy the text, then paste it into the field. |
|
As you type text into a field, you can undo and redo your entries using the buttons on the Standard toolbar. |
| Related topics |
|
Copying and moving data in records |
|
Entering preset data from a value list |
|
Restoring data in records |
|
Using a field index |
|
Inserting the current date or other variables into a field |
|
Working with data in container fields |
|
|
| Contents > Adding and viewing data > Entering data in records > Entering and changing data in fields |
|
|
Next Page |
|