FileMaker Pro 19

Hi All! In Filemaker 18 and earlier it was a possibility mark this: Enlarge the contents of the window for better readability I cant find it in Filemaker 19. Anyone know more? Thanks in advance. -Per

I have a table of data where there may be many duplicate records based on the 'Name' field, however the other fields data are different. I need to find the first 6 duplicated records based on the 'Name' field and then set a number value (incremented starting from 1 ) against them in a field used as a flag. The table may contain as many as 20,000 records with each unique 'Name' value having 0 to 50 duplicates. Does enyone have any idea how I might achieve this using a script or a custom function?

Hoping someone might have the answer to this. I have two new copies of FM19. I installed on 2 machines (Catalina) but like an idiot accidentality used the same licence key on both machines. Not a problem I thought, just trash the app on one machine and delete the <home>/Library/Preferences/com.filemaker.client.pro12.plist then reinstall and enter the second key (as per Claris instructions). But no! each time I reinstall it does NOT ask me for the licence key but automatically picks up the originally entered key. So I am kind of stuck. Does anyone know what other files need to be removed for a truly clean uninstall because clearly trashing the app a…

I have a database that displays a movie in a container. I just provide a path to the video file, using: moviemac:/VolumeName/Clips/name-of-clip.mov Under Mojave, it works perfectly every time. Under Catalina, the movie fails to show. Same FMP 19, same path, same solution, same files. The only difference is Catalina. I have given FMP Full Disk Access and access to Files and Folders in System Preferences. Any ideas? Thanks.

Hello. While I'm waiting for the Claris answering this question, maybe some community member has knowledge on this issue and it may be useful for others, too. I bought a single licence of FileMaker Pro 19 but all my system is working in FileMaker 18. I need to downgrade version 19 into 18 and I could not find instructions for this. How to do it? Thanks

For some reason, I can't create new portal records or edit existing record data in a new db I created in 19. That feature is enabled in the relationship panel, but it doesn't work. Can't find any reason why. No the fields aren't overlapping the portal boundaries. I checked an old db created in an earlier version and the feature works fine inside 19, but not the new one. Possibly it's because the relationship is set up for many to many (not one to many as it should be); Can't seem to change that either. Any ideas? This is the first new db I've done in 19, just getting used to it.

How can I keep two tables in sync? I have two tables, Table1 and Table2. Each table has the field Item and the number of records is the same in each table. I would like to be able to make changes in one table and have them updated in the other table so that the list of items is the same in both tables. That is, when a record is created, deleted or an item is edited it one table the other table will update to match the changes.

Hello; I want to create a new application for Contacts and I want to have the Phone Field as a link to automatically when pressed will dial the number and I do not want to copy the phone no and open phone apps and paste the number then dial. Is it possible ?

I created a database for family and working fine, but when I try to use Preview for any Layout the screen will not show any data and on Browse showing all ok. See attached.

Hello; is there a function or a calculation I can use to Convert between Hijra to Gregorian Date in my FM database?

While using FM Pro (19), accessing hosted databases, my interactive container fields automatically download their content. This happens on Pro, but not on Webdirect. Has anyone else experienced this? I first thought there was a layout trigger firing something, but the problem seems to occur on any layout, regardless of active triggers.

Hello to all Where is custom function in fileMaker 19? I can't find it thanks Dani

Basically the setup is as follows: 3 Tables: People, Join-PeopleTask, and Tasks The Join-Table relationships are working well to manage individual people attached to a Task. Adding new Tasks happens in a Form Layout based on the Tasks Table. It shows a detail view of each Task and then the people attached to it (in a portal). We are curious if we can add a way to click on (select) a person from this portal and based on that selection, have another portal below display what other tasks that person is attached to. Logically, if we click off the portal ("no selection"), we'd like that portal to be empty. This will help in quickly determining a persons work loa…

I recently upgraded to FMP 19 from v9. In v9, I was able to export to RFT. That option is not available in v19. How can I export directly to a text file? The text does not need to be formatted. Much thanks.

We are upgrading from FMS16 to FMS19. We let our license agreement lapse and now are having to buy new Filemaker 19 client licenses "for Teams" (with the server included). We previously had perpetual named-user licenses, but are now considering buying perpetual concurrent licenses (at about half the number of the named-user licenses). We use external authentication (active directory) for our named-user licenses. Please explain any differences, if any, between active directory authentication for named-user and concurrent licenses? How does it work for concurrent licenses? Is the FMS configuration different? Thanks in advance ...

