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
    • 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 107 results

  1. 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
  2. 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
  3. 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!
  4. 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?
  5. 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.
  6. 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.
  7. 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
  8. As shown a while ago the "unexpected feature" still exists: Erratic movements part2 the "old" example can be seen here: Erratic movements part1  
  9. 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
  10. 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.
  11. 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
  12. 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?
  13. 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!
  14. 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)
  15. 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
  16. 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
  17. 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
  18. 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. 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?
  20. 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.
  21. 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.
  22. 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
  23. I need to have a link in each record in my database that goes to the corresponding link with the pdf.
  24. 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...
  25. 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.
  • Create New...

Important Information

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