Jump to content

Search the Community

Showing results for tags 'fmp19'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
    • FileMaker Videos
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Proof+Geist
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development
  • FileMaker Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. A small number of international remote workers require access to specific customer records that they should work on. Each worker has a code number and customer records are tagged with their code number accordingly. For years I have used a complex system of restricted privileges and scripting to hide the thousands of other records from these users. User experience is VERY slow. As suggested on one of the Filemaker forums, I am trying to implement a new system using a CONTROL table of customer IDs linked via a relationship to the CUSTOMERS table. CONTROL TABLE CustomerID Control_Code 123 UserA CUSTOMERS TABLE CustomerID Control_Code Name Address 123 UserA Mr Joe Bloggs 456 Main Street A layout based on the CONTROL table shows fields from CUSTOMERS. The user can navigate their customer records without the performance overhead of loading thousands of customer records they shouldn't access. This is much faster. When UserA logs in, a global list variable sets which code(s) they can access. User $$AccessibleControlCodes UserA X Y UserB Z UserA should see only records in the CONTROL table records with a Control_Code of either "X" or "Y", but not "Z". A privilege restriction on CONTROL::Control_Code works. If I show all records, UserA can see X and Y records. Z records show "No Access". not IsEmpty(FilterValues ( Control_Code ; $$AccessibleControlCodes )) It would be annoying for UserA to have to flip through dozens of "No Access" records, so I still need to limit the visible records with a Find. Sadly, Find does not work at all on the layout. Doing any Find on any field always returns no results. Even though I am logged in as UserA and can see the X and Y records, trying to do a find of those same records doesn't work. I imagine this is a product of the privilege restriction but I can't figure out another route to take. I feel it would be inelegant to build separate CONTROL tables for each user. This would probably work, but I have multiple portal relationships for each control table and would need multiple scripts, multiple layouts, etc If we added remote workers, it would be a nightmare. Ideas please?
  2. Hi, I have Filemaker 19 and have a calendar on the layout. My question is I don't want to have events on the calendar. Instead, I want to display orders and some of the information. Is there a way to do it? Thanks. calender.fmp12
  3. Hi Everyone My database has just developed a strange issue after working fine for years and months after updating to FM19 Mac M1 Big Sur 11.4 FM 19.2.114 I go to a set of records (e.g. Invoices or Bills) I do a find for a company X number of records comes up If I step through the records using the default chevrons (top left) I step through the records without issue However if I click the slider to go from the first found record to the last the records do not change. The record will go from 1 to (say) 25 but it will still show record 1. The chevrons work up to a point randomly changing the record displayed but not changing the slider or the record Has anyone seen this before? Thanks for your help in advance...
  4. Hello; how can we interface between FileMaker Pro Apps and cash machine from Banks so when making invoice the amount required will be sent to the machine and buyer will need to insert bank card and password then will be authorized. Thanks
  5. Has anyone played with latest FMS Linux and LetsEncrypt-Certificates? (How) does it work?
  6. I have a field, item ID, set to auto enter a serial number and validation set to not empty and unique. If the serial number entered is not unique I do not get an error message when exiting the item ID field. If I turn off auto enter serial number and manually enter a non unique item ID, I do get an error message when I exit the field. With auto enter a serial number turned on I only get the non unique error message when I commit the record. I would like to get the error message when exiting the field when auto enter a serial number is turned on Any suggestions?
  7. I have a table with 200,000 plus records. In that table, 1967 records have a BidID of 2018-XXX. Each of those records has an ItemID. Those records are imported from another table. I want to check for duplicates so as to verify the user did not perform the import twice. ItemID is unique. Here is how I am searching for duplicates First search for duplicate ItemID by placing ! in itemID field then perform find Next enter find mode again and place 2018-XXX in bidID field then select constrain found set in Requests menu. This does not find duplicated contained in 2018-XXX. It does find a subset of only 1248 records however. If I switch the order, first find BidID then constrain to duplicates, no luck, still finds 1248 records I have tried many other ways to find duplicates within bidID 2018-XXX with no luck.
  8. Recently I came across the demand to handle a specific file hosted on a FMS from an other, externally opened FM-file. Utilising the BE- or MBS-Plugin I can run system commands on the server from the client as PSOS to e.g. close the file on the FMS or, for instance, create text files. But to just open the fmp12-file locally in FM 18 or 19 (both are installed) a system command like "cmd.exe /c "/PATH/TO/FILE.fmp12"" does not work as PSOS but worked when run locally. Since the way, imho, would be to call a system level script on the server from the remote file I'm looking for the right syntax which works as PSOS. But I'm open to other ways as well ;o)
  9. Hey everyone, Just looking to see if anyone has come across a good solution to for this. I have a set of records with multiple fields that I need to export to Excel, I'm exporting via script and everything works great with the exception of one of my fields "columns". This field has a multi-line description. When exporting, all carriage returns are stripped. A quick google search turns up some solutions for exporting a single filed and preserving returns but not a group of fields with only one "column" needed the returns preserved. I'm on FM19 Server. Is there a plugin that addresses this issue? Thx
  10. I have an application where some of the related files will reside on removable media. When sorting, a message box appears telling the user that the related file (which is not on the server) can not be opened (Not Found) and asks the user to locate it. The related file may or may not be available on the removable media and is not needed for the purposes of the sort. Is there anyway to prevent this message from appearing? Error capture on does not solve the problem
  11. New user I have a "Search" script setup in one of my layouts, which works well but I'd like to refine it a little to make searching quicker and with less mouse clicks. Currently, I have a field into which I enter a client name, and a "Search" button which activates a search throughout my database for any records containing this name. For the search to work I have to input the name (or a portion of it) into the "Search Name" field , and then click on the "Search" button. What I'd like to happen is to enter the name into the field and then hit the enter key to activate the same search. Is this possible? Thanks in advance.
  12. My first try using a Server Side Script. I'm importing csv data which is on "This PC / Documents/CompPBM_checks.csv". I have tried every possible path, but still get missing file error. Options tried include file:FileMakerServer/data/documents/CompPBM_checks.csv file:ThisPC/data/documents/CompPBM_checks.csv file:ThisPC/FileMaker Server/data/documents/CompPBM_checks.csv $Import. $Import equals: Get ( DocumentsPath )&"CompPBM_checks.cvs" FM Server is hosted on AWS
  13. Simple problem with hopefully a simple solution. After installing FileMaker 19 (Mac OS X 10.15.7) and installed the license certificate when prompted, subsequent launches of the application remain in trial mode. I've followed the instructions at the site linked below: https://www.soundsessential.com/blog/191-filemaker-pro-19-how-to-fix-the-license-certificate-not-installing But they made no difference (and I didn't have the folder structure issues shown in that blog post). I also have FM 17 Advanced installed as my default FM application, so perhaps that's part of the issue. Any ideas? Kevin
  14. In list view my fields extend off the available screen area. In Layout Mode the Top Navigation part scrolls to the right together with the Body part, BUT when I exit Layout the Top Navigation part does NOT scroll when I scroll to the right in the Body part. How do I keep the Top Navigation Part in line with the Body Part? This is thoroughly disconcerting as my field labels are all in the Top Navigation Part, but the fields are in the Body Part. The two do not align as I scroll to the right. Any suggestions would be gratefully received. Problem Solved - I should have put the labels in 'Header' rather than 'Top Navigation'. Now the scrolling works
  15. Does anyone know how to do this? calling the "generate as configured" script stacks the script that gets called after the webveiwer is set at the end of the primary script, there for only the last record in the found set of the loops actually has the image file created and saved to the container field.
  16. Recently converted a FM application from V6 to V19. The application will run on FM server. Very new to FM19 Questions related to temporary path I have scripts that exports data to 3 temporary fm12 files. Two of the temp files hold data that is them imported to other files and one of the temp files holds data for a lookup in another file. dhistory imports data from dtemp rhistory imports data from rtemp vendors looks up data from vtemp The temp files are fm12 files Questions 1. I would like to have the temp files sent to the temporary path on the users computer. I have not been able to correctly specify the output path to send the temporary files to the temporary folder on the users computer. This is one attempt: get(temporarypath) & dtemp but this does not sentd the file to the temporary folder 2. Once I get the correct syntax to save the temporary files in the temporary folder, how do I tell the import records script step where to find the temporary files? What is the correct way to point to the file so it would work on any users computer? 3. Vendors file performs a relookup in vtemp, so I need a relationship between vtemp table, located in temporary folder, and vendor table. How do I specify the location of vtemp so it can be found on any users computer? Once the script finish running the temporary files are no longer needed and it is my understanding that the temporary files will be deleted when the Filemaker session is closed.
  17. Hi All, Just had a look at the new Add-ons in Fm19. Is there a way to make the timer work in reverse. i.e. Start from a field (Timer::TimeLength) that a user can input, so that the specified time of say 30:00 will run down to 0:00 Any help would be appreciated. Regards Milton.
  18. I am trying to script an import of three worksheets in the same Excel file. The 3 geographical regions worksheets are not structured the same, i.e. field name rows are not in the same place and are named differently. The script runs but stops to ask which worksheet to process. How do I create a variable/parameter in the script for it to proceed sequentially from worksheet 1-3 without stopping? Thanks DA
  19. Hello Fellow FM'ers! We have been testing Linux and everything has been great, but we are having issues with the authentication via web direct using Windows Federated Services. We followed the steps in the available documentation "Addendum4_ADFS.pdf" and also used "ExtendOAuth_v1.pdf" to get the AD-FS rules configured as well as the necessary admin console requirements (Client Key, Shared Key etc...) We do see the following on attempting to login to our solution: And when we click on the AD FS Option we do receive a login prompt from our Federated Services: However, even with the correct credentials we still see the following error message: We have reviewed the logs within AD-FS and no errors are reported and the credentials are passed as expected. Within our solution and Active Directory, we also ensured the user is in the correct group to access our solution via webdirect. I will gladly provide more details into the configuration of AD-FS or FM Admin Console, but these all match the documentation provided by Claris. We went a bit further and got an inhouse developer to take a look and test the flow and he was able to confirm the following: Our Endpoints are setup correctly and can be viewed internally @"https://INTERNALADFS/adfs/.well-known/openid-configuration" Initial request was tested with "https://oidcdebugger.com/" Postman was then used to test once we received a response. Decoding the jwt received with "https://jwt.ms/" The JWT had a unique_name, an email, and a groups array with one of the values in that group array being the group that is set up in the Filemaker solution. With that said, we are not sure what the next step would be to test this as we appear to be seeing all the correct information in our testing yet we still are not being "authenticated" in our solution. I have also opened a ticket with FIleMaker and no luck as of yet. Any insight would be greatly appreciated!
  20. Thank you in advance... We have a serialized field that has a value of FL2021-0001 and increments by +1. I created a script that makes a duplicate record for reasons that don't matter here... but at this point I need to reset the serialized field to the next correct number. I do this with the Set Next Value function as such: Set Next Serial Value [TableFL::SerializedField ; Max ( TableFL::SerializedField ) + 1 ] The problem is it sets the next value to 20210002 instead of FL2021-0002. Can I read this as a string and increment it or is the return always going to be a strict numeric value? Thanks again.
  21. Hello Everyone, I would like to check what are issues when FileMaker Pro and Server 19 are installed in Windows Server 2012 R2? Thanks.
  22. The content of myField is: text before quotes "quoted text" and I want to format a JSON object: JSONFormatElements ( "{\"object\":\"" & myTable::myField & "\"}") the quotes within my data make invalid JSON, so I escape quotes: JSONFormatElements ( "{\"object\":\"" & Substitute ( myTable::myField; "\""; "\\\"") & "\"}") Then I get valid JSON like this: {"object" : "text before quotes \"\u0016quoted text\u0016\""} I wonder where these \u0016 characters added around the quoted text come from, I don't want them there How should I escape quotes without this problem?
  23. Hello, I'd like to record when a user views a record, and then have a layout where the "Unviewed By Me" records become bold. This idea is similiar to "Unread" in most email programs, but it is generated from a shared set of records instead of only emails delivered to me. I know that I can create a subtable to create a record each time someone views a record. I don't need an audit trail of when or how many times they viewed it, just the LAST time, if they have viewed it at all- which makes me think I want this info in the record in question, not through a relationship. I only have 4 users, and I don't need this to scale up to more users. Would it be a bad idea to just add fields in the table for: Viewed_user1, Viewed_user2, etc. and then do a script where when a record is viewed, Get the user name Set the field (that matches the username) to the Timestamp. I think this would work- but I'm not sure if it's the best way to tackle it. Any thoughts would be appreciated. Thanks
  24. Hi, I am new to FileMaker. Let's say I write an app and upload to the iOS appstore. And later I make lots of changes like adding new functions and new layout in the app and I want to do update of the app which is already in the iOS store and in the users' ipad and iphone. 1) How is it going to be done? 2) Is the user data going to be safe after the update? 3) Is the procedures going to be the same as the desktop app (Any alternative other than doing "Import")? Thanks KC
  25. Is it possible to change the logo of the FileMaker 16 local file? We changed the logo in in "File Options". But it is not reflecting in the FileMaker DB logo. Thanks in advance.
  • Create New...

Important Information

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