Jump to content

Search the Community

Showing results for tags 'fmp12'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

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

  1. FileMaker Coaches' Corner-Tip 8-Converting from fp7 to fmp12-FileMaker-FileMaker Experts Download the free PDFs to see FileMaker’s documentation: http://bit.ly/2nSg7BM Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,R
  2. I have a car rental solution and for rental of short term one to two weeks i just need to create a new record one by one which will appeared in my calender View layout via Portal. In case, the customer decided to take the car for one year, i can't create 365 new records, It their any possibility to create 365 records automatically by selecting Start Date to End Date? Thank you.
  3. I have 3 fields and the first field is Amount the second field is Deposit and the third field is Balance. Generally my calculation should be Balance = Amount - Deposit If i insert the Amount, example $100 and the Balance automatically changed to $100. I need the Balance remain empty unless i insert a number in the Deposit Field. In my outstanding due report, if their is no Deposit, the Balance field should remain empty. Any help.
  4. Hi, In an existing solution one of my client my client has requested to add a field name ‘Item Movement’ (e.g. Best-seller, Fast, slow) and this should be based on a formula per product item and linked to 'Stock re-order level’ field. For example, if product A reaches ‘Stock re-order level’ in less than one month, it is categorized as ‘Best Seller'’. If Product A reaches ‘Stock re-order level’ in 2 months, it is categorized as ‘Fast’. If Product A reaches ‘Stock re-order level’ after more than 2 months, it is deemed ‘slow’ Since it’s depend on a date, I found it a bit complicate
  5. Hello All, Recently, my company installed FM server 15 after much begging. The database that my group uses (built in FM12)is hosted on a laptop (running FM12) and I'd like to upload it to the server using FM . I cannot figure out how do do it; there is no "Upload to Server" option, and I'd rather not do it manually. If anyone has some guidance, I'd really appreciate it...
  6. I have a field, ‘CRM Category’ (I.e. Diamond, Gold, Silver) for B2C End Customer – and another field for Total purchase over last 3 months – Calculation - If customer purchases for Rs 10,000 over last three months, a Diamond Customer, If customer purchases Rs5,000 over last three months, Gold customer. If customer purchases less than Rs5, 000, silver customer My question is for the calculation of the Gold customer as for the Diamond i will use the grater symbol and for Silver the less symbol. Case ( Total_Revenue < "$10,000" ; "Diamond") Thank for your help
  7. I have a stock module with two fields one Stock Re-order level and one Item Movement. Based on the item sold i want the item movement to be changed automatically for example: ‘Item Movement’ (e.g. Best-seller, Fast, slow etc.) should be based on conditional formula per product item and linked to 'Stock re-order level’. For example, if product A reaches ‘Stock re-order level’ in less than one month, it is categorised as ‘Best Seller'’. If Product A reaches ‘Stock re-order level’ in 2 months, it is categorised as ‘Fast’. If Product A reaches ‘Stock re-order level’ after more than 2 months, it i
  8. Here is a demo of how easy portal sorting can be done in FM12. This demo uses the calculation that Tom Fitch provided a while ago with his portal sorting technique but one can use the PositionValue custom function as well. Portal_sort_fast12.zip
  9. Hi, I need some help with a little problem that I have found repeatedly. I attach one image of one of the cases In the first table, I have a ProyectoIdFk (Proyecto Foreign key, to relate the values in this table to another one, the projects table), an Id field which is a unique number for each row (or specifically, an addition. A value added to the initial value of the project), TipoAdicion (Addition Type) that could be either Obra (Construction) or Interventoría (Oversight), ValorAdicion with the value of each addition and c_ValorAdicionesOBRA (Calculation field to add up all the
  10. I am using FMP12 on OS 10.11.1. Each time I select any object in the relational graph everything within the relational graph disappears until I release the selection button. Objects do not disappear when selecting the relationship icon. I haven't found any other discussions about this problem on fmp12 on mac. Does anyone know of any solutions to this? I am not experiencing any other issues.
  11. Hello Everyone. We just applied a SSL certificate that "originated from a certificate authority supported by FileMaker." We checked off "Use SSL for database connections" and restarted FMS 14. What we found was that the Mac clients running FMP12 can't see or connect to any hosted databases. The odd thing is that the Windows 7 machines connect without a problem. The macs are running Yosemite and we have tried uninstalling and reinstalling the software w/o any luck. Re-install process was to install the base 12.0 software, followed by the 12.4 update for Mac and then the security update that was
  12. Hello everyone, The office that I work at currently has Filemaker 12 Pro and the the 12 Server; however, recently, we have made the decision of upgrading to both 14 Pro and 14 Server. Before we bought the actual server and the licences, we wanted to test out the trial version of both. We set up a server machine for the 14 Server, and downloaded the 14 Pro Trial on both the server machine and a client computer. We have tried hosting our current databases with the fmp12 extension on the 14 Server Trial, but we are having great problem with this. To be honest, I don't have any experien
  13. We operate a FileMaker-based event registration system that communicates with a SQL back end. Our customer will be using it for two demo tours they are running, 1 in France and 1 in Germany. Both tours run from April 2016 – June 2016. They have their events on Friday, Saturday and Sunday and we are looking for help providing on-call phone support during their European hours of operation. I don’t have their exact event schedule yet, but each tour will have 8-10 stops – occupying most weekends April - June. The tour staff speaks English. Preregistration records are downloaded from the SQ
  14. I'm designing and working with my first Filemaker database using Filemaker 12 Advanced and Ipads using the Filemaker Go app (self hosted). I am having issues with random records going missing from the whole database (in each table and TO). There is no evidence that the record was ever in the database at all and this only happens every once it a while and is not restricted to a single Table; it happens in multiple tables, randomly, with no correlation between the instants. I would say 1 record in 50 goes missing daily. I have 9 main tables that are connected with a key. Each table has TO of ev
  15. Hi, I have a DB I'm working on and I'm stuck on something that I think will be pretty simple but I cant seem to get my head around it. Its for a school, so you have courses,locations,students etc. Students can take many courses at many locations. So I have a course layout, with a portal to the participants. This works well apart from I cannot get to open the related record from the portal without it showing me all of the records relating to the student in question. I need to create and reprint a certificate for each student \ course. I have created a button on the portal row to open anothe
  16. I have a stacked bar chart based on two records in a found set, one for each year, tracks productive vs non-productive wages. Linear scale with minimum and maximum values set. when I use auto ticks I get 15 values from 0 to 50,000,000 when I select any other value for the number of ticks I get all the labels overlaid on each other at the 0 line. Any suggestions about what I am doing wrong?
  17. I have a report that shows a list of products. Sometimes it's 2 products, but sometimes its as much as 15. Is there anyways i can tell a portal to show across 2 columns? or setup a 2nd portal that reveals whatever is not shown in the first portal?
  18. Hello I have several db which we use to edit films Unfortunately each clip has more than one names according to the various people who looked at it hence the original clip name field is no longer available I wonder if it is possible to create relationship smething like a "conditional relationship" (if this is the proper way to call it) I have a Main DB with every various fields. Each field has the various names assigned to the original clip If I want to relate DB2 to Main DB is there a way so I can conditionally create the relationship In other words DB2 will relate to The MAIN DB if on
  19. Looking for feedback on early build beta release of a schedule creation database I'm working on. The basic idea is this: Many industries uses 'repeating' schedules to accomplish projects. Every time they do a similar project, the same set of steps needs to occur and they can be stored in a template. The template contains all the info needed to build the schedule except a key date. When will the schedule begin or end. From there, the template can count forward or backward and create all the right tasks on the right dates, perfect every time. My initial goal is NOT to provide an all-in-once
  20. Here is a demo of conditional value lists using FMP12 and ExecuteSQL. In the demo there is one sample of using straight text and another using IDs instead of the text. There are no relationships between the user interface and the tables of values. ConditionalVL_SQL.zip
  21. Hi All, Just wondering if anyone has created a ScriptMaster module using the iText library before? I'm needing to create a PDF Splitter and Merger in filemaker, so if you have any advice too, shoot!
  22. Finally getting a chance to play with fmp12. in Inspector, position, I used to have the choice of inches, centimeters or pixels. In fmp12 the default choices are inches, centimeters and what I assume are points. Are pixels gone? I am guessing they probably are because of retina displays doubling up on the resolution, but I would like to know for sure.
  23. Hi all; I made a 1 Mb filemaker abc.fmp12 file which I want to sell. User may download filemaker GO 12 from AppStore. I send the file to user by email. But it should work on only 1 IPAD (in windows it was possible with HDD serial number look plugin). Any ideas ? how to make my software copy protected ? Do FileMaker can look iPads Serial Number? Best Regards
  24. Hi, it's probably very easy, but I don't know how to access the data inside of a container field. I have a script that inserts a small text file (insert, no reference) into a container and all I can see is a file icon with the filename. When I use «GetAsText(ContainerField)», I only get the filename. But how can I access the data inside of this container/file? I need to perform a couple of text manipulations and store the results in another field of this record. Thanks so much for any help. Gary
  25. Hello, I'm using ScriptMaster to combine two PDFs. I can combine the two PDFs just fine if they do not contain any form fields. As soon as I use a PDF that contains form fields, I receive an error that the two PDFs were unable to be combined. I've encountered this on FMP12v3 running on OSX 10.6.8 If you need additional information from me, please let me know and I will provide it.
  • Create New...

Important Information

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