Search the Community
Showing results for tags 'FM9'.
-
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
- 2 replies
-
- custom function
- calculation
-
(and 1 more)
Tagged with:
-
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 downlo
-
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
-
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.
-
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 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 bil
-
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 t
-
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 t
-
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/3
-
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!
-
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 jus
-
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!
-
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 matc
-
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.
-
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 fi
-
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.
-
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.
-
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
-
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
-
Is there any problem running a FM9 application in Windows 7?
-
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?