FileMaker Pro 19

I am creating my own little application and before I get too deep into creating all the fancy layouts et. al. I would like to know if there is a simple way to port this from my Mac to a Windows machine without having to re-create everything on another Filemaker application running on a Windows platform. Any thoughts? Thank you in advance.

I'm currently using the legacy filemaker 7 and would like to upgrade to filemaker 19. How do i keep all my old data and transfer it with minimal downtime?

I'm using FMP 11 and FMP 12 and am having a terrible time setting up lookup and even set field functions. Can anybody send me some relationship example pics, some field definitions pics and some scripts or anything else that would help. I've looked up umteen tutorials online and I cannot get anything to work. I thought it was a problem with my software (FMP11) so I upgraded to FMP12 and still no luck. I'm sure it has to be something simple that I'm missing. I have done this before but that was years ago. A functional file for FMP 11 or 12 would be great. All help is appreciated.

The title says it all. I created a layout for table view and put the column heads in the header. Nothing I do will get them to line up with the columns. I'm sure I just don't know something I should but... I don't know it. Help. Thanks.

Hello, I'm new to FM and am building a graphics database. I want to import the graphics from various folders and use the file name to identify each graphic. Is it possible to import only the name of the file, without the extension (.png in my case)?

I have a script where I want to export a csv file and I would like it to work on both mac and windows. At the moment it works fine on macs but is not working on Windows. I have a script step to create a variable $path1 Substitute ( Get (DesktopPath) ; "Desktop/" ; "" ) Then in Export Records script step in "Specify Output File" I have: filewin:/$path1/Dropbox (Millmaine)/Finance/FROG_Invoices/CREATIVE/$invoice_name filemac:/$path1/Dropbox (Millmaine)/Finance/FROG_Invoices/CREATIVE/$invoice_name I have checked with our operatives and the directory sequence after $path1/ is consistent (i.e. nobody has any additional folders/directories). …

I get the below error every time I call the send mail call. It locks me and the only way out is to kill Filemaker client. I get this error for years now since FM 16 on all the x64 versions. Switch To..., Retry, and X do not work as it keeps looping. Up to now I was able to get around it because I was using the x32 version where the error does not happen. Now I am moving to FM 19 as the FM 16 version has an EOL Oct-2020. The FM 19 version comes only on x64 and I have no way avoiding it anymore. I thought that this will be fixed by now but apparently is not.

I'm running FMS on the new macmini M1 in Big Sur (which I will point out is simply remarkable compared to my old xeon 12 core. Many high resource functions are 40-80% faster) However the new Base Elements plugin with native support for the M1 has a bug in BE_SMTPsend. You cannot send to more than one email at a time now - and this broke a bunch of important scripts in my system. Adding more than one email to either to: cc: or bcc: yields error 55. I took me a whole day to find that this was the problem. Assigning to a variable ($email = "[email protected], [email protected]) or just hardcoding in the command itself both give error 55 and fail. Just a hea…

Here is a Keyboard Maestro macro I have been fiddling with. It will add a list of expressions to the Data Viewer watch tab. If there is a better method, or you can tighten up the macro, please let me know. DataViewer Defaults.kmmacros

Hello, beginner level here, and I'm hoping this is maybe something easy? I'm grateful for any help. In a basic scheduling database, I have a table of unique Events, that each each record has a unique ID and Date (EventDate), and other fields connecting to another table of possible "Names of Events". I want to create an additional field in this Events table with an auto-entered serial number, starting at 1, that represents each event (record), that occurs on a new (unique) date. I keep thinking, it's a conditional statement that says "If the date in EventDate is Unique, then the auto enter value is 1. If it's the first duplicate found of EventDate, then the value is 2, …

I have a field that I set up as a pull down menu to select a category. I would like to have the field content default to the first entry in the list when ever I complete the data required in the layout it is contained in. For example, my field has the following items in its pull down menu : "Please select a Bill type"::"Bill One"::"Bill Two"::"Bill Three":: etc. I would like to have it default back to the upper most selection ("Please select a Bill type"). Is this possible? And if so, how do I do it? Thank you in advance.

