• Import SQL Data via ODBC Driver

    Is there a way to import each SQL Table and its Table Fields into Filemaker?  Then will need to import data from each one of those tables.    I have a ODBC Driver installed and can connect to the SQL ...
    last modified by lovelandj
  • Inventory Problem

    Hi,   I've a small textile business. My main product is fabric and they are stocked as rolls.   I'll try to explain my problem with an example to make it easy to understand so maybe someone can help me wit...
    last modified by decabol
  • Encoded JSON comes back as &quot

    I am encoding JSON using JSONSetElement   E.g. JSONSetElement ( $FinalJSON ; "Assets" ; $AsetJSON ;       JSONObject )   I then use the PHP API to output the JSON to a webpage...
    last modified by CarlSchwarz
  • How do I prevent modification of a field after it has been entered for the first time?

    I need to be able to create a new record, but once created, I want to restrict any modification of the name field or address field.  How do I do that?
    last modified by user447
  • My first File Maker app: a few basic questions

    I'm attempting to create a simple To Do app. I'm part way there but am having a few problems. The basic flow is pretty simple.   I have a list of Users:   When I click on a user I get a new layout with a...
    last modified by colindunn
  • How can I extract content from sub summary layout objects using GetLayoutObjectAttribute()?

    How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html   I'm able to grab the content from the first su...
    last modified by ggt667
  • Not sure how to show relating records in value list

    Hi there,   I for some reason cannot show relating records in a value list. Consider the ERD at the bottom of this post.   For simplicity I will refer to RFQ as a Quote, and you can think of it like th...
    last modified by informationator
  • Data Separation

    After spending too much time and too often in importing data after requested changes into a complex medical multi-language solution I have decided to try moving toward the data separation model. And after reading a f...
    last modified by Wicktor
  • Datensätze in Ausschnittswerkzeug zeigen

    Hallo zusammen, ich möchte gerne mit dem Ausschnittswerkzeug Datensätze aus der aktuellen Datenbank anzeigen.   Wie man Datensätze aus einer Bezugstabelle anzeigt weiß ich und es bereitet mir...
    last modified by mkueffner
  • Master-detail view using a found set

    I have two tables: Users and Tasks. Each User can have many Tasks but every Task can have only one User.   If I click on John Smith in the first layout I'll be taken to a new layout that shows me only John's ta...
    last modified by colindunn
  • Creating a layout from filtered result

    Hi, I am relatively new to FM, so I apologize if my question is dumb.   I have a table for Companies with 20+ thousand records. I've got a field called businessUnitnumber, this identifies who in the sales team ...
    last modified by csanad
  • Externally Stored Documents

    Is there a way to make externally stored documents behave like referenced documents. What I mean is; referenced documents will open from the container, without having to export the contents of the container.   ...
    last modified by mrosenhek
  • Select and Move from One Portal to Another

    Hello,   I am in the process of creating a layout where users select employees from one portal, click a button, and they add that employee ID to another portal.   See image below:     The left por...
    last modified by JulioSandoval
  • Found Set records lost when returning to layout

    We are having a strange and concerning issue within our accounting department only.  The simplest description is that the user starts with 10 records in the found set of Layout A, runs a script that uses a Go to ...
    last modified by jbiggs
  • ODBC using Windows.

    Keep as a reminder and save many hours!   Well I haven’t done this for a while, but I needed to set up a Windows Server 2008 R2 to connect by ODBC to a FileMaker server 13.  Easy right, done it loads o...
    last modified by DonCollier
  • Privilege Set

    Something strange going on when trying to set up a new user. I have the sales team set up with their own Privilege Set. I want to add a new salesperson so I duplicate a current user (they have no log in issues) and si...
    last modified by canoevalley
  • FMS 15 - Additional Database Folders does not work.

    OS: Win2012SrvR2 FMS   After adding the correct path to the console field for Additions database folder 1   a. The validate path button does nothing. You click it and it's like clicking on a pi...
    last modified by ADNPlus
  • Open Record Based off Location

    Hey there..   okay so for my business we disc/mow weeds with a tractor for fire prevention. we do around 30-50 Job locations per day. Every time we get to a new job we must search the work order number to get t...
    last modified by moderndesigns9
  • Serial number validation script

    What formulas would work best in a script written to validate serial numbers. The following are the criteria and meats patterns for the serial values. Ex: The first two digits are the “yr“ the second two a...
    last modified by kirkkolstad
  • Lost Value Lists

    I was doing some development work and went to apply a value list to a field and there were zero value lists showing in the window when using File/Manage/Value Lists... . I tried closing and reopening FileMaker Pro Adv...
    last modified by SteveKeiser