FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Hello all, I am hoping that the fact I don't feel well is why I can't figure this out as I think it should be simple. I have a script trigger attached to a field OnObjectEnter, however the field is part of a portal row and navigated by the tab order, so when the user tabs out of the previous field, it goes to the field with the trigger, but the script is not triggered. Is this a normal behavior? Must the user "click" into the field for the script to trigger? If so, what other options do I have?
-
- 1 reply
- 791 views
- 1 follower
-
-
What is the point of get(CacheFilePath) and get(CacheFileName) functions? Is there utility in reading these files? Are we going to have to monitor their size and manually flush cache files in a future version? TIA Jerry
-
- 2 replies
- 1k views
- 3 followers
-
-
Hello everyone, First off please bear with me as it's been a while since I was tasked to do anything with FMP, so I'm a bit rusty... not that I have any formal training, but I used to be much better at it and I am trying get my mind back in shape! I am working on a solution that invoices customers for booth rentals at yearly trade shows. Many customers attend the same shows year after year. It consists of these linked files: Customers are in a table named "The New World!" (note the exclamation point) in a file named "The New World" Shows are in a table named "Show Names" in the file named "The New World" Invoices are in a table named "WWE Inv…
-
- 3 replies
- 2.3k views
- 2 followers
-
-
I created a file called "Open Notes File" I want that file to execute a script that opens a Notes file and hides the window. But when I try the following, it hides "Open Notes File" instead of the Notes file. Open File [Open hidden:On ; "Notes" ] How do I make this work so it hides the window for Notes instead of the Open Notes File?
-
- 3 replies
- 1.3k views
- 2 followers
-
-
I'm trying to end a loop script with a timer. I've developed a little game for the children and their friends, something and nothing but they love it. However I'm struggling to end a loop script step to make the game work properly. Upon Clicking the 'Go' button, the below script runs. First it generates a random number that will be used as the seconds for the timer. The timer begins, then the script keeps looping through the records, pausing for 2 seconds (the records just being a name and a funny picture of each child). Once the seconds have ran out, this could be 8 seconds, 5 seconds, 10 seconds etc depending upon what random number is generated, whic…
-
- 4 replies
- 1k views
- 1 follower
-
-
I want to create buttons that will go inside a chart and change the x-values and the sorting option. Is this possible? For example I created a Chart called Post, it works fine. Now I want the same Chart to change to Sections if I click a button, and then Change again to Genders with another button. The first current Chart is working now with Post, how can I create a script to change the Chart to other x-values and sorting?
-
-
- 5 replies
- 1.2k views
- 2 followers
-
-
Hello, I have searched high and low and can't come up with an answer to this. Hopefully I will explain it correctly. I am trying to create a universal navigation bar. I have a separate navigation table to do this so any changes I make in that table will carry across the entire database and I don't have to paste the bar on every layout. On my layouts I have 2 navigation bars. Both have a graphic and label to show where they are. One is used to navigate between modules (Jobs, Accounting, Warehouse etc.). This one works well as it is the same on every layout. Each "button" on the bar has 2 repeating fields, a container field and a text field and each is it's…
-
- 3 replies
- 947 views
- 1 follower
-
-
I'm trying to create a simple Cashbook Database which goes like this: In_Table: (Form View Layout showing records from In_Table) Fields: Date - records the date of Incoming Transaction Details - records the details of a Transaction Amount - records the Amount in $$ of a Transaction SumIn - sums up all current foundset of In_Table records Out_Table: (Form View Layout showing records from Out_Table) Fields: Date - records the date of Outgoing Transaction Details - records the details of a Transaction Amount - records the Amount in $$ of a Transaction SumOut - sums up all current foundset of Out_Table records Cashbook_Table: Now …
-
-
- 3 replies
- 1k views
- 1 follower
-
-
I have a table Doc with Documents stored with their titles. I link Docs to other Docs showing their relationship, e.g. Doc 2 is supplemental to Doc 1. I do this with a Join table DocLinks with 4 fields: fkDoc1, Relation 1, fkDoc2, Relation 2. The latter 2 fields are linked to the table Doc 2. I want to be able to see that relationship in the portal when I view Doc 2 in the main Doc Layout without having a separate portal. How do I achieve in Filemaker the equivalent of this SQL Statement? SELECT fkDoc1, Relation 1, fkDoc2 AS fkDoc1, Relation2 AS Relation1 Thanks for anyone's help 🙂
-
- 3 replies
- 629 views
- 1 follower
-
-
I have a simple database with Field Staff Name, Gender and Office Division. Then I wanted to create a Chart that will show how many staff are on each Division. I am thinking of a Bar Chart or a Pie Chart. I have no experience working with Charts so if you could please help me with this simple one and I will try my best to build maybe a complex chart later. Thank you.
-
-
- 8 replies
- 1.6k views
- 1 follower
-
-
So I have a database for Audit Reports with a dashboard that displays the current status of those Audit Reports if the Audit Reports were Fully Implemented, Partially Implemented, Ongoing or Not Implemented. These status are shown on a Pie Chart with percentages on their status. I Also have a public website built with Joomla CMS with these same reports manually uploaded for the public view. I'm looking to build the same Chart on the website but I figured it would be easier if I could just link the Chart from the Filemaker Database straight to the Website. If any thought on how to accomplish this please give a hint.
-
-
- 5 replies
- 1.5k views
- 1 follower
-
-
Is there a way to "find" across all tables in FM? I have an art database which has a welcome page, leading to 3 tables- painting, sculpture and furniture. But some items in these three areas are made by one artist- eg. Frank K may be the artist for a sculpture and a painting. So on the welcome page, I'd like to have a universal find box and you could click in and type, to search for "Frank K" and find his material in the sculpture table and in the painting table. Is this possible? Thanks.
-
- 3 replies
- 1k views
- 2 followers
-
-
I bought Filemaker 4.0 Developer for my business over 23 years ago and spent many hours, weeks, months making multiple (18) databases and probably 3000+ scripts for order entry, invoicing, customer info, vendor info, inventory price/history/location/cost, purchase order, checking, profit/lost & sales tax reports, etc., because I hated quickbooks. I still alter/make scripts on a regular basis. I have records back to 2000 and can access anything with ease. We're now running one network host computer on XP with 5 clients running Win 7 pro 32bit, it works great. We only have 2 people, myself and my wife, accessing it but all client computers are logged into FM 4.0 host at…
-
- 5 replies
- 2.2k views
- 2 followers
-
-
Hello All, I am running Filemaker 2023 on a windows 10 machine. I need to import from an excel file (xlsx) but the sheet has multiple worksheets within it. I need to be able to import from a specific sheet through scripting. It will be a weekly report and the worksheet name will change. Is this possible using a path variable? Thanks in Advance Mike
-
- 2 replies
- 1.1k views
- 1 follower
-
-
FM stop working. I started FM and it now asked me for a License Key. I have my key but it was me to go to my certificate. I purchased this FM 18 Adv on line from Amazon. It worked fine for over a year and now it wants my certificate. I have the License Key, but it doesn't give me a space to manually enter the key. Any Help?
-
- 1 reply
- 1.3k views
- 2 followers
-
-
I have just experienced the Gray Menus of Death. All of my keyboard shortcuts are grayed out ... I can't even use the standard cut, copy, paste keyboard shortcuts. I was using Big Sur, so I upgraded to Monterey ... This upgrade did not solve the issue. It was on FM 18 Advanced, so I upgraded to FM 19 ... I still have the Gray Menus of Death. I deleted the com.filemaker.client.pro12.plist (User > Library (Hidden Folder) > Preferences) thinking that would help ... That didn't help either. I deleted my only plugin ... Still no keyboard shortcuts. Others online are complaining about this issue. However, I not finding a solution that works. Any ideas?
-
- 0 replies
- 1.2k views
- 1 follower
-
-
I have a document management layout that manages several different versions of a document in the record. I don't want the field with the doc name to be a button as i need to access the field for other purposes. So I want to use a single script for multiple buttons opening the file in one particular field using a Script Parameter for the field name. So I set a variable $Field as Get (Script Parameter). Now i want the script to tell it to get the content of the relevant field. (Ignoring the full path on my computer) I tried Set variable [$File;Doc::$Field] but Filemaker says it can't find that field and rejects the setting. How do i achi…
-
- 8 replies
- 1.5k views
- 1 follower
-
-
Previously, my Filemaker allowed me to click "Learn" for a word that is highlighted as spelt wrong. Now "Learn" is greyed out. How would that happen and how can I get it back? Thanks
-
- 2 replies
- 615 views
- 1 follower
-
-
I have a database of 185 records. The record numbers are currently in a text field 'record no', Indexed, Auto-enter Serial, Required Value and Unique. When I sort on record no, the order result is not serial but reads the first digit, so record no 3 is followed by record no 30, then 31, etc, 39 is followed by 4, etc, as it should in a text field. However, I want to sort 1 - 180, so presumably need to change the field from text to numbers. How can I do this without losing the data?
-
- 2 replies
- 1.6k views
- 1 follower
-
-
Script below produces attached rubbish output. Have tried creating new file from Excel data, but same result. Mac Mini Apple M1 running Ventura 13.4 How do I correct this please? 1. Show all records 2. Go to Record/Request/Page [First] 3. Save a Copy as [file:Reg14 File IN USE BACKUP; copy of current file; Create folders:Off] 4. Close File [Current File] Produces file output attached, not a copy of FMPro file: Reg14 File IN USE BACKUP
-
- 2 replies
- 946 views
- 1 follower
-
-
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?
-
- 1 reply
- 3.4k views
- 1 follower
-
-
I have a list layout that previews correctly but doesn't print and a saved pdf is also blank (except for the footer). How could this be? The issue seems to have been triggered by upgrading the OS to Ventura or an M1 Mac. All List layouts in multiple database only display the first record (or none) when printed as a pdf - without any scripts involved. New databases created just using a FM template don't display this behaviour. So it seems to be connected to opening database created in either earlier versions of FM or opened on M1 Macs. Not an issue with v16 on Catalina
-
- 1 reply
- 1.1k views
- 1 follower
-
-
Hi everyone: given that a runtime app is a stripped-down fileMaker with just enough FileMaker to make the thing go; I would assume that just the runtime environment and the data file’s minimum system requirements would be very similar to if not slightly less than the System Requirements For The Full FileMaker Pro 12 or 12 Advanced applications as stated by Claris/FileMaker does anyone have an idea as to if the requirements are less than, greater than, or equal to those linked above? If the minimum requirements for runtime apps differ in any significant way; please specify how they differ. thanks for the help
-
-
- 4 replies
- 4.4k views
- 2 followers
-
-
Hello: I want to ensure that my stand-alone runtime solutions are protected from software piracy, rather than trying to make a serial checking algorithm myself, I have a software protection system that wraps my runtime EXE in a shell that then keeps track of the trial limits and handles entering of registration keys. My questions are as follows: 1) my software protection system can protect a handful (literally 5) of “Additional files” (namely *.dll, *.ocx, *.exe); which files that get created with my runtime app should I add to the additional files area if any at all, should just protecting the runtime EXE be ok? 2) to allow mac users to try my solu…
-
- 2 replies
- 1.3k views
- 2 followers
-
-
Hi: I understand that Runtime Solutions are designed to be single-user, but could a runtime solution be deployed on a Windows Terminal Server and there be no ill effects, or would the thing just refuse to run under such conditions? I know that when I installed my copy of FileMaker Advanced 12 on a terminal server; it didn’t like that too much as apparently my key isn’t enabled for that. So would a runtime app also complain?
-
- 0 replies
- 697 views
- 1 follower
-
-
Trying to POST via HTTP to send an XML file to a recipient. Basically, this is the cURL data that I am trying to use: --location --request POST "https://medidatabox:8100/md/ela/uploads" --header "X-CLIENT-ID: 1000004142" --header "Content-Type: multipart/form-data" --header "Authorization: Basic SHBERGdnaHFOMm9ScmJtQjpmeFERM5mYTczNERyMW9p" -F "[email protected];type=application/octet-stream" I have been trying to use "Insert from URL" and BaseElements "BE_HTTP_SetCustomHeader" and "BE_HTTP_POST", but without success. I am somehow failing to provide the correct info at the correct location (I must assume). "invoice.xml" is an XML file…
-
- 6 replies
- 2.9k views
-
-
Hi, I’m curious how record locking is handled in FileMaker 12 (optimistic concurrency or pessimistic concurrency) thus i can put it in my help documentation thanks again for the help
-
-
- 2 replies
- 1k views
- 2 followers
-
-
Hi Again Everyone: I've got a custom help file (*.chm) for windows that I would like to appear when the user clicks on a custom emu item. Is that at all possible? Also along the same line of questioning I've got a custom "About" layout that I'd like to have launch in the runtime app when the user clicks on Help > About. Any ideas on how to do these things?
-
-
- 3 replies
- 1k views
- 1 follower
-
-
So here's the situation I'm in: 1) got several custom menus 2) while in a report, I click on Action > Print, Preview, or Send to External Application, the script runs but the tool buttons for "Excel", "PDF", "Print" and "Print Setup" are all grayed out even with equivalent options in the Action menu. Note that this only happens with the default user (Hologram), and not the Admin user. Screen 01: Gray Toolbars For end-user Screen 02: No Gray Bars For Admin The script that calls the Print, Preview, or Export menu item looks like this: Screen 03: Script to Go Preview Mode, then wait for user action The de…
-
-
- 7 replies
- 1.4k views
- 1 follower
-
-
When I try to insert a PDF I get a "Missing plug-in" error. See attached. Where do i find the plug -in? I can't find any guidance on this. Thanks
-
- 5 replies
- 2.1k views
- 1 follower
-
-
Hello: I've created custom menus one of which either About my App or Quit. I inserted my custom Quit Option and the default Exit shows up. How do I fix this? Screen 01: Menu W/ 2 options to quit. I'd much prefer to have the First option (Quit Hologram 360) as the one and only way to quit the application Screen 02: Menu as it is defined under File > Manage > Custom Menus. Any Idea why on Earth I'm getting a double Quit menu item and how to get rid of the one I don't want?
-
- 0 replies
- 723 views
- 1 follower
-
-
As of this morning the following stopped working. I updated chrome (as the error message said) but it didn't make a difference. I'm using FM18. "http://local.google.com/maps?" & "q=" & /*Address=*/ Parents::Address & "," & /*City=*/ Parents::City & "," & /*State=*/ Parents::State & "," & /*Zip Code=*/ Parents::Zip & "," & /*Country=*/ "" The above brought up a google map google_directions ( street1 ; suburb1 ; state1 ; zip1 ; country1 ; Address ; City ; State ; Zip ; country2 ) The above gave directions and distance from school to home Now they both don't work and tell me to update browser which I did. …
-
- 3 replies
- 1.3k views
- 1 follower
-
-
In my music database I have a Date Created text field. I have, for example, many records from the year 2013, in the format of 2-1-2013. However, when I do a search for 2013 I get the "No records match this criteria" error. Any ideas? Thank you.
-
- 2 replies
- 827 views
- 1 follower
-
-
If I post the line below with the insert URL script step. The date is ignored, and all customers are returned. -X GET "https://www.scaleif.com/api/v2/grain/scale/customers?createdChangedSince=2023-03-01" -H "accept: text/plain" -H "Authorization: Bearer 1234" Any ideas as to why it's not working properly? TIA John
-
- 2 replies
- 983 views
- 1 follower
-
-
I am trying to help a friend, and don't have exact details at hand, but I'm hoping a description of the situation is enough to get clues which way to go. As far as I know he purchased FM Pro preinstalled on his Mac Mini. Recently there was an upgrade available. Apparently he renamed the old version app filename in order to keep in separate in case something went wrong. He now has both versions on the computer and can start them both. The old one shows it is licensed. The new version is a trial version. I am guessing if he had not renamed the app file, the upgrade would have found the license on the old version and automatically used it, ... but what do…
-
- 0 replies
- 1.1k views
- 1 follower
-
-
Hello Mavens, I have a complex database and I have to export some of it into a spreadsheet. After some experimenting I created the right export order. Now I can reuse it and export from each record individually but now I'd like to automate it in the form of a script. Is there a way to sort of "import" the current export order into a new script? If there is, I have not been able to find it. Thanks, Asu
-
- 2 replies
- 1.2k views
- 1 follower
-
-
Hello, I wonder if, beyond the wonderful shiny new bells and whistles, have any of these long standing issues "under the hood" been addressed in FMP2023? -Insert newly defined fields at the insertion point instead at the bottom of the list (database manager)? -Define the name of a button by calculations? -Create something like an index of defined variables so calculations show error if variables are mistyped? -Possible to make the “hand over button” option the default? -Make the Button Setup window resizable, like other setup windows so long script names are fully visible? Thanks, Asu (FMP18)
-
- 0 replies
- 794 views
- 1 follower
-
-
I just updated to FMP 19 from 17 and switched from Mac to Windows. I'm using a laptop, and when I try to scroll using two fingers on the trackpad, FMP doesn't seem to like that. It will scroll, but very slowly, and sometimes it just won't But no issues scrolling on anything else on the computer.
-
- 5 replies
- 1.6k views
- 3 followers
-
-
Hi, I'm new in FileMaker, so forgive me if that is something simple to solve. My servers: FileMaker Server Ubuntu Ubuntu 22.04.2 LTS FileMaker Server 20.1.1.38 Acme.sh Wildcard SSL IP: 10.10.10.10 (as an example) NGINX Reverse Proxy Ubuntu Ubuntu 22.04.2 LTS nginx/1.18.0 Acme.sh Wildcard SSL IP: 10.10.10.20 (as an example) Windows Pro 22H2 FileMaker Pro 20.1.1.35 Everything works perfectly when connected either by: https://filemaker.domain/fmi/webd/ or https://reverseproxy.domain/fmi/webd/ FileMaker Pro connects ok when using https://filemak…
-
- 0 replies
- 1.1k views
- 1 follower
-
-
This must be an easy answer but could someone please save me a few hours and provide me the steps to setup Oauth 2.0 in office365 to be able to send mail via FMP 2023 new Oauth function? Thanks
-
- 0 replies
- 801 views
- 1 follower
-
-
So I have a bunch of staff records. I want a staff to be able to login and the database will show only his/her record and not other staff records. So I disabled the Status bar upon login and apply the script below to show only his/her record when staff access the records: Set Error Capture [On] Go to Layout [Staff Records] Show All Records Go to Record/Request/Page [First] Loop If [Staff Records::Account Name] Go to Record/Request/Page [Next; Exit after last:On] Else Omit Record End If End Loop This works well the staff is now landed on his/her own staff record and not other staff records, but then if I press t…
-
-
- 8 replies
- 1.6k views
- 2 followers
-
-
I duplicated a d/b and changed the Style from Sophisticated to Apex Blue. Then I adjusted the font settings from Arial 16 back to Verdana 11 as in Sophisticated. That worked perfectly except that the tab sizes on tab control remain big enough to accommodate Arial 16 which messes up my whole layout design. When I double click on the tab control, it shows the padding settings but won't let me change the top or bottom numbers. Why not?
-
- 6 replies
- 1.3k views
- 2 followers
-
-
So I play around with Custom Menu and I created a test custom menu with just the "Edit" menu in it. Then I saved it and set it as a Default menu for my database. Also my Database has an open script that hides the Menus. And now I cannot revert back what I did. I usually press keyboard shortcut "CNTR+SHIFT+S" to open my script window and run the script to show the Menus but the keyboard shortcut is not working after I applied the new custom menu. Can anyone please help me how to revert back? or access the script window?
-
-
- 4 replies
- 827 views
- 1 follower
-
-
Hi brains trust, I want to be able to create an Edit Box field where the field will "pop open" when selected, to show all it's contents (to a certain line limit), similarly to the Pop-up Menu but without a pre-entered value list. Is this possible? Thanks!
-
- 2 replies
- 1.1k views
- 1 follower
-
-
I have a database containing lot of names and titles, and sometimes the users type in names but leave spaces at the end of sentences. Is there a way to show invisible characters? Or a way to find spaces at the end of a text field? Thanks.
-
-
- 7 replies
- 1.6k views
- 2 followers
-
-
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…
-
- 7 replies
- 2k views
- 2 followers
-
-
Hi, I have been working with FM for a long time but never was a power user. I use filemaker to build databases used in our small company. I never used a relational database. I have been creating a new database for each new product arrival. Always the same model, just changing the product names and prices...And every time, I have to re-write the client names, their ordering so on. Now I want to create a relational database that will help us do a better follow-up on customers, to be able to see at the end of the year, what each customer bought, if there are unpaid invoices.... So I am looking to join a group or maybe hire an expert to coach me. Anyone in Montreal?…
-
- 1 reply
- 802 views
- 1 follower
-
-
Hi brains trust Hopefully someone can help me. I am running FMS 19 on a Windows 2019 OS. I have a serve script that creates a PDF in a mapped drive. When I run this directly on the PC with the FMP client the file creates with no issues however when I run it as a server script I get an Error 800 (can't create file). If I run the same script but use path get(documentspath) it works fine. So this is definitely a permission issue but for the life of me I can't seem to resolve. Thanks Spiro
-
- 1 reply
- 1.1k views
- 2 followers
-
-
Greetings, I am attempting to post data to an API. This is the sample from the company: curl -X POST "https://123456" -H "accept: text/plain" -H "Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjEwMjQiLCJ1bmlxdWVfbmFtZSI6IkdyYWluIFNjYWxlIFRlc3QiLCJTZXJ2ZXJOYW1lIjoiREVWVEVTVDUiLCJEYXRhYmFzZU5hbWUiOiJURVNUUExBWSIsInJvbGUiOlsiV3JpdGUiLCJHcmFpblNjYWxlIl0sIm5iZiI6MTY4MDIyODE1MywiZXhwIjoxNjgwMzE0NTUzLCJpYXQiOjE2ODAyMjgxNTN9.yhqi6tMddjt7xyFj1tV4pzJkAPIcpf_hTJtyrH8mrwc" -H "Content-Type: application/json" -d "{\"JobID\":\"string\",\"TicketID\":\"string\",\"LocationID\":0,\"CustID\":0,\"GradeID\":0,\"ElevatorReceiptNo\":\"string\",\"LoadID\":…
-
-
- 4 replies
- 3.3k views
- 1 follower
-
-
Hi Everyone, I have a script as per the attached image below, that sets a variable from a field in my Events table and goes to another Layout and sets a field in my Players Table. Everything works well, my question is: "Is there another way to accomplish this without the multiple Else If statements?". The script will eventually have 50 Else If statements.
-
- 5 replies
- 1.9k views
- 2 followers
-
-
I am attempting to create a Database for people to pick the week of vacation they want by the week number. I would like them to be able to see the actually dates associated with that Week number so they understand the dates they are requesting. I am stumped as to how to do this.
-
-
- 8 replies
- 1.7k views
-
-
I'm working on a document management system where all files are imported and kept in containers in a FM databse. using the File > Import > Folder function, importing all files within the folder into container fields. however, filemaker selectively does NOT import excel, csv or text files into the containers. It imports the other file formats (images, videos, exe files, etc) the error that shows up after the import when trying to this is '4 files in (directoryname) cannot be imported because they are not the specified file type' I am NOT trying to import that data inside the files, just the files into the containers. if i drag and drop the …
-
- 6 replies
- 1.4k views
- 2 followers
-
-
Does anyone know where I can get free png icons to use in navigation menus. I need to have white icons when in focus and black icons when not in focus. Thanks! Tim B.
-
- 3 replies
- 1k views
- 2 followers
-
-
I am working in the sql tables of the accounting software we use. I added a field for the WEEK-NUMBER, using Friday (6) as the start. I need to calculate what the corresponding date is. I cannot figure it out. Any suggestions?
-
-
- 3 replies
- 1.3k views
- 1 follower
-
-
I have an FMP 19 file with 29 tables that was corrupted by Time Machine. I have now excluded all of my FMP file from TM backup and incorporated backup scripts in my most used FMP files. I did manage to find in my backups, an uncorrupted file from Nov. From the corrupt file I I exported all the records from all of the tables, then recovered each one of them and they showed no errors. I then imported them into the clean Nov file. I then recovered the Nov file and it is corrupted again. I tried this numerous times with a few other clean older files with the same result. What am I doing wrong? How can I get a clean file? Do I have to start over from scratch? I…
-
- 0 replies
- 562 views
-
-
I am trying to merge two databases together. Because fields are in portal, no idea how to accomplish. Adding to Table LineItems layout is no problem. Both dBs have same fields, of which the below are relevant. (These are samples. Actual dB1 goes from year 2000 to 2021 with several thousand records and over 200 for dB2 monthly records for 2022 only -- actual dB originated as something else so some fields I didn't use but didn't want to delete to prevent breaking anything) 2001 dB sample.1 dB Table Hours detail layout> one record per month 2001 (one record per month per year = 12 records; one per month for one year) Table LineItems > one record per event per …
-
- 4 replies
- 2k views
-
-
I've read to open my previous fmp5 files, I need to first get them to fmp7 format. I run FileMaker Pro 18 Advance currently on MacOS 10.15. I found site that says I can download Filemaker 11 <https://filemaker-pro-advanced.software.informer.com/11.0/> but will that not overwrite my current installation? And, will it even run on my OS? I only need to get the data out of the files.
-
- 5 replies
- 1.4k views
- 1 follower
-
-
I have made a Card Window to select a document number to assign to a foreign key in another layout. It works perfectly if I specify the table name from which I am searching e.g. Set Field [PartyDoc::fkDoc ; $Doc] or Set Field [ProjectDoc::fkDoc ; $Doc] But I want to be able to select from multiple layouts that all have "fkDoc" field So I want to say Set Field [ Get(LayoutTableName)::fkDoc ; $Doc] but it won't let me do that even with Set Field By Name How do I achieve this effect?
-
-
- 13 replies
- 1.8k views
- 3 followers
-
-
I want to develop relatively basic, database-driven solutions for small business. With the built in ability to create runtime solutions, FileMaker Developer/Advanced used to be a great place to do this. I learned FileMaker years ago and have enough of a foundation to create useful tools, but I'm curious how the recent versions of FileMaker have made it a better or worse place to focus my small business solution efforts. From what I can tell, my only realistic audience these days would be companies already invested in the FileMaker platform. Is there a route to use FileMaker to develop solutions that I could eventually distribute to Mac, Windows or Mobile users? More impor…
-
- 2 replies
- 1.8k views
- 1 follower
-
-
Hello Everyone, I am trying to construct a pedigree tree/chart out of parents and pedigrees for a number of generations in a plant breeding work. Any ideas how to approach this in filemaker or should it be done in JS? Thanks for any suggestion.
-
- 3 replies
- 2k views
- 1 follower
-
-
I have two databases. They have been set up with a relation based on a unique serial number. When I type in the serial number or serial numbers (separated by a carriage return) into the number field in database "A", it gives me a list of colors from database "B". Some of the colors for each serial number may be the same. Currently, I am getting a list of colors that are duplicates (ie: Blue, Blue, Red, Blue, Yellow). I want a field that simplifies/consolidates the list of text to just one of each (Blue, Red, Yellow). How do I go about this?
-
-
- 2 replies
- 1.3k views
-
-
Hi, I have a Dymo Labelwriter 400 printer and was trying to print out some labels (they are in a continuous strip not on a full page) but the formatting was wrong. I tried a bunch of ways with both portrait and landscape orientation but labels still didn't print out right. So, I tried to format the label in a different way which I attached a small image of. It printed that way with all of the info but the orientation is wrong. So, I looked for some kind of tool that would rotate the fields so they would display right but didn't see anything. After that, looked online for some kind of a continuous label template that would work with this printer but didn't see anythin…
-
- 0 replies
- 698 views
-
-
Hi, I ran up against a problem with trying to export a zip field that has a leading zero e.g. 01234 would export as 1234, I tried using Right ("00000" & zipCode; 5) but that didn't seem to work. My zipCode field is formatted as a text field. I am using filemaker pro 19 on a mac running os x monterey. Any help or feedback would be appreciated. thanks, Heidi
-
- 4 replies
- 1.4k views
-
-
I keep receiving an error message that the main dictionary cannot be loaded. Where can I download a copy of the main dictionary for filemaker pro 19.6 for Windows 64bit?
-
- 1 reply
- 1.2k views
-
-
Help! I had a Rich Text Editor working perfectly and, suddenly, it displayed just a "?" even though the underlying field still had all the data in it. I tried re-configurating but it said "This action cannot be performed because the required table is missing". I tried closing Filemaker, uninstalling the Editor and re-installing it. I tried deleting the accessory tables and starting the whole installation from scratch and adding it to a new layout. Previously, it had 2 tables installed but now it only installs one file: RichTextEditorAddon. I tried checking anything in the Inspector that needs updating but, everything I do, it still says the required table …
-
- 1 reply
- 1k views
- 1 follower
-
-
Is there a simple way to sort value lists descending? I don't need anything fancy like BOMS. I just need to be able to see the newest records first and not at the bottom of a mile long historical record scroll! Thanks
-
- 6 replies
- 1.1k views
- 2 followers
-
-
Installed plugin and registered with no problem. Not authenticate with outlook getting the above error. How do I I fix this?
-
- 0 replies
- 525 views
-
-
Hi! First of all, sorry if I can't explain me properly. I am not a user of the filemaker, but my work colleagues are having problems with it. They use the filmmaker 10 (32bits) and Office 365 (64bits) on windows 10 (64bits). The filemaker 10 never had problems opening the "new email" window in Outlook. Some months ago(can't be precise), when it calls for Outlook, it just doesn't do anything, no error, nothing... doesn't matter if Outlook is opened or closed, it doesn't show open the "new email" window. We tried different computers with the same versions and it works, but is happening in 3 computers. They are both HP, I even though the problem was related th…
-
- 1 reply
- 5.4k views
- 1 follower
-
-
Is there a way in Filemaker to get the same result as this SQL statement? SELECT Field 1, Field 2, Field 2 AS Field 1, Field 1 AS Field 2. And BTW, Happy New Year :-)
-
- 10 replies
- 1.5k views
- 1 follower
-
-
How do you create an OR function in a Perform Find script step?
-
- 6 replies
- 1.5k views
- 1 follower
-
-
Objective: Links from within the program to .mp4 files (audio and/or video) that are stored/hosted online and streamed to the webviewer inside the solution. These are not embedded or contained in any webpage or media player. Just the raw files with a filepath to them. Is there a way to get those to play in the webviewer. There are 9000+ of these files and creating a player or webpage for each is a daunting task needless to say. The idea is to keep the solution as small as possible (especially for mobile devices) so I don't think the container approach is the way to go. Any thoughts or help would be GREATLY appreciated.
-
-
- 3 replies
- 1k views
- 1 follower
-
-
I have attached 3 Databases. I have created an order database which contains relational data which are in portals from the Products database and the Summary Database. What links the data is the field CoglineNum My Questions: 1. Is this the proper way to setup the relationship between the databases or would you suggest an alternate way? 2. I have two layouts. The Main Layout has scrolling portals. On the work order screen (which will be viewed by the person processing the order) how can I get all of the data to be displayed when it is printed out on paper. Orders.fmp12 Products.fmp12 Summary.fmp12
-
- 1 reply
- 814 views
- 2 followers
-
-
Hi all - In our Filemaker database, we have an "Appointments" table and an "Appointment Services" table (being one or more services linked to an Appointment). I am working on a print layout to list all the Appointments on a given date, with a sublist of the Appointment Services for each appointment (shown beneath each Appointment). I have set the layout to display records from the Appointment Services table (in the Body part), and I have a leading subsummary part which lists the appointment details from the "Appointments" table (when the records are correctly sorted). This works fine, except that some Appointments don't have any Appointment Services connected wi…
-
- 1 reply
- 1.3k views
- 1 follower
-
-
I have a old database that in the past I've turned into a runtime without issue. I think the last version of FM I used to make a runtime of this DB was v16. I've been trying to use FM 18.03 to gen the runtime this time. It's working fine on the runtime build process but when I run the runtime database exe, in the startup scripts process the DB is terminating on Any "Adjust Window [To Fit]" script step. Hits an Adjust Window step and boom, terminates. I can use the full client to tweak the database in the runtime folder and comment out all of the Adjust Window steps and the runtime will load after that. And, oddly enough, I have some buttons on the main DB menu t…
-
- 0 replies
- 1.2k views
- 1 follower
-
-
My question in the Title is complete! Sorry. Dumb Question! I just found the Configurator!!!
-
- 0 replies
- 764 views
- 1 follower
-
-
All.. Disclaimer - I'm a desktop IT Support person. I'm not a Filemaker admin. Or even a user of Filemaker. We have a Filemaker server with multiple databases for different purposes. Our Staff are using Windows with Filemaker 19 installed. Currently, the people who look after FM have been advising Staff to add the server to Hosts via File, Open, Hosts. They can then see a list of all of the databases on that server, and open whichever one they need. I know we can create a desktop shortcut using fmp://servername/databasename to open a specific database - but that only opens a specific database. I don't want that. I want a shortcut which will op…
-
- 2 replies
- 1.1k views
- 1 follower
-
-
Is there a limit to the number of scripts that can run simultaneously on a server launched from a single application (not requiring completion)? Assuming that a script requires 10 seconds to run, what would happen if 10 of these scripts are launched simultaneously to be run on the server?
-
- 2 replies
- 828 views
- 2 followers
-
-
As an example scenario, if I owned an apartment building and wanted to have a wireless pushbutton in each apartment that when pushed would reach my FM application and be identifiable by the application (by a unique identifier (ie UUID)). I’m looking for the least expensive device that is WiFi-connectable that can, when ‘activated,’ can trigger an event in my FM program. I can accomplish this with an iPad, but I’m looking for something MUCH less expensive. Any ideas?
-
- 2 replies
- 1.1k views
- 2 followers
-
-
Example: I have an Asset table with a FK linked to the PK of an Owner table. On the Asset layout, I create a field called "Owner" which I select from the OwnerName field in the Owner table. With that selection, the system doesn't seem to know what the fk/pk field content is. So, if I want to go to that record, Ii can't use the Owner::PrimaryKey as the search parameter cos this layout doesn't know what it is. The only way I can make it know the FK/PK content is by selecting from a value list in which the PrimaryKey is the first field in the search - which stores a mile long text on the layout and means I can't put a connected field in without also incl…
-
- 4 replies
- 1.1k views
- 2 followers
-
-
Rick Kalman shared a post in the Claris Community that describes the top new features in FileMaker 19.6.1 including script support for transactions. As always, please let us know what you think about the release. I'm listening just about everywhere the community gathers. In addition, I'm writing a roundup of the best community blogs, videos, and other assets that I'll publish next week. Please DM or email links to anything I should consider for that roundup.
-
- 0 replies
- 1.1k views
- 1 follower
-
-
When I post the text below into "Specify CURL options". I get an error message that 'grant_type' isn't supported. Is there a workaround? TIA John curl -X POST -H 'Content-Type: application/x-www-form-urlencoded' \ -H 'cache-control: no-cache' \ -d 'grant_type=password&username=john&password=123456'
-
- 2 replies
- 1.6k views
- 2 followers
-
-
Can somebody, please, help me with a looping problem. I have a simple accounting procedure with 3 tables, Account, Transaction and TxnContra. The Transaction table has the master side of the transaction and TxnContra has the opposite side. E.g. Transaction receives $1,000 posted to account 1 and TxnContra has $500 for a/c 2 and $250 for each of accounts 3 & 4. Records in TxnContra are in a portal of Transaction and new records can be added there. When I post the Transaction, it posts the master amount to the account with the relevant foreign key and then it needs to post each of the contra items to the account with the foreign key that matches fkAccount i…
-
- 2 replies
- 1.1k views
- 2 followers
-
-
HI I have a solution I want to write a script or calculation that counts one day a week as vacation for 1 year, from a specific day forward. example .. every sunday until 2024
-
- 4 replies
- 860 views
- 1 follower
-
-
I created a solution which I want to give to other people. There is no data in it at all - they can add their own data. It's meant to be a database of audio tracks, so there would be no sensitive data. I made the mistake of starting with a file that had an all-access user defined. So I gave the "Admin" user all-access permissions and deleted the other all-access user, and allowed Admin to login with no password. But it still prompts for a user name. Is there a way to put this back to the default for a new file in FM - in other words, no prompt at all? It's quite a complicated solution, so copying scripts, layouts, tables, and relationships from this to a new one is really…
-
- 2 replies
- 1.5k views
- 1 follower
-
-
Fields: ACTIVE = YES value DATE STARTED DATE ENDED gDATE_TODAY = global Get(Current_Date) YEARS OF SERVICE (calculated result) If the ACTIVE field is "yes" then I want to see current YEARS OF SERVICE from today. Else, I want to see YEARS OF SERVICE from start to end date. Tried scenario that isn't quite working: If (Active="yes"; Year (Date_Today) - Year (Date_Started); Year (Date_Ended) - Year (Date_Started))
-
- 6 replies
- 1.9k views
- 1 follower
-
-
I recently installed FileMaker Pro 19 on Windows 10 computer. But I am having a problem when I am working on this. I received this error code 0x80070570 while working on this. I have no idea what the issue could be. Is it a software issue or any internal issue of my computer? Please help me friends fix the issue.
-
-
- 2 replies
- 740 views
- 1 follower
-
-
I'm using a script to run a Google API, but I want it to happen in a CALC field. To better illustrate, I'm translating text that's in a field from English to Spanish using a Google API. I am using InsertFromURL in a script. Can I instead use a calculation field to do the same thing? Thanks.
-
- 9 replies
- 1.2k views
- 2 followers
-
-
I have been using FileMaker 16 on Mac OS 10.14 for many years. One of the scripts I have been using used an Applescript step to control iTunes and it worked without issue all that time. I recently upgraded to FileMaker 19 and OS 12.5 (and Music instead of iTunes). The script no longer works, or works only partially. The script is: "-- set image path" & ¶ & "tell application \"Finder\"" & ¶ & "set pathToImage to (\"OTunes A:_AlbumArt.jpg\")" & ¶ & "set currentArtwork to (read file pathToImage as data)" & ¶ & "end tell" & ¶ & "try" & ¶ & "-- setup Music" & ¶ & "tell application \"Music\"" & ¶ & "activat…
-
- 0 replies
- 986 views
-
-
Hi there. I've been using FileMaker 16 Pro Advanced on OS 10 for a long time. As part of my music licensing business, I often run applescripts via Filemaker - one of the main things is to import music into iTunes, set all the tags, convert to various formats, and export. This week I updated to FM 19, OS 12.1, and had to move from iTunes to Apple Music. Now, many of the Applescripts are broken. I've spent the better part of the day taking small portions of the main scripts and seeing if I can get them to run from ScriptEditor. For the Apple Music script, the import step that used to be: set newfile to ("path to file") no longer worked until I changed it to: set ne…
-
- 0 replies
- 934 views
-
-
Dear All, I am trying to combine data from 2 portals (different portal names) which belong to the same table. I need to create crosses by combining (all possible combinations) all selected parents from the portal on the left (portal.female) with those selected from the portal on the right (portal.male). The result in this example should look like: 18 x 67 18 x 70 18 x 75 The result should appear in a different window as a pre-cross list. Then, I need to select from this list my final crossing list. Any help would be highly appreciated.
-
- 6 replies
- 1.3k views
-
-
I am a decades long user of FM and very frequently use a simple New Window command from button script in my solutions to display a log of user login and logout activity. That layout points to a table which is populated with calculated fields to record account, IP, timestamp, etc. This all works perfectly. However, and perhaps my morning coffee just hasn't kicked in yet, the window always defaults to form view, even though I have repeatedly set it to table view and saved the window layout. When I manually change to browse mode after again setting the default view to table view (the attached images shows a greyed out form view option since I have disabled form and list view…
-
- 1 reply
- 579 views
- 1 follower
-
-
How may I create a value list with all names i have in a table and others in an other one.. example.. table A: Mark, John; Thomas; Anna. Table B: Julia, Michael, Helena; Sophia. The risult of value list needs to be: Mark, John; Thomas; Anna,Julia, Michael, Helena; Sophia.
-
-
- 4 replies
- 1k views
- 2 followers
-
-
The found set will always contain 10 records. I have created a number field called random number, but have not been able to make a script that will give the results i need. This file is for learning Chinese characters. Most grateful for your help.
-
- 2 replies
- 1.4k views
-
-
I have a question about how to solve this ... I have a group of employees who create their own clients (viewed also like list) and which other employees cannot access with security level filters and privilege set customization (based on created by and then Get(AccountName)...but I would like to do this: if a record is "flagged" public the other employees can also view that record, while if I want to make it private I do not apply the flag and only the owner can view the record ... what can I do? Thanks
-
- 7 replies
- 923 views
- 1 follower
-
-
I have a solution for auditioning audio tracks and searching for keywords. There is a track table where each track has a unique track ID, and that is related to a keyword table via a join table "kwd_file" which relates the track ID to the keyword ID's. So far that is pretty straight forward. But each keyword is assigned one of nine categories which have ID's and names, such as "mood" (catID = 1), "genre" (catID = 2), etc. So now instead of displaying all the keywords for a particular track, I want the user to be able to select one of the nine categories and only display the track's keywords that are in the selected category. Seems like it should be easy, but so far the o…
-
- 4 replies
- 973 views
- 1 follower
-
-
My goal is to build a rudimentary game show-style buzzer for a team-based trivia contest. The simple scripts, which fire some lights and sounds, are mapped to a custom menu set which is running fine with commands like Ctrl-LeftArrow. I'm hoping to map them to be used with a Kensington slide advancer, which has three keys on it - 'b', 'PgUp' and 'PgDn'. (My plan was just to mutilate two of these slide clickers, so the left team has one that only fires the left arrow button, which is mapped to PgUp.) I'm just figuring out though that the Edit Custom Menu / Specify Shortcut interface, where I can assign hotkeys, won't recognize the PgUp and PgDn buttons. Don't…
-
- 2 replies
- 937 views
-
-
I want to change selected text to blue (#0090cd) with a button script. I would v. much apprecitate details of the exact script I need.
-
-
- 1 reply
- 922 views
-
-
I have often incorporated and even developed very successful machine loading models into FileMaker, but these are image detection models. I would like to use a text based model to determine the probability of the content of a text field being gibberish or whether it is populated with potentially meaningful English. Without having any experience in developing a text-based ML model, is there perhaps a downloadable model available?
-
- 0 replies
- 537 views
-
-
At some point the results of this query has stopped returning any fields from related files. The FMS version is 19.5.2.201. The related files are hosted on the same server, defined in External Data Sources, and have multiple table occurrences on the relationship graph. SELECT TableName,FieldName,FieldType FROM FileMaker_Fields WHERE FieldClass='Normal' AND TableName IN (SELECT TableName FROM FileMaker_Tables WHERE BaseFileName NOT LIKE '"& Get(FileName) &" %' ) This returns an empty result. If I just query the FileMaker_Fields table without a WHERE clause, it returns lines only for fields in the local file. Here's another query for investigation and …
-
- 4 replies
- 859 views
- 3 followers
-
-
Hi there! Goal: Search and replace in all scripts, database-wide, a particular phrase. Example: Find every instance of 'Go to Layout ["Edit Clients" (Clients) ; Animation: None ]' and replace it with 'Go to Layout ["Edit Clients_New" (Clients) ; Animation: None]' Description: With the advent of server-side sorting, and knowing that it doesn't work (for some reason) on 'Classic' layout types, I've been migrating some layouts across to different types. I've been happy with the performance improvements. Here's my dilemma. Some layouts are called through various scripts, and on various single-script-step buttons on layouts. If I move to a new layout us…
-
- 2 replies
- 1.1k views
- 1 follower
-
Recently Browsing 0
- No registered users viewing this page.