FileMaker Pro 16

I've had a problem with formatting being entered into fields when I paste content. So if I have a field whose formatting is defined on the layout as Verdana 12 but I paste something that had other formatting like Times 24, the other formatting (Times 24) remains in the field. After some searching, I found that if I set a field to a calculated value of TextFormatRemove ( Self ) and uncheck the "Do not replace existing content of field (if any)" box, the formatting is removed when I exit the field and the formatting I defined for the field applies. Is there any way to set this globally for the FM database or for the layout so I don't have to do this for …

I have a Packing List function in my database where I generate packing lists for orders. I'd like to add functionality where I can either select an item from a dropdown menu then click a button and the item is appended to the notes field or where I can have buttons that I can click where text is input. As an example, if I have the following line items: 50 envelopes 100 envelopes 50 postcards 100 postcards 50 pens 100 pens I'd like to be able to put the cursor in the notes field and click "50 envelopes" then click "50 postcards" then "50 pens" and the entry in the notes field would look like this: 50 envelopes 50 postcards 50 pens The prob…

I have a database where I am creating QR codes with URLs for our customers to place orders. I've been using a free service called qrserver.com and have been using this script around this (I can't recall where I found the script): Set Variable [ $theURL; Value:"https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="&qrgen::orderurl ] #Make sure the field you are inserting into is on the layout that the script is running from. #----MODIFY FIELDS---- Insert from URL [ qrgen::QR Code; $theURL ] [ Select; No dialog ] #Turn this on for troubleshooting. If something is wrong, you will see some error information coming ba…

I have a script that finds records with certain parameters in order to print them. Here's the script (I numbered the lines to make it easier): Select for printing script 1 Perform Script [ “go to live airports” ] 2 Go to Layout [ “Select Airport” (airports) ] 3 Sort Records [ Keep records in sorted order; Specified Sort Order: airports::iatacode; ascending ] [ Restore; No dialog ] 4 Pause/Resume Script [ Indefinitely ] Copy [ airports::iatacode ] [ Select ] 5 Go to Layout [ “order detail” (qrgen) ] 6 Enter Find Mode [ ] 7 Paste [ qrgen::airport_code ] [ Select ] 8 Set Field [ qrgen::unprinted; 1 ] 9 Go…

We've built an order management platform that uses Google Firebase as the database backend. I'm exploring using Filemaker (16) to build a front end to make data manipulation, order analysis, and report generation easier, but I'm not seeing how to connect a Filemaker database to Google Firebase. There are some plug-ins such as GManipulator which integrate with Google apps like calendar and contacts, but it's not clear whether that can connect to a Firebase database and I'd like to avoid spending $150.00 per year (more if I have more users) to use it. In the good old days, it was possible to connect Filemaker to a mySQL (or other) database using ODBC, but that seems to not …

I have a database of airports and have a layout where I show airport info. Here is a screenshot of the Canadian airport data: The 4th column shows enplanements, or the number of passengers boarding flights (the field name is "enp2023"). I use this formula to display the numbers as X.XM (millions to one decimal place). This is the formula for the field: Round(enp2023/1.0e+6;1)&"M" However when it is an even million the number is truncated and doesn't show 4.0M (as for Edmonton) but simply 4M. I'd like it to display as shown in the rightmost column (these have been entered manually), as 4.0M. How do I do that? Thanks in advance.

Whenever I paste data into my Filemaker database using command-v (we use Macs), it shows up with the original formatting and not the formatting of the field. I'm attaching an example using my name. If I do command-z it wipes out the formatting and shows the formatting on the layout as in the second image. Is there a way to force the data to just use the field formatting and ignore whatever the original formatting was without having to do command-option-shift v (Paste Text Only) or command-z? I'm pretty careful about this but I'm afraid that as more people use the solution the formatting will be all over the place. Thanks in advance.

I've got script parameters in buttons that I would like to use to find records. Any thoughts?

I have a database of US airports, identified by their three-letter IATA codes (e.g. JFK, ATL, ORD, LAX, etc.). The database includes enplanement information provided by the FAA. I set this up in 2021 so I included the latest year available of this data, 2019. The FAA has just published 2023 data and I want to import that, but my import doesn't work. I've set up a tab delimited file with column A = IATA code and column B = emplacements. My original database has 512 records. This is what I've tried: First Attempt: 1. I select all records. 2. I then select: File > Import Records > File 3. I select the tab delimited file and get th…

I print tear-off receipts on 8-1/2" x 11" Click-N-Ship labels. We cut the labels in half horizontally so we get a label that is 4-1/4" x 11" and is stuck on an envelope with a tear-off receipt that the customer tears off (see image). The customer then scans the QR code on the receipt and pays. I have the layout set up in Filemaker so the labels print two up. The problem is that when I cut them they are no longer in numeric sequence. I'd like to set up a sort order so that if I cut the labels in half I can simply stack them and they will be in the correct numeric sequence. So for example, ideally, if I print 100 labels, the sort order would be such that if I cut the 50 she…

