Search the Community
Showing results for tags 'fmp18'.
-
Dear users, I have three tables for three relevant layouts. Each one has separate table and tables are related with only one field. The scope is to show on the 2nd and 3rd layout the records that related with the 1st one. Here are some screen shots with what I need to do. Actually, I need to have on the seconf layout ("Orders from suppliers") the related records from the first one ("Suppliers list") Thank you thank you Giorgos
-
I find it odd that FileMaker is so intuitive yet hides access to the file name of the data source during importing. It looks like the only way I have found based on posts on the forum is to import the Data Source file as a reference into a container field. That is an extra step that shouldn't have to be done since FileMaker sees the Source file name during multiple points in the import process. Here are three dialogs where it's seen during import. There has to be a way to use the input file name with some kind of Get Function. Please help!
-
I previously used ODBC Manager (32 bit) to great success importing data directly from Filemaker Server to JMP. I recently upgraded to Catalina (MacOS 10.15.5) and knew that one of the casualties would be this ODBC utility. I downloaded the 64 bit ODBC manager from Actual Technologies and successfully installed it but get the following message when trying to open an FM database from within the ODBC interface in JMP: dlopen(/Library/ODBC/FileMaker ODBC.bundle/Contents/MacOS/fmodbc.so, 6): image not found I have navigated to Actual Technologies' web site believing I should download an
-
I've been saving various files - mostly pdfs - in FM container fields, for years. A script triggered by clicking in the field allowed the field to be exported for viewing. Recently I upgraded to FM18, and now when I click in the field, I'm told "container fields cannot be exported"! Is there a new way that I should be doing this? Thanks.
-
Hello, I am novice filemaker developer, and trying to learn the cool ways Filemaker can integrate with other apps. The "simple" task: upload document (.pdf) to Google Drive Folder with native filemaker funtions (no plugin). So far: I have managed to get the authorisation token (following Seedcode guide for Gmail integration and Harmonic DevCon18 presentation and demo files) and make the POST call to create a file in the Google Drive root folder, however the file is unreadable. So my guess is that I am not putting all the curl options correctly from what I understand from the Goo
-
I can ping my PDF document server from Terminal, I can connect to the PDF document server from all browsers apart from Safari, my default web browser is FireFox, I also tried to change to Chromium and Opera as the default web browser. WebViewer has the same symptoms as Safari, server not found. $ ping -nc 1 document PING document (10.0.0.7): 56 data bytes 64 bytes from 10.0.0.7: icmp_seq=0 ttl=64 time=0.002 ms --- document ping statistics --- 1 packets transmitted, 1 packets received, 0.0% packet loss round-trip min/avg/max/stddev = 0.002/0.002/0.002/0.000 ms FileMaker says ’Couldnot c -
On a clean install of Filemaker server 18 on a windows box running W10 Enterprise edition. The hosted files shows "Opening" from the Admin console, and that is how far it can go. The files never get opened. Have done couple of restarts but same problem. Have tried both encrypted and non encrypted files, same problem. Any advice on what might be the cause?
-
The current file format has been active since FMP12. Judging by previous versions and how often file compatibility gets broken, it seems we're due for a new file extension soon. I'm at the point where I need to update a complex database that was created in FMP11. It's not an emergency so I'm debating wether it's worth waiting another 18 months or so until we get FileMaker 20 to convert it to .fmp20 directly. But if we know there won't be a new file extension, I'd start now in FMP18. Do we have any intel on FileMaker 20 file compatibility? Cheers! -
I'm just not getting my head wrapped around this. .. parsing JSON 'properly' as opposed to doing it like scraping. My incoming data is as such: {"ISBN:9780830631292": {"publishers": [{"name": "Windcrest"}], "pagination": "xi, 451 p. :", "identifiers": {"lccn": ["88039223"], "openlibrary": ["OL2059910M"], "isbn_10": ["0830631291"], "goodreads": ["3532499"]}, "classifications": {"dewey_decimal_class": ["005.4/469"], "lc_classifications": ["QA76.76.O63 C365 1989"]}, "title": "Inside ProDOS 16", "url": "https://openlibrary.org/books/OL2059910M/Inside_ProDOS_16", "notes": "Bibliography: p
-
So, basically, in a nutshell: If I just have a relationship setup and use that related field on the layout, I'm forever going to see the oldest entry ever made under that relationship listed there unless I've got some sorting method applied in that layout or to that relationship? First <--> Oldest, meaning if I add 0, 1, 2, 3, entries .. and at a later date delete 1 & 2, add a 4, 5, 6... that 3 being the oldest in the relationship at that point would be the one I would see in that field? This part should be a different thread anyway.
-
Hi, I'm new to 360works so I'm using the demo version of Scribe. I have a problem with the plugin. The plugin seems to only load one document. When I tried loading other document .docx it would always load the first document. It seems that it loads the first document and keep it as a copy in the plugin and re-use it again and again. Is it because I have a demo version?
-
I have been attempting to connect to a SQL database on my network using Monkeybread Software and each time that I attempt to do it I have encountered the same error, which I have attached here. I have set up an ODBC connection as well as made sure that I had the names correct, however I have gotten the same error message each time. Thank you for your help.
-
This is kind of a unique situation. When working with Open Library: You can call for Cover images by creating a URL with the ISBN.. and if the Cover is available, it will show up. e.g.: "http://covers.openlibrary.org/b/isbn/" & ISBN::ISBN_Search & "-L.jpg" will give you the image in a web viewer. Literally, the image only, which is actually a different URL that is not really able to be created via calculation. Otherwise a simple Insert From URL would work. If I drag that image to a container.. I predictably get the actual URL of the image. I want to get that -
Hi Guys, I have a Script running a calculation for a Find. The table is in essence as follows Item Percentage Find Field My Script/Calculation is as follows: I have an identical Script with text relating to the item. This works perfectly. For some reason the calculated field isn't. The input for this Find Field is entered as a decimal number (the setting of the the field turn it into a percentage). So if I am looking to find ≥ 10% I would enter .1 into the Find Field. When running the script, I am gett
-
Hi Guys, I'm back, with some final (hopefully) questions on Reporting. Assuming the Data looks like this: I can create Reports from the Item, Type, etc that's easy. What I'm struggling with is the following: 1. Making a Report which is sorted by Type, but only where the Qty is above 0. So where Bread, Cheese and Crackers would be excluded. 2. Making a Report which shows the 'top 10' owned, and 'bottom 5' owned - based on qty field. 3. Making a Report which shows me the 'best' month (a) per product and [which month did I have the mos
-
I'm having trouble with FMPA 18.0.3.317 creating a runtime. Even with the simplest file, I create it and when it runs it immediately crashes with the following in the crash report: Exception Type: EXC_CRASH (Code Signature Invalid) Exception Codes: 0x0000000000000000, 0x0000000000000000 Exception Note: EXC_CORPSE_NOTIFY Termination Reason: Namespace CODESIGNING, Code 0x1 I did the exact same thing with FMPA 17.0.6.600 and it worked fine. Any suggestions as to what's going on here and how I might fix it? Thanks!
-
Hi Guys, So I am CLOSE to my near final question, until it comes to reports.....yay! This is possibly opening a can of worms, but I want to create a Date Calculation. The table will look something as follows: Type Buy/Sell Date Banana 7 10 April 2020 Apple 10 5 April 2020 Apple -3 9 April 2020 Bananna 4 17 April 2020 Apple 9 14
-
So I compiled a runtime with FM18 running on 10.15. Client says it won't open on his machine with 10.14. My instructions were: 1. Open Terminal app 2. Type codesign --remove-signature 3. Drag the application icon into the Terminal window. This procedure made the runtime work on my machine, but it's a different OS. I really don't understand the ins and outs of this codesign stuff, but I would like to know if perhaps you know some trick that will make the runtime work. Thanks, Stefan
-
Hi All, So my ambitious database is coming on well, and in particular thanks to Comment in this forum! I'm on to the final chapter of impossibilities and the current one is below, which I don't really know how to start. So I have a table of information, which has what I would call an 'original' piece of data, a number. Each month, that number gets updated, on a monthly basis, at the end of each month - the idea being that you can see things in a shapshot of the present, and in the past if required. So when you add Record in the Numbers Update Table and select the Compan
-
Hello Everyone, I got this file which need to be imported into FileMaker, but getting error while importing as the format is in XML. It pops up XML/XSL import specific dialog and when I choose to continue, it shows an warning saying that "XML/XSL information is not enough to proceed with import/export." Please help me to import this file or any other way to import this data into fields in FileMaker. Thank you for your reply. File.XLS
-
My main layout has a portal to itself that I've got a dynamic filter on so I can look for similar records and load information from them to the current record or load that record as the current record. All is good there. What I'd like to do is have a button to click on with whatever value is entered in the filter box, and have it switch the that trigger a find in another window. From there then I can use a similar set of options to load data from that other window / un-related table/portal back to the main layout/window. I'm using a separate database as a place to lo
-
Hi Guys, I have two tables: - Companies (with Company Data) - Transactions (with Transaction Data) The Company ID (serial number) is liked to Transaction via a Foreign Key. So all good. I have a layout on the Companies Table, where I then have a Portal that lists transactions relating to that company only. Again, so far so good. Now, in the Transactions Table there is a number calculation/number, the Field is called Percentage Increase. What I want to do is in the Company Layout view have a field which is a Summary of the Percentage Increases. So if ther
-
I have a macmini running Catalina. I'm trying to uninstall Filemaker Server 15 so that I can install Filemaker Server 18. However the 15 uninstaller does not work on Catalina. Is there another way to uninstall FMS 15?
-
I would like to create a button next to my phone field so that when it is tapped, the number gets dialled (in FileMaker Go). anyone know how to do this? Thanks.
-
Looking for a filemaker alternative to https://www.receipts-app.com/en/ any sugestions? exploring options for a paperless office system using filemaker, which may prove the most cost effective. Ideally it needs to be FM server based supporting multi users suggestions and and ideas
