Community Forums

    1. Community Articles, Tips, & Techniques

      Member contributions of white papers, articles, tips, tricks & techniques.

      4,151
      posts
    2. FileMaker Marketplace Discussions

      Discussions on submitted files from members.

      119
      posts
    1. FileMaker Pro 14 General Discussion

      General discussions that don't fit in to any other topic centric forum may be posted here.

      29,480
      posts
    2. FileMaker WebDirect

      Present your database online with WebDirect. And support external clients customers on Desktop or even Mobile Tablet Browsers (iPad / Android)

      712
      posts
    3. FileMaker Go for iPhone & iPad

      Mobilize your solution. Discussions on designing your solution for IOS. 

      1,977
      posts
    1. Interface Design Discussions

      Make some Eye Candy, discussions about creating a graphical user interface, design patterns & user interactions, and adding that little human touch...

      3,931
      posts
    2. Layouts

      Topics about formatting layouts & parts for labels, envelopes, sub summaries.

      22,690
      posts
    3. Themes and Styles

      Discussions regarding FileMaker themes and how to modify them.

      307
      posts
    4. 203
      posts
    5. Tab and Slide Control Panels

      Using the Tab or Slide Control panels

      1,151
      posts
    6. Portals

      Portals, how when and where.

      17,982
      posts
    7. Web Viewer

      Everything you need to know about the Web Viewer

      2,335
      posts
    8. Conditional Formatting

      Format & style objects with the power of the calculation engine.

      1,596
      posts
    9. 703
      posts
    10. Value Lists

      Working with value lists, pop up lists, conditional menus, radio buttons, and check boxes.

      13,217
      posts
    11. Tool Tips

      Tips and tricks using Tool Tips

      251
      posts
    1. Security Concepts

      Accounts & Privileges & Passwords. Information you need to know about security concepts.

      7,618
      posts
    2. Intellectual Property

      Discussions in protecting all your hard work.

      377
      posts
    1. FileMaker 14 Server

      Deploy, Configure, Manage a FileMaker Server

      150
      posts
    2. FileMaker 14 Stand by Server Deployment

      For mission critical environments where you must maintain uptime on your primary FileMaker Server. Learn how to deploy and manage a Standby server. 

      19
      posts
    3. FileMaker Server 13

      Deploy, Configure, Manage a FileMaker Pro Server

      1,553
      posts
    4. FileMaker Server 13   (2,795 visits to this link)

    5. FileMaker Custom SSL Certificates

      Discussions and instructions for securing your communications with Custom SSL Certificates from third party Certificate Authorities.

      64
      posts
    6. External Server Authentication

      Configuring and administration of FM Server using Active Directory & Open Directory

      975
      posts
    7. 22,845
      posts
    1. Managing Scripts

      Writing efficient automated tasks with scripts, managing complex business logic, passing parameters, debugging and error trapping.

      53,622
      posts
    2. Calculation Engine (Define Fields)

      Field Types, Field Options, and those wonderful Calculation Functions!

      67,023
      posts
    3. Custom Functions Discussions

      General Discussions on developing custom functions with FileMaker Advanced

      2,683
      posts
    4. FileMaker Query Language or FQL

      Discussions about Execute SQL function, and SQL syntax for your your database logic.

      965
      posts
    5. Relationships

      Creating and developing relationships, creating children, avoiding orphans.

      30,269
      posts
    6. Charting

      Adding charting to FileMaker Pro

      783
      posts
    7. Remote Container Fields

      Discussions regarding remote container fields for FM12 and FMS12

      574
      posts
    8. Finding & Searching

      Using the find mode and or relationships to search or find record sets.

      16,329
      posts
    9. Importing & Exporting

      Getting data in and out of FileMaker.

      22,122
      posts
    10. External Data Sources

      Implementing and utilizing External Data (SQL) Sources (ESS) in your solution.

      4,434
      posts
    11. Advanced & Developer Features

      Runtimes, Design Report, etc.

      6,783
      posts
    12. Reports, Printing & Publication

      You got the data in now you need it out without mowing down a forest!

      11,974
      posts
    13. Custom Web Publishing

      Interfacing FileMaker as a data source for the web. 

      30,508
      posts
    1. The Left Brain

      Complex calculations, advanced scripting and other mind boggling topics.

      9,876
      posts
    2. Upgrading & Migration

      Transition, upgrade, migrate your legacy solutions.

      2,649
      posts
    3. Data Analysis

      Discussions about statistics, business intelligence, data visualization, machine learning, or whatever other flavor of data analysis you want.

      69
      posts
    4. The Separation Model

      Learn & discuss the pros and cons of developing & maintaining the separation of data & schema.

      1,277
      posts
    5. Development Standards

      Explore "standards" adopted by developers. Implementation and documentation. Don't start from scratch.

      1,056
      posts
    6. Relational Database Theory

      Discussions on what makes a database 'tick'. Non-tech background on database design.

      1,216
      posts
    7. Damaged / Corrupt File Problems

      discussions on file related issues and procedures for recovering your files.

      826
      posts
    8. OS Level Database Automation

      Save steps learn how to automate your solution.

      4,743
      posts
    9. 4,072
      posts
    1. 360 Works General Support

      general question for product & service support.

      1,054
      posts
    2. MirrorSync by 360Works

      Discussions about MirrorSync, a FileMaker synchronization tool that links FileMaker Server to FileMaker Go and FileMaker Pro

      869
      posts
    3. SuperContainer by 360 Works

      Discussions on how to implement and deploy SuperContainer by 360Works.

      2,991
      posts
    4. ScriptMaster by 360 Works

      Discussions regarding ScriptMaster plugin allowing you to run Java code directly within FileMaker. Share, compare and discuss your code.

      3,482
      posts
    5. FTPeek by 360 Works

      FTPeek is a Universal Binary FTP Plugin for FileMaker that supports encrypted transfers, scheduled server operation, and uploads/downloads directly to FileMaker text and container fields.

      321
      posts
    6. 360Works Email Plugin

      Discussions on how to implement and deploy Email Plugin by 360Works.

      690
      posts
    7. DocuBin by 360 Works

      360Works DocuBin is a full-featured document management solution created with FileMaker. Please use this discussion area to post any questions and suggestions you have.

      134
      posts
    8. Zulu – FileMaker, iCal & Google Calendar.

      Discussions and support for Zulu, which syncs FileMaker to iCal and Google Calendar.

      92
      posts
    1. FM Starting Point - General Discussions

      Discussions about the FREE FileMaker template.

      293
      posts
    2. FM Starting Point - Bugs

      Report any problems that you experience with FM Starting Point here.

      35
      posts
    1. 725
      posts
    2. Monkey Bread Software (MBS Plugin)

      This plugin by Monkey Bread Software is an essential tool for many development projects. Since it has so many options and features this discussion forum is a way to share your experiences, tips, and suggestions. 

      2
      posts
    3. 2,982
      posts
    1. Professional FileMaker Training

      Find out about professional training courses across the globe from a variety of instructors. Discuss training courses and find the best course to suit your needs. Prepare yourself for certification.

      1,292
      posts
    2. ISO FileMaker Magazine

      Discussions and suggestions with the Editor of FileMaker Magazine.

      302
      posts
    3. User Group Central - Sponsored by FMPug.com

      News and Announcements regarding local user and developer groups. Looking to start or join user group? FMPug can help. Come for the FileMaker stay for the Perks!

      468
      posts
    4. Making A Living

      Is FileMaker development your core business? Discuss the business of being in business or relating to the dynamics of working as an in house developer or in the educational sector.

      1,054
      posts
    5. Shrink Wrap Solution Developers

      Discussions for developers producing and distributing shrink wrap solutions.

      199
      posts
    6. Jr. FileMaker Developers' Forum

      Discussions becoming or working as a Junior Developer in the FileMaker Community.

      23
      posts
    7. 873
      posts
    8. Accounting Solutions

      FileMaker accounting solutions & 3rd party integration.
      (Quicken / QuickBooks)

      223
      posts
    1. FileMaker Product & Service Announcements

      Want to tell the world about your FileMaker related product or service? Post your press, releases and highlights are welcome...

      1,149
      posts
    2. Services for Hire

      Spotlight of our member's products & services.
      Announce your availability to take on that next big project.

      41
      posts
    3. Services Wanted

      Take on a job you just can't handle alone. Post your "Help Wanted" ads here.

      1,208
      posts
    4. Solutions Wanted

      Searching for that ready made solution, perhaps someone else can point you in the right direction

      1,014
      posts
    1. Member Lounge

      Off topic community chatter. Mingle and get to know your fellow members perhaps meet a friend.

      1,934
      posts
    2. Wants & Wishes

      Discuss features that you wish to see in the next version of FileMaker products.

      1,518
      posts
    3. FileMaker Developers Conference

      Discussing the annual Devcon, including travel arrangements and associated events.
      Need to find a roommate?

      132
      posts
    1. FM Forums Feedback & Site News

      News and Feedback regarding this site.
      NOT FOR FILEMAKER SUPPORT

      934
      posts
    2. Site Instructions

      Guides and Tips for participating in the community.

      3
      posts
  • Who's Chatting

    There are no users currently in the chat room

  • Topics

  • Posts

    • SM and iText to Compress PDF
      By David Wikström · Posted
      Just wanted to share an experience...   I know this is just a proof-of-concept, but I've been using this code for quite some time now for my own purposes, and mostly had really good results. I just tried it with a client of mine, who however got some interesting results recently. They noticed that PDFs that actually grew in size with certain factors when the documents compressed contained grey placeholder images with a simple text, rather than actual complex images. It looks like the algorithm used doesn't work well in this case - reminds me of my first image database in the mid 90s when somebody decided to save space when scanning images... I did some testing, and got the following results: Original file: 92 KB 0.1 76 KB
      0.2 72 KB
      0.3 79 KB
      0.4 90 KB
      0.5 98 KB
      0.6 116 KB
      0.7 136 KB
      0.8 151 KB
      0.9 174 KB
      1.0 157 KB It's actually only the uncompressed image that gives acceptable quality even for on-screen use. I'll try to look around myself, but if somebody knows of a better compression algorithm, I'm interested!
    • Extending a flat database to a related ditto
      By MikeKD · Posted
      Mmm.... A few thoughts. Although you have 28,000 CDs, there won't be 28,000 composers.Some CDs will have pieces by more than one composer.Composers will have written more than one piece.So you'll need a third table to join multiple composers with multiple pieces / CDs.Pieces and CDs aren't the same thing, so may be that third table is actually pieces?Though very occasionally, pieces are by more than one composer too (e.g. Posthumous completions)There's got to be a fairly complete table, cvs, xl file of composers somewhere!!28,000?!!!!! OMG.Cheers, Mike Here's a CSV from Yale: http://ycac.yale.edu/downloads
    • The correct ERD
      By comment · Posted
      I am afraid we may be going in circles here.
    • Calculating elapsed time as decimal
      By madman411 · Posted
      That'll do it! You rock
    • Calculating elapsed time as decimal
      By comment · Posted
      You probably meant: end time - start time - break 1 - break 2 + 24 * (end time < start time) which should work, if break 1 and  break 2 are already durations. Why don't you do it all at once, e.g. Let ( [ duration = EndTime - StartTime + 24 * ( EndTime < StartTime ) ; break1 = Break1End - Break1Start + 24 * ( Break1End < Break1Start ) ; break2 = Break2End - Break2Start + 24 * ( Break2End < Break2Start ) ] ; duration - break1 - break2 ) 
  • Popular Contributors