Hey all Need a to install pro advanced 16 for a client so I can work on their file. Asked FileMaker and they said "we don't provide downloads for unsupported version", which is odd. Anyone have a link or a copy of pro advance 16 dmg file?

I have this old invoice form I set up a very long time ago using one of the earlier versions of FM. Somehow my Company Code field and connected address field got "broken". When I type in the initials for a given company then hit tab it prompts me to lookup previous year version of FM, and generally I use last year's record since most of my clients have been with me for many many years. Well, as a result of getting messed up instead of the company's address being filled in the address field it's repeating the initials of the company code. I've included screenshots showing the layout for the invoice form, then the specify field box, then the "manage database for 23 client l…

I am trying to modify one of my exisiting databases. I firstly clone the old database they I want to rename it as=nd mnodufy a few layouts for a new business. I have managed to clone it, but I simply cannot open the clone. I just get an error that Filemaker is unable to write to this file. No idea why, file permissions are correct. Anyone else seen this? I have recreated the file, moved it to different folders etc. This is using Filemaker Advanced 16.

Hi, I am trying to hide an object on a report other than in the Part 'Body'. All other parts i.e. sub-summarys etc it is to be hidden. I understand how to do this using the function Get(PageNumber) used in the 'Hide Object When' but depending upon the record I am viewing the records within the body can be anything from 7 pages to 60 pages long. I suppose I am after something like Get(ReportPart) ≠ Body. This function doesn't exist however. Please could someone point me in the right direction on how to refer to the Body Part in a report. Steve

When I attempt to 'learn' a word, "Learn" is greyed out. The dictionary I have selected is: /Applications/FileMaker Pro 16 Advanced/Extensions/Dictionaries/User.upr . When I attempt to edit that dictionary, I get: "The User Dictionary file is Read Only." The permissions are: -rwxrwxr-x 1 root wheel 47 Jun 14 12:16 User.upr FileMaker Pro 16 Advanced, 16.0.3.302 I compared the permissions on the files in Dictionaries with a colleague's (he has the same version of FM), and they are identical, however he is able to Learn a word and edit his dictionary. I also can't create a new dictionary in that folder. I checked permissions on each directory, and not…

Hello all, I wanted to check in, as I'm quite done clicking the remind me later button on my mac to install my Catalina update, and wanted to check in and see if anyone has run into any issues with FM16 Pro Advanced and OS Catalina. I don't have a server, just using the database on my own computer, no plugins, etc. just a bare-bones license of FileMaker. Thanks!

I want to login onto my mac mini as fmserver. In order to do this I went and tried to create an account called fmserver. I've got the following error message "Name is used by another user" I've managed to mount my NAS in the backend. To access the NAS mounted volumes I need to log as fmserver. Does anyone has an idea of what are my options? Thanks!

hello all, First time on here. I have a Filemaker 16 solution on a file server which contains 12 files. I am the only one who uses the database which is why it is not on Filemaker server. I have scheduled it so it creates a backup when I close the database. I have a global field that is set with a timestamp when it backs up and the backup script checks that timestamp and only backs it up if that timestamp is more than 3 hours. The issue is that it takes a bit of time to back up the 12 files. Most of these files are relatively static. Suppliers, Job codes, etc. When I back up the files I replace the extisting backups so there is only the one set. I would like to…

I all, I have a (text) field in my Music Database that has the full file path for every mp3 of my external HDD (around 50.000 classical music mp3s). It would be wonderful if I could use this file path (in text format) to open externally (or internally) the related mp3 file on my external hard drive in a (hopefully) simple way. I have Filemaker Pro 16 Advenced and I'm a real newbie at this... Many thanks in advance.

Hello, I am looking for examples to get AVPLayer working within filemaker pro. All my video files are remotely stored. Those video files will never be stored within a container. I do have too many video files and they are way too big to be uploaded in filemaker. I found FileMaker Pro now have AVPlayer and using a url is an option. I thought that would be very easy and this is not the case. I am getting an error 3. I am looking for documentations and examples. Does any have a suggestion ? Many thanks! With regards! AVPlayer.pdf

I am trying to insert into a container field the file path of a mp4 video as a reference. I am getting an error equal 3. I've followed some example and do not understand why I am getting this error. If I try to import the video file by going to the field and with the mouse do a right click I am able to import the video fiel as a reference. Unfortunately the script does not work. Thanks! inserVideoPath (as a reference).pdf

I need and advise. I am about to create a program which is to be executed in the background. I was thinking in getting it to process with "Perform script server". The program is to scan a folder and when a mpeg file is found it would convert it to mp4 format, the app would be called "CMpegToMp4". My question, is would it be possible to execute "CMpegToMp4 within FileMaker Pro through "Perform script server"? Thanks in advance! Daniel

