• Active Directory linked with FileMaker table for use in scripts to update ServiceNow API

    Hi All,   I have a FileMaker 16 Go app that users login and authenticate with Active Directory.   Once users login, the app updates a ServiceNow API and requires the same users credentials to modify data i...
    last modified by jfencil
  • Moving files from one Layout to another

    I have ask similar to this before.   I have one Table called ACCOUNTS TABLE with DEPOSIT SLIP, CHECK, CHECK REGISTER, AND ACCOUNTS PAYABLE  as Layouts.   ACCOUNTS PAYABLE is a compilation of Account ...
    last modified by ferg1
  • How to prevent a script from running

    How do I prevent a script from running that opens Dialog Box when opening a particular layout, but is required for other reasons.
    last modified by sherab4
  • Update summary table from related tables using scripts

    I am building a dashboard with charts and summary metrics and have found it easiest when all of the summary data I need is in one file (thanks to posts in this forum). I have figured out how to update summary monthly ...
    created by barbaragnelson
  • Capital Gains database - buy date

    Does anyone have experience generating the capital gains "Date Acquired" from a trades (buy/sell) database?   If you have done it before you know what I'm asking. It's a for a cryptocurrency application.   ...
    last modified by chuckburr
  • hospital design database

    Is there someone can give me a hospital design database? or referrence for me to study? I'm a newbie, but i will try to learn?
    last modified by nestorverdugojr
  • Change a Field based upon entering a value another field

    Hi,   I have two fields   Database::Some (Number)   DataBase::Permit Number (It's Text because the number is formatted as 18-XXXX or 18XXXX)     Some has "1" posted into it by script  ...
    last modified by JFWX5
  • Filemaker Diary/Appointment Layout

    Hi, I'm fairly new to filemaker and I am trying to create some form of calendar or diary within my data base. My company has mobile engineers who need to go to multiple appointments per day therefore I need away to bo...
    last modified by ebrown212
  • Google Calendar File attachments for the event

    I am able to successfully create calendar events on Google Calendar thanks to the great demo file from DB Services FileMaker Google Calendar Integration | DB Services . I have added an element to also add the location...
    last modified by dmagill
  • how do I substitute text strings for numeric field values?

    New to FM. I have a huge table of data with fields containing numeric values (e.g. 1="Yes", 2= "No" in one field , or 0="Two Lanes", 1="Four Lanes", 2="Six Lanes" in another field).   I currently view the data i...
    last modified by thilleary
  • Duplication script for multi field criteria

    I have a script in a database that searches for duplicate records in one field and it marks another field with an “x” so I can delete them. The data is coming from a manufacturing system and the field I wa...
    last modified by mhemans
  • Set or Change ContainerAttribute

    I have a DB of over 100K PDF files that were imported by reference. It took 36 hours to import all those PDFs.   Now we are replacing the file server these PDFs are stored on and the path is going to change. (No...
    last modified by briancrockett
  • Most Recent Date from a list that includes Date and words

    Hello, I get data from another program and process it through FMP.   The field is called Status. When a department enters a status, it is separated by department like this, and then sorted by date:   The...
    last modified by lindseym
  • Updating summary fields

    When you work with FileMaker for so lang there are features which are so ‘normal’ in day-to-day use. As far as I know summary fields are recalculated when there visible on the layout? Now, out of the blu...
    last modified by keysolutions
  • Move from FMS 14 to FMS 16 sub summary field woes

    I'd appreciate comments on major performance problems as a result of moving a client from a shared Windows 2012 R2 FileMaker Server 14 server (that had 46 files hosted) to a dedicated Windows 2016 R2 FMS 16 server run...
    last modified by CICT
  • FMS16 - CWP - Send Mail Script Compatibility

    Hi All,   Is FileMaker Server 16 Custom Web Publish has compatibility for Send Mail Script?   Thanks in advance, Suresh
    last modified by Suresh
  • BaseElements, be_smtp_send breaks my attachements

    Version: FM Advanced 14.0.6 System: MacOSX 10.10.5 BE version: 3.3.4     Hello, I am trying something as simple as adding a single attachment to an email via BE. BE plug-in 3.3 and up has an elegant fun...
    last modified by t.andersen
  • How to calculate for billing units based on client/staff ratio throughout the day

    SO I have this unique request from a customer and I'm a little baffled how to elegantly handle. Basically, depending on the ratio of staff to clients throughout the day (ratio changes throughout the day as clients com...
    last modified by applemax
  • How to verify dates from separate portals

    I have a jobs page, on this page are two portals, "Job by Days" and "Job Kilometres Report". I want a popup to advise to add details to the Job Kilometres Report when I add a job in the Job by Days portal. I was think...
    last modified by sherab4
  • Get (ScriptNames) or Get (ScriptCall)?

    Without updating all the scripts to log themselves or to take parameters, Is there a way to find out if the currently running script is being run while the client is running another script? Or can a script test to s...
    last modified by eric