We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About hutcheedingo

  • Rank

Profile Information

  • Gender
  • Location
    Scarborough, Western Australia

Recent Profile Visitors

1,168 profile views
  1. Hi Guys, I've tried a few times too no avail to figure out a way to set the colour of some background objects within my db. Basically, I'm setting things up with a default color scheme, but would like to be able to customise the scheme based on the clients preferences. As I work primarily with Sports Organisations, they all have specific colours that they utilise, and it would be easier and far less time consuming for me if I could select a few colours (primary, secondary, tertiary colors) to allow for much quicker customisation of the db instead of going through the whole system and changing every single Object Style. My preference would be to use HEX colours, but my issue is I haven't been able to figure out how to set things up so that the system will display the colors after I set the HEX code. I don't want the end users to be able to edit it, but I want to save myself time in deploying the solution. Any help greatly appreciated.
  2. Map Directions (fmEasyMap)

    Thanks for the reply, but I was hoping that it would be possible to generate the entire journey, with the same origin and destination, and then create a URL that can be sent to the driver to give him the directions. I might go and have a look at the API, which I'm not very experienced in at all, and see if I can figure it out.
  3. Map Directions (fmEasyMap)

    I'm trying in vein to incorporate google map directions into Tim Dietrich's EasyMaps, and have tried about a dozen or more methods, none of which seem to work. Basically, I work with a not-for-profit that buses minors home after some after school activities, that typically finish around 11pm. To make life easy for the bus driver, I'm hoping to be able to generate the map with directions, and then email it directly to the bus driver, who opens it up on his smart phone, and follows the directions. As I said, I've tried a number of methods, and none of them are working for me. Being a not for profit, spending on operations like Seedcode's ProMaps is out of the question due to cost. Has anyone, or does anyone know how to modify EasyMaps so that it will be able to give me directions, and then send those directions to another person? at the very least, we'd like to be able to send map with multiple points across, but everything would be ideal. Appreciate the help.
  4. EasyMaps Directions

    Hi, So I've been using Tim Deitrich's fmEasyMaps Beta embedded in my file for a while now, and it works fantastically, I'm currently mapping over 3000 addresses. But my inner perfectionist has gotten the better of me, and now I'm wondering weather it's possible to add in directions using waypoints. The idea is that I want to do a few drop offs to multiple addresses in a local area, for kids after participating in a school activity that finishes around midnight. I saw this announcement HERE about EasyMaps, but have been unable to get anywhere since I can't find any place where the new version was ever released. Since Tim is now no longer developing in Filemaker, I'm turning to the Forums. Which leads me to my question... Has anyone managed to include directions and route mapping into EasyMaps, and if so, would you be able to show me how?
  5. Sports Scheduling Problem - Combinations for Fixtures

    Re Multiple Cycles: I wasn't really sure where to add the Loop, but your comment gives me a few ideas Re Times: I may have missed a few points earlier on so I'll elaborate a bit more... Sorry We run all our competitions from a centralised ground, that is all games take place on one artificial Hockey Turf. As a result, there is no Home or Away designation, since there's no Home Ground Advantage. This is an example of the fixtures on any given round. Round # - Date: DD/MM/YY Game 1 - 15:00 - Alpha v Beta Game 2 - 16:30 - Echo v Delta Game 3 - Bye - Charlie So the calculation for the HomeTeamID and AwayTeamID need too allow all of the teams get an even distribution of games across the available Time Slots. This Link should help I hope I have helped clear things up somewhat Again... Thank You for all of your invaluable assistance
  6. Sports Scheduling Problem - Combinations for Fixtures

    I've made some progress... but have found myself stuck yet again. File Located Here I've made a few changes to the script from Comment's solution posted earlier in the thread, too fill in some extra details, Date, Match Results, Competition Ladders. So onto my Problems... 1. Game Time Assignments I've added in some steps that take from a list of times, no problems there. But the output of the calculation does not provide for a 'Balanced' Schedule. What is happening is that one of the teams, usually Alpha, ends up having all of the games in the earliest or latest allowable time, which obviously is not fair. This is happening regardless of the number of teams in the league. As stated earlier in the thread, the Game Time is the only designation required and it must be balanced for all teams (or as close as possible), since all games are played at the same venue. 2. Multiple Round Robins The file creates a single Round Robin Tournament perfectly, everyone gets everyone else once. For large competitions n(teams)<12 thats easy enough. Since one cycle usually does the job. The smaller competitions though, require multiple round robins so that they play for the entirety of the season. The number of Round Robin Cycles required is under League::Cycles. Once the first round robin cycle ends, I need it too start looping again, but this time the Round Number needs to be carried forward so that its not starting at 1 again, and the dates need to move to the next value from the list, instead of going back to the start.
  7. Sports Scheduling Problem - Combinations for Fixtures

    Comment... That file you have posted ticks all the boxes perfectly. Many Thanks. After having a quick look at the file, I was expecting something extremely complex, and difficult to follow, but that is just not the case. Par Excellence on Your Behalf. Again Many Thanks
  8. Sports Scheduling Problem - Combinations for Fixtures

    That is explained in the post Lee Smith
  9. 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. So... 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
  10. Listing Unique Combinations

    Sorry to say, I spoke a little too soon... When I realised, that given the usage for this CF, I will need those pesky 1 | 0 outputs to be included if the list of Values is Odd... But if it's even, then the 1 | 0 outputs need not be there... Any thoughts Comment?
  11. Listing Unique Combinations

    Brilliant... Works an absolute treat Many Thanks, from both myself, and the hole I was banging into the wall with my head
  12. Listing Unique Combinations

    I went back and had a look at the calculations, and went through a bundle of CF's on Brian Dunnings Site... This is what I am working with now, since it meets the requirement for two variables. I added in the If Function highlighted below Combine Values ( list1; list2; divider ) Let([$ƒCounter[1] = Case($ƒCounter[1]; $ƒCounter[1]; 1); $ƒCounter[2] = Case($ƒCounter[2]; $ƒCounter[2]; 1) ]; //end define Let Substitute( MiddleValues( list1; $ƒCounter[1]; 1 ); ¶; "" ) & divider & If ( MiddleValues ( list1; $ƒCounter[1]; 1) ≠ MiddleValues ( list2; $ƒCounter[2]; 1 ) ; Substitute( MiddleValues( list2; $ƒCounter[2]; 1 ); ¶; "" ) ; "0" ) & Case( $ƒCounter[2] < ValueCount(list2); Let( $ƒCounter[2] = $ƒCounter[2] + 1; ¶ & CombineValues(list1; list2; divider) ); $ƒCounter[1] < ValueCount(list1); Let([$ƒCounter[1] = $ƒCounter[1] + 1; $ƒCounter[2] = 1]; ¶ & CombineValues(list1; list2; divider) ); Let([$ƒCounter[1] = ""; $ƒCounter[2] = ""]; "") //clear variables when done ) //end Case ) //end Let This gives me an output shown below 1 | 0 1 | 2 1 | 3 1 | 4 2 | 1 2 | 0 2 | 3 2 | 4 3 | 1 3 | 2 3 | 0 3 | 4 4 | 1 4 | 2 4 | 3 4 | 0 Now, I want to make it recognise that 1 | 2 is the same as 2 | 1. So basically, all the Italicised outputs just don't appear. I'd also like to remove the 1 | 0 outputs from the list in the event that the GetValue of List is Even, but keep it for when GetValue is Odd. Any Ideas? since I'm afraid to say I'm stumped again... Thanking You in Advance
  13. I've been trying to write a Custom Function that will give me a list of unique combinations between two occurrences of the same list. The nearest I've come is with this Function, using the following list as an example 1,2,3,4 ListCombinations ( listofValues ; separator ) Let([ listLength = ValueCount(listOfValues); lastValue = GetValue(listOfValues; listLength); lesserList = Case( listLength > 1; ListCombinations(LeftValues(listOfValues; listLength -1 ); separator); "") ]; Case( listLength = 0; ""; listLength = 1; RightValues(listOfValues; 1); /* Ensures ¶ at end */ lastValue & "¶" & lesserList & /* already terminated by ¶ */ Substitute(lesserList; "¶"; separator & lastValue & "¶") ) ) The output comes out looking like this: 4 3 2 1 1 | 2 2 | 3 1 | 3 1 | 2 | 3 3 | 4 2 | 4 1 | 4 1 | 2 | 4 2 | 3 | 4 1 | 3 | 4 1 | 2 | 3 | 4 What I want is for the output to be limited to only the 2 number values, shown below. I've had a play with the Function, but I think I've been looking at it too long and can't make hide nor hair of what I need to change to produce the below list 1 | 2 2 | 3 1 | 3 3 | 4 2 | 4 1 | 4 Thank You for An Help in Advance
  14. I've done that before Martie, I'm really just looking for something that'll negate the need to remember the 'Ghost' option, which will also allow me to create x number of rounds, even if that means a round stops midway through, since there's only a limited number of weeks the competitions can go for before we MUST wrap things up in order to accommodate the finals.
  15. Thanks MartieH, I have used that solution, but ran into a few problems when it came to a league with an Odd Number of Teams. That being said, an Even number of teams works perfectly... I've found a bundle of solutions that are available in Python, but I just can't figure out how to convert those solutions into a Filemaker Script. http://stackoverflow.com/questions/11245746/league-fixture-generator-in-python

Important Information

By using this site, you agree to our Guidelines.