Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About mpau

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Filemaker crashes on one of the computers in our office every time we run save as PDF. We've followed the troubleshooting steps on the FM website (throwing out the plist, a test user account). We've also reinstalled adobe. However, the problem remains. I'm wondering if any of you out there have any experience with this issue and have recommendations for a fix. We're using FM pro 12. The computer is a Macbook Pro mid 2009. OSX Mavericks 10.9.2 Thanks in advance for any help with this.
  2. Is there a way to trigger a script after a (portal) field value is committed? All the script triggers seem to run before the value is committed and so any set fields or insert calculations steps refer to the prior field value, not the current, active value. For example, I have a standard invoice layout with line item records in a portal. On the invoice record is a subtotal field. It is not a calculation and so requires a script to update it. I'd like to update this field each time a unit price is changed. Right now, I have it updated by using an OnObjectValidate script with the step S
  3. I've been developing a database for the past few years and been learning as I go. My abilities have been proficient enough to develop a database that does almost everything we want it to. We use ours to manage a retail, wholesale, manufacturing business so records deal with customers, vendors, orders, purchase order, products, parts, shipments, etc. However, there is an issue of speed. Locally hosted, it works fine. (Although now that we've integrated more CRM functionality - including a dashboard - it is sluggish on load.) But we rely on remote access for some of our users and it can get ver
  4. I was under the impression that an auto-enter calculation only triggers on record creation. Is this correct? Or can it be re-triggered? Can you explain your example more to me? Ideally, I'd like to have three statuses: Paid, Partial, Unpaid What I meant about the work around, is that I'd prefer to have the status field live update while users are working in the record and not have to rely on the layout exit or enter script trigger to set the status field.
  5. I'm working in an order record. I have a text field called 'Pay Status'. I have a calculation field called 'Amount Due'. When amount due equals 0 I'd like to run a script to set 'Pay Status' to 0. I have the script triggered by the 'Amount Paid' field, which is a number field. However, there are some instances when no pay is required for an order (comps, replacements, etc). In these instances, I don't want the 'Pay Status' to remain as 'Unpaid'. I would like to have the script triggered as well. However, since the 'Amount Paid' field is never activated, the script doesn't trigger. I'd like to
  6. Is is possible to have a script trigger when the value of a calculation field changes?
  7. Vaughan's solution worked. My error was that I set the cActiveCustomerName to return a number and not text. And that I continued to use the cActiveAccountID for the first field of the value list. For anyone who would like it, I have attached the working demo. It's important to note that with Vaughan's solution, the cActiveAccountID calculation is no longer needed. If you try to run the value list using this in the first field it won't work. For it to work, you need to have the first field set to CustomerID and the second field set to cActiveCustomerName. Sort by 2nd field and display 2nd
  8. I tried that solution and the value list field is now returning a "?" See the attached file ActiveAccount.fmp12.zip
  9. The second value (i.e. names) are unique. Any other thoughts? Perhaps you can have a look at the file and let me know your proposed solution.
  10. The calculation field is stored. And the value list works as long as it is sorting by the first field. The problem is that if I choose to sort by the second field, the value list no longer filters but rather now contains all values for the 2nd field. If you have a moment to check out my file, there's a working model there of the issue. The question is can a conditional value list work if it is sorting by or displaying only the 2nd field? If so, what am I doing wrong? Or by their nature, do conditional value lists only function with first field values?
  11. Apologies for the duplicate files. I've edited out the redundancies. Responding to RW, I am happy to sort by the second field. In fact, I'd prefer it. However, by selecting that option the value list populates with all of the values from the second field and not the filtered values established by the condition. So I get all customer records, rather than only the "active" records.
  12. I have a conditional value list set up to show only values for active accounts. The value list is defined by the calculation field cActiveAccountID = If (CustomerStatus = "Active" ; CustomerID) The value list shows values both from the CustomerID field and from a second field: CustomerName The value list works perfectly if I sort by the first field. However, I would like both to sort by and display only the CustomerName. Meaning, I would like to sort by the second field and display only the second field. If I select either of these options the value list now returns all customer r
  13. I just wanted to follow up and say that everything worked out perfectly. It took me a little bit to figure out how to manage the lineitems so that I could still split the order contents across shipments but it is all working fine now. Thank you so much for the help.
  14. Thanks, Win. I'll give it a shot. You're side note is correct. That is how I have it set up not as I previously wrote. I'll let you know how it goes.
  15. Hi Wim, Thanks for the reply. If I set up a many-to-many relationship between orders and shipments, what is the breakdown for the primary and foreign key relationships? Right now, my set up is _pkOrderID => __fkShipmentID How do I alter the __fkShipmentID field so that can belong to multiple orders? Is it as simple as tagging the various orders with the shipping record id instead of the inverse? Or do I need to establish a new field? Thank you.
  • Create New...

Important Information

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