Help - I have tried everything I can think of. I have the fields aligned left and to the top. They won't slide up for blank fields. I would attach a screen shot to this Topic, but can't figure out how to do that!

I have my container field in a portal all displaying the correct images or PDF, as required by the User, but it would make sense if I could save them having to 1. Right Click 2. Export File 3. Save File 4. Open it in another Application They need to do this whenever the stored image is too small to see, so all these clicks just to see an enlarged image seem a waste of their time I want to Capture when the User has double clicked on the container field that has the image they want to see and just open it in WIndows default Picture editor program - they use Paint.net I can use a SEND EVENT to open the default program e.g. but adding it to a button w…

Firstly, sorry if this in the wrong place. Please feel free to move it if necessary. I have a lookup table and associated layout which has largely static data in it. Sometimes I add records to this which I subsequently think that I don't need. However, if a particular field is populated, I absolutely DO NOT want to delete it. Occasionally I don't notice that this field is populated and I go ahead and delete the record anyway. Is there any way that I can prevent myself (I am the only user) deleting these records if this particular field is populated? If it helps, this field will only ever be empty or contain the (calculated) word 'Yes' - if the latter I want to p…

(I apologize if this post is posted in the wrong forum, so please move as necessary.) This is a recent development: I'm unable to select a word (or words) in text fields (and text blocks) using left-mouse-button-double-click. It has worked before just fine, but when I double-click now...nada. I upgraded my MacBook Pro to Monterrey twice; it bricked the first time. (Kernel panic.) After I reinstalled everything, that's when the mouse-click problem arose. I launched MS-Word, Pages, and TextEdit to see if the problem is systemic, but it's not--it's a problem only in FileMaker Pro. I deleted FMP and its ancillary files from the Library and reinstalled it. Same probl…

I'm having the weirdest bug in FileMaker 19.3.2.206 on my Intel Mac running Big Sur. Switching between Browse and Layout modes eventually leads to the right Pane losing its contents. Sometimes it loses a little, sometimes almost all controls are gone. Quitting FIleMaker and relaunching it fixes the issue, until it comes back a few minutes or hours later. Opening a new window, closing the one that has the issue also makes the panel contents come back. I tried to empty the FileMaker cache; it doesn't seem to help. Any help would be much appreciated to fix this! I tried searching for my issue on these forums, without success. F.

We want to be able to import specific emails into user contacts to keep a record of customer contacts. we are looking at Mail8 and 360 works. No need to actually send emails etc just import received and sent emails specifically. I envisage a column of emails and simply select email and click import to contacts.

Hi all, I'm trying to create an appointment in google calendar from a filemaker record. In claris connect the trigger is ok. But I've got an error on the google calendar event creation. Can you help me to find the error ? Thank you Antoine

Howdy FM19 Gurus, I am a simple photographer who has been using Filemaker for my billing and database purposes since FM 7. I have tried a few times to use quickbooks or other apps, but they just don't do it for me. The issue I am having, and maybe it is a simple one, is I am getting a message that says, "Provided name and password cannot be used to access file." I have my username already in the first field, and the password, or what I think was the password is not working. I have tried a number of different passwords too. I have uninstalled and reinstalled FM19. So I don't think it is an issue with the FM program. I did recently update to Big Sur a few wee…

Is there any way to export field content from a container field on the server, running as PSOS? Maybe with a free plugin? I was experimenting with BE_ExportFieldContents, but without success. I need to send emails from the server, as the solution runs as WebDirect, and emails may have multiple attachments. I was thinking, instead of adding content to container fields, would it be a viable alternative to store only the links to the files in the DB? Would the server handle that better? Thank you.

