Jump to content

Search the Community

Showing results for tags 'fmp17'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 77 results

  1. Hello Friends, As such any script which can close the popover portal when a certain field have value ''No'' and if ''Yes'' it remains open. Popover portal is also open by script. Applying the following script steps but not succed Thanks
  2. Can anyone describe how to set up a layout for center fed #10 envelopes?😠 FM help says that after creating the layout you must verify margins and other settings before printing. How do you do that? I've tried everything I can think of, but the script print step prints 2 or 3 envelopes when the print dialog is set to 1 copy. I've tried adjusting the header and body dimensions (by guessing), I've tried deleting the header and keeping the body, I've even tried just keeping the header. Everything looks normal in Preview.
  3. 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 problem?
  4. I have a flat file database with only one table. However, I cannot not delete records. I get the error "This operation cannot be performed because one or more required related tables are missing". However, I can create records, just can't delete them. Obviously, I don't have a related table.
  5. I have a couple of questions before I take the plunge back into Filemaker after a long absence. When purchasing the annual contract can someone explain what a user is? Is it the number of people that can use filemaker at one time or does everyone that will want to get online need a separate licence? For instance would I need one licence when I access from at home and one from work. I might have many people sharing machines etc. Also there is a limit of "2 GB outbound data transfer per user, per month β€” tracked annually." What is this telling me? My databases will tend to be quite large as we use thousands of hi-res photographs.
  6. Hi, My solution opens an Excel file and loops through 3 tabs in it, importing and processing the contents of each. What I really need to do is get the user to specify an Excel file (preferably by opening a script generated default directory and filtering to only Excel files...something I can't seem to get to happen) then, in a loop, import data from 3 separate tabs in the file (tab names are fixed but import mapping is different for the different tabs) and process that data. When I'm running locally I can get the input file name by using Insert File into a container to hold on to the file name and can set up the imports specifying the filename, tab, and import order for each import step. This seems like a really clumsy way to get a filename that can be accessed multiple times without repeated user input, but it seemed to be the only approach back when I wrote .V1 of this script (a couple years back). But it worked for a local database. Now I'm trying to run from FM Server where Insert File is not supported. So how do I do this? I'm running on Mac and Windows so any solution that involves plugins needs to work for either (seamlessly). Conceptually, this seems to be very simple ... get a filename and access it multiple times. But I'm tearing my hair out trying to make this work. Thoughts or guidance? Thanks
  7. I want "Continuity Header Calc" to take "Group_Header" if it exists. If it does not, take Scenes:Scene Header I tried making the calculation with this: If ( IsEmpty ( Group_Header ) ; Scenes::Scene Header {; Group_Header} ) But it gives me the error: "The specified field cannot be found" I think I'm missing something... Thanks in advance!
  8. Hi, i am trying to find a position of new window so that new window opens on each record's line. is there a formular that can give pixel position of an object ?
  9. Hi, i am having a problem when i try to set a transparent color for the portal. previous version - fmp 11 , i never had this problem. is it disabled in fmp 17 ?
  10. I'm experiencing an issue regarding on my database. Every hour 1 I see perform find popping even I just scrolling through records. I already check if there's an On timer script but nothing. This issue happens every day.
  11. Is it possible to put the empty blank new record line on top of the portal view? Currently it shows up on bottom, and I'd love it to be on top if possible. Thanks in advance!
  12. I'm looking for advice regarding strategies for storing photos/scans within my database. Currently, I'm of the mindset that I would prefer to have a single 'container table' that is used throughout the database where needed. This table would have a few identifiers, which autofill based on where (as in from which layout, or where on the layout) the container is populated. Then, there would be a single layout where all photos/scans could be browsed/filtered/etc based upon those identifiers. First question, is this design good practice or should I reconsider my approach? Please note that for my purposes a container is not always necessary for every record (i.e. some records will have photos attached to them, and many others will not), and some records will need multiple containers (a record can have more than one photo attached to it). Second, in the case this is good practice, are there any examples available on how to best implement it? I really appreciate your time, please let me know if further clarification of my question is necessary.
  13. I can't get find a range of dates with a script. The following script is supposed to find the last 12 records on the layout. The Perform Find results in the error that the provided find criteria is not correct. Even if I use Enter Find Mode and insert the variables, I get the same error. What gives? Layout [ β€œLog” ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Log::Date; ascending ] [ Restore; No dialog ] Go to Record/Request/Page [ Last ] Set Variable [ $End; Value:Log::Date ] Set Variable [ $start; Value:$end-12 ] Perform Find [ Specified Find Requests: Find Records; Criteria: Log::Date: β€œ$start...$end” ] [ Restore ] //Enter Find Mode [ ] //Set Field [ Log::Date; $start...$end ] //Perform Find
  14. Hi. I have a database that lists grant applications. I need for my user to be able to view the records in a number of ways according to certain criteria for analysis purposes. These records are displayed in a List layout. I need to be able to: 1) see only records where the submission dates are between x and y then 2) filter these records according to what is selected in 2 dropdowns - Outcome and Status. The Outcome field dropdown value list is : <blank>, granted, unsuccessful, unknown. The Status field is dropdown value list is: <blank>,submitted, in progress, finalised. The <blank> is where that dropdown criteria are not required. Ideally, I'd like to be able to set the dates, select from the dropdowns and perform the find, but happy to do it in 2 steps if necessary. I've tried several things from solutions found searching the internet, but nothing seems to work and I'm getting increasingly frustrated with it. I'm not a coder and anyone good enough to help me out here needs to be aware of this. While I've been using FM on and off for a number of years, I'm by no means an expert or even near it. Thank you in advance for any guidance with this. You guys have helped me out in the past.
  15. Does anyone know about a plug-in for Sales Force?
  16. Hello All, The attached file is the simulation of my excel worksheets. I have three (3) accounts Admin, John & Lola all the three (3) accounts has no password. In my layout "ReportsEquipmentTime", I want that If I click the "project x equipment" button I will see only the record of the current account that is login. The script that Im using is Set Error Capture [on] Allow User abort [off] Set variable[$_columns; Value: ValueListItems ( Get(FileName) ; "Equipment" )] Set variable[$_rows; Value: ValueListItems ( Get(FileName) ; "ProjectCode" )] Set Field[Users::RELOGIN; Get(AccountName) Enter Find Mode [Pause: off] Set Field [DailyReports::CreatedBy; Set Error Capture [on] Perform Find [] Go to layout ["ReportsEqipmentTime" (ReportsEquipmentTime; Animation: None] Set Field [ReportsEquipmentTime::_Column Headers; $_columns] Set Field [ReportsEquipmentTime::_Column Source; "EquipmentUsed"] Set Field [ReportsEquipmentTime::_Row Headers; $_rows] Set Field [ReportsEquipmentTime::_Row Source; "ProjectCode"] Commit Records / Request [With dialog: off] Please see attached File. Thank you Lola Hours.fmp12
  17. Hi there - I need to create a simple crosstab report and wondered if filemaker 17 has this functionality built in ? If not can somebody point me in the right direction on this please. It would be very much appreciated. Also once ive created a series of reports how can i combine them so they appear at the press of a button in a single document ? Any help would be much appreciated. Peter
  18. I have a runtime solution that was created in FMP 12. This no longer works on High Sierra or Mojave. My iMac just gave up the ghost , but Mojave would not have run on that machine anyway. So Instead of sinking money into a new Mac, I am looking to see if there is anyone here on the forum that I could hire to render the runtime for Mojave (from the previous fmp12 file), do a simple runthrough to verify that everything works well and then create an installer package/DMG to get me (and my customers) back up and running. Thanks for your time and consideration!on in this matter
  19. 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've done is successfully in the past with Filemaker 15 with the exact same PDF files). I'm using a MacBook Pro with MacOS Mojave Version 10.14.2 (18C54).
  20. 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 question is this: Is it understood what is it in the restarting process that corrects the problem, and if it is, is it something that can be imitated with some kind of script, command, etc? Thanks
  21. Band Solution Design I am trying to create a filemaker solution for my band. I have been unable to find a pre-made solution that does everything I want, so I am going to try and create my own using filemaker. I am looking for advice on what tables and structure I should use, before I start. Entities Band Members - I need contact info and a history of money I have paid them from any gigs Clients - People that hire us for gigs. I need to send them a press kit in hopes of getting hired. Invoice them, and send a receipt. Fans - Marketing to these people , email, text, social media, etc. Can a fan also be a client? Yes, but it is pretty rare. I am thinking if a fan happens to be a client as well, they should probably be in both tables. I am not 100% on whether or not Fans and clients can be in the same table Assets - An inventory of our equipment owned for tracking and insurance purposes Merchandise - We sell shirts, hoodies, hats, etc, at our gigs. Invoice - We need to be able to invoice our merchandise and invoice our clients for our services (Performing gigs) Our merchandise is sold by us and has nothing to do with the clients. Songs - A table to keep info on all songs we play. Containers with pdf’s, mp3’s, song information, etc. This info will be shared with band members through email. Build reports to show clients what songs we play. Calendar - Track gigs and practices and band member availability. Hopefully I can have the calendar sync the gigs to an external calendar on our websites. Any other information, would be for band members only. Practices and availability should not be seen on any external calendars. Band members should be able to log in and block dates they are not available so I know when I can’t schedule a gig. Main questions from this are Should our services and merchandise we sell be in the same table? On a side not, the price of our services is not a set price but negotiated for every gig. There are too many variables to be able to have a set price advertised. In other words, I can’t have, β€œ2 hours of music for $500”. One gig might be 10 minutes away, require none of our sound equipment, while another is an hour away, requires us to bring everything, and members need a hotel for night. So every gig fee is negotiated. Are Clients and Fans in the same table? My feeling is no, but I could be wrong The Calendar table. Band members need to see everything on this, and be able to block dates. The gigs listed on this table should sync with external calendars on our website, etc. I am not even sure Filemaker can handle this kind of calendar application, but if so, why not try? Any advice is greatly appreciated. Thanks, Dave
  22. Hello -- I would like to open pdf files that are stored in a secure external manner. Only the first page of multipage files show in a FM container window (if I';m not mistaken) so I am wondering about using Preview (Mac, of course). I can retrieve the file path to the secure file by processing the text output of the container file, and then use it as a variable filename in a Send Event script step, but Preview cannot open it. Any suggestions?
  23. I used to be able to host a limited number of clients with FMP. With FM17 it now says "The host's capacity was exceeded, try again later." and the file shows 0 clients connected. Is the only way around this to get FMP server?
  24. Hi Gang, I am reaching out to see if anyone can assist (or maybe point me in the right direction) with some ExecuteSQL() issues I am having in my my next version of my product. I want to execute a query like the following: SELECT code FROM Appts WHERE appt_id IN (’14’,’10’,’8’,’9') ORDER BY FIELD(appt_id, β€˜9', β€˜10', β€˜8', β€˜14’) I have tried several times for this to return a working result with NO LUCK. Do you know if FMP allows this sort of query or does it fall short. Appreciate any help. Thanks!
  25. I know. Don't use them. But There is a simple task and a repeating field would be a quick solution. Field 1: a number Field 2: a calculated repeating field, each repetition adds the repetition number to the value of Field 1. Can it be done? Thanks
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.