Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


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