Hi. Further to the post of: I have a similar problem with applying escape quotes into text. Using these script steps: Set Variable $_outputSelector = "\"" & "Name" & "\"" & "," & "\"" & "MobileNumber" & "\"" JSONSetElement ( ""; ["Filter.Active" ; "True" ; JSONString] ; ["Filter.OutputSelector" ; $_outputSelector ; JSONString] ) I get the 'correct' result of: { "Filter" : { "Active" : "True", "OutputSelector" : "\"Name\",\"MobileNumber\"" } } When what I wanted was actually: { "Filter" : { "Active" : "True", "OutputSelector" : "Name" , "MobileNumber" } } The Filemaker variable displays correctly, however …

I am exporting an XLSX file via Export Field Contents to download the file. On the desktop, this works perfectly, but on WebDirect, the file is empty (no content). The same routine works well with PDF and other files, I just get this strange behavior with the XLSX file export. Any ideas? Thank you.

A very strange problem. I added the default Java calendar supplied with FM19 to a solution. While I can assign the fields from the calendar table to the "required options", I cannot assign the fields in "optional fields". When I open the drop-down in the "All day field" and "Editable field", they remain empty. When I open the drop-down in the "Event style field", I only get this selection: Any ideas how to solve this? Thank you.

What is the easiest way to read parameters supplied with the URL for WebDirect? The goal is for members to receive an URL per email that already contains their ID and the event ID, so WebDirect knows the member and the event and can automatically load the relevant data. Thank you.

LS, What is the fastest way to do relationships? In the 6- days we used to create calculated fields where we combined keys from other fields to create a new link field. Later on FM7+ came along and we were able to use multiple field in the relationship definition at one, but that was pretty slow compared to the old FM6 version. Has the speed of the FM7+ version caught up and surpassed the old FM6 version, yet? Especially using large datasets? Or has a new paradigm emerged in the mean time? Kinds regards, Joost

I'm totally new to Filemaker. Starting out with just-purchased 19 on Mac. I know very little nomenclature. Perhaps there's a name for what I'm talking about, so please name it if there is. I've got a couple K of quotes from various sources, which I collected in another DBMS. I have a table of quote data, and a related table of source data with primary/foreign "source#" key fields. For entering new quotes, I want a layout which has a "source#" field which has a button or area to click to open a popup list of sources from the sources table. Selecting the source from the list wil enter the source# in the field when the new record is created. It would also be nice t…

I hope I have posted this in the correct place. I need to count field for matching contents and record the number of hits in another field. I am sure that is very basic but I can not get around this. Thanks in advance for any help..

I have a portal and add a simple single step button to delete the portal row. Not every row let’s me delete. Some do. Some don’t. I’ve never seen this before. What could be the issue?

We have a report that summarizes data by category, then subsummarizes by product sku and shows the total sold for that product. We are trying to limit the report to 10 in each category. If there are less than 10 then show them all of course. The data itself is imported from an api in json form, then converted to a csv and converted to records. There are approx 30000 records currently as the api sends us back line items from a pos system. I thought about using the executesql function, but can't quite get it. Dave

Hello all, I am pretty new here. I used to be on but that was a while ago. I am not sure I am posting in the correct area but here goes. I have 360works on my local machine at work(windows 10). I am running FM server19. I am the only one using the email plugin so I put a single license on my local machine instead of adding it directly to the server. I run a script to import all the emails from a specific email address and it works great. When I trigger the script, I see a Filemaker window showing that the emails are downloading. It takes a while but there are a lot of emails everyday. However, I also have Filemaker on my home laptop and use a VPN to log in…

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 …

I'm interested in the BarCode Add On that is mentioned on the Claris Web Site. I'm confused though, it points out this Add On is free, but I see no information on how to get it. Also, where can I find out about how to use, or maybe I should say, integrate it into one of my FileMaker Apps I create?

I am currently sending messages to slack when an event is triggered in my FileMaker app using Claris Connect. I am trying to figure out how to send a message to slack that will prompt a user to click a button accepting or declining a job and then have their answer sent back to Claris Connect and then back to the FileMaker app. Does anyone know how to go about this?