I have searched the forum and internet and not found an answer to my delima. I have a solution with a scripted import of a csv file. I do not want import dialog (e.g. mapping), so I have it set to no. I don't know the name of the file, only that it is a csv file. If I leave the filename out of the import dialogue, the default SHOW filetype in the open file dialog is for a filemaker database. The user needs education to change the SHOW to csv or all. That is undesirable. If I import a correct file once, the next time the script runs in that session, it prompts for a csv file, but if I quit the application and run it again, it goes back to SHOWing filemaker databases…

macOS 10.13.6. FileMaker Pro Advanced 16.0.6.600. In a solution "A" on my computer, I created a script as follows, to remove any non (field) default formatting in effect on a selected field. I used this method: "If no field is specified and a field is selected in Browse mode or Find mode, that field is used." The script works as expected: Set Field By Name [ TextFormatRemove ( get ( ActiveFieldContents ) ) ] During testing, I've saved the script in solution "A", and even quit FileMaker and reopened the two solutions. When I copy the script and paste it into solution "B", the script changes, adding Get ( ActiveFieldName ) ; to the specified field (…

Using FM Pro 16 on a Mac with Mojave. I have an existing invoice form for my business I set up many, many years ago and would like the names describing the check number field, check date field and check amount fields to print out on hard copies of the invoices after I've filled in those fields and marked them paid. I've dug through the layout in layout form and can't seem to find where I can mark those field names/labels to print when I print out a copy. The check number, check date and check amount do print out. I've attached a screenshot of my invoice in layout form. Thanks much in advance for any help.

I have been going through the web to look for examples and I have not been successful. Even when looking in Lynda.com. Over the years, I have been using plist files and now wants to change to xml. I am looking for example on how to export and import data in xml format with filmakers pro . Does anyone have an idea where I could find some information? The idea is to create a script which would import a xml file located on a SDHC card. A script is being used to format SDHC cards and at the same time the NX5UCarteNo field will be updated to identify the card with a number from 01 to 10. The information is the being exported as an XML file onto the SDHC …

Using: FMPA 16 Good evening - I have a text field that's auto-populated from an xls file. It's up to six lines long, and contains various data per record that looks like any of the following: (SAMPLE 1) ANYUSER RICK & MELANIE 123 ANYWHERE ST LAS VEGAS NV 89108 (SAMPLE 2) ANYUSER RICK ANYUSER MELANIE & JANINE 123 ANYWHERE ST LAS VEGAS NV 89108 (SAMPLE 3) ANYUSER RICK 50% ANYUSER MELANIE 50% C/O THE RICK AND MEL TRUST 123 ANYWHERE ST LAS VEGAS NV 89108 (SAMPLE 4) THE ANYUSER COMPANY 123 ANYWHERE ST COLDSTREAM BC V1B 3W8 CANADA What I need to accomplish: I need to non-manually populate this data int…

This is the first time I am using a CheckBox set from a list and do not know how get what has been selected within a script. I am showing both the list of possible values along with a script I've thought would work. I know how to work with radio button but never did use this approach. I would appreciate if someone could provide me with an example. Best regards! Daniel Select a step to process.pdf

I've done a "Perform find" where one record out out of 4 has been selected. However, the line 49 " set field (Invoice Data::PRODUIT ID MATCH FIELD ; $__pkCryptedNameFileID)" command does not update the content of the field . Why ? I do not understand, in the meantime, I've noticed the selected record of the 'Invoice Data" table is coloured grey not white. Many thanks for your help.

I've got very little experience in working with "go to related records". I've managed to get to print Customer and Merchant invoice. I'm having difficulties in printing QR-Code Coupon. When comes the time to print the coupon there are 3 records in the "Data Invoice" table. I am trying to print each of those three records as individual coupon. The expectation for this request is to produce 1 Customer invoice, 1 Merchant invoice and 3 QR-Code coupons. At the moment, I only getting 1 Customer invoice, 1 Merchant invoice and 1 QR-Code coupon. I've inserted a loop in order to print each of the 3 coupons and for some reason it does not work. Would someone h…

I am about to upgrade from FileMaker Pro 12 to FileMaker Pro 16. The readings seems to suggest to have High Sierra as the OS. I currently have Maverick and need to upgrade the OS for FMP 16 to be installed. I was going to upgrade to Mojave but believe I would be better with High Sierra. There seems to be issues with FMP 16 and Mojave. I would appreciate getting your advise. With regards! Daniel

I need to be able to execute VLC within FileMaker Pro. The clip to be displayed is to start and to end at a certain time. I have been able to do it using the following under MAC Terminal. Unfortunately, VLC starts but not at the correct place. I've created a variable $paraVLC which contains the "start, end time values to be used by VLC as video parameters. Would any one have an idea how to pass VLC parameters when using perform applescript? Thanks! printVLC.pdf

