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

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
    • Command Line Data Migration Tool
    • FileMaker Pro Advanced 17
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • 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
    • Member Lounge
  • 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

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 110 results

  1. balooka

    Grouping summary

    Hi I'm currently working on a database where photo's are ordered on a website and need to be managed (via .csv imports) in FM12. This is all working pretty well so far but my problem is with the reporting/summary. The setup is that a FMdb (iPad/FMgo) generates the data that is imported into the site CMS where customers can order specific prints. That works fine. The modified data is exported (CSV) from the CMS and imported into another FMdb, that is related to the initial FMdb (where the data is generated). This second FMdb is the one that will generate invoices and ordertickets and so on. The structure is: VENUE (keyA) -> GROUP (keyA) | (keyB) -> ARTIST (keyB) | (keyC) -> PHOTO (keyC) When I generate an orderticket I use summary sort like: -VENUE -- GROUP --- ARTIST--> PHOTOS Which is perfect! But... If an artist has multiple images and also orders multiple it will list all ordered items like above. So Artist1 order 5 images and I'll and up with 5 lines (--- ARTIST--> PHOTOS). That is fine for the orderticket but not for the invoice (unspecified for a reason). Is there a way to only show one instance of Artist1, where the costs are grouped. So even if Artist1 has ordered 10 photo's of 1 dollar each, it will not list 10 lines, but just one with a value of 10 dollar? If I make a selfjoin on the PHOTO-table I can see in the portal that the amounts are added nicely to one sub-summary, but in the report I have no clue on how to omit all the instances but one with the summarized (sp?) price... I hope this made sense, my English isn't all that Thanks a lot!
  2. Bluorchid

    How to create a portal column

    Aloha I am trying to create a columned portal table. My layout will contain several portals. Each portal will show several fields with the final field being a subtotal. A vertical presentation will be much easier on the eyes and the flow of my layout. Thank you in advance for your time and attention.
  3. iking42

    Centering A Record In A List View

    I have an index LIST with titles as buttons. Selecting a title opens a new window with detailed information in a FORM view. The script that returns me to the index needs to center (when possible) the displayed list on the Last_Record_Selected. This is easly done by forcing the list view record pointer to the last record and then moving to the Last_Record_Visited + an offset value. Works like a charm - except - it leaves the active record pointer setting at the last record in the visible list. I am matching a global Last_Record_Visited field to the actual Record_Number field in a Conditional Formatting statement to highlight the active index record and the record I need to return to and place near the center of the list (when possible). However, the active record pointer is at the + offset record number some distance away. This creates a very dangerous situation since the user may damage this record thinking they are working in the highlited record. Any suggestions on moving the active record pointer back to the Last_Record_Visited value without the list moving? Knucklehead
  4. I have FM12Pro adv and FMServe 12 pro. and Win7. ------------------------------------------------------------------------------------------------------ Trying to perform a CASE and REPLACE but not working so good. I have a Script,which should replace (number) Field "FrUSA" in Database " Allfreights" linking "Shport'fields" both sides. ============= Case( T01_ACCOUNTS::Shport="Houston";"800"; T01_ACCOUNTS::Shport="New York";"1200"; ) ============= (this is just an short example of Shipping ports,total file upto 600+ destinations in same script.) If I make a Trial Script with only one line : T01_ACCOUNTS::Shport="Houston";"800"; then all other destination are set to blank,empty. If I run the total scrips (600+) then only a part of it is updated/replaced, but about half of its fields FrUSA are set to zero (0) Where is the error ?? Thanks for helping me out. Willlaim
  5. Jonah74


    Hi  I'm not sure exactly where this question should be asked on the forum as it's more of a "Can it be done?" sort of query and if so, how, so I apologise in advance if its in the wrong place.  Let me explain. I have created a social car database for a charity that matches elderly and infirm people that need to go to various appointments such as doctors, dentists, hospitals etc. with volunteer drivers. The drivers themselves use their own cars and give up their time freely to the help the charity on various days and times each week. This is all co-ordinated using an FM Pro 12 DB where clients are held in one table, destinations in another, drivers in another and the actual journey held in yet another. When a person contacts the charity needing the transport to their appointment an office co-ordinator selects the person, their desired destination, date and time and selects a driver which is all extracted from the various tables via a journey layout, producing a printout for the driver in advance of the appointment.  What I would like to do is, when the user, (who is coordinating the journey), selects the driver, the database picks the driver automatically from only those drivers who are available on that chosen day and who do not already have a job booked for that time on that day. (However, it should also be able to have some sort of a manual override in the event the driver can't take that particular person for any reason. For example, some of the drivers cars aren't capable of fitting folding wheelchairs in the boot of the car so an alternative driver with a bigger car needs to be allocated.) It would also be good if it could make that driver unavailable for the length of the appointment including the journey time to and from the appointment using and linking the date and time fields that are currently on the journey table / layout somehow.  The driver schedule is currently managed manually using an excel spreadsheet and is very labour intensive as it caters for over thirty drivers. (I've included a screenshot of how this currently looks) but if FM can help me resolve this the graphical schedule could then be scrapped and save admin staff many hours in managing it.  I am guessing this is going to be very similar to a roster database but I'm really not sure how to do this or where to start and whether I could amalgamate it into my existing database. I appreciate I may be biting of more than I can chew and it may need to be done by a professional database programmer but any help, advice, pointers or comments on how to to do this would be greatly appreciated.
  6. Andrew Robinson

    Managing lots of reports

    Our system now has about 30 reports and the way I manage them is by haveing a layout with buttons on it that run those reports. I need to simplify it and its really hard to keep it looking neat and tidy. Ideally I could create a table which I could name each report and give a description and when the user clicks on a button it runs the relevant script. Anyone got any ideas?
  7. how can i increment a timestamp by say 5 min to use in a formula. I.e Get ( CurrentTimeStamp ) < Creation_Timestamp + 5minutes confused on which function to use. thanks jW
  8. 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
  9. ianmorrowx

    web services

    Hi, we have a business management system written on FM12 which we use to run all aspects of our business alongside our web based sales magento platform. The relevant magento tables are integrated with FM12 and data is retrieved and sent via odbc. We want to be able to execute scripts in Magento from FM12 via web services and the fmnexus plug in looked like the best route to accomplish this. However, it doesn't appear to be available any more. Does the 360Works web service manager have the required functionality to allow us to do this or is there any other plug in suitable ? I watched the web service manager demo video and it all seemed to be more about puling data into filemaker rather than pushing from it.
  10. I have a simple database which uses 4 fields as shown below: I have Trailing Subtotals set for each column (except Agent). The problem is that the Totals column does not produce the correct total - it's very close but NOT correct. For example, Pay1 may show $500, Pay2 may show $350, and Totals may show $843.46 instead of $850. I have a Microsoft Access program which does the same calculations correctly. Suggestions greatly appreciated. Note, I'm far from an expert when it comes to Filemaker. Agent Pay1 Pay2 Totals
  11. Hi Guys, I've built a iPad registration kiosk for a client at his business place. Everything seems to be working just fine, but on the last step to complete the registration I need the iPad to print the registration out for the back office. That also works fine, but the Print Dialog box on ipad is un-avoidable according to FileMaker Go Documentation. This dialog throws off most customers and hinders the registration process. I need to find some type of work around for this so customers are not prompted with the print dialog. Also, my client doesn't want to have to have to print manually print each registration from the desktop interface in the back office. This should be automatic. I thought of some server-side scheduled script, but the server is remote, so it won't be able to get to the printer without some type of constant VPN connection to my customer's site. Too much overhead. This seems like too much overhead to maintain. Is there any client-side scheduled scripts? Any other ideas would be great. Thanks!
  12. I would like to have options to enter either fields (selling price or margin) and the other should be automatically calculated for instance: Cost Price = 100 (Available) Sell Price = Calculation field or ?? Input amount Margin = Calculation field or ?? Input percentage If i put 160 on sell price it should automatically put 37.5% in margin or if i put 37.5% in margin field it should automatically fill sell price for 160. File uploaded Login name: admin No Password: Thank you in advanced. TEST.fmp12
  13. Hi I’m not sure where this should go as it’s not really a problem but I do need some advice. Let me explain. Last year I developed a social car database for a local Community Transport Charity that matches elderly and infirm people that need to go to various appointments such as doctors, dentists, hospitals etc. with a pool of volunteer drivers. It was developed with FM 12 Pro Advanced and after some help and advice from FM Forum members during its development, it went live last November. The database works really well and has improved the Charity’s Booking and response times and has increased its efficiency no end. Because of the success of it, the Project Manager for the charity invited me to a Community Transport Forum for the South of England to tell forum members about this database as he thought it would help similar charities. The response from the various members of the forum was very positive with the host of the forum, West Sussex County Council, inviting me to the next forum to demonstrate it. The interest was such that forum members said the system would also be suitable for taxi cab companies, bus hire or other transport solutions who needed a client booking system and that I should be looking on this as a commercial venture. As a direct result of the forum one company asked whether it was possible to see the system prior to the demonstration and after having visited the charity’s premises last week and seeing the system in action, have already enquired whether they could now purchase the system. My problem is I’m not a professional developer and I did this as a project as I enjoyed doing it and it also helped the charity that I’m involved with. I’m also fairly sure there are probably better ways to improve on the way I have designed it so should probably be checked by someone with more skill than me before being released commercially. I know nothing about how to cost this or charge for it, how to license it and how this sits with Filemaker themselves in terms of distribution etc. So my question is: Has anyone else come across this and how do I turn this into a commercial product if the outcome to the presentation in May, is that more companies / organisations want to buy this? I feel I need to be prepared and ready in case this does take off and that I feel comfortable in selling a product that is commercially fit for purpose. Any thoughts, suggestions, help or advice would be greatly appreciated.
  14. I have been searching all over the internet for a solution. I am running FileMaker Pro Advanced 12.0v4 on Windows 7 Professional and can't find out why the "Insert PDF..." option is grayed out and not available. With the Data->Images selected only "Insert PDF..." is grayed out. If I select Data->Interactive content both "Insert PDF..." and "Insert Sound..." are grayed out. If I copy and paste the PDF into the container, I can't open and view it. The PDF software installed on the computer is Foxit Phantom Business PDF. Should that make a difference? Any suggestions? I loaded PDF files in container fields and viewed them in previous versions of FileMaker but can't seem to make it work in version 12. Thanks Mel
  15. Hello World (of filemaker users and developers!), We have been using filemaker for years where I work. Recently, I've been handed a simple assignment for a database app. Problem is this: At work, filemaker 12.04pro (+ server somewhere LOL) and everything else is in the french language. At home I use the english install of filemaker and develop my stuff in english. I've noticed a peculiarity with this platform, that is; the scripting language is the same as in the application's installed language, which is very foreign to me!! In other programming platforms, the instructions & code are pretty much always in english even if your screens will display & handle data in another language So my question is, will my scripts that are written in english port over to the french version, or will I have to rewrite all of my scripts in french? Thank you
  16. Filemaker's official release-notes page for the FM Pro / Pro Advanced12.0v5 updater (weighing in at 750MB,) lists "OS X 10.9 Mavericks" compatibility and "other bug fixes" but doesn't go into any further detail. Anyone have a list of the smaller bug fixes in the 12.0v5 updater? Anyone else installed it yet, and if so, what are your experiences with it? Any new problems or new bugs so far?
  17. Hi All Any one Integrating FM12 to QuickBooks online( I have doubt regrading modify invoice data through FM12? Thanks Ritesh Gupta riteshg@mindfiresolutions.com Mindfire Solutions(India)
  18. NewFM85User

    Upgrading to Filemaker 12

    Hi, I am currently using Filemaker Server 8 for server and Filemaker Pro 8 for clients and Filemaker Pro 8.5 Advanced as developer version. Filemaker pro clients run on Mac OS X version 10.4.11 and Filemaker server runs on windows server 2003 Along with this we use MYSQL 5.1 and Lasso Professional 8.5 We are planning to upgrade our system to latest versions of softwares and want to know Do’s and Don’ts. Initially these were installed by person who has known these software for life time and I am just maintaining the DB for changes and enhancements. This is my first time buying these software and updating them. We are planning to buy new Macs and install the Filemaker clients. We may set up the same windows 2003 server for the new Filemaker server. Any advise and tips will save some time. When I import files from Filemaker 8.5 to Filemaker 11 or 12 , what are the anticipated problems and how can I avoid or fix them. Any help on buying these softwares is much appreciated. Please help.
  19. Hello - I am collaborating with someone in the next state on my Food Pantry solution. He is far more skilled at this than I am to say the least... We're using a hosting service (fm47.###.net) to work together. If he is sitting on a layout and I try to hop on it, FM does its thing and warns that the layout is being worked on, that it's locked and would I like to chat with the person sitting on it. I typed a short message and hit Send. He says he sees the message but cannot reply. We're trying to figure out how to make this work from both ends. Is this a "feature" of FM12 or is it actually a feature of the hosting service? We need to determine who to ask about this functionality. We think it's the hosting company but can't be sure. There doesn't seem to be any sort of UI on the receiving end to reply to an incoming. If this isn't doable, what sorts of things have you experts tried when collaborating in real time with someone somewhere else? I'm on Windows and he's on a Mac. Thanks for listening.
  20. A filed with Numeric format designated to store amount cash dividends paid in currency format. This field, however, for sometime is empty if there was no dividends was paid. But keeping the field empty might be misleading for the user. I decided to replace the empty value with "No Dividends for This Year". Becuase the field is in currency format I can't show the text in it. Is there a way to make the field shows a text if the value is empty without afecting the numeric values for other years that table.
  21. As shown a while ago the "unexpected feature" still exists: Erratic movements part2 the "old" example can be seen here: Erratic movements part1  
  22. Malcolm Garbett

    Connection to SQL Server

    Hi all, Background: Starting a new job where they are using Filemaker amongst other things. Downloaded the 30 day trial. I went to connect to a SQL database but it doesn't appear as a driver. Go to the site and was given a "trial" driver which is for a Mac. Question: On my laptop at home - Windows 7 - where I have a SQL Server (2008 R2) instance running, how can I connect to it from my Filemaker (trial version) in order to import data?
  23. JEstrella

    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
  24. I need to have a link in each record in my database that goes to the corresponding link with the pdf.
  25. Andrew Robinson

    Analyzing Scanned PDFs

    We use an appraisal form which is on paper. People fill in their name and answer a few questions. We can scan them all in in bulk. I want to somehow get the scans into filemaker so people can type them up. Ideally FM would split the questions into different container fields and then data entry workers would each get a question at a time to type up. This way the work can be distributed accross workers. Any ideas?

Important Information

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