• Google maps has stopped working in FM web viewer

    Using FMP 12 / WIndows 10 We have been successfully displaying maps in the FM web viewer. It has suddenly stopped working and instead of displaying the map in the web viewer FM displays this text: "You are using a b...
    rbogdanoff
    last modified by rbogdanoff
  • Button bar formatting in Filemaker Go 16

    I have a layout using a vertical button bar. In FileMaker Pro on my mac, all of the buttons have the text centred as intended. In FileMaker Go, some of the text is top aligned and some is centre aligned. There seems t...
    marktrosen
    last modified by marktrosen
  • Missing menubar cannot be restored in Windows

    I have a runtime. This problem only affects Windows. My user opens a second window via a button. It is done via script and it is a Window Style of "Document" and I do not include a menubar. Normally, I have the user h...
    dswatski
    last modified by dswatski
  • File Size?

    What makes a file so big?  I have what I thought was a relatively small database with 3 tables. Table 1 has 18 fields and 950 records. Table 2 has 32 fields and 345 records. Table 3 has 31 fields and 362 recor...
    user447
    last modified by user447
  • FM Data API Multiple Record Create/Update/Delete

    Just in case you did not notice this idea, here it is: FM Data API Multiple Record Create/Update/Delete   I think any ideas regarding the Data API are extremely important right now as FMI is willing to work wit...
    bigtom
    created by bigtom
  • Motion Sensor Alert Notification to Filmmaker 16 via API

    Open video

    raweeus
    created by raweeus
  • Change fill color of a field, for a given record, when the value changes

    I am looking to automate changing a field's fill color (or text color) when I change the value of that field. Based on my understanding of FM, I don't think conditional formatting would work, because once the field ha...
    xtianseel
    last modified by xtianseel
  • MasterDetailSQL.fmp12.zip

    Here's a Master-Detail-Example extracted from one of my solutions. It works by filtering the master- and the detail-table by generating dynamic SQL-queries. All calculation-fields, script-trigger-calculations and scri...
    okramis
    last modified by okramis
  • Change Label of Button Using Programming

    Hi There, I have a button with a name of "Btn1" on a layout that the label says "Start". What I would like is when the button is clicked it changes the label to "Process 1" When that process finishes the program ch...
    pademo57
    last modified by pademo57
  • how to handle the addresses best?

      In one address I have more values: city, street, civic number, postal code, province, common code. Many data. In a masterpiece how best to handle them? Some recommend putting all the caps in a separate table w...
    grabo
    last modified by grabo
  • Auto-enter: Calc vs Look-up?

    In a sitiation where the auto enter needs to store the value from an upstream parent or grand parent record (or any related record ) what is the difference of a calc vs a look-up? Seems to be about the same.   F...
    bigtom
    last modified by bigtom
  • Importing: Avoiding duplicate records

    I have been using an Import script without problems for some months but suddenly ended up with duplicate records. The problem appears to be that the records are imported from files within a specified folder. I think I...
    tays01s
    last modified by tays01s
  • Help with some tricky JSON.  Having trouble getting elements out.

    Hi,   I am having issues getting the data out of the following JSON feed.  I am trying to capture specific attributes, but don't know how to get them short of a very ugly looping brute force type approach.&...
    user19174
    last modified by user19174
  • Boolean False vs Null Indication Fields, which do u prefer and y?

    This is likely minutia and the answer is probably pick one and stick with it.    background: I call these fields indicators or "is" fields.  I name them like isCustomer, isVendor.  It keeps them...
    ericjlindholm
    last modified by ericjlindholm
  • Button State Inspector Style Overhaul

    Setting up button formats for the 5 conditional states, is a tedious process with minimal user feedback in the effort. Something like this as a baseline (maybe extend it with popovers in each button for ALL the style ...
    krheinlander
    last modified by krheinlander
  • scripting abstraction technique help please

    I use a single set variable script step with a let statement to set a large number of locally scoped variables.  I like this approach because the variables I set should rarely change and it keeps my scripts reada...
    ericjlindholm
    last modified by ericjlindholm
  • Finding specific text or any text or empty field in an equasion.

    This script is intended to stop on any record in which the ASGN field contains any of the characters entered in the SHOW option---which is captured in a GLOBAL TEXT FIELD---which is transferred to a VARIABLE---which i...
    jlhfbo
    last modified by jlhfbo
  • Is it possible to use a literal dot in a JSON key with FileMaker's JSON parsing functions?

    I am trying to access a REST web service where the keys have dots in the name. FileMaker interprets a dot in a key name to indicate a sub-element. Is there any way to escape the dot so that FileMaker treats it literal...
    jbarnum
    last modified by jbarnum
  • What Relationship Must Be Established to Get Totals from Two Tables?

    I have the following:   Table 1 – Expenses   Field A: Date Field B: Concept Field C: Amount   Table 2 – Flight Time   Field D: Date Field E: Flight Time (in hours)   I nee...
    fmpuser0
    last modified by fmpuser0
  • Rename files in container fields

    Title Rename files in container fields Post      Hi,      I wonder if there is anyway to rename image files from containers. I need to rename each image with a nam...
    NunoFerreira
    last modified by NunoFerreira