I need to generate QR code within FileMaker Pro. I’ve been looking on the internet but I am not sure on what to do. QR code are to be generated in the background. Customers would make their order and part of their receipts a QR code would be printed. By pointing to their QR code with their intelligent phone some triggers would be activated. Then my need is to gather customer information generate and provide the customer invoice with a QR code for him to point when the product is ready. I would appreciate in getting your advise on getting a FMP generate QR code function. with regards! Daniel

For some reason the perform find function always return the execution as the "record existing". The first execution, there is a record which is different than the one being found. The expected response was "missing record" I've left the new created record in the table for the next attempt. The expected response was "existing record". This is what I've got as a response but do not trust it because I am getting that answer eve of there are no duplicates. I've been trying multiple but it always goes to the else condition of the perform find function. Test.fmp12

Hello, I wrote an applescript program to gather the creation date of a specific file. The result is to be returned to the same table the parameter came from. Unfortunately the command line : set cell "Infile::CreatedTime" to fileinfor does not return the information into the field "CreatedTime" I've also tried : - adding "of current record" - something like "set cellValue of cell "CreatedTime'" to fileinfor Would someone have an idea why the information is not being returned to CreatedTime? Many thanks!

Hello, This might be a very basic question. However, I've seen this for a long time and never been able to figure it out. When doing a "Go to Layout" the table quickly show even with Animation equal to "none". Is there a way to prevent this? To pause the situation I've added a show custom dialog. As you can see behind the dialog box, the table content is being showed. This goes very quickly and makes the behaviour not to be great. With regards!

Hello, This program works with other script but for this one I am getting errors. I am trying to get the value of a field "EventNo" from the called Preference Table. The next step will be to copy the value into a plist file. First image is the Perform script calling the applescript along with the layout of the table being called. The next picture is the applescript program along with the errors I am getting. Would someone have an idea why I am having those errors. With regards! Thanks!

We want to upload our server to filemaker server 16 but we have some doubts about how WebDirect manage the urls. We want two machines deployment, the worker in dmz, the master behind the firewall (same as we have in filemaker 14). I have read in the documentation that I can use the url of the worker or the master to point to our solution, but I don´t know if the url is going to change from one machine to another and if it is necessary to have both fqdn in a public dns or just with one of them as happens in FM14 is enough. Any help would be appreciated. Thanks.