Hello everybody, I am trying to write a script to retrieve a pdf file from an external drive. I am trying to use this command: "file:/Users/alfredomarques/Desktop/Databases/PDF/" & Document Control::Document & ".pdf" This not working and says that the file cannot be found. Even using filemac it doesn't work. Any help on it, please? Thank you very much in advance

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

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 …

Hi all, As mentioned in the topic, I would like to create more than one chart in the main panel that shows me the monthly chart of the number of visitors. As shown in the screenshot, a graph showing the number of visitors per year.

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

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?

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,…

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)

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

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

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.

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

Greetings; New to FM Forums, so I hope I’m posting correctly. I have two primary tables BONUPROGRAMS (BON__BONUSPROGRAMS_tog) & CLASSES (CLA__CLASSES_tog) I have a table BPViews that is a portal to each of the above tables (bon_BPV__BPVIEWS) & (cla_BPV__BPVIEWS) My objectives; When I populate bon_BPV__BPVIEWS::BPVClass, I want to populate cla_BPV__BPVIEWS::BPVClass When I populate bon_BPV__BPVIEWS::BPVDate, I want to populate cla_BPV_BPVIEWS::BPVDate When I populate cla_BPV__BPVIEWS::BPVName, I want to populate bon_BPVIEWS::BPVName When I populate cla_BPV_BPVIEWS::BPVDate, I want to populate bon_BPV__BPVIEWS::BPVDate My relationships…

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

I am attempting the simple task of omitting those records from a search result when a specific field is empty. The obvious solution, Constrain Found Set > Omit Records > Criteria = "" (equal sign omitted) for some reason doesn't do the trick as I'm still getting records that have empty values in that field. Thanks.

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

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.

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 t…

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.

Hey Guys! I am having an issue with my Script Workspace. I am trying to use common functions like GET(CurrentDate) or GET(QuickViewText), but they are not "found". I can type them out, but when I hit "enter" the line disappears in the workspace. They are also missing from my "Steps" window on the right side of the workspace. I searched for "Get", and all I get is "Get Data File Position", "Get FIle Exists", "Get File Size" and "Get Folder Path". Nothing else. If I go into Manage Custom Functions, I can see them listed in the Edit window. Any thoughts? I'm on FileMaker 19.2.1.14

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

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.

Hello Everyone, I would like to check what are issues when FileMaker Pro and Server 19 are installed in Windows Server 2012 R2? Thanks.

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?

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…

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

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.

Good day. I am in the board of a voluntary red-cross organization and work on the project of creating a database to summarize all relevant information into one platform. In the creation of the database I am struggling on the following issues: For the invoicing of the medical services I would like to handle this with one button. The invoice should be created as PDF - named with the invoice number and the event title (both defined from fields) and the invoice should be attached in an automatized E-Mail with the subject text containing the invoice number as well as the event title. The body text can be a standard text and the E-Mail address should be defined from the…

I suggest you post your date question separately, as it is unlikely that anyone else in the future will be interested in this particular combination of problems. When you do, please clarify if it is possible for a shift to span more than 2 periods - e.g. start at 7:00 PM and end at 9:00 AM the following day. Also, please update your profile to reflect your version and OS so that we know what you can use.

Hi all, I would like to create a page count for a found set of records when I am in preview mode and when I export to PDF ie if a found set of records has 3 pages then the first page would contain a field that reads '1 of 3' Can anyone help with how to achieve this? Any help is much appreciated Thanks Michael

I cannot select inside an input field at a specific character. Clicking on the field works and selects the field, but I then need to use the arrow keys to go to a specific characters. Mouse clicking at a specific characters does nothing. Anyone has experienced this? screen.mov

Hello, I moved fields (and scripts) from one FM file to another one. Now, I have a table to 2 fields that has same function but different names, example: Container1 and Container2 Both have their own attached scripts and calculations. I would like to merge "container2" into "Container1" field so the attached scripts and calculations will also change, but I can't rename it simply to "container1" is there a way to without going through all the scripts and calculations? Thanks

