Claris FileMaker Certification Study Guide

Claris FileMaker Certification

Study Guide

Introduction

The Claris FileMaker Certified Developer credential demonstrates to clients, peers and

management that you have achieved an essential level of knowledge, experience, and skills in

developing on Claris FileMaker.

This study guide is designed to help you prepare for the test. It covers the seven Claris

FileMaker knowledge domains that are assessed by the certification exam. Although this

guide divides the tasks and review questions into knowledge areas, questions are presented

randomly during the exam. This guide contains three sections for each knowledge area:

1. The objects or statements that you should be able to demonstrate completely.

2. Links to FileMaker Help topics and other resources to review.

3. The exam consists of multiple choice questions.Questions that represent the kinds of

knowledge tested on the exam and answers to those questions. The exam consists of

multiple choice questions.

How to Use This Guide

We recommend that you use this guide to determine what to study as you prepare for the test

in the following ways:

1. Read each objective. You should be prepared to be able to accomplish the task each

objective states.

2. Answer each question to your best ability.

a. Read the FileMaker Help topics to find the answer.

b. Figure out your best answer to the question. Compare it to the answer given.

Exam Details

The Claris FileMaker Certification exam is computer-based and offered in PearsonVUE testing

locations worldwide.

Here are the Claris FileMaker Certification exam details:

There is a non-disclosure agreement and tutorial. You have 10 minutes to complete

them.

There are 60 scored technical questions. You have 110 minutes to complete them.

The exam uses a random pool of multiple-choice questions. Some questions ask for

more than one answer.

Candidates taking the English test in countries where English is not an official language

will automatically have an extra 30 minutes added to the exam seating time.

You may not access any resources or references during the exam.

If you have questions about the exam, visit FAQs for FileMaker Certification.

1. Defining Database Schema (10 - 15%)

Identify the characteristics and implications of using various auto-entry options.

Identify the characteristics and implications of using various field types available in

FileMaker Pro.

Identify the mechanisms and behaviors of validation options and describe the possible

outcomes when one is triggered.

Use a storage option to achieve a desired result.

Use a container storage option to achieve a desired result.

Given a particular Relationships Graph and scenario, define a result.

Given a scenario, define the appropriate relationship.

Use ESS to integrate data from external data sources and properly design a schema.

Preparation resources

Guide

FileMaker Go Development Guide

Claris FileMaker Pro Help topics and subtopics

Defining and changing fields

Setting options for fields

About container fields

Working with related tables

Accessing external data sources

Questions

1. What are five of the auto-entry options available for fields?

2. The auto-entry field options for a calculated value include a checkbox that says, “Do

not replace existing value (if any)“. How does unchecking this box change the field’s

behavior?

3. What is an index for a field? Describe the two indexes available in FileMaker Pro. Are

there field types that cannot be indexed?

4. What methods of setting a field with data are not considered data-entry for the

purposes of field level validation?

5. List the order in which the following actions occur:

a. A field is exited

b. A field’s value is changed

c. The value is saved

d. The value is validated

6. A hosted FileMaker file has a container field that is stored globally, and it holds the

company’s logo. This field is placed on all report layouts. In a preferences table, the

developer inserts the logo into the container field. A user reports that the logo is not on

any of the reports. What caused this? How can it be fixed?

7. A custom app contains tables for Teachers and Classes. A teacher teaches many

classes and a class can be taught by many teachers. How would you set up the data

structure - the Relationships Graph and any additional tables - to show all the classes a

teacher teaches and/or all the teachers that teach a specific class?

8. In a FileMaker file, there is a table called ContactMethods. The table occurrence

Students_ContactsMethods is related to the Students table occurrence, as shown

below.

A developer wants to add a calculated field in the ContactsMethods table that stores

the last name of the related Students. When setting up the calculation, she discovers

the Students table occurrence is not related.

What would she need to do to have access to fields from the Students table?

9. Does each table in a file need to have a table occurrence on the Relationships Graph?

Answers

