Community Forums

    1. 441
      posts
    2. FileMaker 14 Server

      Deploy, Configure, Manage a FileMaker Server

      105
      posts
    3. FileMaker 14 WebDirect

      Present your database online with WebDirect. And support external clients customers on Desktop or even Mobile Tablet Browsers (iPad / Android)

      48
      posts
    4. FileMaker Go 14 for iOS

      Discussions on using the latest version of FMGo

      19
      posts
    5. FileMaker 14 Stand by Server Deployment

      For mission critical environments where you must maintain uptime on your primary FileMaker Server.

      Learn how to deploy and manage a Standby server. 

      19
      posts
    6. FileMaker 14 Scripting Workspace

      Discuss and Discover the new Scripting Workspace.

      64
      posts
    7. FileMaker 14 Interface Features

      Menu Bars, Button Icons (SGV), Place Holder Text, Navigation Parts, Color Palette, Popovers, Slide Control, Swipe Gestures, iOS Keyboards

      78
      posts
    8. FileMaker Inc.   (451 visits to this link)

      Official product specifications and information.

    1. 4,292
      posts
    2. FileMaker Server 13

      Deploy, Configure, Manage a FileMaker Pro Server

      1,456
      posts
    3. FileMaker 13 WebDirect

      Brand new FileMaker 13 WebDirect is a replacement for IWP. Using HTML 5 and CSS.

      612
      posts
    4. FileMaker Go for iPhone & iPad

      Discuss the latest addition to the FileMaker Family - Get your database on the go!

      1,931
      posts
    5. FileMaker 13 Interface Features

      Popovers, Slide Control, Swipe Gestures, iOS Keyboards

      268
      posts
    6. 28,984
      posts
    1. Articles, Tips, Techniques & Solutions

      Member contributions including articles, tips, tricks & techniques. Please provide links to previously posted threads, and demo or sample files & open source solutions. Discussion and dialog for implementation and development.

      4,153
      posts
    2. FileMaker Marketplace Discussions

      Discussions on submitted files from members.

      118
      posts
    1. Security Concepts

      Accounts & Privileges & Passwords. Information you need to know about security concepts.

      7,429
      posts
    2. Intellectual Property

      Discussions in protecting all your hard work.

      374
      posts
    1. FileMaker Custom SSL Certificates

      Discussions and instructions for securing your communications with Custom SSL Certificates from third party Certificate Authorities.

      61
      posts
    2. FileMaker Server 13   (2,762 visits to this link)

    3. FileMaker Server 12

      Discussing issues with Server 12

      821
      posts
    4. External Server Authentication

      Configuring and administration of FM Server using Active Directory & Open Directory

      975
      posts
    5. 22,006
      posts
    1. Calculation Engine (Define Fields)

      Field Types, Field Options, and those wonderful Calculation Functions!

      66,447
      posts
    2. Managing Scripts

      Writing efficient automated tasks with scripts, managing complex business logic, passing parameters, debugging and error trapping.

      51,287
      posts
    3. FileMaker Query Language or FQL

      Discussions about Execute SQL function, and SQL syntax for your your database logic.

      899
      posts
    4. Script Triggers

      Event models and how to implement script triggers.

      1,641
      posts
    5. Relationships

      Creating and developing relationships, creating children, avoiding orphans.

      29,852
      posts
    6. Remote Container Fields

      Discussions regarding remote container fields for FM12 and FMS12

      408
      posts
    7. Finding & Searching

      Using the find mode and or relationships to search or find record sets.

      16,142
      posts
    8. Importing & Exporting

      Getting data in and out of FileMaker.

      17,669
      posts
    9. External Data Sources

      Implementing and utilizing External Data (SQL) Sources (ESS) in your solution.

      4,400
      posts
    10. Value Lists

      Working with value lists, pop up lists, conditional menus, radio buttons, and check boxes.

      12,890
      posts
    11. Custom Functions

      General Discussions on developing custom functions with FileMaker Advanced

      2,679
      posts
    1. 50,572
      posts
    2. Advanced & Developer Features

      Runtimes, Design Report, etc.

      6,642
      posts
    3. Reports, Printing & Publication

      You got the data in now you need it out without mowing down a forest!

      11,824
      posts
    4. OS Level Database Automation

      Save steps learn how to automate your solution.

      4,717
      posts
    1. The Left Brain

      Complex calculations, advanced scripting and other mind boggling topics.

      9,876
      posts
    2. Data Analysis

      Discussions about statistics, business intelligence, data visualization, machine learning, or whatever other flavor of data analysis you want.

      63
      posts
    3. Upgrading & Migration

      Transition, upgrade, migrate your legacy solutions.

      2,620
      posts
    4. The Separation Model

      Learn & discuss the pros and cons of developing & maintaining the separation of data & schema.

      1,277
      posts
    5. Development Standards

      Explore "standards" adopted by developers. Implementation and documentation. Don't start from scratch.

      862
      posts
    6. Relational Database Theory

      Discussions on what makes a database 'tick'. Non-tech background on database design.

      1,196
      posts
    7. Damaged / Corrupt File Problems

      discussions on file related issues and procedures for recovering your files.

      800
      posts
    8. Shrink Wrap Solution Developers

      Discussions for developers producing and distributing shrink wrap solutions.

      199
      posts
    9. HIPAA

      Deploying solutions under Healthcare Insurance Portability Accountability Act

      79
      posts
    10. 4,041
      posts
    1. 17,505
      posts
    2. PHP

      Choose the right tool for the job FX.php or FileMaker's PHP API

      3,870
      posts
    3. 13,486
      posts
    1. 360Works.com   (16,736 visits to this link)

      Visit 360 Works

    2. 360 Works General Support

      general question for product & service support.

      1,048
      posts
    3. MirrorSync by 360Works

      Discussions about MirrorSync, a FileMaker synchronization tool that links FileMaker Server to FileMaker Go and FileMaker Pro

      • No posts here yet
    4. SuperContainer by 360 Works

      Discussions on how to implement and deploy SuperContainer by 360Works.

      2,979
      posts
    5. ScriptMaster by 360 Works

      Discussions regarding ScriptMaster plugin allowing you to run Java code directly within FileMaker. Share, compare and discuss your code.

      3,472
      posts
    6. FTPeek by 360 Works

      FTPeek is a Universal Binary FTP Plugin for FileMaker that supports encrypted transfers, scheduled server operation, and uploads/downloads directly to FileMaker text and container fields.

      307
      posts
    7. 360Works Email Plugin

      Discussions on how to implement and deploy Email Plugin by 360Works.

      686
      posts
    8. DocuBin by 360 Works

      360Works DocuBin is a full-featured document management solution created with FileMaker. Please use this discussion area to post any questions and suggestions you have.

      134
      posts
    9. Zulu – FileMaker, iCal & Google Calendar.

      Discussions and support for Zulu, which syncs FileMaker to iCal and Google Calendar.

      84
      posts
    1. Visit FM Starting Point   (1,268 visits to this link)

    2. FM Starting Point - General Discussions

      Discussions about the FREE FileMaker template.

      259
      posts
    3. FM Starting Point - Bugs

      Report any problems that you experience with FM Starting Point here.

      35
      posts
    1. Monkey Bread Software (MBS Plugin)

      This plugin by Monkey Bread Software is an essential tool for many development projects. Since it has so many options and features this discussion forum is a way to share your experiences, tips, and suggestions. 

      1
      post
      • No posts here yet
    1. FileMaker Product & Service Announcements

      Want to tell the world about your FileMaker related product or service? Post your press, releases and highlights are welcome...

      1,145
      posts
    2. Professional FileMaker Training

      Find out about professional training courses across the globe from a variety of instructors. Discuss training courses and find the best course to suit your needs. Prepare yourself for certification.

      113
      posts
    3. Jr. FileMaker Developers' Forum

      Discussions becoming or working as a Junior Developer in the FileMaker Community.

      20
      posts
    4. 19
      posts
    5. Making A Living

      Is FileMaker development your core business? Discuss the business of being in business or relating to the dynamics of working as an in house developer or in the educational sector.

      1,033
      posts
    6. 2,811
      posts
    7. FileMaker Resources

      Reference Materials: Web Sites, Books, Videos, Training, etc.

      1,165
      posts
    1. Services for Hire

      Spotlight of our member's products & services.
      Announce your availability to take on that next big project.

      40
      posts
    2. Services Wanted

      Take on a job you just can't handle alone. Post your "Help Wanted" ads here.

      1,207
      posts
    3. Solutions Wanted

      Searching for that ready made solution, perhaps someone else can point you in the right direction

      1,008
      posts
    1. Member Lounge

      Off topic community chatter. Mingle and get to know your fellow members perhaps meet a friend.

      1,922
      posts
    2. Wants & Wishes

      Discuss features that you wish to see in the next version of FileMaker products.

      1,517
      posts
    3. FileMaker Developers Conference

      Discussing the annual Devcon, including travel arrangements and associated events.
      Need to find a roommate?

      131
      posts
    1. FM Forums Feedback & Site News

      News and Feedback regarding this site.
      NOT FOR FILEMAKER SUPPORT

      909
      posts
    2. Site Instructions

      This forum is where site administrators and staff will post articles to assist you in using and navigating FMForums.

      2
      posts
  • Topics

  • Posts

    • General question on tables
      By troutstudio · Posted
      That last comment is especially useful, thank you. On the layout - I understand what layouts are capable of. I mean that I am using layouts as a way of presenting data choices. As for updating the schema - unavoidable in this environment. I am the person who shows admin the value of Filemaker. They would not pay for the license without me. If the project grows, I recommend they hire a developer. It's really as simple as that.
    • Can I set an external data source via a variable?
      By GC GYM · Posted
      Sorry I didn't see the reply earlier, but thanks again for replying James. Yes it seems the only way I can accomplish this is to add every client's own Data Source, Relationship graph and Layouts to the separation file. And yes, it did make sense at first for a locally hosted file. This was developed over many years for my own organisation using our own in house FMS. It is now quite a large file with 60 tables, some of those with 250 fields. The RG requires a lot of scrolling. A few friends in other companies in our (non-profit) industry saw it and wanted it so I sold them a copy and personalised it for them. Then others saw it and wanted it too, so I made copies for them and made a few mods to suit them too. Now more people want it and I'm finding that as a potentially commercial product it should have been designed differently. Maybe I should put up my own FMS and have as many files as I like? Thanks again for your advice, it has helped me a lot.
    • General question on tables
      By comment · Posted
      It is very difficult for me to follow your description without having at least a "map" of your solution, such as an ERD. Offhand, I would say that a student could select a subject and a year using global fields, then either view the corresponding subjects in a portal from their own record, or find them in a layout of the Subjects table. There is no such thing as "a layout which only has the subjects that were available in that year"1. Any layout is capable of showing any or all records of the table that the layout is associated with; it's only a matter of performing a find (or creating a found set in another way). If you're adding a layout for each possible found set, you're simply wasting your time and your solution's resources. --
      (1) That is, unless you mean a layout that only shows some fields of the underlying table (which I suspect you do). See my next note.   Updated (with new data) - yes. Modified (with new schema) - no. That's not a smart way to proceed.   IMHO, you should have an individual record for each atomic value. IOW, if there are 6 subjects offered each year, and so far there were 5 years, there would have to be a table with 30 records.
    • Surgical database - populate a field with pop-up menu
      By GarthT · Posted
      Thanks EOS. That's helpful, but not what I am looking for at the moment I have moved on to the patients' occupations at the time of surgery So what I want is a field called "Occupation", eg. Teacher, bus driver etc. in the table "Operation" that I can populate from a table called Occupations. I envisage this as a many to many relationship - a patient can have many occupations (over time) and an occupation can be done by many patients; thus I will connect the two tables with a join table; "OccupationAtOperation" I want to be able look at the Occupations table and use this as a value list and, if the occupation is not present, add a new occupation (record) without having to go back to the Occupation table. thanks Garth
    • General question on tables
      By troutstudio · Posted
      Actually, this is to create records, not find them. I want this scenario: a user chooses their year of enrolment and their subject area from two different pull down menus. Then they click on a "new record" button. This fires a script which takes these two pieces of data; and from them, switches to a layout which only has the subjects that were available in that year. The student ticks boxes for the subjects in that year as completed; or not. Then they print the result and take it to a meeting. This is for postgrads who are getting further degrees and an advisor needs to just look at a printout and see which subjects were actually finished. There are no results, as these have no bearing. Of course the database will need to be updated once a year, because they create some new subjects every year. I don't want to show Maths students who enrolled in 2011, the Humanities units from 2015 - so they need to be on a different layout. I have all the subject units as fields. There are about 25. Then there are 6 choices for year - they are values; and 5 disciplines which are values too. So it's now quite a simple database. I feel I only need one table. I realise for a developer that this will not be a production design but it's just something I am doing to assist mentors in advising students on missing units of study needed for a postgrad degree.
  • Popular Contributors