Hi all, I have created a portal in a related table and I want to apply a filter to it so that it only shows the latest versions from a found set of records and to hide the others. There is a related field within the portal called 'scan version' which displays the version number as eg 'v001' 'v002' 'v003' etc I've been hunting around online to find a calculation that fits my needs and have played around with the 'Max' function but to no avail If anyone can give me some pointers that would be awesome, I'm still very new to this and learning so any help is always appreciated! If you need any more info please let me know Thanks I have just …

Hi everyone, I am trying to make a database for my analogue/film photography with FMP19. In my ERD I have a “MediumBatch” (parent) and a related “Exposures” (child) table. A MediumBatch record can be a single 4x5 or 8x10 film sheet (hence 1 single exposure) but also a 6x6 film roll (roughly 10 exposures) or a 35mm film roll (24 or 36 exposures). I have a Get( UUID ) primary key in both the parent and the child table. I also have an auto-enter serial number for the MediumBatch table (I need it in order to match it to my paper database). I also need a serial number for the Exposures table. When I create…

Hi, I have tried to pass the below JSON data to the API. But it doesn't accept the JSON data due to Square brackets[] in the JSON Key. Is there any solution available to pass the below value? JSONSetElement ( "{}" ; "[Name | Last]" ; "Test" ; JSONString ) We need the output like below. { "[Name | Last]": "Test" } Thanks in advance.

Hi all, I'm a film editor and have started building a FM database to be able to track visual effects shots that go in and out of an editing timeline. I am trying to create a calculation that will enable me to add frames to timecode and get the result back in timecode. At the moment I have a text field called 'Scan TC In' which has the following TC entry 18:59:48:23 (HH:MM:SS:FF) and I need to add 8 frames to it, the timeline runs at 24 frames a second. Does anyone know how I can achieve this? I'm a newbie to FM so any help is greatly appreciated! Thanks Michael

Hi all, I'm new to this forum and to filemaker and looking for some help. I have the following number in a field 101_010_0010 and I want to extract 010 from the middle of the number and paste it to another field. I have been trying to do it with replace field contents but with no luck... does anyone have any advice on how I can achieve this? Many thanks, Michael

I have a database of around 35K music tracks, each of which has a file ID and any number of keywords up to around 200. There is a fileID-keywordID table, and a main table with a global keyword field. Using a relationship between keyword ID's in the two tables, the user selects keywords from some pop-down menus for different categories, and I create a list of keywords in the global field - this is the "Magic Key", which automatically shows any tracks that contain those keywords in a related portal. However, this shows *any* tracks containing each keyword (ie this is an "or" relationship). I then wanted the option to show "all" (an "and" relationship) which would only displ…

I have an older "contacts" database that I want to update using the template from Filemaker Pro 19. Unfortunately, importing the data from the old DB to the new DB is impossible due to how they structured the database. The "new" way is better, using related fields, so that one could have, say unlimited phone number fields, as opposed to a pre-determined amount. The problem is the import window only shows fields for the current layout to import into, and not any related fields connected to that layout. So, phone numbers, addresses, etc. all wont import. My idea was to just copy said layout to the old DB, so the data would still be there. Then map the fields to their c…

Forgive me if this is a dumb question, but I am new to FileMaker. I want to automate the process of users importing an "update" fmp12 file into an existing database. Sometimes this update file will include a container field of images, other times (to keep the file size down) this field is omitted from the update file, so I don't think I can use Custom Order or Last Order because of this variation in table structure (and the user will not necessarily know which structure it is). I had expected "Matching Name" would cope with this, but when I am creating the script, when I select the blue Match Field option (which I have to do because I want to Update, not Add) the "Ma…

I made an awesome capture utility to capture pics from a webcam for ID card purposes. Works perfect online, but in the fm web viewer is does not (it loads the basic html, but nothing more). It uses javascript and css, nothing fancy or out of this world. Tried it as a link to my server, and as complete html code. Anyone got an idea on why this is not working? https://fieldsmedia.com/cameracapture/

