Jump to content

  •  

Photo

How do I get the 4 lowest scores from 6

FM7

  • Please log in to reply
44 replies to this topic

#1 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 07 March 2005 - 10:44 AM

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).
  • 0

#2 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 07 March 2005 - 11:51 AM

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.
  • 0
Ralph

#3 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 07 March 2005 - 01:11 PM

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.
  • 0

#4 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 07 March 2005 - 01:22 PM

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.
  • 0
Ralph

#5 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 08 March 2005 - 07:07 AM

Since I haven't hear from you I put together a sample file.
  • 0
Ralph

#6 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 08 March 2005 - 07:36 AM

I hope this makes sense to you. Again thanks.
  • 0

#7 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 08 March 2005 - 09:47 AM

I have modified my file to display like your example.
  • 0
Ralph

#8 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 08 March 2005 - 09:51 AM

He is my file, the one you made looks great and works great, but I would like to print this off when the golf meets are done without all of the extra fields. Thanks much
  • 0

#9 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 08 March 2005 - 10:06 AM

Did our files pass each other? I think the last one I sent is almost what you want.
  • 0
Ralph

#10 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 08 March 2005 - 10:30 AM

yes the files must have passed, I will check it out.
  • 0

#11 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 08 March 2005 - 11:24 AM

It's almost perfect. The new one you sent me doesn't have a team score. Thanks Ralph.
How can you enter all of that data in such a short time.
  • 0

#12 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 08 March 2005 - 11:37 AM

It did when it left here. On the layout Score Card it is under the center 2 columns. I didn't think that 9s fast. Once I had one portal laid out I used duplicate to make the next 5 and then changed the starting portal row in each.
  • 0
Ralph

#13 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 08 March 2005 - 01:12 PM

I cant get the team score to work, I tried to change scores, to no sucess.
  • 0

#14 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 08 March 2005 - 01:27 PM

Try clicking on the team score field after updating. You may also want to look at using a script with the Refresh Window Flush Cached join. You can use the Event Script Plug-in to automate this.
  • 0
Ralph

#15 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 07 March 2005 - 10:44 AM

I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).
  • 0

#16 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 07 March 2005 - 11:51 AM

Make a caluclated field = Score & " " & GolferID, were GolerID is an unique serial number. Use this field to make a related value list. Then use ValueListItems to make a list of the golfer scores & Id's Pick the top four scores off the list.
  • 0
Ralph

#17 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 07 March 2005 - 01:11 PM

Thanks so much, is there anywhere I can find an example close to this, because I'm a beginner and this makes sense but I'm not sure how to go about this.
  • 0

#18 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 07 March 2005 - 01:22 PM

What do you have so far? Can you post a sample of your database? I could make a sample but it would be easier to build on what you have.
  • 0
Ralph

#19 RalphL  Pooh-Bah

RalphL
  • Members
  • 1,750 posts
  • LocationSt. Louis, MO
  • FM Application:12 Advance
  • Platform:Mac OS X Snow Leopard
  • Membership:TechNet
  • Time Online: 2d 19h 47m 17s

Posted 08 March 2005 - 07:07 AM

Since I haven't hear from you I put together a sample file.
  • 0
Ralph

#20 Aric H  novice

Aric H
  • Members
  • 21 posts
  • FM Application:7
  • :

Posted 08 March 2005 - 07:36 AM

I hope this makes sense to you. Again thanks.
  • 0





FMForum Advertisers