1. A field’s auto-enter options include:

a. A calculation

b. Record-creation data

c. Record-modification data

d. A serial number

e. The value from the same field of the last active record

f. A static piece of data

g. A looked-up value

2. When you uncheck the “Do not replace existing value (if any)” checkbox, data in the

field will be overwritten when one of the fields referenced in the calculation is modified.

3. An index is sorted list of the unique words or values in a field. Indexes are used in finds

and relationships. There are two types of indexes:

a. Value indexes

i. Can be created for text, number, data, time, timestamp fields, as well as stored

calculation fields that return these data types.

ii. Used for relating records and searches in non-text fields.

b. Word indexes

i. Only created for text fields and stored calculations fields that return text.

ii. A list of the unique words in a field.

iii. Used in searches

Container fields, summary fields, any field with global storage, and unstored

calculations cannot be indexed.

4. The following actions are not considered data entry for field validation purposes:

a. Replacing field contents

b. Importing records

c. Setting a field during a script

5. The order of the actions:

a. A field’s value is changed

b. The value is validated

c. The value is saved

d. The field is exited

6. A field with global storage retains the last value set when the file was closed on a local

computer, and global storage is unique to each user of the file.

The developer has two options. He can remove the file from FileMaker Server, insert the

logo into the container field, close the file, and host it again. Or, he can store the logo in

a container field with regular storage and write a script that runs when the file is opened

that inserts the logo into the container field with global storage.

7. To show all the classes a teacher teaches, a join table, possibly called “Schedule” is

needed. A record in this table represents the association of a teacher with a class.

8. The developer needs to change the context from which this calculation will evaluate.

That is done at the top of the calculation dialog.

Changing the context to the Students_ContactMethods table occurrence will allow the

developer to create this calculation field.

9. No, you can delete any table occurrence.

2.  Building Layouts  (10 - 15%) 
Describe the implications of tying a layout to specific table occurrence. 
Identify characteristics and behaviors that can be assigned to a portal. 
Describe which field/ layout object behaviors can be modified. 
Describe the types and attributes of script triggers. 
Given a scenario, identify the implications of choosing a particular trigger type.  
Identify the properties, use, and capabilities of themes, object styles, and states. 
Describe the setup and behavior of layout parts. 
Identify the implications of layout design across different clients. 
Preparation resources 
Claris FileMaker Pro Help topics and subtopics 
Creating and managing layouts and reports 
Editing objects, layout parts, and the layout background  
Working with related tables 
Deciding where to place related fields 
Navigating in web viewers 
Creating charts from data 
Sorting records by subsummary values 
Script triggers reference 
Navigation script steps reference 
Questions 
1. The phrase “Context is king” is at the core of FileMaker Pro. How does this idea affect 
FileMaker Pro actions such as scripting, data entry, and layout creation? 
2. A custom app has three tables: Companies, Employees, and Contact Methods. 
The employee John Smith has three records in the ContactMethods table for cell 
phone, work email, and personal email, entered in that order (in the ContactInfo field). If 
a portal to Employees is placed on the Companies layout, and the field 
ContactMethods::ContactInfo is placed in the portal, what would you see in that field 
for John Smith? How would you change the portal on the Companies layout to be able 
to view all ContactMethods records for each employee? 

3. What are the three options for the data source of a chart object? Explain how each

differ in terms of the way the data is gathered.

4. What object attributes can be modified in the Objects tab?

5. A developer uses the Objects tab to hide an object so she can work with other objects

on the layout. What circumstances will cause the object to become visible again?

6. A field has a themed style called “Edit_Left” that is set to be left-aligned with 12pt gray

text. What are two ways that this style can be overridden?

7. A FileMaker file has a custom style for a field called “Label_Right”, which is styled as

right-aligned, 10pt, and red. The developer wants to use this style on another layout, so

he copies the object’s style using the Copy the object’s style button and selects

another field on another layout. He uses the Paste a style button. What happens?

8. A phone number field on a layout needs to have a script trigger on it that checks to see