I have a regular text field with a height of 20 px in Layout mode. In Browse mode that height is respected. But when I select the field, the height seems to triple and a blue border is added. How do I get rid of this behavior? No doubt it has to do with the stupid Themes thing, but how do I edit that? And is there a way to completely remove the Themes/Styles from a database? This feature has zero usable themes as they are ALL UGLY. I create a nice pro look and copy paste fields, Filemaker Themes/Styles s*ck.

I know the solution is probably very easy but it escapes me. I got this database, which I use to create invoices, year after year, I created a report page where with a neat summary field I get the "lifetime revenues", "lifetime general expenses", "lifetime total taxes" and "lifetime total invoices number", which is handy, but I need to have the same data broken down by year, and I can't figure out how to achieve that. In another post I have been suggested to consolidate the three tables I had (Invoices 2018, Invoices 2019 and Invoices 2020) into a single table (Invoices) and then use a "subsummary" which would give me the data I want based on how I sort the records b…

I have a calculation that goes like that, I input a number on "Base Imponibile" (say 100), it adds 15% (it gets me 115), it then calculates 4% to the previous result (115) and it gets me 4,60, I then add 2 and the total is 121,60 which is perfect. And that's the part that works just fine. But I then want to make a reverse calculation, where I input the expected result of Total Calculation and tells me all the other values and here it's where things go awry. I'm attaching the initial calculation that works as a reference and the reverse calculation which doesn't work as an example. The "2" that gets subtracted in the reverse calculation is a fixed value of…

I have a nonprofit in my town. They rescue horses. I reached-out to see if they need any I.T. support. They responded and do. I went onsite to find-out whats going on. It's a complete mess. running wifi EVERYWHERE and wondering why everything is slow. They are a mac outfit and just recently went to the web(Claris). They have 6 Macs and only two can use the client, because the others are so old(only web based and looks completely different then mac client). Now, I'm a windows\Linux guy. 28+ year I.T. consultant that has pretty much worked on everything, but apple..... I even have worked on Fielmaker pro(server v7, lol) How involved would it be, to switch them to wind…

Hi everyone, This may seem pretty basic to most but I am a very new user. I have managed to create my asset database with the following fields: MAKE - TYPE - SERIAL NUMBER - SERVICE DATE I have scripted a button to enable me to click on a record in portal and update the service date to current date (pretty easy). What I would like is to be able to store each date the item was serviced and have a list of those dates appear inside a pop up when a SERVICE HISTORY button is pressed. I have been trying to script it so each time the SERVICE button is pressed it updates the SERVICE DATE field with current date and also stores that date is a c…

Good evening, I would need to create a script that exports the data of a format to an email. My difficulty is to insert the data in the mail in table format, instead of as simple text. Thanks.

I'm not even sure to describe under which category my specific problems fall into, I can only advance some hypothesys, so I'll just describe it and let the wisdom of others guide me. I have a DB with several tables, I use them to make invoices. With every invoice I input the desired price and it adds automatically 19% taxes and produces a neat invoice which I can print, these three tables are called: Invoices 2018 Invoices 2019 Invoices 2020 Now on to my problem. I wanted to create a forth table where from every previously listed table it would calculate the total revenue of the year in question, broke down like this: - Total Net price paid for 201…

Hi Group how can i copy a parent record and all the child portal records in it into a new parent record with a new parent id number with all the copied portal records updated with the new parent id number? Fluffy

I just moved form 18 to 19. In FMP 18 I had a folder in my applications folder that was called “FileMaker Pro 18 Advanced”. It contained: FMPA Read Me (English).pdf FMPA Acknowledgements.pdf FMI Runtime Resources FileMaker Pro 18 Advanced Extensions English Extras After upgrading to 19 IO do not see that 19 has the same folder. Is this a problem? What to do? Any tips or ideas?

