📌 TECHNICAL & ROLE-FOCUSED

1) What versions of FileMaker have you worked with?
✅ Answer: “I have experience with FileMaker versions 16 through 21, so I’m familiar with the evolution of the platform, especially improvements in security, JSON functions, and integration capabilities.”
💡 Tip: Highlight you stay current and mention version-specific features you’ve used.

---

2) Explain how you design a relational database in FileMaker.
✅ Answer: “I first gather requirements, identify entities and relationships, then build a relationship graph. I define primary and foreign keys, use anchor-buoy or other naming conventions for clarity, and test with sample data.”
💡 Tip: Show you care about clean schema, performance, and future scalability.

---

3) How do you handle security in a FileMaker solution?
✅ Answer: “I use privilege sets, account management, role-based access, encryption at rest and in transit, script-level security checks, and regularly audit user logs.”
💡 Tip: Emphasize you understand FileMaker’s RBAC and security best practices.

---

4) How do you troubleshoot a performance issue in FileMaker?
✅ Answer: “I check the relationship graph for unnecessary table occurrences, optimize scripts and calculations, use Data Viewer for debugging, monitor server logs, and index fields when appropriate.”
💡 Tip: Give an example where you fixed a slow system.

---

5) Have you worked with Custom Web Publishing?
✅ Answer: “Yes. I have built PHP pages using the FileMaker PHP API for custom portals and dashboards. I know how to handle authentication, error handling, and data exchange securely.”
💡 Tip: Be ready to explain a small project.

---

6) Describe how you’d connect FileMaker to an external REST API.
✅ Answer: “I’d use Insert from URL with cURL options, pass headers for authentication, parse the JSON/XML, and handle errors gracefully. I’d schedule it with scripts or server-side scripts if needed.”
💡 Tip: Show that you can handle OAuth, tokens, and JSON parsing.

---

7) How do you integrate FileMaker with an SQL database?
✅ Answer: “Using ODBC/ESS. I set up a DSN, link the SQL tables, and either query via SQL or work directly with the linked tables in FileMaker layouts.”
💡 Tip: Mention performance considerations — e.g., limit the number of fetched records.

---

8) Tell me about a time you solved a complex bug in FileMaker.
✅ Answer: Give a real example — e.g., fixing a faulty script trigger or a broken API call.
💡 Tip: Show your methodical debugging approach.

---

9) How do you keep up with FileMaker updates?
✅ Answer: “I follow Claris’ release notes, community forums, FileMaker blogs, webinars, and experiment with new features in a sandbox.”
💡 Tip: Show proactive learning.

---

10) What’s your experience with container fields?
✅ Answer: “I’ve implemented container fields for storing documents and images, used external secure storage, handled file uploads, and managed versioning.”
💡 Tip: Mention best practices like external storage and performance.

---

📌 COLLABORATION & SOFT SKILLS

11) How do you gather requirements for a new FileMaker app?
✅ Answer: “I interview stakeholders, create user stories, sketch wireframes, get feedback early, and translate that into a clear data model and layouts.”
💡 Tip: Emphasize communication and documentation.

---

12) How do you handle tight deadlines or changing requirements?
✅ Answer: “I break tasks into smaller sprints, communicate proactively, adjust priorities, and always keep stakeholders informed.”
💡 Tip: Show flexibility and calm under pressure.

---

13) Describe your preferred working style: solo or team?
✅ Answer: “I enjoy both. I can work independently, but I also value brainstorming and reviewing with a team to deliver the best results.”
💡 Tip: Show you fit their hybrid work style.

---

14) What other technologies do you use with FileMaker?
✅ Answer: “I use PHP for CWP, JavaScript for WebViewers, REST APIs for integrations, and tools like Postman for testing. I also use Figma or similar for wireframing.”
💡 Tip: Highlight relevant tools they mention in the job description.

---

15) Do you have questions for us?
✅ Best Q’s to ask:

• “What are the biggest challenges the team is currently facing with FileMaker?”
• “How is success measured for this role?”
• “Is there room to grow into other Claris tools, like Claris Connect or Claris Studio?”

💡 Tip: Show genuine curiosity and engagement.