FM External Data Sources Tables

Posted on 2014-08-19
Last Modified: 2014-08-26
I have a few questions regarding External Data Sources:
1. Can the list of External Data Sources be viewed via a script or calculation?
2. Once a External Data Source (mainly to another filmmaker file) in the Manage External Data Sources window, is it possible to view the list of tables available on the external source via a script or calculation or any other form?
Question by:PachecoPrimo
    LVL 9

    Accepted Solution

    there is no universal answer to your questions as it depends on your external datasource (which can be very different) and it depends on what you want to do, so i'll try to help with some thoughts:
    - most of the external datasources functionality in filemaker is limited in what it can and is a manual job (filemaker menus), it's not a universal connector.
    - sometimes an external datasource offers a system table with the metadata you want.
    - you can copy the metadata (tables & fields) from the external datasource to a local filemaker table (just by  copying and pasting the tables), this can bring you a step closer to what you want.
    - have a look at which goes in the metadata direction, i didn't test it on external metadata though.
    LVL 24

    Assisted Solution

    by:Will Loving
    I don't know of a way to generate a list of external data sources. The "DatabaseNames" function only gives you back a list of files open on the current computer. If the external data source is a FileMaker files and it's open, it might be included in the list (I haven't tried it).

    With regard to the list of tables available in an already connected external data source, the "TableNames" function will return a list of all table occurrences in the relationships graph for the specified fileName, separated by carriage returns:

    TableNames( fileName )

    You could certainly use that in a script or calculation, and the FieldNames function returns a list of all fields on a layout (rather than all fields in a table).

    For a complete list of the various "Design" functions, and details on the ones mentioned above see:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Are you looking to clear some space on your phone for the latest iOS 8 update? Did you switch to Spotify so you no longer need to keep music native on your phone? Run out of space for taking photos while in the middle of vacation? Sometimes the quic…
    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now