Newbies thehand6 Posted February 28, 2006 Newbies Posted February 28, 2006 Hello all, I would like to know if anyone can help .. I have a wrestling app. in fmp8 that assigns a unique # based on the number of wrestlers within a wht-class... (5 wrestlers in wht-class 125lb) so wrt#1 wrt#2...... wr#5. Now heres the tricky part... i want to use a custum function to show a list of every wrt# and match it up with every wrt#, without any repeats or matching itself.. 1-2 3-4 5-Bye 2-3 4-5 1-Bye 3-5 1-4 2-Bye 1-5 2-4 3-Bye 2-5 1-3 4-Bye I know there are some functions CombineValues( list1, list2, divider ) that combins all values in two lists but they have repeats and match ... ( 1-1¶5-5) (2-4¶ 4-2 ).. but that will not work in my case.
comment Posted February 28, 2006 Posted February 28, 2006 Not a custom function, but might help: Link
Newbies thehand6 Posted March 2, 2006 Author Newbies Posted March 2, 2006 ok that help , but i had to put the wrt#'s into two repeating fields, then use a script to get them to rotate for every round.. rnd1... rnd2... rnd3 ... 1-2... 1-3... 1-4 ... 3-8... 4-2... 5-3 ... 4-7... 5-8... 6-2 ... 5-6... 6-7... 7-8 ... and for odd # of wrestlers I used a "Bye" rnd1... rnd2... rnd3 ... 1-2... 1-3... 1-4 ... 3-7... 4-2... 5-3 ... 4-6... 5-7... B-2 ... 5-B... B-6... 6-7 ... I used a couple CF's to get it to work.. NumRange( From ; To )by Ray Cologon // to get 1¶2¶3¶4¶5¶6¶7¶8 MinValue( list ; value )byTheo Ros // find the middle value in the range list Reverse( text )by Andrew Persons // reverse list2 list ...9¶8¶7¶6 CombineValues( list1;list2;devider )by Jonathan Stark //combine both list 1-8 2-7 3-6 4-5 ExtractLine( Field; Number)by Michael Haymore // used to extract the wrt# from the list now there has to be away of puting this all in one CF ... any ideas?
comment Posted March 2, 2006 Posted March 2, 2006 Maybe there is, but I cannot see the advantage in struggling with a custom function (that does not have a counter) or putting the data in repeating fields, when you can simply make a list of the wrestlers as records, and generate a list of matches as records.
Raybaudi Posted March 3, 2006 Posted March 3, 2006 Hi maybe that I haven't understand you correcty, but give a look to this custom function: http://www.briandunning.com/cf/276
Recommended Posts
This topic is 6860 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now