Jump to content

Search the Community

Showing results for tags 'FM9'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • 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
  • 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
  • FileMaker Platform
  • Forum

Blogs

There are no results to display.

There are no results to display.

Categories

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

Found 222 results

  1. I was doing a bit of work for a client who is running FM9 clients, connecting to a file hosted on an FM11 server. I don't have FM9, so was doing development on FM11. I thought I had checked out that everything was compatible, but I somehow generated a calculation that doesn't evaluate on 9, but does on 11. The components of the calculations and custom functions used all appear to be innocuous... I am hoping someone here knows what I tripped up on. Here's the field calculation, and the 2 custom function definitions that it uses. The entire point of this calculation is to take a mish-mash text field that they have and make it sort nicely. For this bit I added, I'm just concerning myself with sorting some suffix numbers that occur between parentheses, e.g. 12345(A-1). Field calculation definition: Let ( [ _fileNum = Files::File Number ; //Position of 1st open/close parens, and then extract the text between them: _sParen = Position ( _fileNum ; "(" ; 1 ; 1 ) + 1; _eParen = Position ( _fileNum ; ")" ; 1 ; 1 ) ; _suffix = Middle ( _fileNum ; _sParen ; _eParen - _sParen) ; //Count the leading digits before any non-digit character, e.g. an alpha, or dash or space, etc. _count = CountPrefixDigits ( _suffix ; 0 ) ; //Remove extraneous characters (dash, space): _suffix = Substitute ( _suffix; ["-";""]; [" " ; ""] ) ; //Pad out the string to min 5 characters (helps 75-A sort next to 75): _suffix = _suffix & Left ( "!!!!!" ; 5 - Length (_suffix) ); //Reverse the character sequence (so the Code() call works out better): _suffix = ReverseString ( _suffix ) ]; _count & Code ( _suffix ) //prepend the digit count, but don't encode that count, just the rest of it ) -------------------- 'CountPrefixDigits ( aString ; aCounter )' custom function: If ( IsEmpty ( GetAsNumber ( Left ( aString ; 1 ) ) ) ; aCounter ; CountPrefixDigits ( Right ( aString ; Length ( aString) - 1 ) ; aCounter + 1 ) ) -------------------- 'ReverseString (aString)' custom function: If ( Length ( aString ) > 0 ; ReverseString ( Right ( aString ; Length ( aString ) - 1 ) ) & Left ( aString ; 1 ) ; Left ( aString ; 1 ) ) Thanks, Justin
  2. Hello, All! I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1 I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories. My question is; Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere! Thank you for your time, Tumma K.
  3. Hello everyone. How can I set the calculated value of field C to the number of records having field A equal to the value inserted to field A and field B equal to the value inserted to field B? For instance with the following situation record 1 => A = "house", B = "pay" record 2 => A = "house", B = "win" record 3 => A = "car", B = "pay" record 4 => A = "house", B = "pay" when I create a new record having A = "house", B = "pay" C should automatically be 2 (since record 1 and 4 have the same A, B. Thanks
  4. Hi everyone. I have a field called documents rendered as checkboxes (values are taken from a value list). Now I need to perform some calculation (basically to set the value of an other field) according to the checked values (number and values themselves). Which function should I use to get the list of checked values? For instance in the situation below: [ ] Book [ ] Magazine [ X ] Journal [ X ] Diary [ ] Paper I wish to get 2 and to get Journal and Diary. Thanks.
  5. I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases. I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases. Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
  6. I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc). Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money). In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac. Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13. Any ideas on how to make this work?
  7. Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records? All of my access privileges and passwords are correct. thanks!
  8. Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade. Does anyone still host filemaker 5.5? Thanks!
  9. Hello, I'm seeking the updater to FMP Developer 6.0v4 on windows platform. Download from FM is no longer available Does anyone still have it? Thanks in advance! Erwin EDIT: "OK, we found it back on an old backup system."
  10. Suddenly, after several years of use, FMP 6 won't open. (this happened on two not-connected computers). I get an error message "The feature you are trying to use is on a CD ROM or other disk not available. Insert FMP 6 disk" When I insert the original disk, it still doesn't work. When I uninstalled and reinstalled the program, it still doesn't work. I also notice that there is no filemaker pro.exe file in the Filemaker Pro 6 directory. There are FM subdirectories and many .dll files, but no .exe Any ideas? And, if this is a dead end, what steps can I take to get my data? 1) would the data import with a newer version of FM? I would rather not purchase 13. maybe a discounted 7 or 9 found on ebay? 2) Is there any other program I could use just to import my data? My database is a very simple address book? Thanks for any advice.
  11. Hi, We are using FMP version 9 and want to do the following Post a simple web form from FMP 9 for our users to enter data. Allow the user to log in through our current employee portal, click a link and access the FMP form. Restrict the user's access to records in the FMP database to only their location. FMP must use the portal login credentials to authenticate them against Active Directory (the SSO part). Sounds simple enough but I haven't used FMP for several years (got into the management end of things). Publishing the form for web consumption is no problem. It's the SSO part that I certainly need help with. It would also be OK for the user to come in as a guest (without having to log in again) as long as the data they see is only for their location. There are about 300 locations that would have access to the form so it's vitally important that the data be segmented for each location. I would prefer to create 1 database for all 300 locations rather than creating 300 versions of the same database. If you can point out any posts that speak to these issues I would appreciate it. Jammer
  12. Hello All! I have a hugh problem. Today it works fine on my XP SP3 but the day I have to change computer I have to change platform from XP to 7 or 8. I have a huge number of registers working together so its no option to migrate those to FP7 format or re-write for FP7 as it would take to long time. Today I work with Shubeck Pdf plug-in which combine several pdfs within my script and put out an email with the pdf as attachment. It works great with ghostscript version 8.5. I have borrough a computer with Windows 7/64 Bit for testing purposes. I found ghostscript 9.01 for windows 7/32 and installed it. Seems to be OK. I then installed Schubeck plug-in but under installation I got an Error-messeage with a lot of 0 and 705 at the end and it tells me that it couldnt found the printer drivers (which must be the ghostscript?). With a lot of work I can re-write my pdf-printing scripts if some other multi page pdf-printer for FM5 is avaible and works on W7/64. I hope some of you have some ideas which can help me and maybe have a plugin to sell. -Per
  13. Hello, I lost my Filemaker Pro 3 CD, but it is still running under Windows XP. Now I want to change to Windows 7. I have an Filemaker Pro 5 Upgrade licence but I still need a CD for Filemaker Pro of a previous version, which I can also install under Windows 7. Does somebody know if it is possible to install FM 2-4.1 under Win 7 and where to buy it? Thanks!
  14. FM5.5 Access Privileges

    I know, why would anyone be using FM 5.5! I have a client that uses FM Server 5.5 and FMP 5.5. They somehow have the access privileges configured to the layout and field level with no groups. This setup also has standard users (by their shared password) set to not be able to edit records in the Access Privileges Dialog, yet they can create new records and edit the new record. I had to add some new fields for them to use. The standard users cannot edit these new fields. They can edit the already existing fields. WTH? I need to have it so a standard user can only edit a new record that they just created but also be able to edit the new fields I just added to the database. They can edit the new fields if I put a checkmark in Edit Records in the Access Privileges Dialog, but then they can also edit records made in the past and the client does not want this but wants them to only be able to edit a new record they just created. This makes no sense to me. Can anyone help? Dave
  15. Hi guys -- I've FM 5.5v1 running on Mac OS 10.6.8. On one of the databases, everytime I created a new field FM would automatically enter it on the Table view but some weeks ago it stopped doing it. The database is around 90 fields so it's not too large. Does anybody know why and how to fix it? Best!
  16. Hello, Am I struggling with something or what! I fear that I'm trying to do too much with FMP9 and certainly more than my brain can handle! Simply put, I want to use a search string to filter a portal. Is this simple? On the Master table I have records of unique reference numbers (think contracts) consisting of an alphanumeric string, at least 9 characters long. On the portal table, I want to enter a string of 2 or 3 (random) numbers, then, (contract-side) perform a Position calculation which determines whether or not the string is contained within each record's reference number. The match and the filter would be based on Position equalling 1 (not 0). Problem 1: the Position calc is non-indexable so the relationship can't be made. One potential solution I've researched is to introduce a ValueList comprised of the record number and the Position calc result, in a self-join, then have the original Master table do a look-up on this TO. The new problem however is that having succeeded in indexing the field and making the relationship work, the indexing needs to be refreshed each time a new search string is entered... I'm into three tables and two more TOs currently. Constant fiddling and tweaking in an effort to fix the problems has probably broken more than it's fixed! I'm snow-blind, clueless and currently can't even make a script do this! Has anybody got any suggestions how to go about this more successfully?
  17. Hi all! Does anyone of you run FM 5 on Windows 7 or 8? Do you have plugins from Schubeck pdf? Does it work? -Per
  18. Hi there, I'm currently developing an ongoing solution where I have used decimal times. ie. 1.5 = 1hr 30mins, 3.75 = 3:45 etc. The reason I used decimal was clear to me at the time but now I would like to dispay the resulting calculation in "proper" time format. I could probably nut it out using some convoluted method but was hoping that someone has a more elegant solution. Cheers, Steve.
  19. I have a couple of errors on the server and I am new to Filemaker. Below are three errors that have reported in the event viewer, application logs. 1. File "Promissory Note.FP5" could not be opened: either allow FileMaker Server to host Single-User files or set the file to Multi-User in FileMaker Pro. 2. File "Receipts.fp5" could not be opened: maximum number of files already opened. 3. File "Credit Card Charges.FP5" could not be opened: a database with that name (or the same initial 31 characters) is already open; please rename one of the files. The only one that I could find information about was #3, and it was more than 1 file that I had to rename it was like 20. I just added a 1 to the end of the file name in the databaseBackup folder and those problems seemed to correct themselves (after I did a stop and start of the Filemaker Server service). Not sure on #1 and #2. Any advice on how to resolve these issues are greatly appreciated twells@uca.edu
  20. Hi everyone and excuse me please if I seem ignorant of the inner workings of Filemaker. I stuck together my database a couple of years ago when my brain was younger, fresher and it took me the best part of 2 months !! We use it for writing invoices and creating quotations for my wife's business. It has worked absolutely brilliantly and I think FM is a wonderful bit of software. However I have just upgraded my wife's computer to Mac operating system OS10.7 (Lion) and suddenly a strange thing seems to be happening. This only happens on her computer and not on mine running OS10.6.8. When she uses one of the little drop down calendars to insert a date it begins fine but when the date appears on the page the year appears is in Japanese/Chinese Kanji characters. (I have attached an image of the characters) I have, of course, checked the language prefs etc in her computer and that all seems ok. Anyone else had this problem or know of a solution ?
  21. I have heard from several sources that the FileMaker Pro cache should be set to 256 MB. I would like to heard recommendations on cache size for FM Pro 9 and the following memory sizes: 1 GB 2 GB 4 GB Any help would be appreciated.
  22. Hi, I am having a problem with FileMaker Pro 9 in MacBook Pro (Lion). I got an error message "FileMaker cannot share files because another user is already sharing files" when I started my databases. I have tried all the solutions I could find on the internet, but the problem still not resolved. Any help from you will be very much appreciated. Below are what I have tried. 1. Uninstall and reinstall. (no luck) 2. Set IPv6 in Network advance setting to "Linked-local onlly". (no luck, it is not possible to turn it off). 3. No other copy of FM Pro is running 4. No FM Pro server is running in the network 5. unplug network cable from the computer (still getting the error message) Whatelse can I do to get rid of this problem? Thanks a lot in advance. Chi
  23. Filemaker 9 Bug

    Has anybody experienced a failure within a new calculation of the "Evaluate this calculation from the context of.... " list to update with all appropriate relationships in the relationship graph. My file which started life in FM5 lost its reference to the main table recently, necessitating all new calculations to be copied from a previous calculation, which still had the full list, and then amended. I have partially overcome this problem by deleting the two relationships that remained in the list. Somehow this forced the main table to reappear in any new calculations and a couple of others popped up as well. However, I am still missing about 20 that have been created over time. I would rather not delete these 20 as well and reinstate them because this appears to corrupt relationships / lookups in other files which use this file, not necessarily these relationships. There must be an underlying table that is being referenced and has become corrupted. Any ideas how I might force it to behave, please?
  24. FM9 in Windows 7

    Is there any problem running a FM9 application in Windows 7?
  25. Window - Open Files

    When I open a series of files I find that the majority are neither listed in the Window - Open Files listing nor the Window / Show Window (hidden files) listing. The only practical way to navigate between files is to minimise the one in view, select the other file I need and maximise it. Surely there must be an easier way than that? I wonder whether this is an error on my system or a shortcoming of Filemaker 9 Advanced?
×

Important Information

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