Jump to content
Sign in to follow this  

Employee Scheduling in FM

Recommended Posts

Hi guys, I've been tasked by my manager to find or create a program that will take into account  availability and the target number of hours per week for each person and schedule shifts. can this be done in Filemaker? how hard is it? am I barking up the wrong tree? thanks

Share this post

Link to post
Share on other sites

can this be done in Filemaker? how hard is it? am I barking up the wrong tree?


These questions are very difficult to answer, because we don't know the exact (or even the approximate) specifications for the required solution. How hard is it? Depending on the number and type of constraints it needs to take into account, it could be anywhere between intermediate to extremely difficult, or even impossible to implement in Filemaker. It might be very difficult to implement by other means, too - see: https://en.wikipedia.org/wiki/Nurse_scheduling_problem


Perhaps your requirements are more modest, but it is difficult to imagine a scenario where such thing would be really easy. If you're just starting with Filemaker, then this would hardly be a good project to cut your teeth on.


See also:


  • Like 1

Share this post

Link to post
Share on other sites

Agree with comment.  Been a hacker/developer while running my psych practice for some 6 years now and I just found a way to pull this off that is approaching usable.  I employed a lot of execute SQL to make it work - but ... well thats another post.  Needless to say - likely possible but also hard to do.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By CobaltSky
      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:
      including demo downloads, documentation, screenshots, pricing/purchase links and videos outlining the basic operations of each system.

      R J Cologon, Ph.D.
      Director of Development
      NightWing Enterprises, Melbourne, Australia
      Email: cologon@nightwingenterprises.com
    • By John Sindelar
      Your FileMaker Calendar in a Browser
      Our Pro Calendar now includes a second set of scripts and layouts tuned for WebDirect in FileMaker Server 13.
      The v2 rev of FileMaker Server 13 made a lot of small improvements to WebDirect and we're pretty stoked about what we've been able to accomplish. The WebDirect calendar has almost complete feature parity with the calendar in FMPro. Filtering, resource scheduling, and even Gantt Charts all work (screenshots below).
      And since this is all done with unlocked, straight forward FMP layouts (some of the techniques here even come from FM 8.5) you can modify all this without getting into any crazy javascipt, php, or web publishing stuff.
      Learn More: Demo, Movies, and Screenshots
      Get what you need here: SeedCode Calendar for Pro, Go, and WebDirect
      New to SeedCode Calendar?
      Buy the Pro Calendar and follow our instructions to link it to--or embed it in--your file. Already Using SeedCode Calendar?
      Good news: the WebDirect add-on consists of layouts and scripts you can paste into your existing copy of the calendar. Purchase the Upgrade Follow our instructions for adding these features to your copy. If you purchased the calendar since March 1st we've already sent you a free upgrade. (Please let us know if you missed it.) - John

    • By StevePolk
      I need help writting a calculation for a scheduling tool. I need to write a calculation that determines the start date when you know the end date (delivery date) and the amount of days for each milestone between the start and end dates and of course calculating only using weekdays; for instance:
      Start date: unknown
      Picking: 2 days
      Packing: 3 days
      Shipping: 4 days
      Delivery date: 4/1/2014
      Any help would be greatly appreciated.
    • By hutcheedingo
      Let me first preface this by saying I am by no means an expert on Filemaker, more an enthusiast looking to save my small regional field hockey facility from purchasing an expensive shrink wrapped package.
      After searching high and low for a way in which to generate a sports leagues fixture, by using a combination of Custom Functions, Calculations and Scripting.  I've also been working on my own to generate something that will get me closer to my goal.
      This forum post is VERY close, but I've come up with a few things that make for a little more flexibility.  Also, the solution posted by Eos has an issue with calculating the fixtures for a league that has an odd number of teams.  That being said some points within this solution have been invaluable in getting my solution to where it currently is, so a very big thanks to Eos for his assistance previously.
      Onto my solution... Posted Here
      There are two issues at this stage, no doubt more will pop up...
      1) The Match List, which utilises a CF called UnorderedPairs found on Brian Dunning's site, is sequential meaning all the 1 | x values are generated first, and then the 2 | x values and so on... Instead the combinations need to come out in a series that allows each team to play only once, and balances the distribution of the fixtures over the time slots available during the season. Home and Away designations DO NOT Matter, since all games are played at a single venue, with the time being the only designation for each round of fixtures.
      2) The Loop that creates the fixtures does not carry the previous values forward with the counter, so each round ends up being the same, the script needs to 'remember' the used values and then step forward to the next available value from the match list at the completion of each round.
      As an alternative, I have a Python Script that will create the schedule perfectly, but I have no idea how to integrate Python into a Filemaker Solution, so I've moved away from that, but I do still have the Script available should I need it.  So if anyone out there is able to help out in that respect, please let me know.
       Any and all help is greatly appreciated 
      Many Thanks
  • Who Viewed the Topic

    2 members have viewed this topic:
    Dave Carmean  totoleheros 
  • Create New...

Important Information

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