Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About RussBaker

  • Rank
  1. You can do it without all those intermediary fields, and you need a double equals sign to make the exact match work. Try: Enter Find Mode [] Set Field [Event ID, "==PCN"] Insert Calculated Result [Date of Event, DateToText(Status(CurrentDate)-182) & "..." & DateToText(Status(CurrentDate))] Perform Find []
  2. Or there is this one in the samples section of this forum. http://www.fmforums.com/threads/showflat.php?Cat=&Number=60900&page=2&view=collapsed&sb=3&o=&fpart=1
  3. Paolo, The 2 samples of mine that Ugo referred to are at: http://www.fmforums.com/threads/showflat.php?Cat=&Number=43001&page=0&view=collapsed&sb=7&o=&fpart=1 for the "RussCalcs from Oz" file in "Handy Bits" which has an example under the Bar Graphs tab of how to use multiple "|" character graphs to produce a mean, +/- SD and Min/Max bar graph, and http://www.fmforums.com/threads/showflat.php?Cat=&Number=68888&page=3&view=collapsed&sb=7&o=&fpart=1 for an example of a highlited histogram. Download the file attached to th
  4. I'd do this with 5 buttons, designed to look like a list. Each would contain an unstored calculation field which would be: Date_1 = Status(CurrentDate) + 1 Date_2 = Status(CurrentDate) + 2 etc Then write a script for each button which Sets your required date field to the date in question. You could also create some "Today", "Tommorrow" and "Yesterday" buttons in the same fashion. If screen real-estate is at a premium, create a duplicate layout to which the user is taken when they click in the date field. This would display the list. Have emailed you a file.
  5. Download my Handy Bits post in the Samples section of this forum. There is a calc in there (under the Dates Tab) which returns the Aussie FY in which a date lies. If you sort the Samples by the Views column, Handy Bits will be up near the top.
  6. Have a look under "Finding Names" for my sample file in the Samples section of the forum. Its on about page 6 by now. This technique is demo'd there. There is also coverage of conditional background colour fills in my Handy Bits file.
  7. There is an example of this (both changing the font colour and changing the background colour) in my smaple file under the title of "Handy Bits" in the samples section of this forum. Click on the "Views" header at it should be near the top of the list.
  8. Have a look at my sample file under the Handy Bits thread in the Samples section of this forum. It has numerous examples of date range calcs. Its down a few pages in normal view, but if you show the topics by number of views, it will be up near the top.
  9. Try this calc. Left(Number,2) & " " & Middle(Number,3,2) & " " & Middle(Number,5,2) & " " & Middle(Number,7,2) & " " & Middle(Number,9,2) & " " & Right(Number,2)
  10. Create a number field called "Place" Sort the records by points as you already have worked out. Run this script: Go To Record/Request/Page [First] Loop . Set Field [Place, Status(CurrentRecordNumber)] . Go To Record/Request/Page [Next][Exit After Last] End Loop If you want to be able to deal with tied placings, then its a bit more complicated. You will need to create some extra global fields where you store the points from the previous record and compare them to the current record. If they are the same - set the place as the same place as the previous record.
  11. If you download the latest version of my sample file "RussCalcs from Oz" under the "Handy Bits" thread in the sample section of this forum, there is an example of selecting a conditional coloured background. I think its on page 2 by now - or if you sort by the number of view it will be up near the top. Make sure you go towards the end of the threas to get the latest version (v5). In your case, the condition would be when you r record is marked or the name matches certain criteria.
  12. While there may be ways to get rid of the startup and/or closing screens - depending on which FileMaker product you are using and your OS, you might want to get out the magnifying glass and check the fine print on your FileMaker Pro license.
  13. OK - Enough already ! This attachment is for all those who got cricks in their necks from looking at a "waterfall" style histogram and want a standard "horizontal" style histogram. For those who are interested, this is done by copying page 1 of the original waterfall style histogram in preview mode and then pasting it into a 270 degree rotated container field in another layout in browse mode. This works fine on Macs but has not been tested on a PC yet and I won't be able to do that for a few days - but in the interests of stable necks, I thought I'd get it posted quickly. HiLite B
  14. Based on the date of each record, create calc fields for Year = Year(Date) and Month = Month(Date). Have a Summary field which = Total of Cost Sort your records by Year, then Month, Then Date. Create a layout with the following parts Sub-Summary when sorted by year (contains Year field and Summary field of cost) Sub-Summary when sorted by month (contains Date formatted to sjow full month name and Summary of cost) Body (contains Item, date and cost) You can delete the body patr if you don't want the report to show every cost item. Assuming you delete the body part
  15. You could either use a dummy record or a global field for the left side of the relationship. You might need to run a startup script which will populate these global fields - for 2 reasons. 1. In a networked environment, global fields are loaded up from the server on opening but are local (ie they could end up being different) on each machine. In these environments, you can also load them up from a "preferences" file you create on the server. 2. Creating a clone of the file will clear the global fields.
  • Create New...

Important Information

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