if the field contains an entire phone number in the proper format. If the user enters

“2123” in that field, how can you set up the script to prevent the user from leaving the

field and saving the data?

9. List the order in which these object script triggers run: OnObjectModify,

OnObjectEnter, OnObjectValidate, OnObjectExit, OnObjectSave.

Answers

1. In FileMaker, context refers to the underlying table occurrence of a layout, the current

found set, and the current record. Almost every action in FileMaker operates from the

current context, so if the context is incorrect, you are likely to get unexpected results.

For example, consider a script intended to delete a Student record. The Delete Record/

Request script step will simply delete the currently active record, so if the script were to

run while the current context was a teacher or class record, a record in the wrong table

would be deleted. You can change or check the current context using a variety of script

steps, including Go to Layout and Go to Related Record.

2. In this scenario, you would only see the first related ContactMethod for each related

contact. For John Smith, it would show only cell phone. To view all of ContactInfo

records, the portal’s context would need to be changed to ContactMethods. This action

would result in all three of John Smith’s ContactMethods records being visible in the

portal, as well as all ContactMethods for all other company employees.

3. A chart’s data can be gathered in the following three ways:

a. Current Found Set – data sets contain one element from each record (or subgroup,

like a subsummary report) in the found set.

b. Current Record (delimited data) – data set provided by return-delimited lists. These

can be built or gathered using text functions or fields that contain return-delimited

values.

c. Related Records – data sets contain one element for each record (or subgroup) in a

set of records related to the current record.

4. Using the Objects tab, you can modify an object’s name, conditional formatting (if

applicable), script triggers (if applicable), and stacking order.

5. An object hidden with the Objects tab will always be visible in Browse mode. It will also

be visible in Layout mode if the file is closed and reopened.

6. A field’s themed style can be overridden by local formatting or by conditional

formatting.

7. When copying a style from one layout to another, the style is not copied. Rather, the

attributes are copied and applied as local formatting.

8. To prevent the user from saving a phone number with an incorrect format, you would

set an OnObjectValidate trigger for the field. The associated script would check to see

if the value in the field is correct in terms of format and length. If not, then the script

would have an Exit Script [False] step, thereby cancelling the event and not allowing

the value to be saved.

9. The order is:

a. OnObjectEnter

b. OnObjectModify

c. OnObjectValidate

d. OnObjectSave

e. OnObjectExit

3. Working with Calculations (15 - 20%)

Identify proper expression syntax, logic, and order of operations.

Describe the behavior and use of core calculation functions.

Describe the behavior and use of specialized calculation functions.

Describe the behavior and use of custom functions.

Preparation resources

Claris FileMaker Pro Help topics and subtopics

Working with formulas and functions

Functions reference

About custom functions

Questions

1. In a calculation formula, what is the difference between using the operators “&”, “+”,

and “and”?

2. A developer built a recursive custom function called “CF_AddDots”:

Case ( numOfDots > 0 ; CF_AddDots ( text & "." ; numOfDots

- 1) ; text )

What will this function return: CF_AddDots (“FileMaker” ; 3)?

3. For the following calculations, write down the results:

a. Position ( “Fred Millstone” ; “e” ; 1 ; 2 )

b. Round ( 56.32 ; 1 )

c. FilterValues ( “Red¶Green¶Blue” ; “White¶Blue¶Red” )

4. Given the field Assignees that contains a list of four values, what is the difference

between the results for MiddleValues (Assignees ; 2 ; 1) and GetValue (Assignees ; 2)?

5. What are some reasons for using a custom function?

6. Given this JSON data

