Search the Community

Showing results for tags 'fm12'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 15
    • FileMaker Server 14
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • 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

Blogs

  • 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

Categories

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

Calendars

  • FileMaker User Groups

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. 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. 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. 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. 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.
  8. 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
  9. 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.
  10. 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...
  11. 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!
  12. 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
  13. 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.
  14. 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.
  15. 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
  16. 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
  17. 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?
  18. 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
  19. 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
  20. 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.
  21. 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?
  22. 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.
  23. 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.
  24. Hi all and thanks for looking, I've got a container field to which I drag & drop references to PDF files as a sort of library within the database solution. It is formatted as: -reduce or enlarge image to fit -maintain original proportions ON -Interactive content The referenced PDF files are stored on the same remote machine as the .fmp12 file. The problem is sporadic crashing of acrobat within the container field. Either when dropping a new PDF file into the container or when trying to view one in the container. Less frequently, the problem leads to a lock up and crash of the Filemaker software. Has anybody else experienced this problem? Any ideas? Thanks!
  25. 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.