I recently upgraded to Big Sur and I use the lasted Claris/FileMaker 19. Since upgrading to Big Sur one of my scripts no longer works in iMessage. The script involved pasting several mobile numbers into iMessages via the URL Script ("iMessage://" & Filter ( Contacts::MobileGroup; "+610123456789," ). Instead of phone numbers I now only get the first record/number. Or if I do a manual copy and paste (from FileMaker to Messages I get "⬀㘀㄀㐀㈀㜀　㜀㤀㄀㌀㠀Ⰰ⬀㘀㄀㐀㐀㜀㜀㤀". My script worked perfectly before Big Sur and was able to send texts to over fifty people at once. Is this a bug, a redacted feature in iMessages or a change that I need to make in FileMaker to…

Guys, there is a task, to establish work between FileMaker Server v19 and clients FMS Pro & Go. What is the challenge? 1. On a new computer, Windows 10 is installed, then a virtual machine, and on a virtual machine Microsoft Windows Server 19, and on this server has installed FileMaker Server v19. To my mind - Frankenstein)))) The installation was completely done by me. We set a task, completed it ... but ... 2. To the admin panel - I have access through local host. In the admin panel on the main page I see all the data as well as the IP that the server has. The installation was carried out according to the official instructions. 3. It's time for t…

I have 1100 records in a found set. 12 records are for 1 customer 2 records are for another customer etc. My question how can I get an individual count of each customer in the found set.

Hello! I am a beginner and I need help of advanced users in the matter of converting characters, namely from period to comma. What's the point? There is a CSV file, it contains data. Example - 5.00%, 20.00%, 2.456, 22.564 and so on. Below is a screenshot of the file so that you understand the content. When importing data from a file into an existing table, the data is displayed as follows - 500 2000 2456 22564 As you noticed, data has no structure and is just a set of numbers. The screenshot will show how it looks after import, and it will also show how the data after import should be displayed. In short - In the imported file, there is a dot between the numbers, and…

I have a script that distributes a quantity across various number fields using a "set field" script step. It is possible for the number being distributed to be zero. When I run the script with debugger, it puts zeroes in the number fields as expected. But if I run the script without debugger, it enters zeroes as null (blank). I have absolutely no idea why! I've tried modifying the script to specify the value with GetAsNumber and I've even tried adding to the Case statement (which determines the portion of the value to be distributed) that if the value to enter is not greater than zero to just enter a zero. Still makes the field blank. 99% of the time but n…

Under Mojave, my version of Filemaker was funky but more or less functional. My recent upgrade to Catalina put a stake thru its heart. I came here after and hour of reading endless sales pitches on the website, 20 minutes waiting on the phone for sales and another 20 in the chat jail with CalrisBot, also awaiting someone with a heartbeat. I'm sold, I want the product but I'm getting a bad feeling. I was an advanced user in the past with Filemaker Pro 11 but my work took me away from database paying work and although my work is now more involved with research and activisim, I'd like to bring Filemaker back into my toolbox. Can you purchase FileMaker or …

Total newbie question: I am a registered user of Filemaker Pro 15 (from back in the day). I am about to write an application for a small organisation to maintain contacts and workshop bookings. This needs to available remotely by one, maybe two users (and me). There is a company that offers Filemaker Server 14 shared hosting at a reasonable cost (filemaker-hosting.co.uk). So, they licence FM Server 14, I have FM Pro 15, my client needs one or two copies of FileMaker Pro 19, yes? and will that interact successfully with an application on Filemaker Server 14. Does my plan seem feasible? Any issues here? or any other way of approaching this situation. Ma…

Is there a way to change my coding of scripts so that so-called scripting errors don't show up in server logs when a scheduled script is executed on FM Server? I get dozens of such errors for each daily execution, and Using a Set Error Capture [On] script step doesn't seem to make a difference as to whether the "errors" show up in the server log. The kinds of error codes that do show up (101, 401) don't seem to me to be be the result of scripting errors at all. Rather, they are part of ordinary operations (e.g., testing to see whether to stop looping by checking whether a record exists in a found set). I raised this question a couple of weeks ago in a much longer ema…

