Database Reference
In-Depth Information
—
— Microphone
. Set a Maximum duration for recording and whether recording will
Start Immediately.
—
— Bar Code
. Choose from two sources: Camera (Front or Back) or another field in
the database. Choose the type of encoding(s) you want to allow.
—
— Signature
.
▪
Insert from Index
makes your script show the same View Index window just like
choosing Insert→From Index in Browse or Find mode. Someone picks a value from the
list, and FileMaker inserts it into the field. This option is especially valuable in Find
mode, both to keep people from having to type a value (and possibly making a typo)
and
to make sure the search always finds records, since if a value is in the index, then it's in a
record somewhere.
▪
Insert from Last Visited
grabs the value from the
same
field on the
last visited
re-
cord, and inserts it. This step is particularly useful on data entry layouts. Imagine, for ex-
ample, you have to enter 300 people records from 15 different companies. You could use
this step to create a button that pops in the
last
company you typed into the Company
Name field, rather than type it over again.
NOTE
You can't just take a peek at a record and call it visited, though. The record has to be entered or
opened. An
Open Record/Request
script step helps ensure you get the record you intend.
▪
Insert Current Date
and
Insert Current Time
do just as they say. Unfortunately,
there's no
Insert Current Timestamp
step; use
Insert Calculated Result
and the
Get(CurrentTimeStamp)
function instead.
▪
Insert Current User Name
puts the user name of the person using FileMaker into the
field. Your operating system normally determines this user name, but you can easily
change it from FileMaker Preferences' General tab.
Insert step.
Putting Data in Container Fields
With FileMaker Pro 13's managed container fields you have great power to create solutions
that can move files to a shared location (using base directories, see the box on
Managed Con-
tainer Storage
)
so they're available to everyone using the database. You can either embed the
files into the database (which increases its size dramatically when you're storing lots of files)