I want to sum values of each 7 records only and not to sum all records of a database. How could I do that? Thank you

Hey Everyone We are having this issue with the change of any of this variables IOS 13 FileMaker 18 FileMaker Server 18 FileMaker Go 18 We have a Layout for FileMaker go to upload photos from an iPod Touch or iPhone Pro 11, and when we use a script to take the photo directly from the camera works perfectly, but when we use the another one that has to open the library from the device it will happen either of this 2 things 1. It will duplicate on the mini preview the last "good" picture and when try to maximize the picture nothing shows up 2. It will happen this weird "no signal tv" ( that's how I call this lol ) i…

Gents, would you please help me to create a script?

Gents, I have an excel price list with header fields. I want to import it into a newly created FM database. Is it possible to make FM use those header fields instead of me manually creating corresponding fields in FM?

As a new user, even the basic structure of a solution seems to have hundreds of options for getting started. I'm hoping someone can enlighten me on how to achieve the following: I have a Main Menu layout that works off of a "Main Menu" Table. I have a "Team Contacts" table and layout that shows the 5-8 people that are working on a given project. There are simple fields in this table: Role, FullName, Cell #, Email. Due to the nature of these projects, sometimes additional specialists are required (and are temporarily brought on for different tasks). This is why I set up the "Team Contacts" Layout as a List view: so that we can see all of them at once, and so that the …

I would like to be able to generate a printable form or ticket from my application. I am new to filmmaker and I am switching over from Access. In Access I would do a mail merge in word and select records and print from there. I would print 2 records on a page thus making two "tickets" that I could use to add information to and have in a paper file. help!! I have tried doing a report and a form but I am having trouble getting it to fit (2 on a page) and to have the look of a form or ticket with boxes. I am a paper in hand in addition to an electronic record kind of person and I want to be able to print a "ticket" or a "form" out for my listed inventory.

Hi, I would like to make the spell-as-you-go function bilingual. I understand I can change the language completely, but that way I'd always have a lot of records with the wrong language setting, as entries are made in German and English. Using separate fields would lead to loss of information as some would only read their language. Thinking about combining dictionaries or defining the other language as user dictionary. Maybe importing a lot of words in the user dictionary? Anyone any ideas? Experiences?

The short video linked below shows a radio button value list that shouldn't work because the 2nd field is an unstored calculation however it does some of the time and others not. I've been noticing this for some considerable time and I'd love to get to the bottom of why. Any thoughts will be greatly appreciated. https://www.screencast.com/t/7CWCfpqfeP

Hi, I wonder if someone might be able to help me. We own a pub and I am trying to collate all our recipes. Among other things, I want to print labels that we stick on to any pre-made items, but would like to include all the ingredients. I've got a table for the menu and then a related table that lists all the ingredients. Is there a way of bringing the list of ingredients into one single string like you see on food packaging. The labels can't be too big so listing them a line each would be too much. Thank you!

I am carrying out a project to finalize a project for the college which consists of the following. An automatic serial number of two groups with numbers with a space in the middle of the third digit (ex: 159 023) ex: 159 023 159 024 159 025 Thanks for the help.

I am finding that my new install of FM19 is very slow. when I go into manage database I have to wait for the fields to populate for about 30 seconds. Is anyone else getting this slow behavior?

This packed livestream covers the GetContainerAttribute function, defining and using Let statements, and more on the new FileMaker 19 Add-ons! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Firstly by telling if it is even possible I have a customer contact database that I use to keep track of clients that use our services on an annual basis. We are event photographers, and we are not guaranteed that a given client will rebook us every year, so I need to keep track of who the current contact is, what we offered them and so on and so forth. When I eventually speak to the contact, I then need to follow up email with a PDF. I have created a layout that is a letter format that contains the fields that has offer details that are specific to them. I want to be able to click a button that Switches the layout from the "Form" view, to …

I'm still on Filemaker 17 and was surprised when looking at a colleague's computer to see that Filemaker 17 doesn't support Windows Emoji's, and wondering if that's been fixed in Filemaker 18 or 19? I've been holding off on upgrading due to the hassle of remotely installing, and also because other than the While statement, it doesn't seem that FM 18 or 19 have any real benefits, but this might push me over if one of them supports Windows Emoji...

We’re not ready to upgrade our server to 19, but would like to upgrade some clients to 19. I understand that we won’t be able to leverage any of the new functionality of 19, but will there be any issues with accessing a database hosted on FMS18 with FMP19?

With so many amazing new features in the latest FileMaker release, it may have been easy to miss some of the smaller features. In this FileMaker 19 Q&A, we take a moment to look at some miscellaneous new features. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

I'm a Filemaker beginner and I can't do any calculations, could you please help. The first calculation was to add one. (dot) the middle letter. The field is called middle_name The second calculation was to change the date to DD-MM-YYYY, by importing the data it is MM-DD-YYYY Thank you all :)

