Jump to content

Poruchan

Members
  • Content Count

    41
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Poruchan

  • Rank
    member
  • Birthday 08/05/1945

Profile Information

  • Industry
    Retired
  • Gender
    Male
  • Location
    Tokyo
  • Interests
    Horseracing

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    El Capitan

Recent Profile Visitors

1,030 profile views
  1. I was able to get something working with Aussie John and Ash's solution:
  2. Hi, I’d like to show days since last race for a horse where the first race returns 0. I played around with ‘last’ and ‘GetNthRecord’ but something went wrong. I had some problems with races where the horse was scratched, but I can live with that. Thanks, Paul
  3. Poruchan

    Case / If Perhaps

    Thanks, Doug I reproduced it and I have the 2nd place horses now. My new recent goal is to understand why these things work rather than just ask for and get solutions. As what you did is not obvious to me, Im working up a few questions.
  4. Very fundamental concept query. This might not belong here, but I'm here to discover if I am thinking 'case' and 'if' wrong. Quite often I come to a situation with 2 tables (something like this): Table A fields: ID_A, RaceID, Horse Name, Time, Finish Table B fields: ID_B, RaceID, Winner, Second In Table B I want to populate 'Winner' and 'Second'. I would do a simple look-up for 'Winner', but then I go for 'Second' and I start bumbling around and thinking like this (just English, not FM-ese): If Table A RaceID = Table B RaceID and Fin = 2 then give me the Horse Name. Then I start fumbling around. I check the manual, the Missing Manual, videos ... and then I start thinking that this is such a simple task, I must be thinking it wrong. Am I?
  5. Didn't want to leave this hanging -- I think Don's file is it -- though I haven't gotten it to work yet, I think I will soon enough if I keep at it. I've got to work on the fundamentals. So in the future I am going to limit my queries to things that I might actually be able to discuss. It's fine asking for help and getting a solution, but there's a line between "help me do this" and "do it for me". It feels like I have a new car and I am pushing it around town, and people are saying 'why don't you drive it' and I'm answering 'I don't how to drive'.
  6. It doesn't help, yet. I'm still playing with it ... the script has been running quite a while ...
  7. Hi, After the weekend races and all the results are imported into FM, I mark (now by hand) the “Key Races”. I’ll find each horse who either won or finished 2nd. As in this screen shot of Cherry Summer you can see he won his last race on Oct 3. (1) Then I mark the preceding race. (now I’m using a ‘K’, but I intend to change it to a number — different problem). The point is to show which race produced winners. The screenshot shows I have put a 'K' in Cherry Summer's race on may 31 and changed the 4 to a 5. Then I find matching records for RaceID (31may15tok5) on the record I just tagged, and count the ‘K’s and enter the number in KRG. So before I updated this there were 4 'K's in the field KR and the field KRG showed 4s. It would be nice to have FM do this, but marking the previous race is my problem. It's not a terrible task now, but a while back I lost everything and it took me a month to get all the key races data back. I'd like to avoid that. Any suggestions? Thanks
  8. Poruchan

    Portal With GetSummary Sorting Problem

    These race averages do not change all that much once you get a dozen or so races averaged. There are 10 racecourse and 2 or 3 are holding races at a time. They rotate the races seasonally. I think I'm just going to create fields for each race type average and update them monthly. An inelegant solution, but I'll be able to move onto other projects that I desperately need to get to. Thanks for all the help -- I will be using the ideas I got here for some of those other projects.
  9. Poruchan

    Portal With GetSummary Sorting Problem

    Thanks, I downloaded the sample file 'fast summary' from FileMaker Hacks (Kevin Frank). Very interesting and seemingly simple (though I don't understand the script). I want to use it somewhere else. To me it seems like a cool way of doing a report, but the end is the same. I don't see how I would take the class average from it, use it in a calculation to get the speed rating and then drop it in the portal I'm using to show past performances. Perhaps it is possible, but I just can't see it. Since it is a given that I cannot use the sub summary value if it is not sorted by the breakfield, then I suppose I have to find another way. And since I'm mathematically challenged, I must assume I have convoluted this discussion. I want to continue this, but I'm afraid I would ask the same question. So I have to ask a different question ... I'd like to ask how would you do it? And if you say 'Do what?' Perhaps we could start there.
  10. Poruchan

    Portal With GetSummary Sorting Problem

    Don, That Avg Race Report is really something and has given me some new ideas. I've been going over it and trying to figure out how to put it to good use. I probably will have some questions. Thanks, Paul
  11. Poruchan

    Portal With GetSummary Sorting Problem

    Hi, I have not explained myself well, so I am going to give it another go with pictures. I've creating a nifty racing form -- actually, you have. Anything other than the basics was supplied by members of this forum. I have a completed product, but the speed rating is tediously worked out in Excel. Here is a picture of the result. The columns with the red 82 in Italian Neo and the red 83 in Silk Brooklyn are the speed figures. I get those in Excel through some calculations that involve race averages and class averages. I have reproduced the numbers in FM in a summary report. But first, it might help to show you how I receive the data in Excel: What I actually receive is from columns Date to Time (I left a few things out as they were not essential for this problem). On the right you can see 'Class Speed' which is the magic number I need in the form. Here is the layout: The portal is everything - the past performances which are of course sorted by date. As I said, I reproduced the speed rating via the summary report using GetSummary in the calculation, but I can't use the speeding rating in the portal. This is the last piece of the puzzle -- getting the speed rating in the portal -- do you have any suggestions? (there are about 150,000 records in the table 'Performance' which the portal is showing records from) Thanks, Paul
  12. Poruchan

    seconds to minutes

    Wow, that's nice. I'm just sitting here handing you the hammer. Thanks.
  13. Poruchan

    seconds to minutes

    Did it in Filemaker -- works great, thanks ... so, about the first three characters in the time [0:0]1:55 -- is it possible to remove them? I'm thinking it's not as it is from a calculation. What a shame - if I just limit the size of the filed on the layout it reduces nicely, but from the right. I shamelessly covered the first three characters with a little white box. Looks great.
  14. Poruchan

    seconds to minutes

    For some reason FM is recieving the time with some extras: Excel: 1:55.8 > 115.8 Import FM: Shows 115.8, but clicking in the field shows 115.79999999999998 and GetAsTime() returns 0:01:55.799999 Not all of them, but the lions share. No luck with formating But this is low priority - I’ve grown accustomed to using seconds. Thanks ― I’ll play around with it.
  15. Poruchan

    seconds to minutes

    "Why not?" Really? Can I? I haven't been able to import race times such as 1:58.1 (min:sec.x) from Excel. (plus I've had a bunch of problems in Excel because of the colon) "Huh?" So in Excel I multiplied the race time such as 1:13.6 * 24 * 60 * 60 to get 73.6 -- and have been happily working in seconds. I can stick with seconds, but presentation-wise, people want what they are used to -- I'll stick with the seconds unless I can get exactly 1:13.6 or 1.13.6
×

Important Information

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