Jump to content

Wayne Irvine

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Wayne Irvine

  • Rank
  • Birthday 08/23/1968

Profile Information

  • Gender
  • Location
    Sydney, Australia
  • Interests
    Mac and karate
  1. I am looking to create a system to administer and report on a series of timed services. I have most of it in place. I can create a new record for one hour, or 2 hours or whatever and produce reports daily weekly or monthly. The bit I am missing out on is a countdown timer for each event (portal record). When I create a new record with a value of 60 minutes I would like to include a timer which you can start, pause, stop, add X minutes to etc. When this timer expires I would like to sound a chime until acknowledged. There would be more than one record visible in the portal simultaneously and all could have active timers running. Is this possible? Are there countdown timer plugins or functions I should investigate?
  2. Wayne Irvine

    Serial numbers

    I want to start at 1 for the next quarter, but it is currently 13 days before the end of this quarter. Logically I could start auto-enter serial at -13 and incrememtn by 1. So the first record would be -13, then -12 etc. Doesn't seem to like it. First record is -13, second is -14. Is this a bug, a feature, or known behaviour?
  3. Wayne Irvine

    Filtering portal records

    Excellent! The option is what I am looking for.
  4. Wayne Irvine

    Filtering portal records

    I have a portal that shows records from another table. They are 'available' or not currently assigned records. The problem is that the list is too long. I would like to be able to filter the list by entering characters in a Filter field. The relationship currently looks like this: Available = yes I would like something like: Available = yes and Filter (is a substring of) Productname I can't for the life of me figure out how to do that.
  5. Wayne Irvine

    Calculation updates

    I'll go back and see if I can replicate in fm7.
  6. Wayne Irvine

    Calculation updates

    I couldn't use this as it it based on a related field. I will modify your example and see if I can demonstrate. Before I do, can you accept fmp12 files?
  7. Wayne Irvine

    Calculation updates

    I got the multiple field relationships working and if I change a field manually it updates just fine. Never knew that was possible. And I converted my calculations to lookups so the values will remain even if I change the prices later. Thanks for that. I have one field which is DurNo which is of a calculation. I have a drop down field which is a list of values from a separate table (durations). The values are '1 hour', '2 hours' and 'Half hour' and they have the corresponding values 60, 120, 30. So when you select '1 hour' for the Duration the DurNo recalculates to the corresponding value and I thought this would trigger a recalculation of the cost. No go. I changed the duration calculation to a lookup as well and it seems to have resolved my problem. Still not really sure why dependent calculations don't update though.
  8. Wayne Irvine

    Calculation updates

    It is a calculation field. On the Relationship, do you make multiple relationship string between the tables? Profile updated.
  9. Wayne Irvine

    Calculation updates

    I have a look up table of products with parameters such as style, size, colour etc and of course price. In another table I have the items ordered which allows you to choose a style, size, and colour and looks up the price form the products table. I achieve this calculation using a field which contains a concatenated string like this 'style-size-colour' in both tables and a relationship based on this field. I use this relationship to return the price. It works the first time, but when I change one of the parameters the price is not immediately updated. How do I force a refresh?
  10. Wayne Irvine

    Change field in portal row

    Brilliant! Thanks for that. It's been decades since I played with scripting in Filemaker and a lot has changed.
  11. Wayne Irvine

    Change field in portal row

    On a further issue, how do I get the page to refresh? One portal is showing available records and the other, liked records. When I Set Field to the value of the main record it is no longer Available but is now related. If I remove the focus (click somewhere else) it updates. There must be a fucntion for this. I have tried 'Refresh Window'.
  12. Wayne Irvine

    Change field in portal row

    I was doing a bunch of copy and pasting etc but Set Field works first go. Thanks.
  13. Wayne Irvine

    Change field in portal row

    I have a FileMaker layout with a portal to another table. The relationship shows all unassigned records (related < 1). On each portal row I have a button which runs a script. The idea is that when you press the button the a value from the main record is copied and pasted into a field in the portal row (and as a result the portal record becomes 'assigned' and is removed from the portal. I have the button running a script and pasting the value from the main record but it is pasting it in the first portal record, not the one whose button was clicked. Is there a simple way of having the value pasted into the portal record where the button was clicked or do I have to store the record number (or something) and paste back to that record?

Important Information

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