Over the years, we've run into a situation where two people try to access the same record at the same time. A message is displayed saying "Name (username) is modifying this record. You cannot use this record until Name (username) is finished." Two responses are offered "Send Message" and "OK". If you click "OK", the message simply comes up again, so as well as being locked out of the record you are effectively locked out of using Filemaker. If you click "Send Message" a dialogue appears headed "Message to Send" with a field enabled for a message to be written. Despite having tried this many times over the years, nobody has ever received the message. Do…

Apologies if I've put this in the wrong place. My Filemaker solution uses a FM database and an ODBC connection to a MySql database that is used to serve data to a website. I have complete read/write access to the data in the MySql database from inside FM and thus control of data published on the site. I would like the MySql database to be able to access tables in the FM database in the same manner. I have set up an FM ODBC connection to our FM server and that is visible in my local ODBC Manager, have tested the connection and that is good, but I can't see any way in the MySql apps I have installed on my system to create a table in the MySql database us…

I currently use FMP Advanced 18 on several personal projects (and also enjoy playing around with it). When Claris announced an upcoming version 19, I read a number of articles and posts hypothesizing that Claris was going exclusively(?) to a subscription plan aimed at corporations and smaller shops. I have been buying the upgrades almost every year/every other year (depending on what advances each new version contained). This past week I went to the Claris sight, and it seemed the pricing was aimed at multiple user seats. But I finally found the link to buying a single license. Seems the price is the same as last year ($197 for upgrade). What I'm wondering abo…

https://youtu.be/SZ0Q2Ex39Zo

Since we can see values from a related table why would we ever need to enter those values into the related table itself, i.e., entering a company name (either via a Lookup (not recommended) or by Insert Calculated Result in Field Options). This video discusses 3 reasons why you would want to do this.

In this video, we add a related value list to the mix allowing users to select a year and see only clients with invoices for that year.

Lookups have been around for ever and they are never going to go away but it's important that you understand the reason they are there and, more importantly, why you shouldn't use them any more

John Mark Osborne and Michael Rocharde are proud to release a special 2 hour episode discussing the release of FileMaker 19 and what it means for Claris, the developer community and ultimately its customers. While, on the surface and at first glance, there doesn't appear to be all that much that is new, a closer look reveals a version that is about to revolutionize the way that solutions are developed. With our regular guest, Marc Larochelle of Productive Computing, we discuss every aspect of the FileMaker 19 release which is new in many ways not least of which is that there will now be incremental releases every few months instead of a big annual release. Not all of the …

FileMaker 19 has arrived, with many exciting new features that everyone can benefit from! Check out our detailed overview of FileMaker 19, which includes links to learning materials for these new features: https://dbservices.com/articles/claris-filemaker-19-overview/ dbservices.com

Next point someone already has experience with? I am playing around with the new script step Filemaker Data Api execution. I am getting results with this: JSONSetElement ( "{}" ; ["layouts";"Forms";JSONString]; ["limit";Get(FoundCount);JSONNumber] ) all fine, but how to execute the _find command?

So, the time has come. Runtime support is gone in 19. This puts me in a quandary. At my company, I have a handful of small apps that do nothing but import CSVs and print labels with barcodes on Zebra label printers, or packing slips with pictures for each item. These are one-off special purpose databases. There is no active data management. The scripts clear out the DB and import a fresh CSV on each run. I have tried making these applications work with Server, to no avail. I doubt anything has changed in 19. I can understand Claris wanting to move to an online subscription-based model, but the problem is that the server version is not at feature parity with…

Claris just shipped FileMaker 19! Check out the Top 10 things you need to know about this release! New video courses (including a totally new player) will be shipping from RCC on Wednesday, May 27th. [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We are looking to manage web content and pages but it must involve php since we are using filemaker custom web publishing. What are our choices? How do we go about deciding on a technology for our website