Jump to content

Search the Community

Showing results for tags 'fm12'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • 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
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing


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

Found 109 results

  1. I have FileMaker Pro 12 installed on four computers on my network, and FileMaker Pro Advanced 12 stored on a fifth computer. There is a shared database stored on one of the first four computers. When using the shared database from the fifth computer and I attempt to check any of the checkboxes for the field Events, I see the message shown in the attachment and I am unable to check the checkbox (This behavior occurs only on the fifth computer). If I then do a search, after doing the search I am able to check any of the checkboxes in the previously problematic field. I've restarted the fifth computer and the problematic behavior stills occurs. Any suggestions?
  2. Creating a Virtual List Report

    Hello Forum. I had some basic questions (for starters) about a report I am trying to create: 1. Can this type of report be created? 2. Can you point me in the right direction. I have the following tables: People connected to both Readings and Sessions with the usual primary key-foreign key relationship People-----------<Readings -----------<Sessions I would like to generate a report for a person, with 1 Reading record, then Session records after that Reading record timestamp, then another Reading record, etc. So basically it would look like this: Person Name August 1 9:00:00 am (Reading record) August 2 10:00:00 am (Sessions Record) August 3 10:00:00 am (Sessions Record) August 4 10:00:00 am (Sessions Record) August 5 10:00:00 am (Sessions Record) August 6 9:00:00 am (Reading Record) August 6 10:00:00 am (Sessions Record) August 7 10:00:00 am (Sessions Record) August 8 10:00:00 am (Sessions Record) August 9 10:00:00 am (Sessions Record) I've researched and used the VL technique, but didn't see an example that matched this. I could do it with 1 Reading record and multiple Sessions records, but not multiple/multiple. If it is possible, I just don't know where to start. I've considered another TO where all the records reside, basically creating them in the order I need them for the report, but that's more like the VL. If I want them all to line up it would be easier, or do I just do a VL report, and as I'm appending the records, if they are Session records, just add a tab space? Just need some pointers. Thanks Steve
  3. I have a business unit within my company for whom I set up a quick time tracking database about 6 months ago based on the time tracking system that my business unit has been using for years. After their "pilot" usage, they sent me back this graphic of what they want the interface to look like. It's a spreadsheet. Really. I'm super frustrated. I don't even know where to post this. I don't know why they don't just use a spreadsheet if they want a spreadsheet. What I would like to do (after my top 3 completely unprofessional responses) is either refer them to an existing product that someone has already developed that looks like this OR find out if there's a relatively simple way to set up something like this in FileMaker. Did I mention this is all a "favor" that I'm expected to do at no cost, and aside from my normal workload? Right now I can't even begin to wrap my head around how to do something like this. One record with the Project, Task, Notes, and then one field per day of the week for hours to be entered? Grateful for any suggestions!
  4. I am examining a demo file. The field SportName uses a curious auto entry calculation. Let[Trigger=SportCategory;""], where SportCategory is another field in the same table. What's the purpose and what does it mean? Being auto entry, I thought it only effected new records.
  5. Open URL

    I have a script that is supposed to open a URL. Instead, it opens a folder on my desktop. Two script steps: Enter browse mode; OpenURL. The field that the script uses is a text field and contains the web address that starts with http://. Why should it be opening a folder? I can't find a setting anywhere to control this.
  6. Select Entire Column

    This should be a easy one to answer... Recently imported an excel file and all of the formatting was off. Looking at the table, I need to select everything in a field (column) so that I can center every entry in the column. How do you do this? I tried selecting the top entry, hold down the shift key and then select the bottom entry, but that didn't work.
  7. I'm using FileMaker Go version 12.0.8 for iPad to run a database created using FileMaker Pro 12 Advanced. After collecting several days worth of data and backing up daily with no problems, I suddenly lost a day's worth of data while attempting to transfer the data to my laptop via iTunes. I could see all of the data on the iPad, but after trying to save to the laptop, all of the most recent data I collected disappeared. It's as if the most recent data was never saved on the iPad and was lost during transfer to the laptop. The only thing I can think of that might be related to this problem was an update to the iPad operating system (to version 8.4 (12H143)) that I performed prior to the last day of data collection. Now I am very nervous about using FileMaker Go to collect additional data for fear that the data will be lost. Anyone have any thought about what may have caused this or how to prevent it in the future? Thanks very much. Casey
  8. I need to print labels for items (products), and the number of labels (copies) for each product is calculated in a field of the database. Each record calls for a number of items to be labeled with specific instructions for packing (date, location, etc.). For example: Record 1 calls for 3 items type no.1 Record 2 calls for 1 item type no.2 Record 3 calls for 7 items type no. 5, and so on... I have duplicated the number of records in a separate database just for printing, but is so tedious (I have to process one record at a time) and is error sensitive. The databases I work with, generally have between 200 and sometimes up to 2,000 records (or more) per database. And each one can generate from 200 to 5,000 labels (or more), that's why I'm looking for a more convenient solution. Any ideas are really appreciated.
  9. Hi! I am new to Filemaker, but have done several hours of tutorials and was pretty confident when I started to build a little portal yesterday. Essentially, my portal needs to act as a portal on an Invoice layout, where the user can add a certain quanity of specified products to a invoice list, which is then summed at the bottom. My first try did not work, but I found a fantastic little example Filemaker Pro file that seemed to work perfectly (admittedly, it was Filemaker 7), but its portal included fields that could be edited with the number of the product, which then populated the price further along on the line, and the user was expected to enter the quantity. What I need to do is exactly the same, but with materials and components. I think the relationships are the same and I have been very careful in setting them up with a join table between materials and components. But even when I COPY the portal from the example file to my own file, something gets lost and the nice little fields that can be entered data into are not visible in Browse mode (even after I change the table references to the appropriate name). Would someone mind please having a look at the example portal on the Invoice layout of the attached file, and telling me what on earth I am doing wrong? I have been meticulous in checking that the settings are consistent, but I must have missed something. (Ok, now this system won´t let me upload the fmp12 file, despite the fact that it is only 246KB in size.) I will post this message and then see if I can figure out what the problem is with the upload...
  10. Hi, I am sure my if statement should execute as 'true', but it is not. I am on a table called SALESINVOICES. I want to check how many SALESINVOICELINES (ie, the products attached to the invoice) qualify for a special. My 'If' statement is: $CorS = "C" and ( SalesInvoices_SALESINVOICELINES|CompanyID|fqualifiestoptenspecial::s unique no products count customer ID = SalesInvoices_PRODUCTS|toptenproducts::z_FoundCount ) where SalesInvoices_SALESINVOICELINES|CompanyID|fqualifiestoptenspecial::s unique no products count customer ID is a summary field counting the total of lines that have flagged as qualifying for the special, and SalesInvoices_PRODUCTS|toptenproducts::z_FoundCount the found count of products that qualify for the special, and $CorS is a variable that shows whether a store is a customer or shipping store. Before this If statement runs, I put a Show Custom Dialog to check whether the fields are definitely giving me what I expect of them. The dialog box shows: $CorS & " " & SalesInvoices_SALESINVOICELINES|CompanyID|fqualifiestoptenspecial::s unique no products count customer ID & " " & Count ( SalesInvoices_PRODUCTS|toptenproducts::a_c1 ) & " " & SalesInvoices_PRODUCTS|toptenproducts::z_FoundCount and the output is: C 12 12 12 So I believe the If statement on the following line should execute, as $CorS = "C", and the other two fields are identical. Is there some other problem - will it not work out the summary field correctly in the If statement? Any help would be appreciated, it is driving me crazy!
  11. Portal TimeStamp Problem

    Hi, I set up a child table for "Notes" with Time stamps and used four different portals to bring them into the layout of my main table. For reasons that I cannot figure out the timestamp is not working correctly. I have tweaked the settings to no avail. After the first attempt, I decided that it must be related to the duplication of the time stamp for each notes field. So I set up independent time stamps for each field. I am starting to think that the problem may be that I can only have one time stamp per table. here is a screen shot of the layout. http://prntscr.com/5y5kcj and screen shot of table view. http://prntscr.com/5y5njr Thanks for advice
  12. Hello, I am trying to think through a relational database involving medieval maps as linked to manuscripts. I have set up the manuscript end of the database. What I am trying to figure out is whether or not I should make the maps in each manuscript relational or not. Each manuscripts comes with on average 21 maps but these can sometimes be missing, so the numbers can fall. Some contain only 1-2 maps and others no maps at all. On the other end there are a few manuscripts that contain 100+ maps and images. There is in other words, no steady amount. If I had to pick a fixed number I would opt for 21 since those are the map manuscripts that I work with the most. I could set this up as a flat database with container options for 25 maps and info for each one repeated and then fill in those as needed according to each manuscript. But my better sense tells me that I need to make this relational and set up the maps in a separate database and link them. Then the question is do I need one separate database for all the maps or one for each type of map. So, for instance, there are world maps, maps showing the Mediterranean, maps showing North Africa and Spain, etc. It would be useful to be able to search for all maps of the Mediterranean or the world across all manuscripts but this is not essential because I am also a Lightroom user and I can tag my images to create collections of maps. My own experience with FM databases varies with the decades. (My skill level should read Beginner not Intermediate) Back in the early days of FM (FM4) when it was owned by Claris (yes, I go back that far) I designed a super complicated manuscript-map database. Then I stumbled over the lack of a big container field for notes so I ended up used printed copies and hand-filling out the data. Life, research, teaching, deprived me of time to work on this again. I bought FM12 ran out of time and now we have FM13 and I cannot afford to buy the upgrade. So I have to do this on FM12 and limp along until FM14 comes out. At which point I will spring for the upgrade. It sounds odd to say this in 2015 but I really love those delicious container fields that can now even take a pdf. Wow! Thanks for any advice on this crazy complicated database for a poverty-struck academic who cannot afford to hire a professional to help her out.
  13. Hi, I have noticed that FM13 is backward compatible. I designed a test data base with FM13 and was able to open it in FM12. Is this deliberately built in because some clients may still be on FM12 but the designer is on FM13 Reason for this weird question is that I am testing out a 30-day free trial version of FM13. Given that according to the rumor mill, FM14 is due out soon, I don't want to pay for the costly upgrade to FM13. I had hoped to be able to sign up for the monthly $9 subscription but a call to the FM sales rep clarified that the subscription is only available for those who buy multi license not lowly indivs like myself. I made the mistake of buying FM12 a couple of months before FM13 was released and I don't want to make that mistake again. So I need to hobble along with FM12 as best as I can until FM14 is released at which point I will cough up for the upgrade. What I am wondering is if I should go ahead and design my database on the free trial FM13 with the intention of using it on FM12 until FM14 is released. FM13 has some nice features that makes designing more comfortable. Or should I just stick to FM12 and fully design my database there? What is the opinion of the experts? Thanks in advance for feedback. PS. I mistakenly listed myself as intermediate. I should be listed as Beginner as I have had previous FM experience prior to FM12 way back at the time of FM4 when we didn't have these delicious container fields.
  14. Mac OSX 10.9.5. Today i was messing around trying to get connected to a client's Server via the admin console - in banging around with that I updated Java. At some point I went back to do something else with my local copy of FMPA 12 and it wouldn't launch the app... when I click on it in the dock or the app folder itself the splash screen appears for a bit then goes away.... just like I had quit the app. I restarted the computer, did a single PRAM zap, reinstalled FMPA12, uninstalled Java... all to no avail. All worked fine earlier today. Java could be a red herring in all of this. Any thoughts would be appreciated. Thanks, Mark
  15. Search in Multiple Layouts

    Hello File Maker Community: I am working in a data base with different schools with several layouts. Each layout have different information like Google maps, Websites and data. All different sources of data have a common key (school number) which has been used to create relationships. The solution works well all the information shows as I wanted. However, I want to create a search menu to select one school then all layouts will show for that school. So far I am able to create a search but only goes to one layout, the other layouts show different schools. I hope I can get support to find the solution to have one search for multiple layouts. Best, JEstrella
  16. File Integration

    How does one integrate individual filemaker files? I have a contact management file, a task management file and event management file but I want them to work together to create one big database that works together. Is this possible and how do I go about this?
  17. User input validation

    Hi, Hopefully I've posted this question in the right place! I'm developing a maintenance database (spares) and have came across an issue regarding data input of items. When a user creates a new record (adding new product) there could be different wording of products entered. For example 'lamp or bulb','box or crate' etc. What I want is to prevent duplicate naming of items. I'm thinking possibly some kind of buffer table that would compare say a unique manufacturers id and/or supplier and validate the item name on entry?, meaning if the manufacturer and ID was the same then there would only be a single possible value to enter. Not sure the best way to go about this. Any help/advice would be really appreciated. Thanks Neil
  18. Hi all, Hopefully I 've posted this in the right place I'm new to filemaker and have been developing a maintenance inventory database. I have a 'stock transactions' portal where I can add and remove stock. I am having trouble figuring out how to put a condition on the amount in stock where there can't be a negative amount. So if there is a quantity of 2 items in stock, only 2 can be removed. (if someone trys to take 3 out of stock at the moment, the stock amount would go to -1 for example). Thanks in advance for any help/advice on this issue, I'm still learning so any feedback is greatly appreciated. Thanks Neil
  19. Hello, I need some help on making a form like this one http://i.imgur.com/wCpcHmc.png?1. I have a database which includes the names and addresses of all the people in my community. I have a separate table just for this form and is linked to the "contacts" table by their address. Each record in the neighborhood watch table has the address of each house. Which then shows the name of the people living there by using a portal. However, here is my problem. The form has two separate fields for Adults and Children. Each person has their own record but is not organized well because not everyone wanted to include their age. So they were given these options: Infant/Toddler PreK-Grade 2 Grade 3-7 Adolescent Adult Senior Citizen Special Needs What kind of fields would I have to make to separate the Adults and Children? We can assume that Adult and Senior Citizen are adults. Anything that isn't that is not. So I think I can use some if/else calculations but I'm still not sure. Any help would be appreciated.
  20. Hello.. Some time ago I was getting regular FM crashes.. No error code.. FM just not responding This happens when I am in Edit layout, Layout, and I click.... Set Tab Order !!!! What really works for me NEVER CRASHED AGAIN.. when I want to adjust Set Tab Order Is FIRST... select Layout Order.... then click OK Then Set Tab Order Don't know why?
  21. Copying records in a table

    What is the easy way to have a script copy a found set of records and then manipulate some data in the copied set? Specifically, I have a table that has date field and has a bunch of other fields that basically tell me how much inventory I have on that day. I then want to run a script that will pull the ending inventory on the last date in the table, copy that information and create a new record with a beginning inventory level on the new date (the date the script was executed). The catch is that this has to be able to run using FileMaker go. So importing/exporting the found set isn't an option. Any help would be appreciated.
  22. I have a simple accounting solution that I enter my check book transactions in. I am beside myself trying to figure out how to show my account balance at the end of each day. I acquire the current balance with this formula; Beginning Balance-Summary Expenses + Summary Deposits. My issue is capturing the balance daily. I have tried numerous calculations, all to no avail. I believe I need to write a script to accomplish this. Any suggestions would be greatly appreciated.
  23. I want a privilege set that can create and edit records, but not delete them. However, when I use the "create and edit" setting for a privilege set, it also seems to remove the ability for a user to right-click on a container to add a document/pdf/picture, etc. Does removing the delete ability in a privilege set simply remove the ability to do anything with a right-click?
  24. Hi folks, As a relative newcomer to FMP, I am trying to export some records and am having difficulty..... 2 of the tables in my database are: MANUFACTURER [mName, contact email, contact name] (approx 50 records) PRODUCT [pID, pName, description, price, mName] (approx 300 records) So, a manufacturer makes many products..... I want to export each manufacturers most expensive product, but only the top 10. This is probably quite straight forward, but I just cant quite get my head around it! Any help appreciated. I am using FMP 12 Many thanks Brian
  25. Hi All, I have used FileMaker for YEARS but only for very simple projects (mailing lists, etc.) I'm on version 12 now and we want to container fields for a project. For instance, we'd like to have a file saved alongside each record so the file and the info/status/etc. are never disconnected. We would be exporting these files using scripts at some point in the project. Question: I keep reading nightmare stories about data loss and corruption when using container fields. Are they actually dangerous to use? I want to be clear: these projects would be short-term. A few months of use, maximum. We could close & back up the filemaker project each evening. We also would delete and start over with an empty database every time we get a new project. I can clarify the idea more if that would help -- I didn't want to make this too long. I've experimented with external data fields, but I think they will cause us problems. I'd love to hear about your experiences with container fields that are NOT externally stored...

Important Information

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