I have seen various articles and videos that explain how to upload a file from a Filemaker Container to Dropbox using the Dropbox API. However I would like to create a script so that a user can save a pdf directly from Filemaker to a shared Dropbox Folder. Any tips?

My script in a hosted file needs to export records as pdf into the user Downloads folder, needs to run under Mac and Windows, so I set the variable $path_filename to: Case ( Get ( SystemPlatform ) = 1; "filemac:"; Get ( SystemPlatform ) = -2; "filewin:"; "file:" ) & Substitute (Get (DocumentsPath); "Documents"; "Downloads" ) & "file.pdf" And then: Save Records as PDF [With dialog: Off; $path_filename ; Records being browsed ; Create folders: Off] The script it works in Mac but not in Windows: I get an 800 Error and a message warning that it can't create the file. I don't get what's wrong with the windows version, any idea?

As there isn't a thread about this I thought I'd post about this annoying bug as it affected me and I thought I had a corrupt db. The issue seems to be that when editing layouts with certain summary parts in FileMaker 19.1.2 it changes the way that the layout is configured, so that a DDR created in FileMaker 18+ (at least) crashes FileMaker Pro and fails to create the DDR. Some points from my testing: Creating a DDR without selecting 'Layouts' works fine. 'Save a Copy as XML' works fine. It seems that running Recovery or compact/repair in 19.1.2 also introduces the issue. I don't know if running this in 19.0.1 fixes the issue but worth trying…

I have a small Filemaker Member's database (less than 1,200) with some 650 existing members but I am not the Membership Secretary. The Membership Secretary uses Excel to record who joins and resigns, and each time there is a change in membership (joining or leaving) the Excel file on Dropbox is updated and I am notified. I therefore have to import that data into my Filemaker Members database each time there is a change to the members (new member, change in personal detail or resigned member). However I am in control over the data of the existing members who also join our web membership (at present less than 100). The web members have to be manually activated when…

Hello hope all is keeping well? Please I need help with this script what I have been trying to do for the last week is to put a saved PDF into a container field after its been created? I have tried to insert into a container field with the field be interactive and not Interactive but with no joy. The script attached is where I have been trying to place the script where the red line are? So after its saved to the desktop import into a container field so we have a copy of the PDF I hope someone would be so kind to help me Thank You

I need to import a large amount of data from excel spread sheets into FM19. Is there a way to create a custom import order of field so it will be easy to match the source fields with the target fields. ( I know there is an "arrange by" -custom order) option but that is not a fast enough way The excel spread sheet (source fields) will not be in the same order as the Filemaker File (Target Fields) I often spend a lot of time matching up the source field and the target field and I am looking for a more time efficient way

Hi all, Novice here. I have a simple two table database for inventory tracking. Parent table "Cases" and child table "Items". The cases can be filtered by finding all cases with the field "Status" set to 'Yes' or 'No' I am able to create a report Layout with the found set with the field 'Case Name' in a Leading Sub Summary part and the content field of each case (Items) listed in the body part. What I am struggling with is a way of having a field in the Leading Sub Summary part along with the 'Case Name' that sequentially numbers the Cases in the found set from 1 to xxx Can anyone help me please?

I know that peer to peer sharing has been deprecated. I also know that it still works on my network between two computers. My client has a two-person shop and has been doing peer to peer for years. He wants to upgrade from an old version of FileMaker to 19 because he is getting new computers. He has been hit hard by events this year so he wants to spend the minimum amount. My versions of 19 are part of a volume license, so I don't know if p2p sharing is only working because of that. Would it work with two or three individual licenses of 19?

Hi, My issue is that my customer layout has a script trigger on LayOutEnter that sorts my customers portal list by "Active" customers, but when I do a go to related record from another table say from quotes or any other the customer layout does not load that customer or show my related customer because the OnLayoutEnter script trigger changes it, I would like it to go to the related customer and also sort it by "Active" on the list. Hope someone can help me with this. Thanks, Pio