Search the Community
Showing results for tags 'fmp17'.
-
A google search reveals that FMP not recognizing modifier keys is at least a decade old problem. It's hard to resist making some kind of a comment but I will resist. At any rate, it seems that restarting the computer, at least on a Mac, resolves the problem, (until it pops up again). My questi...
-
Hi everyone, I'm trying to get attaching files go mails generated using FM17 to work. The idea is to attach a variable file to a mail-message generated for a specific record. The filename for the attachment is specific to the record and I've got a field that generates that filename (fileNamejpg... -
I have in my small store, a sales system running on a POS with an extra display, for the customer to see what is being added to the invoice. How do I make the filemaker present on this small monitor the summary of what is being sold? how can I maker filemaker to display on the seco...
-
Hello, I've come upon a strange phenomenon, and wonder what could have gone wrong: In layout mode, I select gray solid coloring for a couple of fields and their labels, but in Browse mode (both list and table views), the colors fail to show in some instances. Only in form view, everything is di...
-
I'd like to be able to export a text file that would contain several fields from a single record, with each field on a separate line. Here's an example: John Q Public 111 West First Street New York, NY 10001 How might I do that? I know how to export csv or Excel files,... -
To try to explain the setup as succinctly as possible: Database is running on a FM17 Server (on a Windows virtual(?) machine... Our IT department handles that part). The FM database does a number of imports every morning from our primary (4D) database, using an ODBC driver, but I have not...
-
I have a field called Price. I need to create another field called calculated price that will add a percentage depending on the value of the original Price field. Example: If the Price is $100.00 or more Subtract 10% from the price If the price is $10.00 or less Subtract .25%... -
Hi, I am using the Base Elements plugin Execute SQL command to select SQL on a table in another FileMaker file. For a file with many fields and quite a lot data in some fields, this times as about 1 minute just for SQL SELECT command for 1,000 rows. I haven't used MBS (monkeybread software) plugin y... -
I have a layout calculation that looks like: Round(If($$NoGPABump = 1;Classes::GPANoBump; Classes::GPABumped);2) In most instances, this rounds the appropriate value to 2 decimals and displays those two digits. But on occasion, it displays only one decimal as in this one: . Instead...
-
fmp17 Weird hover state problem with popover button
vinnygi posted a topic in FileMaker Pro 17 Advanced
I have a layout with a number of button bars, all with the same style. Each button is set to have an inner shadow and a white fill on Hover. For any of the buttons that call a popover, after the popover is closed, the hover shadow no longer works, but the fill still changes to white. I've tried add... -
Is this at all possible? I want to have two buttons that will each do the following. Have one button to ‘Strike Thru’ text that is highlighted before. Means not all the text in the field will be changed. And one button to change the text colour to Red, again highlighted befor... -
For about 12 years, we've had a FileMaker database import external data from a .mdb (Access) database that has data that is downloaded from some equipment. The process has survived several computer upgrades (Windows XP and Windows 7) and FileMaker version upgrades (created in 7 and currently runni...
-
Say I have a 2 page letter pdf in a container. I want to make a 1 page pdf that is 11X17 of this PDF. Do I need a plugin to do this? If so what? Or can I achieve this natively in FM?
-
Hello, good afternoon! I'm from the Philippines and I really need help here regarding how to send SMS using Semaphore. Semaphore is an alternative for Twilio. I use Semaphore since this is a SMS Gateway for Philippines and it's every cheap as well. Here's is my script using Insert from URL...
-
Dear All, I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here. The criteria of entering a value is xxxx-xxxx-xxxx-xxxx 1111-2222-3333-4444 1. Length of valu...
-
I am using Filemaker Pro 17. I have created a container field with 'interactive content (PDF, MP3, etc.)' checked in the Data tab in the Inspector. PDF's won't upload. I've uninstalled and reinstalled Adobe Reader DC. I've tried other PDF files and they just won't load. What am I doing wrong?...
-
I have filemaker server on virtual server, I have a script that exports emails and or names i cannot get the file to be saved to the local desktop it tries to save to server with an error when i do manually it works fine so i am doing something wrong... Thanks in advance
-
I have been using FM17Adv for some time. I am on a MacPro 12-core tower and I had been running macOS Sierra. All the internal scripts I had in one database worked perfectly. I recently updated to High Sierra and now I am getting script errors I don't understand. And this is from the same exa...
-
Hi Guys, There are any logic or resource that i can use to make like a "text to columns". Make text from field one flow to another fields but only with in the middle of coma regarding your sequence, like a excel? Full text with Comas Text1 Separated...
-
fmp17 Activate Script Trigger on entering window
carlsson posted a topic in FileMaker Pro 17 Advanced
I don't really know what I'm missing here. I have two windows next to each other. I want to activate a Script Trigger on Record Load (I have tried On Layout Enter as well) , and it does that fine as long as I'm only having one window open. But not when I'm switching between the windows. Ie, I w... -
Excel and Filemaker calculates the difference between two dates differently. I always thought that when you subtract two date from one another, the result was the number of full days between the dates. For example: Calculate the difference between 1/15/19 – 1/9/19. There are 5 full da...
-
Hi everybody, looks like I do have a sort of rookie problem here. I created a subsummary report which is sorted by a break field and all works fine. All is fine in layout and preview mode. Just in browse mode I seem to have a problem. There is a large grey empty area just underneath of t...
-
Hi everyone I am working with filemaker on and off for the last recent years but, no doubts about it, I am still a rookie. lately I have created a db similar to a booking engine for shore excursions for river cruise ships. Lots of modules, layouts, scripts etc. As I really have to work wit...
-
Hi Guys, There is any script who request user and password of user after click in a button. I have a check box in my solution with get username for log register and validation, i want to request user and pass to allow user enter this option. Thanks for all.
-
This is a problem I frequently have. I can't custom format a date in the Inspector. I can't make a selection because the drop down menu becomes a long vertical blue stripe and selections are not available. I wonder if this is a FMP problem or a Windows 10 problem. Does any one else have the same pro...
