Search the Community
Showing results for tags 'fmp18'.
Found 76 results
-
Hi, As a complete novice to FMP, I'm attempting my very first database. We rely on storing our contracts on Google & Dropbox. I've been trying to either embed the pdf's into a "tab", or (my preferred option) to have an "Add URL" button to link to the online pdf. I tried adding a field and copying and pasting the URL, but it's not clickable, and I'd need to add another field for each pdf/contract. Is there a better more efficient way to do this? Thanks Steve
-
I just migrated our FileMaker Server from a Mac Mini running MacOS High Sierra and FMS 17 to a Mac Mini running MacOS Catalina and FMS 18. Everything went well except getting FMS to backup to an external Hard Drive. I simply unplugged the External HD from the previous server and plugged it into the new server. It mounts no problem. I gave "fmserver" "Read & Write" access to the drive AND the folders on the drive it needs access to. I can read and write by dragging files onto the drive, but when I try to enter that Default Backup Folder Path under Configuration>Folders in FMS Admin Console I am told that "The path is not valid.". I used the exact same path as was used on the previous FMS. I even went so far as to set the permissions on the drive and folders to allow "everyone" "Read & Write" access. The only thing that I can think of that might be the issue is that the internal hard drive on which FMS is installed is formatted using APFS and the external hd is formatted using Mac OS Extended (Journaled). Before I go either reformatting the internal drive as Mac OS Extended OR the external as APFS, I wanted to see what the community thought. So I'm posting here. Am I on the right track here? Is it because of the difference in formatting of the drives? If so, which format would you recommend.....I'm leaning towards Mac OS Extended? If not, I'm open to any and all thoughts. -
web viewer and script to send carriage return
johnmarcel posted a topic in FileMaker Pro Advanced 18
I have setup a layer with web viewer. I can maneuver within the website just fine but, I would like it if when the website loads it would send 4 carriage returns to get to a specific field within the website. If anyone has any ideas on how I can accomplish this it would be greatly appreciated. Thank You John -
filemaker sends mail with the program FM18. does not send mail with runtime. gives an SSL error.
-
Have copied a shell script which works in other settings onto a new machine Changes paths - it zips a backup folder and does a ditto command to copy as a zip file to an external drive I worked out that I needed to change the sudoers file to allow no password access to the script. Running the shell script in terminal was requiring a password, now it doesn't Added the fmserver user to that too. If I run the sh script from the admin console as fmserver it fails straight away, if I run it as the local user with its password it appears to run but in fact times out with a fail message, both of which are about invalid account name or password The script is working fine when run through terminal, doe not require password, just not when triggered from console. Does anyone have any light to shine on this???
-
Hi All, Apologies for perhaps being in the wrong part fo the forums for this query! I'm on FMP16 right now, and I've a container field that I use to display square pictures of people. Due to different layouts, the container is landscape on one, and portrait on another (ie wider on one, and taller on another). Because the only option in FMP 16 is to FIT the image, when the container is wider than tall, either the image is distorted or there are gaps on the sides, depending on whether I've got the 'maintain proportions' box checked or not. And similarly, when the container is taller, then the image is either distorted or there are gaps on the top and bottom. What I'm after is being able to FILL the container, so that whilst I loose a bit of the image on the sides or tops, the container is filled without distortion. Is this possible with FMP 18? (If there's a work around for FMP 16 I'd love to know it, but I don't think there is!!) Many thanks in advance -
Actually, I guess this could apply to macOS Mojave as well, but is there any way to get the Send Email script to work when creating a Runtime solution in macOS Catalina? I'm using FileMaker Pro Advanced 18 to create my runtime solution. I created a button on my main menu to send an email. When I click the button in High Sierra (and all previous macOS versions) it works. But in macOS Mojave and Catalina, nothing happens. I know that Apple placed security limits on applications, but there's no way to add my runtime to the list of allowable applications to execute a script. What is supposed to happen is that macOS is supposed to have a pop up that allows you to click to allow this application to run scripts and access mail.app. So this works in FileMaker Pro Advanced 18. However, when I covert my solution to a Runtime, it's no longer "FileMaker Pro Advanced" and instead is considered a Runtime app. In macOS Catalina, manually adding my runtime solution to this area didn't work: System Preferences > Security & Privacy > Privacy (tab) > Accessibility > (Allow these apps below to control your computer) Is there any way to allow a runtime to have a simple button to click Send Email in Catalina? I'm stumped. -
Someone any idea why FileMaker does not know it's own error codes? This happened when a customer with FileMaker 18 is trying to perform a scripted QuickFind. I cannot reproduce it.
-
Good morning I was wondering if anyone had template for a basic home accounts sytem or the schema for the databases. Thanks again.
-
macOS Catalina. 1. Make a new file and save it to the desktop 2. While the file is open, move it to the trash 3. empty the trash The trash is emptied without any error. Weird. This does not seem right, in fact it seems VERY wrong. Can anybody reproduce?
-
Hi guys, Im trying to autofill a field depending on the value of other fields -- Ideally this field would be autofilled with some text immediately followed by a numeric value that increases by 1 for each new record. I currently have this: If ( Case1 = "A" ; (Case(Type = "Protein" ; "test1xxx"; Type = "Antibody"; "test2xxx"; Type = "DNA"; "test3xxx"))) I would like to replace the "xxx" components with "000" through "999". I was hoping someone would have some insight on this. Any help would be appreciated. Thank you! -
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 not sure how to explain this properly but I will try. I have 2 tables, one main customer table and a phone log table with over 700,000 records. They are related with a customer number field. on my main customer table, I currently show the last phone log entry, date and user initials with a field in the main customer table called (last phone log name) (last phone log date) (last phone log initials) using the last function. This works perfectly but it is massively slowing down when I scroll through hundreds of records on my main customer table. Is there any way to create a new field or store this information so it isn't calculated on the fly, any thoughts?
-
I recently purchased a new server for our FileMaker databases to live on. To migrate our databases, I simply copy and pasted the Database folder from the old server to the new server. The old server was running Windows Server 2016, and the new server is running Windows Server 2019. The clients are running on Windows 10. The Clients are running FMP version 18.0.3.317 and the Server is running FMS version 18.0.1.123 The server is in our building, and all clients are accessing it locally using Bonjour. After the migration, all of our Container Fields are displaying a 404 page. I have attempting the following troubleshooting steps: Disabled firewall on the server Disabled firewall on the client Disabled both firewalls Switched the container field from internal storage to external storage Tried both Open and Secure storage. Tried to access the container fields from a FileMaker install directly on the server When I tried it on the server I got the following information: Module: IIS Web Core Notification: MapRequestHandler Handler: StaticFile Error Code: 0x80070002 Requested URL: http://Juniper.local:80/Streaming/MainDB/69C195279B5026B83046F07324A22947B573DE471A28D1F7BA92374DD54F758F.pdf?REType=EmbeddedRCFileProcesser Physical Path: C:\inetpub\wwwroot\Streaming\MainDB\69C195279B5026B83046F07324A22947B573DE471A28D1F7BA92374DD54F758F.pdf Logon Method: Anonymous Logon User: Anonymous Following the "Physical Path" listed above on the server, I am unable to locate the "Streaming" folder within the "wwwroot" directory. I am wondering if the server is attempting to find a file where there is none. Please let me know of any more information I can provide. Any assistance you all can give will be greatly appreciated! -
Hello, the following is the essence of a problem I need to resolve. The code is AppleScript display dialog "Hello \"world\" " This code needs to run in FMP18 as a calculated applescript. I tried: Perform AppleScript [display dialog \"Hello "world" \"] Perform AppleScript [display dialog \"Hello \""world"\" \"] Perform AppleScript [display dialog \"Hello "\"world"\" \"] Perform AppleScript [display dialog \"Hello \""world\"" \"] and other permutations of 1 backslash and 2 quotation marks cause the calculation to be unsavable b/o error. Perform AppleScript [display dialog \"Hello \"world\" \"] results in "A identifier can’t go after this “"”." -- after the calculation is saved. (Yes, "A identifier") Perform AppleScript [display dialog \"Hello \"\"world\"\" \"] results in A “"” can’t go after this “"”. -- after the calculation is saved and an error message of -2740. Can anyone help me please?
-
Hi, just upgraded to Filemaker Server 18 on Windows 2019 Server. In the Logs, during the backup, he often says something like "The file hasnt changed since the last backup so I am saving a hardlink to the original file only". (This isnt the exact text - its translated from German). When I look at the backups though it looks like the Server really actually did backup the exact file, which is the behaviour I want. What gives? Is this a false message of some sort? I absolutely do not want him "not" to back up dormant files. I transfer the files elsewhere later and for that I dont want any hard links or similar. I want the full file. Incrementals are switched off. Thanks Spongebob
-
Hello, we have filemaker server 18 hosted on windows server 2012, the server is connected to an APC ups thats keeps the server running for 40 minutes when power is loss, after power is loss we have to manually close the databases and stop the FM server , then we shutdown the windows server .... i would like to know if there is an automated command that close the databases and stop FM server when power loss is detected?
-
Hi all Our server decided to shutdown just now due to windows updates. Here is the FMS log: 2019-12-11 17:18:45.641 +0000 Information 745 FM Stopping FileMaker Server processes... 2019-12-11 17:18:45.675 +0000 Information 704 FM Stopping Database Server process... 2019-12-11 17:18:45.704 +0000 Information 488 FM Stopping Database Server... 2019-12-11 17:18:45.734 +0000 Information 410 FM Stopping FileMaker Database Engine... 2019-12-11 17:18:45.770 +0000 Information 140 FM Closing database "BS"... 2019-12-11 17:18:45.778 +0000 Information 140 FM Closing database "Case_Feedback"... 2019-12-11 17:18:45.778 +0000 Information 140 FM Closing database "ML"... 2019-12-11 17:18:45.778 +0000 Information 140 FM Closing database "ML_Correspondence"... 2019-12-11 17:18:45.874 +0000 Information 168 FM Database "BS" closed. 2019-12-11 17:18:45.994 +0000 Information 168 FM Database "Case_Feedback" closed. 2019-12-11 17:20:34.367 +0000 Information 743 FM Starting FileMaker Server processes... As you can see it did not close the last two databases in time. As such, I've just had to wait 30 minutes for one of those two to finish 'checking'. It has now succesfully opened however and we can access it. Obviously we need to disable such automatic Windows shutdowns. But is there another safety net I can put in place to ensure that no shutdown procedure can complete until all FMS services have stopped? And that FMS services cannot stop until all databases have successfully closed? Thanks!
-
Hello, I'm new to FMP and want to set up a single database solution for a small team of 4 people. Our systems aren't running the latest MacOS to keep our older Macs reliable, so the server won't run on our system. I'm wondering what the best option might be for such a small team - can we a use a file sharing system to serve up the database to the other 3 people on my development team? Or do we need to buy into a cloud based server to do this? Thanks in advance!
-
Hello; can I change the content of any error message that I get during edit or modify?
-
Hello; how can I create a Chart same as in Excel?
-
Hello all On FM 18.03, the closing of a popover, the button of which is in each row of a portal, causes FileMaker to close. This appears to only happen when the fields which are in that popover (the portal records) are edited. Has anyone else experienced this? Thanks
-
Hello; how can I link FileMaker Pro Apps with the Mobile Phone Contact Program so when any call comes if my apps has the name will show on screen? -
I have started sending emails using the INSERT FROM URL method shown by soliant here: https://www.soliantconsulting.com/blog/html-email-filemaker/ Emails are being sent out but many recipients seem to be getting my emails sent to their spam folders. I'm curious if this has anything to do with this method of sending emails. -
Hi everyone, I am trying to run a server sided script that will import a found set. The server sided script opens a handler file that opens data file 1, does the find, imports into data file 2. However, the search works in script debugger but imports all records. The script opens layout A, searches goes to layout b, imports. Also the import of the selected fields seems not be remembered. I am stuck..... Thank you
