Jump to content

Search the Community

Showing results for tags 'fmp18'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 40 results

  1. Hi guys - maybe some of you have been getting snapshots from ip-cams (axis, hikvision)... I have had a system running for YEARS with no problem, suddenly after a firmware update, this snapshot (image.jpg) doesnt work anymore... Have you maybe found a workaround...???
  2. Hello all On FM 18.03, the closing of a popover, the button of which is in each row of a portal, causes FileMaker to close. This appears to only happen when the fields which are in that popover (the portal records) are edited. Has anyone else experienced this? Thanks
  3. Why would I be getting this on install? MacOS Catalina, latest MacBook Pro, just recently installed Python 3, Django, PIP, Eclipse which had me install the latest JDK from Oracle. Thanks!
  4. Hi All, I added security to limit the DataAPI user from accessing certain records, with the limited option. I tested this while running these files on my HD no server. Worked like a charm. After moving the files to FMServer the DataAPI account can access all record in the table all of a sudden. Any thoughts as to why this is happening? Kind regards, Joost
  5. I'm having trouble with FMPA creating a runtime. Even with the simplest file, I create it and when it runs it immediately crashes with the following in the crash report: Exception Type: EXC_CRASH (Code Signature Invalid) Exception Codes: 0x0000000000000000, 0x0000000000000000 Exception Note: EXC_CORPSE_NOTIFY Termination Reason: Namespace CODESIGNING, Code 0x1 I did the exact same thing with FMPA and it worked fine. Any suggestions as to what's going on here and how I might fix it? Thanks!
  6. If a user accesses a file via WebDirect on a mobile device, what is the easiest way to let them take a photo and capture it in the system? Do they have to take a photo outside of the file and then upload it, or there a faster/better way to take the photo and capture it in fewer steps?
  7. Is anybody else seeing an issue with exporting to .xlsx in FMP 18? I have a scripted find/export that has never been a problem before. But, ever since I updated to FMP 18 I sometimes get errors with the Excel spreadsheet that is created. As you can see in the attached, if I make my changes and hit save it says I have to Save a Copy (if I use the same name it saves over the top of the open file just fine) because the original spreadsheet was an "older version of Excel". If I open it and try to save immediately, I get an error saying a "new version [is] available". I am using FileMaker Pro 18 on a Windows 10 machine and have Office 365 Premium.
  8. I have a date field that is set by record created date, whenever I create a new record in this table it enters the current date. This is a phone log field so there are literally hundreds of thousands of records. I'm trying to create a calculation that displays the today, if the record created date is current date, and yesterday if it was yesterday and all other should be the date itself but when I create this calculation, it doesn't seem to update on a daily basis and just shows today even if the date was yesterday, unless I create a new record. Any ideas on what I'm doing wrong here?
  9. https://community.filemaker.com/en/s/article/Startup-Restoration
  10. Working on an inventory bin consolidation solution, I have a portal that shows all of the locations & qty for an item. I also have a drop down that the user marks as yes to move, the qty they want to move, and the bins with the same item in them. I would like to filter out the current bin from the drop down, the current value list is the location field from the "count" table. Suggestions?
  11. having trouble with calculating related fields scenario: inventory bin consolidation app Item 3AT17 is in 5 locations - 2 locations have just 1 unit, other 2 have 36, 65, 94 units. we want to move the two single units to the 36 unit bin. (see below) the locations/item info is in a portal. The move to list from the related locations field - showing all locations with the item. How do I calculate the new total for the "move to" field? Layout is pulling from Item Master (IM_) with related tables Count (CO_) and location (LO_) Relationships: IM_ITEM=CO_ITEM LO_Location = CO_Location & LO_ITEM = CO_ITEM Field Names: Location: CO_LOC item : CO_ITEM QTY: CO_QTY move:CO_RELOYN Move QTY: CO_RELOQTY Move To: CO_RELOTO For the above example moving 1unit from 2 bins - into third bin need a cell for the new qty in that bin. so in this example new qty would be 38. I am sure I am missing something that would help with figuring this out...
  12. Hello, I have been trying to figure this out for weeks and have gotten nowhere. I have a script that ran perfectly fine on server 17 and it also works when run locally on Pro 17 or 18, but it won't complete a perform find function when run on server 18. I was wondering if anyone has experienced this and might be able to take a look at my script steps to see if I am causing something that isn't viable in server 18 scripting. The Pro or Go client calls a local script called "Send SMS to Server", then the server runs a script called "Send SMS on Server" . Here are screenshots of both scripts that were working on server 17. The script kicks back error 401 for no records found. I really appreciate your time looking at this and hope someone knows right away what the issue is. Thanks Chris Konash
  13. HELP! This is driving me nuts. Need to send emails with an attachment from server side script. The attachment path calculates correctly, as far as I can tell. Permissions are 777 (I Know...), but the file still does not attach! This is the variable calculation that yields the path: "/Samsung SSD/Library/FileMaker Server/Data/Documents/"&$filename Only problem is: attachments don't attach! I have tried every iteration I could think of: "filemac:/Samsung SSD/Library/FileMaker Server/Data/Documents/"&$filename "/$filename" "<Documents>/"&$filename What am I missing here??? Thank you!! I can't believe I'm the only one who ran into this issue?
  14. Hi everyone, Can you help me to setup a webwiever to display videos on OSX ? I've search but didn't find the solution. Kind regards. Antoine
  15. I have a script that performs a find and returns about 500 records. I am looking to limit this set to the first 5 found records and then perform another script (loop) for these 5 records. Is this possible with filemaker?
  16. Hi All Apparently FMI knows about this, and their advice is as follows The problem for me is I don't have an SSL certificate and am using the in-built FM certificate. I would have thought the in-built certificate would at least let me import from the hosted file, especially as I did this from the desktop of the server. The script doing the import has not changed for many years and still runs fine on pre-18 servers. Other than purchasing an SSL has anyone get a solution, without resorting to downloading the hosted files and running locally (I'm trying to avoid that step). Thanks
  17. Hi, I have some FMP development experience but more so on the intermediate level. We have a FMP database, hosted on a FMP server, that we use to track a bunch of our digital signs. All the data in the db is manually entered with fields such as 'name' and 'ip_address'. Sometimes these signs go offline, hangup, change ip addresses, etc. I had the idea to have the remote signs call a url every hour that is our signage db hosted on our FMP server. Something like: https://fmp.server.com/fmi/webd/db_name?name=signName&ip_address=ip The db could track these calls for all signs in the db and I could create a layout or report that would list the ones that haven't called in within a certain timeframe. I know exactly how the signs themselves would technically call the url, and can handle the layout & report, but don't know how to get the db to listen for the call and handle it. How can I do this? Are there any examples anywhere that explain this? I'm thinking the db would need to have webdirect enabled with a layout that is shared to Guest so a login isn't required but other than that I'm not sure where to start... or if there is a better way to handle this. Once the url call is made, the db wouldn't need to do anything back to the client/sign itself except for perhaps a simple 'success' message. Thanks!
  18. Hello, I have a FileMaker server 18 installation that’s crashing about once a week. When I look at the event log for the time of the crash. I see client 1 not responding, client 2 not responding etc. until all clients are disconnected. All databases show as open in the server console. From a client PC no open files are listed for the host. If I telnet to the server from a workstation on port 5003 a connection can’t be established. Stopping and starting the database server does not help. Restarting the FileMaker service does not restore operation. The server is still communicating with the network. I can open a web page or browse other computers on the network. Restarting the Windows server restores normal FileMaker operation. My environment is as follows: Windows Server 16 Standard Edition dedicated FileMaker server. 8 GB memory 80 GB RAID disk drive (40 GB free) Indexing turned off No third party backup software running No AV software running Windows File Sharing turned off for all folders. Windows Defender Turned off IPV6 protocol turned off What we have tried so far: We replaced the network switch (after the first crash a few weeks ago). Tested all databases for corruption. Compacted all databases Reinstalled FileMaker Server 18 Any insights would be greatly appreciated TIA John
  19. I just updated my office to filemaker 18 and I have a script that imported records but skipped the first row which are all titles. I don't see a skip first row checkbox in the import interface anymore?
  20. https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-2/ This is Part 2 of a 2 part (90 minute) amazing conversation with Rick Kalman, Director of Product Management for FileMaker, and Robert Holsey, Senior Product Manager for FileMaker. Rick and Robert talk about, among other things, Claris Connect, the benefits of acquisition instead of strategic partnerships, save as XML, responsive layouts, Apple's influence, live database development, moving to a web first strategy and changes to the relationship graph. We are very honored that they took so much of their time to talk with us candidly and openly. Part 1 was released last Wednesday and has had over 700 downloads. Thanks to all for listening. Steven Blackwell tweeted that it was an 'Exceptionally significant PodCast' and that 'All #FileMaker developers should listen.' https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-1/ Follow us on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes Follow us on Podbean https://firesidefilemaker.podbean.com or find us on YouTube by searching for Fireside FileMaker ~
  21. I have a FileMaker solution that powers an internal "TV network". It runs over Intel Compute Sticks which have FileMaker installed on them and are connected to TVs mounted to the wall throughout the facility. A FileMaker script runs through various layouts and steps thru records on each layout. This lets us show a calendar, weather report (in a web viewer), company news, birthdays, customer feedback, employee recognition, and pictures. I would like to add a news ticker to the solution, like you'd see on CNN scrolling across the bottom. I have a table with the news stories in it. Since you can't run more than once script at the same time, I have a script set on the server to step through the news stories. For each story it uses "set field" to put the story in the field one letter at a time, then cuts off the left side when it gets too long. I then set the solution to open a floating document window at the bottom to display the layout that has the new field on it. In theory, it should then appear that the story scrolls across the screen. It doesn't really work. It is jumpy and sometimes just doesn't show at all. This is the gist of the script for the ticker: Loop Set Variable [$message; Value: (news story)] Set Variable [$letter; Value: 1] Loop Set Field [Data::News;Right(Data::News;68) & Middle ($message; $letter; 1)] Commit Records/Requests Refresh Window [] Pause/Resume Script [Duration (seconds): .05] Set variable [$letter; Value: $letter+1] Exit Loop If [length($message) < $letter] End Loop Set Field [Data::News;Right(Data::News;68) & " | "] Commit Records/Requests Go to Records/Requests [(If ( Get(RecordNumber ) = Get(FoundCount);1;Get(RecordNumber ) + 1)] End Loop I've tried it with various pause durations, with/without the refresh, and with/sithout the first Commit. Nothing works the way I want. Has anyone successfully implemented such a thing?
  22. https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-1/ This is Part 1 of a 2 part (90 minute) fascinating conversation with Rick Kalman, Director of Product Management for FileMaker, and Robert Holsey, Senior Product Manager for FileMaker. If you aren’t familiar with these two experienced Claris International employees, we consider them to be part of the backbone of the company. Rick and Robert share some incredible insights about what goes into releasing a new version, their vision for the future and their quest to make FileMaker the best tool on the planet. We are very honored that they took so much of their time to talk with us candidly and openly. Part 2 will be released next Wednesday. Follow us on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes Follow us on Podbean https://firesidefilemaker.podbean.com or find us on YouTube by searching for Fireside FileMaker
  23. What does the superscript letter in the upper left corner of a field mean? I'm trying to relate fields in one table to fields in another table . . . Thanks!
  24. I have a parent table with 3 child tables. In the child table, there can be many related fields. I need to export only one row of data for each record in the parent table. This would require that a new column be created for each of the many values related in the parent to the child. For Instance: Noah Justin has 3 Email Address NJ@Test.com, NJ2@Test.com, and NJ3@Test.com When I do an Excel Export from FM I get Column 1 . Column 2 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I need: Column 1 . Column 2 . Column 3 . Column 4 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I'm sure it's pretty common and there is an easy solution to this. TIA
  25. Welcome Back Claris - Episode #7 At the FileMaker Developer Conference last week, FileMaker, Inc. announced they had changed their name to Claris International and purchased Stamplay. This is a bit of déjà vu for anyone who remembers MacWrite, MacPaint and Claris Corporation. It’s a blast from the past that’s been modernized. We’ll share our thoughts on the announcement and even speculate as to what the future holds. Come join us for this exciting new era for FileMaker. https://firesidefilemaker.podbean.com/e/welcome-back-claris/ P.S. This is our 7th episode. The podcast has already had well over 1600 downloads in just under 3 weeks, so a huge thank you to all of our listeners. It's getting some great reviews and we would love to hear your thoughts and comments. New episodes will be released every Wednesday. Coming up: KISS (Keep it simple stupid) FileMaker Certification Favorites & Features P.P.S. If all goes to plan, a very special episode will be released on August 19. Stay tuned Follow us on iTunes https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.