Help

Adding and viewing data
F
ILEMAKER PRO HELP 83
• When you revert a record, any changes made to related data (such as related records
displayed in a portal) are also reverted. For more information, see Committing data in
records.
Related topics
Working with data in date fields
Selecting the current record
Using a field index
FileMaker Pro can create an index of values for each text, number, date, time, timestamp, and
calculation field. You can view the values in the index, and insert them into a field to prevent typing
values incorrectly.
Note To use index values, indexing options must be enabled for the field. See Defining field
indexing options.
To insert values from the index:
1. In Browse mode or Find mode, click the field you want to insert an index value into.
2. Choose Insert menu > From Index.
3. In the View Index dialog box, choose a value, then click Paste.
Notes
• While the View Index dialog box is open, you can view the list of values as individual words
by selecting Show individual words.
• You can enter two or more words in a field and have them treated as one word by the index.
For example, you may want a name like Jean Louis to appear as one word in the View
Index dialog box, even when Show individual words is selected. To have two or more
words treated as one, enter the space between words by pressing Ctrl+Space bar
(Windows) or Option-Space bar (OS
X) instead of the Space bar alone.
• For a text field, FileMaker Pro sorts the value index according to the index order of the
field’s default language. If you want to display the values in a specific language’s dictionary
sort order, select Re-sort values based on and choose a language. Note that the re-sorted
index lasts only while the View Index dialog box is displayed. The next time you access this
dialog box, values will be displayed in the original order. For more information, see
Choosing a language for indexing or sorting.
Inserting the current date or other variables into a field
You can insert the current date, time or user name into a field.
After you insert one of these values into a field, that value doesn't change unless you change it. To
display a value that updates, place a date, time, or user name symbol on the
layout. For more
information, see Inserting the date, page number, or other variable onto a layout.
To insert the current date, time, or user name into a field:
1. In Browse mode, click the field.
2. From the Insert menu, choose one of the following menu items:
• Current Date to insert the current date in a date, number, text, or timestamp field.