$$json = "{”Person":[{"Age":42,

"First":"John","Last":"Smith"}, {”

Age":39,"First":"Jane","Last":"Jones"}]}"

What is the result of each of these functions?

a. JSONFormatElements ( $$json )

b. JSONListValues ( $$json ; “Person” )

c. JSONGetElement ( $$json ; “Person[1].Last” )

7. What will the function below return?

While (

[

i=1 ;

text = “FileMaker”

];

i<4 ;

[

text = text & “.” ;

i=i+ 1

];

text

)

Answers

1. Here are the differences:

a. “&” concatenates strings together. Example: Students::First & “ “ & Students::Last

b. The “+” symbol is used to add values together. Example: 4 + 5

c. The word “and” is used in logical functions. Example: if ( Get(CurrentDate) > Date (

6;1;2018) and Students::Gender = “Male”)

2. CF_AddDots ( “FileMaker” ; 3 ) will return “FileMaker…”

3. The returned value of each calculation is:

a. Position ( “Fred Millstone” ; “e” ; 1 ; 2 ): 14

b. Round ( 56.32 ; 1 ): 56.3

c. FilterValues ( “Red¶Green¶Blue” ; “White¶Blue¶Red” ): “Red¶Blue¶”

4. The MiddleValues() function includes a carriage return after each value. GetValue ()

does not include the return character.

a. MiddleValues (Assignees ; 2; 1 ) = <second value in list>¶

b. GetValue (Assignees ; 2) = <second value in list>

5. A custom function might be created as a place to store often-used logic, such as

finding the age of a person based on her birthday or cleaning up a phone number

format. Rather than repeating the logic over and over, it is set up once and called

wherever needed. Another kind of custom function, recursive functions, can be

created. These functions perform complex tasks, such as parsing individual letters of a

word into separate lines, and returning the result. This allows a developer to perform the

calculation and get the result in one step.

6. The returned value of each calculation is

7. Human readable JSON:

{

"Person" :

[

{

"Age" : 42,

"First" : "John",

"Last" : "Smith"

{

"Age" : 39,

"First" : "Jane",

"Last" : "Jones"

}

]

}

8. A return delimited list of each element in the Person array:

{“Age”:42,”First”:”John”,”Last”:”Smith”}

{“Age”:39,”First”:”Jane”,”Last”:”Jones”}

9. The Last element from the second item in the array (JSON arrays are 0 based): Jones

10. The function will return “FileMaker...”

4. Working with Scripts (15 - 20%)

Given a scenario, identify the use of core algorithm techniques.

Identify the use of core scripting features.

Describe how context and context changes can affect script behaviors when retrieving

or updating data in related or unrelated tables, and/or navigating between tables or

windows.

Describe the considerations required when writing scripts for a multi-user environment.

Describe the tools and techniques for troubleshooting scripts.

Identify the implications of writing scripts for different clients or environments.

Preparation resources

Claris FileMaker Pro Help topics and subtopics

Automating tasks with scripts

Script steps reference

Paths in server-side scripts

Debugging scripts

FileMaker Server Help topics

Running FileMaker scripts

Questions

1. What are the implications of using the Set Error Capture [On] script step?

2. A custom app contains a script, shown below, that is supposed to find a set of People

records using City as a criteria. Users report a problem. They expect to see a dialog that

says “There are no records for that criteria.” when entering a city that does not exist in

the system, but instead they are left with a blank screen. Explain what the problem is

and how it should be fixed.

3. In a custom app containing people and contact methods, there is a script that deletes

all the related contact methods for an individual person record. The script, shown

below, is triggered by a button on a layout linked to the People table occurrence.

Describe what will happen if this script is run on a People record with no related contact

method records.

4. A file contains a script for updating product records with current sales information. A

user needs to run this script, but her privilege set doesn’t allow her to edit any product

records. How could this script be set up to allow her to perform this action?

5. Script A sets the variable $ID to the primary key of the current record. Then it calls

Script B as a subscript. What are some options for getting the value of $ID into Script

6. A script contains a New Window script step set up as follows:

What should the layout include to ensure the user is not stuck on the card window

when calling this script in FileMaker Pro? How is this different than in FileMaker Go?

7. Can you choose the location of a PDF to be saved when using the script step Save

Records as PDF in FileMaker WebDirect?

8. You need to write a script that deletes all records from a table called “Temp_Invoices.”

Related records from a related table called “Temp_InvoiceLineItems” should also to be

deleted, and the relationship is set up to cascade delete the invoice line items records.

To ensure all Temp_Invoice records and related Temp_InvoiceLineItems records are

deleted, which script step should be used: Truncate Table or Delete All Records.

9. What are some examples of things you can do with the Create Data File, Open Data

File, and Write to Data File script steps?

Answers

1. The Set Error Capture [On] script step suppresses any error dialogs from being shown

to the user and allows the script to keep running. This could result in accidently altering

data in some unexpected way.

2. The Get (LastError) function returns the error of the immediately preceding step. In the

script above, this function is called after the Sort Records step, so it returns any error of

that step, not from the Find Records step. To fix this problem, the developer could move

the Sort Records script step to after the Get(LastError) check.

3. If this script is run on a person record with no related contact methods records, line 14

will fail and the layout context will not change. Line 16 will then delete all the records in

the found set in the People table. Finally, line 18 will close the window the user was on.

4. This script can be given the ability to run with full access privileges. This can be set by

right-clicking on a script name and choosing “Grant Full Access Privileges” or by

choosing that option in the Scripts menu.

5. Variables with a single $ are local to that script only. There are several ways Script B

could have access to the data.

a. Pass the variable into Script B as a script parameter and use the

Get(ScriptParameter) function to retrieve that value.

b. Change the local variable ($ID) to a global variable ($$ID) and reference this

variable in the subscript.

c. Set a field with global storage with this value and use that field’s value in the

subscript.

6. Since the option to close the window is not checked in the options, it is vital to have a

button that will close the window by a script. Card windows are modal to their parent

window in FileMaker Pro. In FileMaker Go, a card window can be closed by tapping into 
the gray area of the background window. If you do not select the Close option, users 
have no way to close the card unless you include a script (for example, assigned to a 
button in the Card) that performs the Close Window script step. 
7. No. FileMaker WebDirect downloads the PDF to the browser’s default download folder. 
8. The Truncate Table script step will delete all the records of the current table, but will not 
delete child records even if the relationship is set up to do cascading deletes. The 
Delete All Records script will delete all records in the current found set and trigger any 
cascading deletes. 
9. Create custom log files or export data in a custom format. 
5.  Securing FileMaker Systems   (10 - 15%) 
Describe how accounts, privilege sets, and authentication interact. 
Describe how to control access and manage security in custom apps through privilege 
sets. 
Describe how encryption and external file protection is used to protect FileMaker data. 
Describe how to secure an app for deployment. 
Preparation resources 
Guides 
Claris FileMaker Security Guide 
Claris FileMaker Server Installation and Configuration Guide 
Claris FileMaker ODBC and JDBC Guide 
Claris FileMaker Pro Help topics and subtopics 
Managing Security 
Using ODBC and JDBC with FileMaker Pro  
Accessing external data sources 
Adding and selecting table occurrences 
Claris FileMaker Server Help topics 
Securing your data 
Claris Knowledge Base articles 
Proactive and Passive security warning improvements in FileMaker Pro 

Configuring Security for FileMaker 17 and Later

Questions

1. FileMaker Security can be defined as figure out who the user is, and figure out what the

user can see and do. What part(s) of FileMaker security is the “who”? What part(s) of

FileMaker security is the “what”?

2. Which extended privilege must be enabled so that users can connect to a custom app

using FileMaker Go, FileMaker WebDirect, and via the FileMaker Data API?

3. George uses a custom app with these tables: Customers, CustomerContacts, Invoices,

InvoiceLineItems, and Products. His job is to update customer records with new

information, such as new contacts, a change of address, etc. Occasionally he needs to

add customers to the system, but he should not be able to delete them. He doesn’t

need to create or edit invoices. He does need to view them, however. George’s account

is linked to a privilege set called “CustomerEntry”. Describe how this privilege set

should be set up to give him access only to the customer area for working with those

records.

4. A FileMaker file sits on a physical server machine. What are three ways to ensure the

file cannot be opened by unauthorized users in the event the machine on which it

resides is stolen?

5. What are the two default FileMaker accounts present in any new file? List four

attributes of each account in a new file.

6. A custom app contains a Web Viewer object. This Web Viewer uses the FMP Protocol

to run a script in FileMaker Pro. A user, however, reports a bug. Clicking on a link that

references that fmpurl in the Web Viewer shows an error message. What should be

done to allow the link in a Web Viewer to run?

7. If a FileMaker file contains multiple accounts using oAuth authentication, which

account is used when the user opens the file?

Answers

1. FileMaker Security:

a. The “who” consists of

i. FileMaker Accounts

ii. External authentication through oAuth or External Accounts (via Open Directory

or Active Directory)

b. The “what” consists of

i. Privilege Sets

ii. Extended Privileges

2. The required extended privilege for each client:

a. FileMaker Go – fmapp

b. FileMaker Web Direct – fmwebdirect

c. FileMaker Data API – fmrest

3. The privilege set “CustomerEntry” should include the following access in the

privileges:

a. Records Access:

i. Customers: View, Edit, Create

ii. CustomerContacts: View, Edit, Create, Delete

iii. Invoices: View

iv. InvoiceLineItems: View

v. Products: View (to see product data displayed in Invoice line items)

b. Layouts Access:

i. Any layouts with Customers or CustomerContacts as the underlying table: view

only for layouts and modifiable for records

ii. Any layouts with Invoices or InvoiceLine Items as the underlying table: view only

for layouts and records

iii. Any layouts with Products as the underlying table: no access for layouts and

records

4. The three ways are:

a. Encryption at Rest. This feature makes sure that the database is encrypted while

residing on a machine, and this provides one measure of security if the physical

machine is stolen.

b. Do not allow the file to open automatically using any level of account.

c. Require full access privileges to create external references to this file.

5. There are two default accounts: Admin and Guest

a. Admin

i. [Full Access] privilege set

ii. No password

iii. Used to log into the database automatically

iv. Fully editable

v. Can be renamed

vi. Can give it a password

vii. Can be made inactive

viii.Can be deleted

b. Guest:

i. Enables a user to log in with no specific account information

ii. [Read-Only Access] privilege set

iii. Inactive by default

iv. Not fully editable

v. Cannot delete

vi. Cannot change its name

vii. Cannot give it a password

6. By default for all privilege sets, the “fmurlscript” extended privilege is disabled. This

privilege should be enabled so that a link in a Web Viewer is able to run a script in

FileMaker Pro.

7. The first matching account in the authentication order.

6. Deploying FileMaker Systems (10 - 15%)

•

Describe the available configurations, location, and administrative options for all

FileMaker Server and FileMaker Cloud components and services.

•

Describe the key elements of FileMaker Server and FileMaker Cloud installations and

deployments, configuration and administration, troubleshooting and monitoring.

•

Describe best practices for effective and secure back-ups.

•

Describe the key elements of using server-side scripting.

•

Describe the options for deploying a custom app to FileMaker Go.

•

Describe the differences between deploying for FileMaker WebDirect, FileMaker Pro or

FileMaker Go.

•

Describe the available web publishing options for FileMaker Server.

Preparation resources

Guides

FileMaker Server Installation and Configuration Guide

FileMaker WebDirect Guide

FileMaker Go Development Guide

Claris FileMaker Server Help topics and subtopics

New features in FileMaker Server

Using the Deployment assistant on a secondary machine

Notifications settings

Database and backup folder settings

Monitoring FileMaker Server

Scheduling administrative tasks

Claris FileMaker Go Help topics and subtopics

Transfer files

Claris Knowledge Base articles

General hardware considerations for FileMaker Server

Questions

1. A scheduled back up can be set to run every hour during the day. What does FileMaker

Server do with a file that has not changed between consecutive backups?

2. Progressive backups are a type of backup that can reduce the impact of backups on

FileMaker Server performance. How does this backup type accomplish that?

3. FileMaker Server can be installed on multiple machines: a primary and one or many

secondary machines. In a multiple machine configuration, which elements of FileMaker

Server are installed on the primary machine? Which elements are installed on the

secondary(s)?

4. What information can be found by looking at the Top Call Statistics?

5. A script called “Process Data” performs some operation on the found set of data. It is

called from a parent script called “Update Report”. The subscript runs as expected in

FileMaker Pro using the Perform Script [Process Data] script step, but fails when it runs

on the server using Perform Script on Server [Process Data ; Wait for Completion]. It

does not return the calculated data for the report. What might cause the script to run

differently using Perform Script on Server?

6. When installing FileMaker Server in a multi-machine deployment, which do you install

and configure first, the primary or the secondary(s)?

7. What are the choices for deploying a custom app to FileMaker Go?

Answers

1. A scheduled backup checks to see if a file has been changed. If not, the schedule

creates a hard link to a previous backup.

2. Progressive backups start by making a complete backup of all databases and are

stored in a folder of your choice. After that, the schedule only copies changed blocks

from the hosted file to the backup folder every time it is run. A progressive backup

keeps two backups—a timestamped file available for use and an in- progress copy that

accumulates the changes.

3. The components of FileMaker Server are: The Web Server, the Web Publishing Engine,

Database Server, and the Admin Server. During a multiple-machine deployment, all the

components are installed on the primary machine, and the Web Server and the Web

Publishing Engine are installed on each secondary machine.

4. The Top Call Statistics log describes the 25 slowest client requests. You can see what a

specific user was doing and how long it took to process the request in microseconds.

5. When a script is run using Perform Script on Server, FileMaker Server opens a session

and runs the script. This opening procedure will open to the layout specified in the File

Options menu, as well as run any onFirstWindowOpen script triggers before running

the actual “Process Data” script. If the script does not have a Go to Layout script step

as well as the correct found record or set of records, it will attempt to perform the steps

on the layout and with the records the script lands on. To fix this, ensure that the

subscript contains steps that navigate to the correct layout and find the correct

records. To return data to the parent script, use the Exit Script step and pass the data as

a Script Result.

6. The primary machine must be configured first.

7. A custom app can be deployed to FileMaker Go in the following ways:

a. Hosted on FileMaker Server

b. Transferred to the device using iTunes

c. Transferred to the device using a sharing option such as Mail, AirDrop, iCloud

Sharing or other third-party sharing methods.

7. Data Integration (5 - 10%)

Describe the formats and methods to import data into FileMaker files.

Describe the formats and methods to export data from FileMaker files.

Describe the methods for integrating FileMaker with web services.

Describe which live back-end data sources are supported for ESS.

Describe how to connect to external data sources and how to integrate them into a

custom app.

Preparation resources

Claris FileMaker Pro Help topics and subtopics

Saving, importing, and exporting data

Accessing external data sources

Supported import/export file formats

Question

1. What are three things you can do with a shadow table, including its fields and records?

And what are three things you cannot do with a shadow table?

Answers

1. Here is what you can and cannot do with the fields and records in a shadow table:

a. Can do

i. Display the data on FileMaker layouts.

ii. Add unstored calculation fields to perform calculations on the ODBC data.

iii. Add summary fields to summarize the data in the ODBC source.

iv. Add, change, delete external data if your permissions in the ODBC source allow

it.

v. Create relationships between fields in FileMaker and the ODBC fields or

columns.

vi. Specify the primary key of an ODBC table (this process is done during the set

up of the ODBC source).

vii. Use the records in value lists.

b. Cannot do

i. Add additional text, number, date, or container fields to the table inside

FileMaker.

ii. Change the schema of the ODBC data source.

iii. Make use of field indexes.

the file folder logo are registered trademarks of Claris International Inc., in the U.S. and other countries.

The Claris logo and FileMaker WebDirect are trademarks of Claris International Inc. All other trademarks

are the property of their respective owners.