Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


CobaltSky last won the day on October 30 2018

CobaltSky had the most liked content!

Community Reputation

11 Good


About CobaltSky

  • Rank
    FileMaker Developer

Profile Information

  • Gender
  • Location
    Melbourne, Australia

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
    Authorized Trainer
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Sierra, Win 10

Recent Profile Visitors

4,370 profile views
  1. UPDATE: Our series of classes at Introductory, Intermediate, Advanced and Expert level are underway, with the Introductory class now complete. For anyone still considering attending one of the remaining three classes in the series, we're announcing a Cyber Week discount voucher offer valid for the next seven days (starting today), that will give forum members 20% off the course fee for any of our upcoming training events. To claim your 20% discount, enter the code CyberWeek2018 into the voucher field in the course registration form at: http://www.nightwingenterprises.com/training/NFTapplication.html
  2. A quick follow-up for anyone who may be interested. All four of the classes mentioned above are confirmed and will go ahead as scheduled. There are still places available if anyone is considering attending! http://www.nightwingenterprises.com/training.html
  3. Hi Folks, You - or someone you know - may be interested to know that NightWing Enterprises is offering four confirmed courses for FileMaker users and developers at all levels, in Melbourne in November and December. The details are as follows: Introduction to the FileMaker Platform (Beginner) Melb, AU, commencing 22/11/2018 (Duration: 2 days; Cost: AUD $1,150.00 ex. GST) The Power of FileMaker - Part 1 (Intermediate) Melb, AU, commencing 26/11/2018 (Duration: 2 days; Cost: AUD $1,150.00 ex. GST) The Power of FileMaker - Part 2 (Advanced) Melb, AU, commencing 29/11/2018 (Duration: 2 days; Cost: AUD $1,150.00 ex. GST) FileMaker Master Class (Expert) Melb, AU, commencing 3/12/2018 (Duration: 3 days; Cost: AUD $1,600.00 ex. GST) Additional details including topics and content to be covered at each level can be found on our web site at: http://www.nightwingenterprises.com/training.html Places are limited and will be allocated on a first-come-first served basis. Registration for the above events is now open at: http://www.nightwingenterprises.com/training/NFTapplication.html If you - or anyone you know - would benefit from one or more of these action-packed training events, we'd love to see you in Melbourne for the classes listed above! Regards, Ray Cologon ---------------------------------------- Director of Development NightWing Enterprises, Melbourne, Australia http://www.nightwingenterprises.com ----------------------------------------
  4. Hi Folks, In a new development for FileMaker users in the Asia-Pacific region, NightWing Enterprises is now offering 3-day courses for all levels of FileMaker users (four separate levels). To begin with, we've scheduled classes at the first two levels, introductory and intermediate, in both Sydney and Melbourne in April and May 2017. The events coming up are: • Introduction to the FileMaker Platform (Beginner) 3 days - Sydney, AU - 26-28 Apr 2017 - AUD $1,650.00 (including GST) • The Power of FileMaker (Intermediate) 3 days - Sydney, AU - 1-3 May 2017 - AUD $1,650.00 (including GST) • Introduction to the FileMaker Platform (Beginner) 3 days - Melbourne, AU - 17-19 May 2017 - AUD $1,650.00 (including GST) • The Power of FileMaker (Intermediate) 3 days - Melbourne, AU - 22-24 May 2017 - AUD $1,650.00 (including GST) Additional details including topics and content to be covered at each level can be found on our web site at: http://www.nightwingenterprises.com/training.html Places are limited and will be allocated on a first-come-first served basis. Registration for the above events is now open at: http://www.nightwingenterprises.com/training/NFTapplication.html If you know anyone who would benefit from three days of action packed training at introductory or intermediate levels (or both), and who is able to get themselves to either Sydney or Melbourne for the sessions listed above, please draw this message to their attention! : ) Regards, Ray
  5. NightWing Enterprises is pleased to announce two new products for managing booking (in whole-day periods) or scheduling (in quarter-hour increments) of assets such as rooms, venues, equipment, people, vehicles etc. These two new systems are similar in design and concept but adapted for different applications. Both products can be used in FileMaker 13 or later, and both are optimised for FileMaker 14. The products can be used stand-alone, or hosted on FileMaker Server, and can be accessed by FileMaker Pro, FileMaker Go or FileMaker WebDirect. In addition to supporting the placing and management of bookings, both products include a Gantt-style display of bookings for a user-selected period, and support drag-and-drop editing of bookings in place on the chart in FileMaker Pro. Bookings can also be edited on the chart screen in FileMaker Pro by double-clicking on them, or in FileMaker Go and FileMaker WebDirect by tapping/clicking on them to invoke an editor pane. Walk-though videos showing both products are available on our web site. Demos of each product can be downloaded free, and the products can be licensed from us starting from $140 for a single seat license. Developer licensing is also available for those wishing to modify the systems or incorporate some or all of the functionality into an existing solution. Full details are available from the product pages on our web site at: http://www.nightwingenterprises.com/products/BookingSystem_v3.html http://www.nightwingenterprises.com/products/SchedulingSystem_v3.html including demo downloads, documentation, screenshots, pricing/purchase links and videos outlining the basic operations of each system. Regards, Ray ------------------------------------------------ R J Cologon, Ph.D. Director of Development NightWing Enterprises, Melbourne, Australia Email: cologon@nightwingenterprises.com http://www.nightwingenterprises.com ------------------------------------------------
  6. For those interested, I understand that there are a few additional places available for the East USA class (Norwalk, CT) so if you'd like to join us, the registration page is at: http://www.kyologic.com/filemaker-master-class Also, registrations are now open for the Sydney (AU) class, and can be made at: http://info2.filemaker.com/APAC_FTS_EDU_Seminars_Q215_FM_Master_Class_2015.html Regards, Ray
  7. As noted above, registration for the Master Classes in California, Germany, the UK and Connecticut was set to close later today. Good news is that it's been agreed to extend the registration deadline by a further week, to 2 March, after which decisions will be made about the viability of each of the first four classes in the series. So, if these events are of interest to you, you have a further week from today to 'make it happen'. Meanwhile, I'm told that a group discount rate is a possibility at the hotel in Norwalk, assuming most attendees want to stay in the Courtyard Marriott hotel where the class will take place. I don't have all the details as yet, but will post them once they're confirmed. Regards, Ray
  8. CobaltSky

    Filtered Value List

    Hi 3guk, To achieve this, you'll need to enable the user to specify the filtername in the item record in order to then present them a list of the corresponding values from the Category table. So you'll need a filtername field in the Item table (you might consider making it a global field, assuming you don't need the value to persist in each record), and then a relationship (using the equijoin "=" relationship operator) from Item to a Table Occurrence of Category that matches the filtername fields in both tables. With this set up, you'll then be able to set the value list to use values from the Category table occurrence (the one related Item::filtername=Category::filtername, choosing the option to display only related values, and specifying the "starting from" context as the Item table. Regards, Ray
  9. A quick heads up for those who may not yet have caught up with the latest on this demo series... The thirteenth demo completes the set and is available on our demos page at: http://www.nightwingenterprises.com/demos.html This new demo shows a way of working with relational data - analogous to a "portal within a portal" - involving cascading portals where selecting a row in one portal invokes the display of related records (i.e. related to the record that's active in the first portal). And selecting a row among the 'child' rows in the second portal invokes the display of 'grandchild' records in a third portal. It's a sequel to a cascading portal demo that some might remember me posting on this site many moons ago... In this case, the demo shows only three portals interacting, but the technique can be extended to as many levels (on a single layout) as you wish. Also featured in the new demo is a FileMaker 13 technique using conditionally hidden attributes to enhance the user experience of adding records to a portal. In each portal, you can add, edit or delete records within the cascading hierarchy (preserving relational links as you do) - all from a single layout. Also, as an aside, if you've found our demos and other resources interesting and/or useful in the past, you may be interested to know that I'll be presenting a series of master classes in various parts of the world in the coming months. I recently posted an announcement elsewhere on the forum: [ANN] FileMaker Master Classes - 2015 While the master classes do include discussions about specific techniques, including some of those featured in various demos, the main focus is the thinking behind these and other approaches, placing them within a wider framework for advanced FileMaker development. Regards, Ray
  10. Building on the success of classes offered for the first time in Europe last year, an announcement has gone out today about a new series of three-day FileMaker Master Classes offered from March to June 2015 in: • San Francisco (March 2015)• Berlin (April 2015)• London (April 2015• Westport CT (May 2015)• Sydney (May 2015)• Tokyo (June 2015) The classes are unashamedly targeted at advanced developers, and are packed with high level content ranging from designing for scalability, advanced development techniques, process control, FileMaker application and deployment models, solution design perspectives to code logic. From the 'brochure': "These intensive three-day seminars are dedicated to expanding your knowledge and broadening your approach to FileMaker development." Full details including event dates, pricing, locations, detailed content outlines and online registration can be found at: http://www.nightwingenterprises.com/MasterClasses The deadline for registrations for the first four locations (San Francisco, Berlin, London and Westport) is 23 February. It would be great to meet some of you at one of the events in this series! Regards,Ray
  11. A further update on this today... The twelfth demo in this latest series is now available for download and is listed at the same location as the original group - ie at: http://www.nightwingenterprises.com/demos.html The latest addition is a new/updated version of the "Dynamic Layout" technique we first published for FileMaker 9 back in 2008. While the basic concept is similar, v2.0 includes some additional functionality, an updated interface and shows a variant of the techniques that have been adapted to make use of the expanded feature set of FileMaker 13. Regards, Ray
  12. Hi Folks, A quick heads up for those who may be interested... An additional demo has now been added to the set, bringing the total number in this group to eleven. You'll find it on the same page as linked in the first post in the thread. The new demo shows an updated FileMaker 13 technique for viewing found records in a portal - with the portal contents dynamically updating as the found set changes. We've published demos on this subject before (for FileMaker 5.5 and FileMaker 8) but the approach in this one is all new. FWIW, the new demo also includes a custom Find interface and a portal-based navigation system, so there are several things going on... Regards, Ray
  13. I'm pleased to announce the availability of the first group of a series of new and updated demo and example files for FileMaker 13. The first ten demos in this series are available immediately and include a mix of new techniques based on the features of the FileMaker 13 platform, along with updated versions of some of our previous demos (reworked in light of the new features). This set of demos showcases a number of our favourites among the features of FileMaker 13. Eight of this first set of FileMaker 13 demos are unlocked, so that you can access the code. Two are preview-only (code available to registered users). These include an update to version 2.0 of our UltraLog audit tracking system (which is a free upgrade for paid licensees of version 1.0), plus a Custom Status Panel system that replicates the navigation functionality of the Status Toolbar (including a 'draggable' slider) as a compact native layout object group. Other demos in this group include a new three-way interface system for portals, a new take on showing progress indicators, our fourth and final demo of active row highlighting, a new method of highlighting search text in a field, an updated and extended distinct values toolkit and more... Links to the info and download pages for each of the new demos can be found at: http://www.nightwingenterprises.com/demos.html Further demos are planned (also a mix of new techniques and updates to earlier examples) and will be published at the above link when available. Regards, Ray
  14. Daniel, The fact that you were trying to include the word "Calculation" within a calculation formula suggests that you're not at all familiar with syntax in for form I posted it, nor with FileMaker calculation syntax, for that matter. That being the case, it is going to be pretty difficult for anyone here to communicate a solution to you, without actually simply doing it for you. I will go one step further than I did in my previous post, and provide you with a simplified file that contains the script I described. Perhaps looking at this example will give you the information you were unable to parse from the words I posted. Orders.zip
  15. Reading between the lines, it sounds like there may be some redundancy in the data design. Reconciling conflicting order statuses across two tables ("Order" and "CustomerOrder") might not be necessary if the structure were approached a little differently. At any rate, as described it is unclear. Notwithstanding that, assuming there is a relationship that is based on a match between the Order::InvoiceNo and CustomerOrder::OrderNo fields, it should be possible to achieve something analogous to the status update procedure outlined above using script code along the lines of: Go to Layout[“Order” (Order)]Perform Find[Restore: Find: CustomerOrder::Status: “C” Omit: Order::Status: “R”]If[not Get(LastError)] Replace Field Contents[No dialog; Order::Status; Calculation: "S"] Replace Field Contents[No dialog; CustomerOrder::Status; Calculation: If(CustomerOrder::Status = "C"; "R"; CustomerOrder::Status)] Go to Related Record[show only related records; Match found set; From table: “CustomerOrder”; Using layout: “CustomerOrder” (CustomerOrder)] Constrain Found Set[Restore; Find: CustomerOrder::Status: “R”]End If Since the method described in this code snippet is using the Replace Field Contents command, it would be unsuitable for use in a hosted solution (ie it would fail silently if any record locks were encountered). If the solution is hosted, a loop construct to update the statuses would be a better idea, since it would enable you to trap for errors in a record-by-record basis.

Important Information

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