Hello, I am not to knowledgeable with custom function. I’m having difficulties, I am getting an error. I’m investigating the input « dataIN » and returning the result in « dataIN » Case ( Parameter = “deCRYPT” (substitute( $dataIN ; [“b”;”0”];[“c”;”1”];[“d”;”2”];[“e”;”3”];[“f”;”4”];[“g”;”5”];[“h”;”6”];[“I”;”7”];[“j”;”8”];[“k”;”9”]; ["m";"0"];["n";"1"];["o";"2"];["p";"3"];["q";"4"];["r";"5"];["s";"6"];["t";"7"];["u";"8"];["v";"9"]; ["B";"0"];["C";"1"];["D";"2"];["E";"3"];["F";"4"];["G";"5"];["H";"6"];["I";"7"];["J";"8"];["K";"9"]; ["M";"0"];["N";"1"];["O";"2"];["P";"3"];["Q";"4"];["R";"5"];["S";"6"];["T";"7"];["U";"8"];["V";"9…

I need a solution to generate QR code within Filemaker Pro. The solution needs to work offline. When running filemaker pro the internet is off. Does anyone has something to recommend? Thanks!

FileMaker Pro 16.0.6.600 On a Mac I am having a container field where I store PDF files. Every time I start the DB and I get to a file in the DB with a PDF in it, I get a box asking me: adobe pdf viewer can not find a compatible… etc. Now if I select Adobe Acrobat Reader DC it now runs fine, however it will ask me again the next time I open the DB. Boring indeed. Any solution to that? My first choice would be to use Preview, I did select it when the box appeared but this does not work. Any solutions to that? If it needs to be Adobe Acrobat Reader DC, where can I set the preferences so it does not ask me all the time? Adobe Acr…

Is there an easy way to change the color of the scroll bar in a portal? Mine is white and you can barely see it and or make out what it is. Any help appreciated.

Just upgraded to FMP 16. Now when I try to log into my solution as an admin by hitting the option key I just go straight into the solution. Unfortunately I go straight in as low level user and not as an admin so there doesn't seem to be an easy way to fix this than I can think of. Any suggestions?

I am building a directory for my HOA. All of the data is in the Mac address book. I can sucessfully export that to Numbers and then export to a .csv file. I have designed my directory page and I can import the .csv file into it and I get a correct page for each homeowner with all the data, addresses, names, etc. That all works fine. In the upper right hand corner I have a block for the picture of the house. I have to go to each page of the directory and drag and drop the picture to that box. Needless to say I would like to get that automated. One of the things I import with the .csv file is the Lot Number of the house. Simple 3 digit number of 1 to 250. I have all of th…

como crear directorion desde filemaker 16

Hello! Came over to this forum since FM screwed up the community, so feel free to move this post around if I have it in the wrong place! Is there a way that I can put a transparent button over the body of my list layout, but only allow it to be clickable of the user first clicks to make that record the "active" record? Essentially, they would then be able to click to make the record the active row but remain on that layout, but then a second click would direct them to the appropriate layout? Can the button only be shown when the listed record is active? If so, what would my "Hide object when" formula look like? Thanks for the help, here's to hoping this foru…

I am stunned why I cannot get rid of the white space in a text field. I created a note window for my solution that runs in a separate window. I want to be able for the user to resize it as small as possible, the same way it can be done with the native TextEdit app the Mac. But even with the layout settings set to the minimum, I get this result, I cannot drag the bottom windows side higher: This is how the layout looks like: Any idea what causes this?

Has the recent Mac update broken filmmaker 16? I would love to move to 17 but the cost of hosting it on any of the hosting services is prohibitive. Is filemaker forsaking me and driving me to airtable?

I chose to suppress the SSL warning for a given host in my FileMaker 16 Pro Advanced. Which file can I edit or remove for FileMaker to forget that I chose to suppress invalid SSL warning?

In my opinion the FMP "Launch center" just destroys some more FMP user friendlyness. What could have been more friendly than being able to have the solution start file shortcut on the windows desktop. But Nooooo, from v14 on we must have a launch center whether we want it or not. What was wrong with FMP "Quick Start" and the option check box to "Show this screen when Filemaker Pro opens". How about adding a check box the the launcher to "Show this screen when Filemaker Pro opens". Or, how about a workaround to disable, bypass or delete the "Launch Center". Is this at all possible?

I am beginner to use Filemaker pro, I Created visitors system how can getting data from reader (HID Omnikey) to fill the fields automatically like first name, middle name ,and ID Number (Emirates ID). how can make script for this issue? Could you please provide me course training for this matter ? note: i am live in untied Arab Emirates

Running FileMaker Pro 16 Advanced on a Mac (NOT Server). I currently have some databases set up to send data to a third party software to create barcode files. Data is imported into FMP and there are buttons that activate scripts. Everything is working fine. My understanding is that FMP talks to the other software via AppleScript. However, I may need to switch my third party solution and I cannot find anything that will do what I want via AppleScript. A few claim to work via Automator and one other seems to work via "Command Line" input. My question is - can I send Command Line instructions from FMP 16? I have searched this forum and the internet in general and…

I am getting a value from a plist file and I am trying to update the value of a field in a FileMaker Pro table. The script read the plist files correctly but the field does not get updated in the FileMaker Pro table. Would anyone have an idea why set _EventNo to field "EventNo" of table "Preferences" does not work? Many Thanks! tell application "System Events" tell property list file ("Volumes:NX5U:NX5U.plist") tell contents set _EventNo to {value of property list item "EventNo"} end tell end tell end tell set _EventNo …

Hello, I've been doing some search on how to Get the content of a plist file within FileMaker Pro and the only information I am getting are links on "Where is FileMaker plist preference path located". I have been able to perform this action in using "Perform AppleScript...." Are there another way then using "Perform AppleScript"? tell application "System Events" to tell property list file ("Volumes:NO NAME:NX5U.plist") set value of property list item "EventNo" to "44" end tell Many THANKS!

I'm trying to arrange for "Insert File" to open in a particular folder (cross platform). It seems it will only go to a specific file that I fully specify. If the file doesn't exist, it seems to go to some other place (like the last folder or the documents folder). Any way to control this? Thanks

Hello, I am completely new to the FileMaker platform however not new to databases. I love FileMaker so far however, I'm a bit stuck. I have a customer table, a cities table and a states table and a form (or layout). The cities and states are drop down boxes for the user to use however, how do I set it up so that the user can enter NEW data into the drop down box (table) and have it check that for duplicates? Thanks so much for your help!

Running FMP Adv 16. Looking for the best way to handle this situation. Examples are simplified. I have a list of stores: Red, Blue, Yellow, Green Each store has a number for sales in each month (Jan, Feb, Mar, etc.) I would like to generate a report for output so I can plot the monthly sales on a graph (via Excel). Since sales data involves a new entry each month, I didn't think it a good idea to put everything in one table. I currently have two tables - stores and sales. These are related via a unique code number for each store. I can easily see monthly sales for each store in a layout using a portal. I cannot figure out how to …

Greetings I wonder if anyone knows of a method for FMP to monitor the fields and records in my database for changes, flag and report the changes on a semi-regular basis? if I can achieve a report, it would massively simplify my update process, for hard-copy and PDF distributed documents. TIA for any suggestions! RS

Announcing fmSearchResults 5. This latest download delivers new features with simple implementation. And it's free! fmSearchResults 5 adds fast, multi-table searching to your FileMaker solutions by importing a few scripts and pasting a simple search field on to your layouts. It feels like the type of Google search that all your users are already familiar with, and it’s far more powerful than FileMaker’s Quickfind feature, because it searches across multiple tables and has data-type awareness. Read more about the new features and download it now! Implementation is so simple, watch me do it 5 minutes (and 12 seconds).

I have laid out a report that will display results on a month by month basis. I have the calculations done, and the report looks good. But I have to input a set of dates (1/1/...1/31, then 2/1...2/29, etc.) to get the report to display the full report. What function or script steps can I use to increment the search, and have a report showing a line of results for January, then February, etc.?

Hello everyone, i have to sort many portal on the same layout. My idea is to use one field for the table display in the portal. In the script i display layout with table used in portal, sort and then replace field content by serial. Then go back to the main windows and the portal is sort. What do you think about that ? is there a better way ? Tom

When I try to add pictures from camera roll on my phone I get a question mark. Does anyone know the cause of this and any possible fix?

Hello and Thank you for your help I need to create date calculations, Objective to use a date that I enter in to a field and then calculate a due date. For ensample: Field Date is 20/06/2018 add 1 month = 20/07/2018, 2 month = 20/08/2018, 3 month = 20/09/2018 so on. So I need a field that I enter the number of months in 1 to 12, (Frequency Field), a date field where I enter a date manually (Last Inspection Date). Then I need a date field that calculates the date I entered (Last Inspection Date) and number of months (Frequency Field) to calculate the next due date. Regards Robin

Image attached. The second-to-last line is the only line with the word "changed" I don't quite know where to begin looking. In the past when I have dealt with corruption (different database / company, > 5 years ago) it was on a layout and I deleted it and all was happy dory after that. Your thoughts and experiences are appreciated.

I am a french guy, so please excuse my poor english. My filemaker is french so I don't know what are the real words in script. Finally, this file is about billing, but please do not consider the bill itself but only the script. So for the billing, I use 4 tables - Job table - Internal jobs (for hours and rate) - External jobs (for supplies) - Billing These 4 tables are linked by the filed id_job. So this is how it works. When the client accepts the quotation, i edit the deposit invoice. When the job is finished, I edit the final bill. The problem is that the script does not work correctly. The 1st script is for the deposit invoice. Il create…

Hi there, I know this question is going to be a bit vague but I would be grateful for any help. The database is Hosted on FMPHost on the cloud hosting, the clients use FMP 2016 on Windows. The tables in question are a contact information table and a donations table. The donations table is seen via a portal on the contacts layout (picture of portal and relationship attached). A new donation portal row is added via the attached script. The client said that they entered 20 donations, and now they're all gone. They were all from the same batch, the batch to donation relationship is just batchid=batchnumber. I have checked the donation records, they are certainl…

I have many years experience in other databases, but just getting started in Filemaker. I am looking into the relationship graph and I see a lot of duplicated tables that I don't see in the tables list. Are these "virtual" tables? Thanks.

What installers are people using to deploy their FM apps on Macs? OSX Packagemaker is 32 bit and soon won't be supported.

I want to use the find/replace script function to find and highlight specific text across several fields, but I need to use a variable and would prefer not bring up the dialog box and have the user type in the text, but the find/replace function won't accept a variable. Is there an alternative? It's important in my solution that the found text is highlighted when found.

Hello FM Gurus, good morning. Currently, I'm making a solution it's called "Enrollment and Grading System" of a certain school here in our place. I'm having a problem here with this Checkbox. (Image Below) As you can see in the image, I checked all the boxes on the checkbox list but unfortunately it will display only the letter "M". I want the output should look like this "MTWThF". I really need your help guys. Does anyone here can help with this? Thanks and God bless!

Hi Everyone, Here I'm trying to execute VBScript file which is hosted in my local system.Now I'm trying to execute that file in FileMaker. But it doesn't work.So could anyone please update the basic example which executes VBScript file and get the result in console. (or) Give an Example on how to Connect VBScript file to FileMaker ?

Is there a way to count the number of records in a portal (got that part figured out in a sum field) AND account for if a record has a specific field entry? I have a portal that displays games and sometimes the games are paired together in one record. I want to be able to count the paired games as 2, not 1. I'm thinking something like If ( Qty = 2 ; ( Get ( TotalRecordCount) * 2 ) ; 1 ), but currently what I get is ALL the records, times 2.

We have a solution "Hub" and want 4 clients to be able to access the file on a network drive - J drive. We are using FM 16 on Windows. Is it possible for multiple clients to share a file on a network - with simultaneous use? If so, how do I set this up? We cannot simultaneously use the file. When one user is logged in, the other users get an error message: "Hub.fmp12" is currently in use and could not be opened. If the file is shared, you can use the open Remote command to open the file on the network. (If you've opened the file before, check the Open Recent menu.) There are no remote files listed. I have Network Sharing turned on. (see attache…

Hi all, i have a script that is for certificates , its simple really if the person has passed that test then a cert would be printed. I have the same script for PDF on Desktop. The email one doesnt print the spot certs even though he has passed . The PDF script doesnt even save it to desktop.This all worked before but seems to have stopped working after last update. Any ideas? Oh also minimise doesnt minimise in script anymore especially if you use CARD. as i say they did before.

Hoping that someone here can point me in the right direction, and that this is actually a simple task (but one that has me stumped right now). I have a solution that I have developed and would like to make better use of a Checkbox. The checkbox would display the contents of a field that contains multiple options/accessories that we can supply. For the sake of this question, let's say it's 5 options; Window Tint, Trailer Hitch, Floor Mat, Tool Box, and Sunroof. Each Item would have a different cost. What I would like to be able to do is have a field that calculates the total cost of the options that have been selected (could be zero, or all 5). I've looked for help o…

I have a set of order forms, in which each order form has X amounts of orders from X amounts of clients. I can summarize with a Summary field the number of orders each client has ordered on one order form (weekly order form) and now I want to make a report that tells me the breakdown from week to week, and quarter to quarter. I can get the report to break apart the weeks by quarter, and it displays each week's correct total, but it won't do a total sum of each quarter, let alone for the entire database. I've tried summarizing the weekly summary field to get the quarterly amount, either in a new field, or on a trailing sub-summary part. The new field just copies the n…

I've just upgraded to FileMaker Pro Advanced 18 and I realized that most of the themes are missing!!!! Is there any way to recover or import them from previous version like Pro 14? Thanks

Our company sends emails to client reps with FMP URLs that take them to the relevant database record. We have been using the tinyurl webservice to shorten the FMP URL with success for some time. Since the most recent Windows update, however, we are getting no result from the insert from URL request. I'm sure it is related to the update, because the when the insert from URL is requested from a client machine that has not run the update, the tinyURL result comes back with with no problem. Does anyone have a similar experience or can anyone suggest a fix or workaround? Thanks, John

Where can I find out which FM versions will run on which Mac OSX versions?

Hi - I'm having an issue I've never had since starting with FMP 7. I'm using FM Pro Advanced 16 (latest update), working on a database that I've been working on for years. It's always been very stable. Lately, it's been crashing unpredictably. When I say crashing - the program just quits, no messages, warnings, etc. It's happened at different times - running a very simple script, going to a layout, closing the relationship graph. No apparent pattern. Is anyone aware of any particular issue like this? I am running a couple instances of chrome at the same time (quite a number of tabs) plus an SVN client and various things in background. I don't know if it …

Hello Out There! Just got a new iMac and it was time to update my individual FMP to 16. Currently there is a buy-one-get-one-free deal so I got two license keys: one for me and one to share. Anyone else out there ready to upgrade/update their individual copy and wanting to share the cost? It would be HALF of $329—just $164.50. Let me know, if so! Would hate it to go to waste!

**This is a fairly esoteric type of question, so I expect not many answers. Even if you have an idea of what to try, I'm all ears. Has anyone else run into issues with Windows 10 and FileMaker Pro 16.03 accessing a file on a FMS16.03 server? Sometimes the user's computer will freeze to the point of not responding at all, leaving the user no choice but to hard reboot. Othertimes the RAM or Hard Drive usage will ramp up to 100% and stay there, with the blue circle just chugging away with no end in sight. All of the computer exceed the recommended hardware, and the network ping is less than 1ms to the server. There are three plugins that are being used (SQL R…

Hello All, I am using the invoice starter solution, I add a Catalogue Field to the Invoice Data Table which is an (Text ; Indexed, Look up from related Table Products::Item) I've been playing over the weekend but I cant make into work. If I put the Catalogue Number my item its not filling automatically. Can you please help me. I have also attached the file that Im working for your reference. Thank you Invoices.fmp12

Hi all, I remember that there was once a solution where a business card could be read and the field/blocks discovered could be assigned to a type (Email, Mobile, Office etc.) and these blocks imported into FM. But I can't find it anymore. Anyone an idea? One way or the other, is anyone aware of a solution which does OCR with a higher accurancy than tesseract ocr?

When I launch my solution in FM16, the window is maximizing. This doesn't happen in FM15 and I can't see anything in my opening scripts that would cause the window to maximize. Any ideas?

This is something I discovered by accident. The solution is one that was worked fine in FileMaker 13, but appears to break in FileMaker 16. In FileMaker 13, you can do a GTRR and specify that you want to use an external table's layouts. In this case the "external" table is in another file. When you do that and do this in a pop-up window, the normal behavior, based on my experiences, allows the window to be referenced by name, moved, and resized. It does not appear to work that way in FileMaker 16. In FileMaker 16, the window will appear, but cannot be moved, resized, referred to by name, or closed. This may be due to having the menus on each window or the extern…

When I try to start FMP16 - since the latest update - I get an error message without any part of FMP appearing on the screen. There is a lot of data but the bit that caught my eye is this: Anybody else having or had this issue? Any known solution? Filemaker support seem to think its an Apple problem - something to do with my user account. Apple seem to think its a filemaker problem. Happy to supply the rest of the error message if required.

HI Folks, I've just bought a new MacBook and am using it as an excuse to force me to organise my HD! In Mac OS Sierra, documents and desktop are synced (optionally) with iCloud. This feature is obviously handy as it provides an easy way to access files without carrying memory sticks etc around. My questions are: 1. Is there a danger of a FM file being corrupted if it is on a disk that is being synced with iCloud? (I believe that this is the case with DropBox etc?) 2. Is that danger only present when the file is actually open in FM, or does it apply to backup files / files that aren't open too? Cheers folks! Mike

Hey, I have a question about hosting my filemaker database. If I buy a license for 5 people form here: https://store.filemaker.com/filemaker-cloud , will I also need to purchase 5 normal FileMaker 16 Pro Client licenses so people can actually connect to the database? I don't quite understand how this works yet, maybe someone can help me out. Do I get the client licenses with the purchase of a server license? I need 5 people to be able to access it. Thanks in advance, Mike

After the latest update 16.0.2.205, Inspector is not working properly on two checkboxes. I see it on Browse and Snap to Grid check boxes. When I click on the checkbox, it won't refresh immediately. I have to switch to other tab and get back. Then only it refreshes. If I continuously click few times, entire Inspector window becomes empty. Sometimes few clicks and sometimes many clicks. Then I have to restart the FileMaker to get back the Inspector. Another issue happened on 16.0.1 itself was position values are not updating dynamically when I move the objects either by mouse or arrow keys. I have to click outside the object and click again to know the new position. O…

I have been using a navigation technique I developed back in FM12 and have used successfully in 12, 14 and 15 that utilizes global variables to track forward and back history. In order to make it multi window friendly I use Code ( Get ( WindowName ) ) as the variable's repetition number. When I updated to FM16 the navigation script failed. While investigating the failure I found that Code ( Get ( WindowName ) ) as a variable repetition in FM 16 resolves different than it does in FM 15. I created a test file and a script that set two variables as shown below. The name of the window is codeTest Here are the results in the Data Viewer of both FM15 and FM1…

So I got a copy of 16 from Tech Info and just bought a real 16 version. In the past there have been people who say it was a problem if they did not remove their prior version. Is that still the case? If so, how do I remove it from my Mac since I do not see an uninstall in its folder? I don't want any problems. thank you.

Hello! We are considering FM 16 (and other products) as a platform for a SaaS development and have a license question. As far as I can tell the old "concurrent user" license model is gone. We are contemplating building a public web based platform for hundreds (and hopefully thousands) of end users of our product to utilize on a weekly or possibly daily basis. Our dev team is less than 5. Does the new license model support something like that at a reasonable cost or is it only suitable for an enterprise type of model? Thanks.

Anyone else not yet received their web letter with their FM16 license info? FileMaker says they are on their way but still waiting.

Hi, I have a FM7 database (Mac) that I developed for myself to manage a small apt rental biz. I just upgraded my Mac and now need to repurchase FM. At the same time, I'd like to add remote use so that I can manage things when I'm away (without taking the Mac), but don't want to add in significant annual costs since most use is at home. Seems to me there are three basic options: 1) Put it on a server, and always use the server for everything. No local copy. 2) Keep it on my Mac, and put a copy on a server. 3) Keep it on my Mac, and put a copy on a device using FM Go. Seems the whole hosting solution got complicated, and costs/issues are n…

You might want to review a new Tech Info about a number of significant behavior changes in FileMaker® Pro 16 and FileMaker® Server 16 compared to behaviors of prior versions: http://thefmkb.com/16316 Steven---Steven H. BlackwellPlatinum Member EmeritusFileMaker Business Alliance

I'm old and I fear change... Is there any way to get the bottom toolbar back in FM16? I used it ALL THE TIME to change layout modes, change zoom level, and turn the top ribbon on and off. In fact, I have one solution that I couldn't edit at all in FM16 because there was no way to access the menus. I ended up going back to FM15 and telling it that when my account logged in to turn the menus back on so that I could work with the file. I used to just log in, click the icon to turn the top ribbon on, and then switch to standard menus as needed. Also, my Alt-tab functionality is pretty much ruined now that each window shows up separately. I also don't like that …

Hi, Has anyone else found that you are unable to export .fmp12 records from FM 16? I use this step in many scripts and the first machine I upgraded ( out of 48 ) I get the "unable to save file" error every time. FM 15 works, FM 16 fails on the same DB, same table, same record set. I can't even export manually. I made a screen movie here: https://www.youtube.com/watch?v=iOGcm4bt86o

FM16 is out and it looks like there are some very good improvements for Web Direct, but I'm not finding a lot of info on licensing. Have there been any improvements in the licensing for high user count Web Direct users?

I see that, as a new Filemaker's 16 feature, every fm file opens in a new window instead a unique windows for all files. This is a good advance but, in some situations, we need to maintain the old behavior. Is this still possible by any preference o script step?