Jump to content

Search the Community

Showing results for tags 'fm11'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • 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 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • 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 57 results

  1. Hi, I have a scenario where I have to display the top sales guy's photo on the sales summary page. Top sales guy might change day to day. I want to display the picture of top sales guy always on the summary page. How can I achieve this?
  2. I am using FMP11 Adv. I want to do something similar. I have Multiple vendors for products but not every vendor has all of the products. I want to find the average price and then mark the avg price up. I would also like to have a double check that the Sell Price is above the highest vendor price so I never sell for a loss. Example Product Sku Vendor 1 Vendor 2 Vendor 3 Avg Cost Max Price Sell Price Mouse USB 1001 9.97 13.42 10.41 11.27 13.42 14.08 Keyboard USB 1002 10.01 15.48 12.75 15.48 15.94 Optical Drive 1003 45.23 84.91 44.98 58.37 84.91 106.14 Calculated value off average would be --> 72.96 <-- Two vendors are clearing stock of an Item but the third vendor is not. The 2 vendors run out of the item but the more expensive still has stock. so to fill the order I have to get it from the vendor with highest cost. I need a double check here for the selling price so I don't accidentally blow it. One way I have thought to do this is simply to use the highest priced of all vendors. I know how to do this with the Max command in Excel but I can not seem to get an equivalent to work in Filemaker. I have done a lot with MySQL on servers and Excel on workstations. But I am new to Filemaker. I have FM running on a dual xeon quad core with 24GB so cpu time or memory is not a big deal. I know some calculations from all the reading I have been doing takes large amounts of both. My database is around 260K items and around 90Meg on the drive. I do want a clean and maintainable solution. My product list changes about 3 times a week. As I update stock and prices.
  3. We have a FileMaker 11 Server/Client environment, using Active Directory to authenticate users. I have a layout where a user would like to perform a find and export the found record set, however the Export command is greyed out. The user has the ability to view and create records and has access to all fields. He has limited Edit and Delete access based on if the record was created by him. His privledge set has Allow Exporting checked. The layout is using the FileMaker standard menu set. My Account (that has Full Access), can export records. I'm at a loss here and need some help figuring this out.
  4. I am working with a FileMaker application that was built and maintained in FMP4, and am trying to migrate into FMP11. The files were converted first to .fp5, then imported into FMP11 and coverted to .fp7. Overall the fields, layouts, scripts and security accounts survived the process with only some adjustments. However, there is a problem with deleting records through a portal. Our main DB layout contains a portal to another table in another .fp7 file. The Relationships chart shows the relationship, and has the "Allow creation of records in this table via this relationship" and "Delete related records in this table when a record is deleted in the other table" checkboxes set for the portal source table. New records can be added through the portal with no problem, but when trying to delete I get "This operation cannot be performed because one or more of the relationships between these tables are invalid." Some particulars: The delete button is a container field from another table/file (not the portal source file). The Relationship is keyed on an ID field, but that field is not shown in the portal; the Delete Portal Row script is preceded by a Go to Field[select/Perform] that references a name value field on the portal row. The portal source table has Relationships that also set the "Allow creation of records in this table via this relationship" and "Delete related records in this table when a record is deleted in the other table" checkboxes - so deleting the portal row should also delete rows in that relationship (cascade). Deletion doesn't even work when clicking the "Delete Record" button directly on the DB file. (I've seen on numerous occasions that this particular dialog is unhelpful and I agree - its no more helpful than the Check Engine light in your car). I will also note that this delete functionality DID work in the conversion from .fp3 to .fp5: I can open these .fp5 files in FMP5 and the app works fine. Any thoughts?
  5. Hi, Â I've set up a few buttons than run scripts to send emails out with pdf invoices attached. All is working fine and as expected but I'd like to include an option to add a personal note to the email. Currently I've got it set up so that you click the button to send the email, the script runs and then a window pops up to ask if you're sure you want to send the email. Â I've got the email message populated with data from the invoice but there are times when I'd like to add a note to my standard message. I'm using gmail and couldn't get Filemaker to open gmail in a browser to send the mail so opted for the SMTP route. The problem is that you never see your email, it all happens in the background. Â What I'd like to be able to achieve is to click my 'Send' button in Filemaker and then for my 'are you sure' pop up to include a box you can input an additional message into the body of the email. Â No idea how to go about it though! Any ideas? Â Thanks, Chris
  6. Hey everyone I am pretty much new to Filemaker Pro so I am not sure what is going on. I have a database of around 800 entries and I was cleaning up blank entries. Deleted 19 blank entries. Then went to find duplicates in the database and everytime I click FIND, it will show it is looking in 1 entry which is blank. I go back and click show all and I see my 800 entries and able to scroll through them but when I click find. It looks like it is looking at one entry and not my 800. Hopefully I've worded this correctly. Anyone know whats going on? Thanks!
  7. I have a database with just under a couple of dozen fields within each record. In its current form, only four fields are included in the Tab Order--about a third of the fields are calculated or otherwise don't use keyboard entry so I wouldn't tab to them anyway, and the rest are only used in particular instances. However, there are another three fields that I do enter text into with some regularity; when I do so, it's usually in all three. What I'd like to be able to do is to have two independent sets of Tab Orders--that is, if I'm editing any of the four fields that currently have a Tab Order set, then tabbing switches between the four. If, however, I click into one of the three fields that I periodically need to edit (but don't currently have a Tab Order) then tabbing switches between those three only, until I click back to a different field. I suspect this is impossible (at least, I don't see how in FM 11, which I currently use), but I thought I'd check, as well as see if there are any esoteric options.
  8. Hi, We have a FMP Server 11 and a FMP 13 version. We cannot upgrade the FM Server 11 to 13. We need to get FM13 data into the FMServer 11. Are there ways to accomplish this ? - Export records script from FM13 - ODBC connection between FM11 and FM13 ? Thanks for looking into my question.
  9. Windows 7 printer settings, when I choose Page Setup manually it works, when I restore from script it works when I choose default printer, but not if the printer in the restore is not the default printer, what to do?
  10. I'm getting the attached error messages when trying to modify records in a file. It's appears as though there is some protection in place, privilege sets etc, but there isn't and never has been. I've tried recovering the file to no avail, is there anything else I can try? I haven't accessed this file in approx. 6 months, but have never had issues before and I'm the only user of the file.
  11. Hi everybody: I have a product drop down list that shows all products for a certain supplier when making a new order. The list changes according to the supplier of the products. This is easily done by indicating who the supplier is in the products Table and making the appropriate relationship. Now, I want to shorten the list by eliminating obsolete products (I need to keep history, so I can't simply delete the obsoletes from the products table) The products table has a field which I can click when a product becomes obsolete. My solution (it works, but I don't like it) is adding a field called obsolete in the purchase orders table, which is automatically set to "no" and I added a second relationship for the value list, so that if product is obsolete, it is no loger valid via the relationship. Any ideas of a better way to do it? Thanks Carlos
  12. I have a vertical solution that is designed to fit on screens that are 1024 pixels in height or higher. I have a client with several computers that have resolutions of 1080 pixels in height, but our solution does not fit correctly. The FileMaker window is maximized and if I run the function Get ( WindowDesktopHeight ) it returns 641. Has anyone ever seen this before? Is there a fix for this problem? OS: Windows 7
  13. Hi, I have FileMaker 11 and I created a interface to pull data from my website's sql. I am able to change the name of a product, but I cannot change the price of the mysql table through the FM 11 interface. Is there something I miss doing? I am using odbc to connect. Thanks.
  14. I'd like to keep the user on the currently selected tab even when the user leaves for another record. I have a script that identifies the currently active tab and another that restores that tab state. I can trigger the latter via layout script trigger "OnRecordLoad" but how do I trigger the "memorizer" - even when no changes have been made to the record? I am on FM11 so I don't have access to the new Tab-script behaviours.
  15. This could very well be a very complicated question, but I'm hoping that someone with far more knowledge than me will have a quick answer to this issue. I have created a financial database that I use to display my boss's financial information via different reports. Let me first say that I KNOW there is a better way to do this, but I have managed to make this work for almost five years, so I'm just looking to fix this one issue, not restructure my database. No question about the fact that I probably did things the hard way. Oh well... I use this database file only for the current year. I generally make a copy of the file and then erase prior year data so I can start fresh. However, some data must remain in the database, like budget information. I enter the actuals on a monthly basis. I have one report that is called "Cash Flow Summary" that is mostly portals used to display the relevant data for each month. Each month remains blank until the data for that month is added to the file. However, when I generated this report for the first month in 2014, it found data for future months that doesn't exist in the current file, and some fields that are blank when there is data to be displayed. I have compared this report structurally with prior years to see what I may have done wrong, but everything looks identical. I even compared prior years that worked to other years that worked and cannot see where I'm going wrong in 2014. They all look the same structurally. As an experiment, I made a copy of the file so I could erase EVERYTHING and see what happens with this report. The Cash Flow Summary report is still pulling data from other sources even though the file is empty of records. I just don't get it. I tried to attach the file, but it says I'm not permitted to upload this type of file. I'm not sure how I am going to get assistance if I can't provide the file for someone to review. Anyone who can offer a suggestion here will be greatly appreciated. Thanks in advance for your time and assistance.
  16. Hi all, I have a filemaker customer database and one layout includes a webviewer to display the map from google-maps for a customer's location. While the map is displayed perfectly in browse mode I am having the problem that when I print the record or enter preview mode, the content of the web viewer is blank. I have fiddled with all options in Inspector but I cannot find a way around this and am finding it very challenging! One time only, for no apparent reason it displayed correctly in preview but since then nothing - Is this a known bug? Any help would be very greatly appreciated as I'm getting ready to tear my hair out.... :-/ I am using FM Pro Advance 11 on Mac OSX 10.7.5 and this is the custom code I have in the webviewer: "data:text/html, <style type='text/css'> html,body { overflow:hidden; } </style> <html> <head> <title>NavText</title> </head> <body bgcolor='#FFFFFF' TopMargin='0' style='border:0'> <iframe width='" & GetLayoutObjectAttribute ( "WebViewer" ; "width" ) & "' height='" & GetLayoutObjectAttribute ( "WebViewer" ; "height" ) & "' frameborder='0' scrolling='no' marginheight='0' marginwidth='0' src='http://local.google.com/maps?q=" & DATABASE::Street 1 & "," & DATABASE:City" & "," & DATABASE ::Postal Code 1 & "&amp;output=embed&iwloc=0&z=17'> </iframe> </body> </html>" regards, Jeb.
  17. Could use some help hunting this down. I have a relational database with one table containing 3 primary data fields to find records including a status which is Pending, Active or Complete. The other selection fields are Activity, Project type, Program type. When the found set selection is status is Pending and Program type is Emergency Repair, a phantom record is created which I can delete. If I add the Project type to the find, no phantom. If I add the Activity to the search, a phantom is created. When I search for Pending on all other Program types in the database, there are no phantoms created. It is only for this one program type, Emergency Repair. Once parameters are met to switch the record to Active, there are no phantom records created for a search for Emergency Repair. Only when in the Pending status for Emergency Repair. Baffled. Ideas? Thanks, Dave
  18. I am modifying the Invoice sample that comes with FM to provide some basic Inventory management functions. Works pretty well. However...I really need to be able to order a product in 2 ways : (1) (Kit - ISBN) and have that deplete and ship all of the parts that make the kit. (2) as individual pieces) For example: Kit 1234 (includes) 3 of part 2234 5 of part 9987 1 of part 097 Someone might order Kit 1234 PLUS an extra 9987. Make sense? No clue on how to connect them. Thanks in advance File Maker Jedis.
  19. Dear all, thanks for reading and thinking about this post. I observe a strange behaviour of my supercontainer plugin in filemaker 11 when used in IWP. Either I´m totally blind what error I created or there is a general problem with my use of the plugin. Any help would be appreciated. The plugin is used for uploading files to my database on the server. This works fine using FM-clients and IWP; the folders are generated properly and the files are deposited correctly within the folders. The general structure where the files are deposited is: ....cal/SuperContainer/Files/supplychaindata/Bestellung/" & ID_Bestellung So far so good, Using the SCGetinfo command I created a function which checks if a file is uploaded or not and which also generates a hint in a different layout that there is a file containing additional information to an entry (I tried "isempty" and comparing the "lengths" of returned strings, both functions work fine in my FM-client. However, the same functions which return a result in FM-client just shows a "?" in IWP. All following calculations don´t work since the "?" is returned no matter if a file is uploaded or not. In contrast, the same database and functions work fine if accessed directly via FM-client. Does anybody have an idea what happens here and what I´m missing ?? Any help would be appreciated JZerweck
  20. I and most of my clients are still on Windows 7 and Windows Server 2003. I have several FileMaker executable files (solutions) developed using FileMaker 11 Advanced. Will these run on Windows 10? Will the Windows 10 compatibility mode (i.e., Windows 7) run these files? I don't have a Windows 10 machine to test.
  21. Hello,  I have a similar problem like this one: http://fmforums.com/forum/topic/88460-blank-sc-fields/  - FM database running on FM 11 Server Advanced - Supercontainer 2.864 - Customer using Win7 64-bit Home with a Fm11 client  After some refreshing or flipping through layouts the webviewer field start to become white and then black. Other customers on different platform (OSX, Win7 Pro) don't experience this. After closing and re-opening the database on the client the images show up again, only to disappear shortly after.  It seems this also is the java caching problem...  Screenshot is attached.  Any help would be greatly appreciated.  Regard, S. Steinfeld
  22. Hi, Â I've created a layout that uses 2 images to act as buttons running scripts. The problem I have is that the bigger my database gets the slower it is to navigate and it's due to the images. Â I've attached a screen shot of my layout. The images are on the far right of the body section. They're just very small jpgs. Â I'm guessing filemaker is loading this image for every row (rather than once and repeating) so does anyone know of a technique I can reduce the load I'm putting on the file? Â I've set up a few filters to reduce the list to the most recent/relevant records but it can still be a bit laggy. Â Using Filemaker 11. Â Thanks, Chris
  23. Hello Fellow Filemakers! I have a IWP solution which is working well apart from a couple of issues with Portals. I have discovered that the "Go to Portal Row" does not work for IWP which is a headache for my users as they are often working with over 100 records in the portal I am referencing. So the problem is the portal resets to the top after my users interact with the records. I am thinking of adding two fields "Initial Row" and "number of row" and using the filter option on the portal to display the records the user specified. But I am drawing a blank on how to achieve this. I've done date range filters in portals and am thinking I want to employ a similar strategy. If anyone could shed some light on this request I'd really appreciate it. - I've got Admin staff putting pressure on the big wig to replace my Filemaker solution with a boxed product so if I can get this solution working it would really help me out. thanks Jordan
  24. I create a sales ticket in FMP11 and then print the sales ticket out for my customer. I have a layout for the sales ticket. I'd like to be able to give my customer the option for me to email this sales ticket to their email address. I already have a field for their addredss in my layout. How can I email a one page form? I use Windows Live Mail 2011 on a PC.
  25. What is the optimal setup for hard drives, RAM, processors to maximize performance for a growing database running on FM Server 11 and FM Pro 11? We will have about 20 onsite clients, 10 VPN clients and 5-10 iPad clients maximally for the next few years. We are sticking with Mac and looking at either a top end mac mini server or investing bigger in a mac pro tower. We are running on a mac pro tower purchased 2 years ago and seeing serious dragging during busy work days. we have 2.66 GHz Quadcore with 6 GB ram. solid state hard drives worth it? how much RAM is too much? is it worth buying the top end 12 core "westmere" processors? We can afford to go there but I would prefer to use our money on database customization and enhancements. Should we stick with our existing machine and juice up the RAM and add a faster hard drive? Any perspectives or advice welcome.
  • Create New...

Important Information

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